Button not working

[GeorgeMar]

I am at wits end.

I deploy my application by giving the end users the latest Front End as an
MDE. This has worked for many years.

Last week, I did a new installation and this time some of the buttons will
not work at this particular site. The OS (XP or 2000) and Office (2002 or
2003) are the same. I have installed at other sites since, and they all work,
bar that one.

Has anyone seen this? Thanks for your help. I don't even know where to
begin.

many thanks
george

 

[Graham R Seach]

George,

It sounds to me like the button's event procedure has become unhooked from
the button.

Copy the event procedure (either to Notepad or the Clipboard), delete the
procedure stub (Private Sub...End Sub), and remove the [Event Procedure]
text from the Properties dialog. Then re-create the event procedure stub by
clicking in the event's textbox on the Properties dialog and then clicking
(...). Lastly, re-insert the code.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Douglas J Steele]

That sounds like overkill to me. Most of the time, it's simply that the
[Event Procedure] has disappeared as the property for the event. Picking it
from the combobox (and clicking on the ellipsis, to ensure you still get
taken to the correct code) is usually all it takes for me.

My March 2004 "Access Answers" column, in Pinnacle Publication's "Smart
Access" shows how to automate checking that this problem hasn't occurred.
You can download the column (and sample database) for free at
http://www.accessmvp.com/djsteele/SmartAccess.html

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

George,

It sounds to me like the button's event procedure has become unhooked from
the button.

Copy the event procedure (either to Notepad or the Clipboard), delete the
procedure stub (Private Sub...End Sub), and remove the [Event Procedure]
text from the Properties dialog. Then re-create the event procedure stub by
clicking in the event's textbox on the Properties dialog and then clicking
(...). Lastly, re-insert the code.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

I am at wits end.

I deploy my application by giving the end users the latest Front End as an
MDE. This has worked for many years.

Last week, I did a new installation and this time some of the buttons will
not work at this particular site. The OS (XP or 2000) and Office (2002 or
2003) are the same. I have installed at other sites since, and they all
work,
bar that one.

Has anyone seen this? Thanks for your help. I don't even know where to
begin.

many thanks
george

 

[GeorgeMar]

Thanks Graham and Doug

George