disable command button after click

  • Thread starter Thread starter Martin
  • Start date Start date
M

Martin

question, I'd like to disable a command button after it is
clicked until the following day, can anyone offer any
suggestions as to how I would go about this?

Any suggestions appreciated,
Martin
 
question, I'd like to disable a command button after it is
clicked until the following day, can anyone offer any
suggestions as to how I would go about this?
Click to expand...

depends on what kind of access database you have. if it's a standalone
database and will only run on one computer than you can store the current
date in the tag-field of the button and write a sub or function to control
the information.

if it's a multiuser database and more than one person is allowed to access
the database i suggest to create a new table to control the state of the
table... more than ever when you want to disable (or enable) the button
depending on what user is logged in or using your database.

hope this helps.

Joe.
 
-----Original Message-----
question, I'd like to disable a command button after it is
clicked until the following day, can anyone offer any
suggestions as to how I would go about this?

Any suggestions appreciated,
Martin
.
Click to expand...
Hi Martin,

consider having a table to store an inital date. when the
form opens compare the current date with the date in this
table. set the enabled status of the command button
depending on the comparison between dates. Use the button
click event to update the date stored in the table and
also to disable the button (after setting focus to another
control).

Luck
Jonathan
 
Back
Top