[AccessD] Weird A97 happenings

John Clark John.Clark at niagaracounty.com
Tue Mar 27 13:42:53 CDT 2007


Years ago, I wrote a A97 program for our Hotline program. This is the program that you call if you are going to hurt yourself, and is part of the Mental Health department.

It really isn't anything very complex and they have been using it for all these years w/out any problems. It is one of the first programs I wrote in Access, so there really isn't any big programming tricks going on.

Basically, it opens via the "Startup" options, to a form called, "HotlineSplash" which OnTimer then closes, and OnClose is goes to the "HotlineMenu" form. The first problem that they encountered was that it wouldn't make the switch from the splash screen to the menu. It gave the standard error message about a macro or code that could not be run...the first message listed OnTimer as a problem.

I'll interject here that I wrote the program using A97, but they have since switched to A2K. I believe this was done early in 2006 (yeah, we're always a bit behind).

The first "Odd" thing that I notice, when I was nosing around, was that I encountered a message that said something like, "You cannot make any changes because this was written in an earlier version of hotline." It apparently picked up the name of the program and put it in the place of the word "access."

I figured that a quick fix, to get them going, and I could look at the real problem later, would be to skip the splash screen. So, I went into the startup area and made the switch to open to the menu. It seemed to work, because it came up to the menu and had no error. However, as soon as I try to push a command button choice, a similar error occurs. Basically, an error appears when any function is attempted, other than simply opening an object from the Access menu.

I have A97 and A2003 installed on my PC, so I figured I'd make a copy and look at it from my desk...I was remote controlling their PC originally. Whether I use A97 or  2K3, on my PC, I get a password screen. It doesn't have a password. And, when I was using it from the desktop, I didn't have to enter a password.

ANY ideas here would be greatly appreciated! At this point, I'm ready to drop back and punt. If your advice is to leave work and go get a drink, I would probably heed your advice ;o)

Thank you!

John W Clark




More information about the AccessD mailing list