Search results for query: *

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 >...

[2thumbsup] ThankU! thankYou! thankU! jrBarnett!!! [2thumbsup] ...my search is working!!!!!] there is a small part that was overlooked. perhaps, i was not clear in my description. in any event, once i have pressed the [search] button for a surname search, i need to be able to choose from a...

John, thank you so very much for your help. i'm eager to implement it. ...just wanted to let you know that 'i'm on it' and will keep you posted. again, thanks. stellJess

Everyone, i am in desperate need of your help. i need to implement a search from a command button on a main data entry form. this is how it should work (i just do not know how to do it). will you please break it down to the lowest terms for me? i am at wits end. @ the main data entry form...

hello Everyone, i have another problem so i'm creating a new thread. i have a form w/a subform. the subform has a tab control. i need to change the fore color or caption of the second tab control IF a field is populated. how do i do this? in advance, thanks for your help. stellJess

hello everyone, i need your help. i'm trying to run a query based on an unbound form w/unbound text boxes. i need this form to provide results based on all or some of the unbound text boxes being populated. there are 4 text boxes on the form. then the results should display all the related...