|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Be the architects of evolution and help create the mobile internet future. It’s your move---enter to win here! |
|
#1
|
|||
|
|||
|
Command button fails to operate in VB Access
I have a strange problem with a command button on an Access form. The button is called cmdRunSearch. In the form's code there is a corresponding subroutine called Private Sub cmdRunSearch_Click(), and in the routine there's a bunch of code.
When I click the button the routine does not get called. This is bizarre, since the routine used to be called and all the other buttons on the form work fine. I cannot figure this out and it's holding up my work. Does anyone have any ideas? Thanks |
|
#2
|
|||
|
|||
|
I solved the problem by deleting and recreating the button and its subroutine, but I'm still curious about why a button should fail to call its subroutine? I made no changes to the properties of the button, although I did physically move it a few millimetres.
|
|
#3
|
|||
|
|||
|
Apparently strange things like this happen in VBA, other users having experienced the same thing. A faster solution than mine would be to export and then reimport the form from VBA. Thanks to Rob Broekhuis from tek-tips.com for the tip.
|
|
#4
|
|||
|
|||
|
Sometimes a control loses the event hook to the event subroutine. You can often cure this problem by opening the properties for the control and resetting the event procedure for onclick or whatever event.
|
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > Command button fails to operate in VB Access |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|