Automatic Macro's

[Noah114]

Is there a way to have a macro run the second the database is open?

 

[ZmrAbdulla]

Can you please tell us what you are exactly looking for?

________________________________________________________________________
Zameer Abdulla
Visit Me
A person who misses a chance and the monkey who misses its branch can't be saved.

 

[Noah114]

Every day I need to run a query that dumps infor into a make table. Is there a way to have that query run as soon as I open the Access database. Kinda like when you open an excel file that has a link to a database and you can select to have it update as soon as the file is open.

 

[ZmrAbdulla]

I believe you have set everything to dump the data to the backup db. Only thing you need to run the query as soon as you open the working db.

You could use the first switchboard's open event to run the query.

Here is a code sample that opens a different db and add a record to the table.

http://forums.aspfree.com/t20517/s.html

________________________________________________________________________
Zameer Abdulla
Visit Me
A person who misses a chance and the monkey who misses its branch can't be saved.

 

[PHV]

An autoexec macro ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mp9]

PHV is right to say AutoExec - any macro with this name will, by default, run when the database is opened (as long as the db startup is not bypassed by holding down the shift key).

As an alternative, any other macro can be specified to run at db start by means of the /x command line parameter, e.g. [Location of Access EXE] [Location of db] /x YourMacroNameHere

As another alternative, you could use something like the freeware Access scheduling tool HAL (

http://www22.brinkster.com/accessory/resources/001.shtml)

to let you schedule the macro to be run at a certain time each day (or on the days of your choosing) - then you wouldn't have to do anything to do your backup data dump other than create the HAL schedule file and include it in you Windows startup.