How to auto run a VB routine as soon as databse opens

[avayaman]

I already have a routine to save a dated backup when I close the database via a yes/no, but I would like an option to run the same routine as soon as it is opened also with a yes/no popup box.

Don't need any coding for the backup, just to get the prompt to appear & I can take it from there.

I know how to do this with excel but not sure about access.

Paul Beddows

Consulting, Avaya/EAS implementation, Training
Vancouver, Canada
E-mail paul at natcoa.com

 

[PHV]

Use either an Autoxec macro or a startup form.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[MajP]

If using a startup here is how:

http://msdn.microsoft.com/en-us/library/bb256561(v=office.12).aspx