Re: Upgrade from Access 2000 to 2003, MsgBox Error$ not working

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Error$ is old Access 2 syntax, but it is still supported for backward
compatibility - it works fine for me in Access 2003. I suspect you have a
missing or mismatched reference. In the VBA editor, select 'References' from
the 'Tools' menu. Are any of the checked references marked 'MISSING'?

--
Brendan Reynolds (MVP)

"tthaav" <tthaav@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8E88ADBD-824B-4080-B3B2-209F8D442E45@xxxxxxxxxxxxxxxx
> Hi. I upgraded my Access 2000 to Access 2003 but my database is not
> working
> correctly anymore. When I try to use .mdb, Access throws Microsot Visual
> Basic errormessage stating: "Compile error: Can't find project or
> library".
> Debugger stops in line MsgBox Error$ two times in following form code:
>
> Sub Form_Load()
> On Error GoTo Form_Load_Err
>
> If ParentFormIsOpen() Then ......
>
>
> Form_Load_Exit:
> Exit Sub
>
> Form_Load_Err:
> MsgBox Error$ <--- Debugger stops 1st time here stating Error$ can't
> be found
> Resume Form_Load_Exit
>
> End Sub
> Sub Form_Unload(Cancel As Integer)
> On Error GoTo Form_Unload_Err
>
> If ParentFormIsOpen() Then .........
>
>
> Form_Unload_Exit:
> Exit Sub
>
> Form_Unload_Err:
> MsgBox Error$ <-------- 2nd time here
> Resume Form_Unload_Exit
>
> End Sub
>
> Please help with this! Should I replace Error$:s with something? I'm not
> experienced Access form coder so this might be easy problem for you...
>
> Thanks already
> - Timo


.

Relevant Pages

  • In Tools | References Missing
    ... The missing reference is "Microsoft ActiveX Data Objects ... In Tools | References Missing ... >> I had the following macro working in Excel 2000, ... >> Sub UpdateProgress ...
    (microsoft.public.excel.programming)
  • Re: References to XLA files
    ... references to other libraries beside the one i'm checking. ... > project contains missing ones. ... > Private Sub Workbook_Open ... > Dim addInName As String ...
    (microsoft.public.excel.programming)
  • Hash problem
    ... I am doing an example from Perl Objects, References & modules. ... HASHis missing preserver ... my $all = shift; ... sub check_items_required { ...
    (perl.beginners)
  • Re: Run two from one cntrl button
    ... > Private Sub Command88_Click ... You might try checking your References for any marked Missing. ... Microsoft Access' ...
    (microsoft.public.access.formscoding)
  • Re: VBA References
    ... I dont mean to be thick but where would I put this code? ... Do I put it in a module and call it in the Workbook_Open sub? ... Also what happens if there are other references missing when my customers ... On Error GoTo NOTFOUND ...
    (microsoft.public.excel.programming)