Hi-
I am trying to add a dreary task to a macro and I'm stuck...
In my Access 97 database, there are 10 or so tables which get refreshed (from an inventory mgmt. package) every few days. I need to append data related to new information only (from ORDER TABLE)to a separate table (HOLD STATUS)...
Hi-
I have a macro launched at night which deletes/appends lots of different tables and then the database is compacted. After the database is compacted, the switchboard is displayed (per the Startup options).
I need to quit Access as the last step in the process but if I add this command to...
I have some similar forms and queries. They way I accomplished this was as follows:
My forms have an unbound text box for users to input criteria (for your example, product).
The criteria for the field product in the underlying query is as follows:
Like Form!(form name)!(unbound text box...
Hi -<br><br>I was able to get my switchboard to display the last time a particular macro was run by a long, round-about process. I'm thinking there must be an easier way.<br><br>The way I did it was to create a table called Last Update with one record (Date). Then I created...
I tried both suggestions but I am still unable to get all the results I need.<br><br>Zelandakh, your suggestion worked great as an "OR" criteria but when I tried to make it into an "AND" criteria, it didn't work. Any other ideas?
Hi -<br><br>A simplified version of my challenge is this...<br><br>I want to use a parameter query to select records that match two different Field2/Field 3 criteria.<br><br>Field1 Field2 Field3<br>lot...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.