Subject: Compile Error
Posted By: aglatfel Post Date: 1/13/2004 2:57:31 PM
I am getting a Compile Error when I try to use the buttons after Access converts the macros to VBA code in the beginning exercises in the " Access 2000 Beginning VBA" book. The error reads Can't find project or library.  Also, After converting the macros to VBA on pages 73-75 the buttons no longer function at all.  I get the following message in the IDE upon pressing any button in the frmCompany (First,Next,etc): "Compile error: Can't find
> function or library".  the debugger shows 'Private Sub cmdNext_Click()'in
> the cmdNext_Click sub highlighted in yellow and 'Error$' highlighted in
> gray.  Have tried redoing all steps.



Reply By: BethMoffitt Reply Date: 1/13/2004 3:00:43 PM
If you are using Access 2000, make sure you have service packs 1 & 3 loaded as there was a corruption issue fixed with the sp's.  Anytime you copy & paste code from an existing form, report or module you need to debug & compile before saving, unless you have the sp's loaded.

Regards,

Beth M
Reply By: jrwlkn Reply Date: 1/13/2004 3:01:54 PM
Have you checked the event properties of the button to make sure the onClick() event is pointing to the right code.

In design mode select the button, right click, select properties, select event then press the ... button in event onClick

this should take you to the vb code

Cheers

Let me know if this helps


Go to topic 8486

Return to index page 970
Return to index page 969
Return to index page 968
Return to index page 967
Return to index page 966
Return to index page 965
Return to index page 964
Return to index page 963
Return to index page 962
Return to index page 961