Cannot run macro

T

Trish

Hi, I was not sure where to post this question, as it concerns more than just
a macro problem. I am using Windows XP Pro, running MS Office 2003. I
have the same set-up at home as I do at work. I created a database at home,
with a form that had command buttons (macros) to minimise current form, and
open other forms. It all worked perfectly. I put it on disk and took it
to work. The database opens okay, but when I hit the command buttons, the
macros won't work. The macros are still there, and I can manually open the
other forms. I didn't get any message about enabling or disabling macros.
This is SO frustrating! Please tell me what I have done wrong! Thanks in
advance.
 
T

Tom Wickerath

Hi Trish,

Do the macros work if you run them directly, instead of via the click event
of command buttons? If you open the form in design view, and view properties
for the command button(s), are the macros correctly specified on the Event
tab? Try clicking the build button (the button with three dots). This should
lead to the macro being opened in design view. It sounds like somehow a
disconnect has occured between the click event of the command button, and the
macro. This is why I suggest running the macro by itself, to rule out a
problem with the macro first.

Tom
____________________________________________

:

Hi, I was not sure where to post this question, as it concerns more than just
a macro problem. I am using Windows XP Pro, running MS Office 2003. I
have the same set-up at home as I do at work. I created a database at home,
with a form that had command buttons (macros) to minimise current form, and
open other forms. It all worked perfectly. I put it on disk and took it
to work. The database opens okay, but when I hit the command buttons, the
macros won't work. The macros are still there, and I can manually open the
other forms. I didn't get any message about enabling or disabling macros.
This is SO frustrating! Please tell me what I have done wrong! Thanks in
advance.
 
Top