[AccessD] HELP Very odd problem (to me anyhow)

John Clark John.Clark at niagaracounty.com
Fri Jun 20 13:39:07 CDT 2003


To add on to my own post...

When I finished writing this Email, I created a new form from scratch,
and cut & pasted all controls from the old form to the new one. This new
form worked fine, but of course none of the code is there either, so I
went back to the old form to cut out the code...I was going to do this
piece by piece, hoping to find the snag...but, when I attempt to go to
the code window, I get the afore mentioned error, and although it lets
me into the coding section, no code seems to exist.

>>> John.Clark at niagaracounty.com 06/20/03 01:57PM >>>
I haven't bugged any of ya in quite a while now...about two months
plus.
I have actually been away from 
Access and instead, learning the fine art of IP phones, and wireless
networking.  Now I am back into Access and having a major problem.

I am working on a program that I was probably 90% done with, when I
was
pulled off for the other project. And, when I press certain buttons, I
was receiving errors that, "...Network connection my have been lost." 
I
first thought it was no big deal...the program, because of my other
duties, has run so far behind, that I will just delete the offending
buttons and recreate them...but then grew more concerned, when I
received this error, while trying to comment out the code behind the
buttons. I decided, because of time constraints, that it would be best
to create a totally new program and import the pieces into it. This
isn't working either. 

I have only inported the tables, queries, and three very simple
forms...these are just "switchboard" type forms...that, using buttons,
call other forms or each other. I reuse these same forms for each
program that I do, so that all programs in the county have a similar
look and feel to them. I have done this a few times now, and each time
they work, until I restart the program. I then get the following
error,
when I attempt to open the form: 

<ERROR START>
The expression On Open you entered as the event property setting
produced the following error: Error accessing file. Network connection
may have been lost.

* The expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure].
* There may have been an error evaluating the function, event, or
macro.
<ERROR END>

There doesn't appear to be any code there, when I look. And, equally
puzzling, is that I am not using it on the network. I created it on my
hard drive, and I am running it from there now.

Anybody seen anything like this before?

Thanks!



John W. Clark
Computer Programmer / Asst. Network Administrator
Niagara County
Central Data Processing
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list