Macro

[Charles Carter]

Hi All
Access 97 DB

I have a database that opens a macro and runs code to import a text file and parse information into several tables. It works great.

What I would like is:
When Access Opens, I would like it to open a form that allows the adminstrator to perform actions before the code runs (compact, repair, table modification etc.) - if the administrator doesn't choose anything - the code will run when the form has been open for 15 seconds or so..

Any thoughts
Thanks

 

[The_Doc_Man]

When Access Opens, I would like it to open a form

Look up "startup form" in the Help files.

the code will run when the form has been open for 15 seconds or so

Look up "timer events" in the Help files.

opens a macro and runs code to import a text file and parse information into several tables

Look up "DoCmd" and subtopic "RunMACRO" in the Help files.

Everything you want to do can be found in the help files.

Item 1, the startup form, can provide the platform from which you can trigger a timer (item 2). You need to remember to reset the timer if your sys admin clicks one of the buttons you have to write to drive the events you want done - like repair, compress, etc. The timer event can be the thing that runs the macro for you.

Therefore, I think this must be considered a single-shot timer.