A
Andy
This is a strange one...can someone please help?!
I have a database I have been working on for several
weeks, it is in three different files.
File 1 is the data. All tables, no queries and no forms.
File 2 is the "working file". Includes all queries, forms
(and vb code) and reports.
File 3 is the "development file". A copy of file 2
several weeks ago...with all changes and additions to
forms and queries over the past few weeks.
File 3 has been working fine with no problems...until I
copied it to a USB memory card and took it home. Worked
on it at home and made only a few minor changes. When I
brought it back to work...most of my "Event Procedure"
buttons would not work. I get "Complie error: Can't find
project or library". I get this error even in the old
forms that I never even opened at home.
File 2, the working file still works fine...but the
development file bombs on simple commands like storing
something to a varible, using a Chr(34) command, and a
simple docmd. The code is 100% correct and used exactly
the same in the "working file".
Then I tried to import the changed queries and forms from
the development file to the working file...and got a new
error. "Error accessing file. Network connection may have
been lost." I get this error even from a local drive.
Any ideas on what is going on here?
I have a database I have been working on for several
weeks, it is in three different files.
File 1 is the data. All tables, no queries and no forms.
File 2 is the "working file". Includes all queries, forms
(and vb code) and reports.
File 3 is the "development file". A copy of file 2
several weeks ago...with all changes and additions to
forms and queries over the past few weeks.
File 3 has been working fine with no problems...until I
copied it to a USB memory card and took it home. Worked
on it at home and made only a few minor changes. When I
brought it back to work...most of my "Event Procedure"
buttons would not work. I get "Complie error: Can't find
project or library". I get this error even in the old
forms that I never even opened at home.
File 2, the working file still works fine...but the
development file bombs on simple commands like storing
something to a varible, using a Chr(34) command, and a
simple docmd. The code is 100% correct and used exactly
the same in the "working file".
Then I tried to import the changed queries and forms from
the development file to the working file...and got a new
error. "Error accessing file. Network connection may have
been lost." I get this error even from a local drive.
Any ideas on what is going on here?