Recent content by stellJess

Thanks to everyone for the input. you gave me the answer i needed. therefore, i will create a table to capture the data that will be retrieved later. thankYou, thankYou, thankYou!!!

Ok. but i will have 4 X 10 fields which is why an array would be perfect. but how does the array work? will it store the data and can the data be retrieved at a later date? if the data is being captured in the same named and same type field, isn't that the criteria for using an array? just...

for an array, should the field be created in table design? if so, should it then be declared in vba code as an array? can you tell me how and where the data is stored according to the subscripts of the array? will the data be stored as long as the db exists? please let me know because i...

Hi GHolden, tried the spacing suggestion -- not it. even tried the choose() that does not completely work either. while the choose() does place the object (as a sql statment) into the me.cboDepartmentNo.rowSource for the first value, the remaining values (choices) for the optionGroup (2...

Hi GHolden thanks for your reply. however, it is not working. here is my code in the onClick property for the option group (ogRevCenter) and the combo box (cboDepartmentNo). case 3 - 5 has been commented out but has the original doCmd.openQuery commands. will you take a lookC and tell me...

Hello Experts! can anyone out there please tell me if this is possible. need to select from option group of 5 and base on the option selected, the combo box on the same unbound form needs to only display the values for that option. o technical o professional o n then in the combo box below...

Thank you!!!

Hi, A report has been created in Access97 using linked tables. The enduser does not have Access but needs the report each day. Is there a way to do this? In advance, thanks for your assistance. stellJess

Hello TechTip Experts, I am having a problem with a mainReport and subeports. I need to create a mainReport with two subReports. Maybe i do not need subReports because i only need the grand totals from the subReports to use in calculations on the mainReport (as denominators). The problem i...

a related record is required in table <tableName> can someone please help me out with this. i have a a mainForm with clients demographics and a subform that captures the many details pertaining to the client. one client can have many details. however, when i try to add a detail record on...

Tranman, thank you!

Can anyone tell the maximum number of records an MsAccess table can have? in advance, thanks. stellJess

Steve, thanks, i'll try it and keep you posted. i may need your help again. stellJess

Hi Steve, thanks for your reply. i do not need to save the query results. although, i have created and saved the query but need help with the wizard-like funtionality. i do not know how to make this happen. any help is appreciatedm, thanks. stellJess

Hello Everyone, i may be posting this in the wrong forum. if so, let me know. is there a way to allow the user to select some or all fields in a query like the wizards we use in Access. something like this: FIELDS TO SELECT FIELDS CHOSEN field1 >...