Automatically run a query when the database is opend...

[Jan T.]

How kan I have my database run a Stored query "qryUdateMembers"
each time the database program is opened? (It is checkin a date for each
record
and if it is less tha the date to day, I do some updating stuff...).

I know from Excel that you can make a Auto_Open makro that is triggered
each time the Excel file is opened. How can this be done in Access 2k.

(I have Access 2000 and Windows XP).
Thank you for any suggestions.

Regards
Jan Thorstensen

 

[Jan T.]

Thank you so much. That was exactly what I needed.
JGT

 

[guido via AccessMonster.com]

Create a macro and call it "AutoExec".