Form Display for a time limit (AGB)

[Guest]

Is it possible to display a form for a set time period only ?
What I want to do is diaplay an information form as the database exits,
basically when the macro button is pressed to close the database a form is
displayed for ten seconds first, then it shuts down

 

[Brendan Reynolds]

Private Sub Form_Activate()
Me.TimerInterval = 10000
End Sub

Private Sub Form_Timer()
Application.Quit
End Sub

Leaving the TimerInterval set at 0 (zero) in design view, and setting it
programmatically in the Activate event procedure like this, helps to ensure
that the form is visible before the timer starts ticking.

 

[Guest]

Thanks for your help, but is it possible to do through a macro ? My VB skill
leave a lot to be desired

Andy

 

[Douglas J. Steele]

You don't need great VB skills: you have to type 2 lines of code (the VB
Editor will give you the declaration and End statements), and Brendan's
given them to you.

I don't believe it is possible to do using Macros.

 

[Brendan Reynolds]

Don't know about macros. As Doug says, you don't need to know a lot about
VBA, you can just copy and paste the code I posted. If you really want to
know about macros, though, try asking in the macros newsgroup. There are
only a few people who regularly answer questions about macros, so you've
more chance of your question being seen by one of those people if you post
it there.

 

[Guest]

Thank you. Never really used Event Procedures before, seems to be an area
that can open up a lot more functionallity than macros. Time to study i think
!
Again, thanks

 

[MBSNewbie]

Andy,
This may be a great time to introduce yourself to VBA.
With Access 2003 you can save the macro as a module, it will automatically
convert the code to VBA, you can then insert this statement into it.
While you are there, take a look and understand the syntax, a whole new
world of possibilities will open up for you!
Good Luck!