Macro fails to run at start up

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database on a network that is shared by client PCs who have a
shortcut to the file on their desktops. There is a macro that runs at startup
that does not seem to run on one PC.

Normally we have been able to add a shortcut to a PC to allow them to access
the database but on one PC (we have just set up with XP sp2 and office 2000
sp3) it gives the following error:

The expression on open you entered as the event property setting produced
the following error:
Object of class does not support the set of events

I cant understand why we have this message as it works fine on other PCs
with the same software and service packs installed. Anyone know what could be
wrong? Thanks.
 
One suggestion to start the troubleshoot,

-Open one module (or create a new one if you do not have any) in the source
database.
-Select References from the Tools menu in the VB window
-Verify that both computers have the same references, if they are different
match the non-working pc to the one that works,
 
Thanks for that - I have checked and both references are identical. The
Access installations are also identical, and I am lost as to what could be
wrong. Any further ideas? Thank you.
 
Back
Top