Search results for query: *

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

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

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

Can anyone tell the maximum number of records an MsAccess table can have? in advance, 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...

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

Hello All, i need some help. i've had to make changes to a split db [mde]. the new tables have been put in 3NF. so, how do i go about updating the split db with the normalized tables and get rid of the old linked tables while maintaining the data and ensuring the most up-to-date data? i...

G’morning! I need some help w/subforms. I have 3 forms A, B, C. A is the main form w/subform B nested. Subform B has subform C nested w/a tab control. The functionality in subforms B & C works fine without problems as a standalone --> Subform C sends data out to subform B. however, when...

hi there! i've inherited an access2000 database that is performing poorly. while it has a primary key for each table w/foreign keys as appropriate, the primary keys are autonumber and randomly generated. perhaps this is the cause of the poor performance. one patient can have multiple unique...