Error Converting Macros to VBA

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

Guest

Hello

I just tried some simple button macros (navigation) to code and I get the following compile error when I click the buttons

Can't find Project of Librarie

The debugger is highlighting "Error$" from this code
cmdNext_Click_Err
MsgBox Error
Resume cmdNext_Click_Exi

Any ideas

Thank yo
Brian
 
Change Error$ to Err.Description

Error$ is very old syntax - circa Access 2. Some of those 'wizards' are a
little behind-the-times! :-)

--
Brendan Reynolds (MVP)

Brian T said:
Hello,

I just tried some simple button macros (navigation) to code and I get the
Click to expand...
following compile error when I click the buttons:
 
Thanks

Is there a list, online or somewhere else, for this sort of errata? I am just learning VBA for Access and it would be a great help

Brian
 
Hello,

I just tried some simple button macros (navigation) to code and I get the following compile error when I click the buttons:

Can't find Project of Libraries

The debugger is highlighting "Error$" from this code:
cmdNext_Click_Err:
MsgBox Error$
Resume cmdNext_Click_Exit
Click to expand...
 
Hello,

I just tried some simple button macros (navigation) to code and I get the following compile error when I click the buttons:

Can't find Project of Libraries

The debugger is highlighting "Error$" from this code:
cmdNext_Click_Err:
MsgBox Error$
Resume cmdNext_Click_Exit
Click to expand...

This appears to be the very common References bug. Open any
module in design view, or open the VBA editor by typing
Ctrl-G. Select Tools... References from the menu. One of the
..DLL files required by Access will probably be marked
MISSING. Uncheck it, recheck it, close and open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.

Sorry - think I sent a blank reply first! Note that the code generated
by the macro converter is often very crude code: if it's a one or two
step macro it may be OK, but anything with multiple actions should
perhaps be recoded from scratch.
 
Back
Top