Error Message in a Form

M

Manuelauch

When I switch a database to OFICCE 07, I get in one of the forms after any
botton is clicked the following error "The expresion On Click you entered as
the event property setting produced the following error: User-define type not
defined."

I have to terminate the application because not even the 'Close' button works.

Does any body have an idea what could be?
 
M

Maurice

This is probably a library reference that is broken. Try doing the following
steps:

1. Open the db by holding the shift-key
2. Go to the [Database tools] ribbon
3. Click on the visual basic button on the far left
4. In the VBA screen click on tools (in the menubar) and choose [references]
5. You will probably see one reference with MISSING in front of it
6. See if you can locate the missing library in the list and check the
checkbox in front of it.
7. Click save and close the db.
8. Open the db again and see if that fixed the problem.

hth
 
M

Manuelauch

Thanks Maurice, but I forgot to mention that there are many other forms in
the database and they run OK. I did what you suggested though and there was
nothing missing. I thought off re-creating the form in case it is currepted,
of course this is extra work that may not work

Maurice said:
This is probably a library reference that is broken. Try doing the following
steps:

1. Open the db by holding the shift-key
2. Go to the [Database tools] ribbon
3. Click on the visual basic button on the far left
4. In the VBA screen click on tools (in the menubar) and choose [references]
5. You will probably see one reference with MISSING in front of it
6. See if you can locate the missing library in the list and check the
checkbox in front of it.
7. Click save and close the db.
8. Open the db again and see if that fixed the problem.

hth
--
Maurice Ausum


Manuelauch said:
When I switch a database to OFICCE 07, I get in one of the forms after any
botton is clicked the following error "The expresion On Click you entered as
the event property setting produced the following error: User-define type not
defined."

I have to terminate the application because not even the 'Close' button works.

Does any body have an idea what could be?
 

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