hide command button

[meenctg]

i have a command button in my form. it has a macro on click event for another form open. the command button usges 1 time for 1 day. so i wanna after one time click it will be hide from my form for today. it will show on my form nxt day. is it possible?

 

[Johnny Drama]

What is the function of the button? Is the database opened and closed multiple times a day?

 

[John Big Booty]

The code to hide the button is quite straight forward something along the lines of;

Me.AnyotherControlOnYourForm.SetFocus
Me.YourButton.Visible = False
DoCmd.RunSQL "UPDATE TBL_DateRec SET TBL_DateRec.DateRun = Date();"

You will need to add a table TBL_DateRec with one field DateRun (to keep track of when the command is run), then in the On Load Event of your Form put;

If DLookUp("DateRun","TBL_DateRec") <> Date() Then
Me.YourButton.Visible = True