Code:
ev = MyArray(0, 0) cust = MyArray(1, 0)
THANKS TO ALL!!!
Now i am just going to play with if for a bit so that i dont need to do a form...
ckeller06
Last Activity: Nov 27 '07, 12:10 AM
Joined: Aug 18 '07
Location:
-
ok totally works perfectly now... the problem was that for the array I only had it called for the customername in the form listbox, once i added the event and then modified the array dimension to:
it fixed my subsript out of range problems
THANKS TO ALL!!!
Now i am just going to play with if for a bit so that i dont need to do a form... -
ok that was a simple fix, however now it's saying Subscripts are out of range with MyArrays() or ev and custLeave a comment:
-
well i have followed what you have done, and you have done a good job, I see the logic behind this process a little bit better, however, I am stuck on an error that needs debugging: it says user function not defined... when i enter in debug mode it has rs As DAO.Recordset
I fiddled around with this making it a string/integer/recordset but i still haven't been able to correct this error
ps: when i do chance DAO.Recordset...Leave a comment:
-
Is it possible to join these rows with a select statement or grouping them together in a string value?Leave a comment:
-
Combining Names in A Textbox on a ms access report or form
i have 2 tables which are linked together
table 1:
[Event] { EventID, EventName, CustomerID }
table 2:
[Customer] { CustomerID, CustomerFirstNa me, CustomerLastNam e, AGE }
they are join by CustomerID obvouisly, but i want a report that shows multiple customers in one textbox for one Event.
I.E. Report would look like:
Event: Saturday Customers: Charlie...
No activity results to display
Leave a comment: