problems with running database on my laptop

[Guest]

hello all

I wrote a database program using Access 2000 on my home computer, and it
works well. I am trying to use the database on my laptop. The laptop has
Access 2002 installed, and a trial version of Office 2007 was also installed
recently.

I want to use Access 2002 with my application. On the laptop, the database
window opens and the starting switchboard appears. Then the troubles begin.
Whenever I click on a command button, I get the following message:

"The expression On Click you entered as the event property setting produced
the following error: Object or class does not support the set of events."

Frequently I even get the above message (with On Open instead of On Click)
when I double click on a form in the database window.

Can anyone offer a suggestion as to how I can get this working? What seems
to be the problem?

 

[Guest]

Hi Sarah,

Check that you do not have any missing references, and that any VBA code
compiles without an error. Here are two excellent articles on missing
references:

Solving Problems with Library References (Allen Browne)
http://allenbrowne.com/ser-38.html

Access Reference Problems (Doug Steele)
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

When you are in the Visual Basic Editor, click on Debug > Compile
ProjectName. Does your project compile without any errors? If the answer is
yes, then I would next check to make sure that the DAO and ADO Object
libraries are properly registered. To do this, click on Start > Run. Then
enter the following commands(one at a time), and press the Enter key to run
the command:

Regsvr32 "C:\Program Files\Common Files\system\ado\Msado15.dll"
Regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\Dao360.dll"

Notes:
1.) You may need to verify the correct paths on your PC.
2.) Make sure to include the quotes, as indicated above, around the paths.
3.) There may be other libraries that you need to re-register, depending on
which references that you have included as checked references.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Pls, check out & fix references on your laptop.

1) Open your project in design mode.
2) Open a code module.
3) Select Tools, References from the menu.

Vlado