Hello,
I have a command button that reads data from my scale, this process takes about 2 seconds so I would like to make it that the user cannot accidently click the button again until the code finishes executing or else it will give an error. I know that it does not allow the disable a button when u press it is there any way of doing this?

Thanks

Have the button open another form and make it modal. Put a message on the form to wait a second, and put a timer on the form to close it after 2 seconds. This will prevent them from doing anything in Access until the modal form closes.

mmcdonal

Another option would be to set a form level variable...

On the form (General) (Declarations)..
Dim blnScaleProcessing as boolean

In Form_Load...

blnScaleProcessing = False

In cmdProcessScale_Click..

If blnScaleProcessing then
    msgbox "Error"
else
    blnScaleProcessing = True
    Call ProcessScale
    blnScaleProcessing = False
End If

QED

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org

How about giving the focus to another button, e.g. EXIT, then disabling the first button and re-enabling it later?

Me.cmdExit.SetFocus
Me.cmdProcess.Enable = False
'Do your processing here...
Me.cmdProcess.Enable = True
Me.cmdProcess.SetFocus


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division