Reference help

  • Thread starter Thread starter JB
  • Start date Start date
J

JB

Hello
I put together a database for some people.
I did it on my machine, took it on a memory stick to give it the them in
their office and show them how to use it. To my horror when opening some
forms it was being debugged!
Couldn't work out why as when I used it on my computer it was fine. Then I
tried it on another computer in my house the next day and same thing.
Finally I realised it was to do with references and that the Microsoft
Office Object Library wasn't ticked. Didn't realise that the database
doesn't automatically save that.
So I sent instructions to the people who I did this for, blow by blow on how
to tick the missing reference and they are telling me that they don't have
the same settings as they must have an earlier version. Mine is 2003 SP3
I have to take a long trip to their office to see for myself which is a pain
so I thought I would try here first.

On a few of the forms there's a command to open a folder on computer to
insert an image. Could an earlier version of MS Access be the problem?
Thanks
 
Thank you for this.
The command isn't just to open a file (jpg) it is to insert the image in the
form so that an image is seen in each record in the form.
The database is for archiving hundreds of photos of designs.
Will this api thing be for this sort of thing?
J
 
JB said:
I did it on my machine, took it on a memory stick to give it the them in
their office and show them how to use it. To my horror when opening some
forms it was being debugged!
Couldn't work out why as when I used it on my computer it was fine. Then I
tried it on another computer in my house the next day and same thing.
Finally I realised it was to do with references and that the Microsoft
Office Object Library wasn't ticked. Didn't realise that the database
doesn't automatically save that.

Try running the following code and let us know what references you
have.

Sub ViewMoreReferenceDetails()

Dim refIDE As Object

For Each refIDE In
Access.Application.VBE.ActiveVBProject.References
Debug.Print refIDE.Description & " " & _
IIf(refIDE.IsBroken, "Broken", "") & vbCrLf & _
" " & refIDE.name & " - " & refIDE.Major & "." & _
refIDE.Minor & " " & refIDE.FullPath
Next refIDE

End Sub

Tony
 
Back
Top