Search results

Have you turned the filter on in your form? In the load procedure for the form try adding code something like: Me.FilterOn = True

"Compile error: variable not defined" You've checked to ensure there isn't a typo in the field name and/or the field name is slightly different in each query?

O.K. - if I understand what you want to do instead of having three identical forms you want to use just one form and change the recordsource depending upon the conditions in the form generating the opening command. You could use the OpenArgs portion of the OpenForm command to pass the...

One way would be to set up a couple of queries. First would contain the detail - the second would be grouped by CoID. First query would have columns something along line of: 1) CoID 2) 1999 Year=1999)*Cost*-1 3) 1998 Year=1998)*Cost*-1 4) 1997 Year=1997)*Cost*-1 5) 99IncDec: [1999]-[1998]...

Depends on how your database is designed and how your users operate it. One way would be a command button (copy data from an existing project) that is enabled only when in add mode. It could prompt the user for the project # they want to copy data from. Then have code set to copy the data from...

Look at the Instr function. If it finds the requested text in a string it returns an integer of the location of the text in the string. I'm not quite sure I understood what you were wanting to test for. However, if you want only records which do NOT contain a "U" you could use: If...

There is a function someone wrote I believe called fConcatChild that does what you want. Try out this page of the Access Web: http://www.mvps.org/access/modules/mdl0004.htm Good luck!

Five different forms??? Are these forms based on five separate tables? Look into building a union query - possibly based on a query for each table where the information is grouped by date with a count. Give more info on how things are structured (separate tables? Do you want to compare Date 1...

One way might be to use a make query table in Access on a daily basis to refresh the order #'s. Then, make a form document in Word which pulls from this daily table and could be designed to ONLY allow access/entry into the Tracking #'s and Ship Date fields. You could even use code to build a...

In the past I've used a separate table called tblBatchNum to do this. This table only contains one record. I set up a procedure to increment up the number in the tblBatchNum file first. Then, in the update query for your other table, you can update the IDNumber field to the number in the...

First, did you check Microsoft's Knowledgebase to see if they address this issue? I tried numerous variations of exporting from a table and query and kept getting only two decimal places. One work-around I found was to build a query and for each column of numbers you want to retain the 7-digits...

Look at Container Object and/or the various Collection (report collection, form collection, etc.) to cycle through objects &/or controls in a database. Hint: I seem to recall collection only works on open objects

First, the way I read your explanation with example data of ABC, ADB, CDEB, or DEA and user entered value of AD the query should return all four sample values as they each contain an "A" and/or a "D". However, since the Values column of the query seems to be correctly flagging which records you...

Look at help on Section Property to see if it might cover what you want. A sample of code (you would need to determine what section # the lien falls in) might be: 'For the header: Me.Section(5).Visible = False 'For the footer: Me.Section(6).Visible = False