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

closing a db with an error

P: n/a
i have a db that i'm trying to finalized so i can get it out to 3 other
branch offices. when i was testing it, i found an error that i don't know
how to describe well, let alone fix. basically, i have one form that i use
to open all the other forms for the db. this one form, formlauncher, goes
visible=false every time another form opens, and in the closing codes of the
various other forms and reports is set to visible=true again. the problem is,
when one of the incidental forms is opened, and the program is closed (the
close button on access itself is clicked), it comes up with an error and
prompts you to either close or debug the code. no matter which option you
chose, it will close the whole program anyway. any ideas?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200512/1
Dec 6 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Br
ka******@comcast.net via AccessMonster.com wrote:
i have a db that i'm trying to finalized so i can get it out to 3
other
branch offices. when i was testing it, i found an error that i don't
know how to describe well, let alone fix. basically, i have one form
that i use to open all the other forms for the db. this one form,
formlauncher, goes visible=false every time another form opens, and
in the closing codes of the various other forms and reports is set to
visible=true again. the problem is, when one of the incidental forms
is opened, and the program is closed (the close button on access
itself is clicked), it comes up with an error and prompts you to
either close or debug the code. no matter which option you chose, it
will close the whole program anyway. any ideas?


Why not just close and reopen the form when needed?

Your code that runs when whatever form is closed must be causing the
problem. It would be helpful showing us the code.

You should have some error trapping code in it too. If you want to
"cludge" it put "On Error Resume Next" in the code (but that's bad
programming).
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response
Dec 7 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.