fAccessWindow - I hid it and can't close

[Dymondjack]

I know this has been done by many people before me, and I can remember
reading about how to solve my little problem at one point or another, but for
the life of me I can't find it now. Please help...

I hid the access window using fAccessWindow on my startup form, which is a
splash screen, but I forgot to call my main form before the splash closes
(the splash closes at the end of my autoexec function). So that leaves me
with nothing... the app is open but not in the task manager or anywhere
else I can find.

Like I said, I've seen how to get by this and get back into the DB, but
cannot seem to find the info now (when I really need it).

Any ideas on how I can do this without reverting to my previous development
backup would be greatly appreciated.

Thanks,
Jack

 

[Stuart McCall]

I know this has been done by many people before me, and I can remember
reading about how to solve my little problem at one point or another, but
for
the life of me I can't find it now. Please help...

I hid the access window using fAccessWindow on my startup form, which is a
splash screen, but I forgot to call my main form before the splash closes
(the splash closes at the end of my autoexec function). So that leaves me
with nothing... the app is open but not in the task manager or anywhere
else I can find.

Like I said, I've seen how to get by this and get back into the DB, but
cannot seem to find the info now (when I really need it).

Any ideas on how I can do this without reverting to my previous
development
backup would be greatly appreciated.

Thanks,
Jack

Just press F11 to open the database window. Or, preferably, hold down shift
while the database opens. That stops the Autoexec macro from running.

 

[Dymondjack]

Thank you Stuart for the reply. I did not find out how to get around this,
but I figured I'd post another one for reference with anyone else playing
with this.

Where the Shift key works with an autoexec macro, I had my AutoExec() sub
running off the Open event of my splash/startup form. If you do this, be
carefull, the shift button does nothing to stop it running when setup like
this.

The F11 key (or Alt+F11 for the VBA IDE) do not work when this happens. The
closest reason I can figure out is that after hiding, the application no
longer has the focus, so F11 will do whatever the windows default is for
whatever window is open.

As the taskbar does not show the application, I tried to delete the
recordlock file, to which my system told me that I couldn't do because it was
being used by another program. The only way I have been able to shut the
program down is to restart the CPU.

I ended up having to revert back to my last devel copy (the only thing I
lost was the 'hiding' code anyway, not too big a deal). So anyway, if you
are playing around with this, make sure if you use a splash form to open the
main form before the splash closes. Otherwise, as near as I can tell, you
might loose the database.

For the record, the fAccessWindow that I was using here was from the
tek-tips website: http://www.tek-tips.com/faqs.cfm?fid=2562

I have switched to the Dev Ashish version,
http://www.mvps.org/access/api/api0019.htm
which looks to be a bit cleaner. (and was probably the original source of
the tek-tips post on it anyway)

Happy coding!

 

[Dirk Goldgar]

As the taskbar does not show the application, I tried to delete the
recordlock file, to which my system told me that I couldn't do because it
was
being used by another program. The only way I have been able to shut the
program down is to restart the CPU.

For future reference, I expect you could have killed it from task manager.
Even if the application didn't show on the Applications tab, you could have
found msaccess.exe on the Processes tab and terminated it. Of course, if
there happened to be more than one instance of Access running, you'd want to
make sure you killed the right one.