Database form fails on users PC

  • Thread starter Thread starter Jim Stuart
  • Start date Start date
J

Jim Stuart

Developed a simple Access database using Access XP on my PC for use by our
local Library which has Access 2000 installed. The first beta went fine and
I added enhancements including more use of events and VBA. This worked fine
on my PC but at the Library I received errors. One error being an 'On Open'
event as follows "Forms!New_Periodicals!Title.SetFocus" which fails and
brings up the debugger option.



Any help would be appreciated.

Jim
 
Most likely a reference problem. On the machine where you developed the
database, open the VBA editor and select Tools->References. Make a list of
all the references that are checked. The be sure that the same references
are checked on the libraries machine. You may see one marked "Missing".
That means the reference required by whatever code that is failing can't find
the file it uses.

It can be difficult to read the path of the references, so here is a little
routine that I run from the immediate window that tells me how many
references I have, the names of all of them, and the path and file name of
the reference.

Sub CheckReferences()
Dim objRef As Reference
Debug.Print "you have " & Application.References.Count & " References"
For Each objRef In Application.References
Debug.Print objRef.Name & " " & objRef.FullPath
Next
End Sub
 
You are correct as I also had reference issues, some of which point to a
non- existent folder on the end users PC. I tried to install one of the
missing references but with no luck.

Jim
 
The best way to cure that is to create the folder on the user's PC and copy
the file referenced on your PC to the user's.
 
Done that in the past on a different PC. Looks like I might need to do it
again.
What puzzles me is my development PC is a clean Windows XP/Office XP system,
with no extra office goodies downloaded and installed!

Thanks Klatuu
Jim
 
Back
Top