By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,491 Members | 879 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,491 IT Pros & Developers. It's quick & easy.

HELP! After opening, a database immediately closes using startup form

P: n/a
Hm, I have put a form in Startup... but, forgot to remove docmd.close
from it's code. Result... oh it's remarkable. After opening, a
database immediately closes!!

How to stop it? How to break code? ..what can I do?

thanks...
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Mark" <ha****@yahoo.com> wrote in message
news:22**************************@posting.google.c om...
Hm, I have put a form in Startup... but, forgot to remove docmd.close
from it's code. Result... oh it's remarkable. After opening, a
database immediately closes!!

How to stop it? How to break code? ..what can I do?

thanks...


Hold the SHIFT key down when you open it.

Regards,
Keith.
www.keithwilby.com
Nov 13 '05 #2

P: n/a
Mark wrote:
Hm, I have put a form in Startup... but, forgot to remove docmd.close
from it's code. Result... oh it's remarkable. After opening, a
database immediately closes!!

How to stop it? How to break code? ..what can I do?


Mark, just hold the shift key while you open the database (this assumes
you haven't disabled the shift key). You'll get the mdb window and you
can then find the offending line and rem it out.

I actually use the on open event of start up forms to check for things,
be it Oracle connections (most of my regular work is against an Oracle
database) or a version control system. If the connection/version is not
as it should be, the on open event fires docmd.quit. If all is ok, I
set cancel = true without having to open the initial form and in you go...
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.