Error when trying to use command buttons

S

Sharyn

I copied a database I was creating on my home computer to
a laptop. The command buttons and list/combo boxes in the
forms I created on my desktop have stopped functioning. I
get an error that the expression is not valid, and it
takes me to the VBA screen where I can see there is no
code for the event procedure. It won't let me create code
for any event procedure either - once it is created it
doesn't work. I also get a "can't find file, network
connection lost" error when using command buttons.

I created the new database on the laptop importing objects
from a replicated database I put on CD. I need the laptop
version to function as it is an application for my
husband's work.

Help!
 
W

Wayne Morgan

Part of this sounds as if it may be a references problem, but that second
error is a nasty one. I hope you still have the good copy on your desktop
computer, as it will make this a much easier fix.

First, if you're using Access 2000, install Office 2000 SP3. The service
packs are not cumulative as the Windows SPs are, so you'll have to install
SP1, SP2, then SP3. For information about the need for this see this
article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;304548&Product=acc2000

Now for the references. Open the database then open the code window
(Alt+F11). Go to Tools|References. Compare the references between the 2
computers, which ones are check and what order the checked ones are in.
Also, make sure that there aren't any listed as Missing.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top