Run query on table exit

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to run a query when a table is closed. I know information
should be added throught a form, but necessity dictates adding right into a
table at this time. I want to run a check duplicate query each time the
table is closed.

TIA
 
No, there's nothing like that available in Access.

I can't imagine why, though, you must use the table: it would only take a
matter of minutes to create a datasheet form.
 
I can't imagine why, though, you must use the table: it would only
take a matter of minutes to create a datasheet form.
Click to expand...

Didn't MichKa once allude to the fact that table datasheets had
events, too, and you could attach event handlers to them using the
Immediate window?

I'm not recommending this -- I'm just saying that I have a foggy
memory that perhaps it's not as impossible as you say.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record insert/delete anomaly 0
Dropping a table from a report 2
Append Query Issue 0
Common ID for several tables 4
Run query before closing database 1
Combine Duplicates in Query 0
Table Security: Retricting Update queries to only run to one table 1
Alternate method to dynamic tables 2

Back
Top