Error Messages

[gheyman]

I am trying to open my database on a different PC and I am getting these error messages. I don't get them on mine (we are using the same versions of Access).

"Your Microsoft Access database or project contains a missing or broken reference to the file "MSCOMCTL.OCX" version 2.2.

Then a another message "Microsoft Access cannot run the macro or callback function "GetVisible".

I get a compile error

The Line "Public Sub CloseThisForm (vstr as Form)' is highlighted in yellow

Public Sub CloseThisForm(vstr As Form)
'+=============================================================+
' Copyright by Paul Goldbeck. All Rights Reserved.
'Created: 23.03.98
'Last change: 23.03.98
'+=============================================================+

On Error GoTo CloseThisFormError
  
  DoCmd.Close A_FORM, CStr(vstr.Name)

CloseThisFormDone:
  Exit Sub

CloseThisFormError:
  DisplayError Err, Error$, "Fnc::CloseThisForm()"
  Resume CloseThisFormDone

End Sub
It also highlights "Error$"

Anyone know whats going on?

 

[alansidman]

Open the VBE (Alt + F11)
Click on Tools
Click on references
See if there are any missing References and if so add them
Close and Save the VBE changes.

 

[Joe4]

Sounds like you may have some missing libraries/references.

Open the database on your computer, go into the VB Editor, then go to the Tools menu and select References.
Note all the different references that are selected.

Now go to the other computer and make sure that all the same references are selected. If you are on different versions of Office, the version number might be slightly different, but pick the closest ones.

See if that resolved the issue.


EDIT: In the time I was typing this up, I see Alan already replied with the same advice!

 

[gheyman]

Thanks, I wont be able to check this until I get home and check what's selected there. It sounds like this should resolve the problem.