Please help !!

  • Thread starter Thread starter Susan
  • Start date Start date
S

Susan

I don't think you can assign a macro to more than one
event. At least not without writing some VBA code.
Sorry, can't help you with that. As for having it open
when you open the database, just go to Tools/StartUp. In
the Display Forms/Page drop down menu, choose your form.
Then click ok, and exit the db and open it back up again
to make sure it worked.

Susan N.
-----Original Message-----
Hi,
I made a form called "Auto Update" which contains an option group and an "OK" key
The option group contains 2 options :"A" and "B"
When "A" is selected and the "OK" button is pressed, I
Click to expand...
want a Macro to be run, and when the "B" button is
selected and the "OK" button is pressed, I want the form
to close
 
Hi,
I wanted the "Auto Update" form to appear at startup with the main switchboard. i.e. i want the two forms to appear at the startup, but i want the "Auto Update" form to delay for 10 seconds
 
Hi,
I wanted the "Auto Update" form to appear at startup with the main switchboard. i.e. i want the two forms to appear at the startup, but i want the "Auto Update" form to delay for 10 seconds
--
Click to expand...

You'll need a little bit of simple VBA code to do this. Use the
Tools... Startup menu to specify the main switchboard as the startup
form.

Open the switchboard form in design view and view its Properties. Set
the Timer property to 10000 (ten thousand milliseconds = ten seconds).
Find the On Timer event on the form's properties Events tab; click the
.... icon by it and select Code Builder. Access will give you the Sub
and End Sub lines, just add the following in between:

Private Sub Form_Timer()
' fires after ten seconds; reset the timer interval to 0 so it only
' fires once
Me.Timer = 0
DoCmd.OpenForm "[Auto Update]", <optional parameters>
End Sub

Air code, untested!
 
Back
Top