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

replace query message prompts?

P: n/a
Hello,

I've got a "data import form" that is a simple dialog type form. On
the form is an "Import" button with code that runs several action
queries. The queries import data from an Oracle database into various
staging tables, then appends the data to the main tables in the
database. Currently, the user has to click yes on all of the query
prompts (e.g. "are you sure you want to run this type of action
query?" and "are you sure you want to create a new table with the
selected records?", etc.

1. Is there a way to code this so the user doesn't receive all of the
messages prompting for a yes answer. The default will always be yes.

2. Instead of seeing all of the prompts, how would I put just one
message with an hour glass saying, "import process running" Then
another that says, import process complete?

Thank you for your help.
Aug 11 '08 #1
Share this Question
Share on Google+
3 Replies


P: n/a
WPW07 wrote:
Hello,

I've got a "data import form" that is a simple dialog type form. On
the form is an "Import" button with code that runs several action
queries. The queries import data from an Oracle database into various
staging tables, then appends the data to the main tables in the
database. Currently, the user has to click yes on all of the query
prompts (e.g. "are you sure you want to run this type of action
query?" and "are you sure you want to create a new table with the
selected records?", etc.

1. Is there a way to code this so the user doesn't receive all of the
messages prompting for a yes answer. The default will always be yes.

2. Instead of seeing all of the prompts, how would I put just one
message with an hour glass saying, "import process running" Then
another that says, import process complete?

Thank you for your help.
Docmd.SetWarnings False
docmd.openquery
Docmd.SetWarnings True
Aug 11 '08 #2

P: n/a
On Aug 11, 12:29*pm, Salad <o...@vinegar.comwrote:
WPW07 wrote:
Hello,
I've got a "data import form" that is a simple dialog type form. *On
the form is an "Import" button with code that runs several action
queries. *The queries import data from an Oracle database into various
staging tables, then appends the data to the main tables in the
database. *Currently, the user has to click yes on all of the query
prompts (e.g. "are you sure you want to run this type of action
query?" and "are you sure you want to create a new table with the
selected records?", etc.
1. *Is there a way to code this so the user doesn't receive all of the
messages prompting for a yes answer. *The default will always be yes.
2. *Instead of seeing all of the prompts, how would I put just one
message with an hour glass saying, "import process running" Then
another that says, import process complete?
Thank you for your help.

Docmd.SetWarnings False
docmd.openquery
Docmd.SetWarnings True


Thanks for your reply. If I turn the warnings off, is the default
answer always yes to the warning prompts?

Aug 11 '08 #3

P: n/a
On Mon, 11 Aug 2008 10:02:17 -0700 (PDT), WPW07 wrote:
On Aug 11, 12:29*pm, Salad <o...@vinegar.comwrote:
>WPW07 wrote:
>>Hello,
>>I've got a "data import form" that is a simple dialog type form. *On
the form is an "Import" button with code that runs several action
queries. *The queries import data from an Oracle database into various
staging tables, then appends the data to the main tables in the
database. *Currently, the user has to click yes on all of the query
prompts (e.g. "are you sure you want to run this type of action
query?" and "are you sure you want to create a new table with the
selected records?", etc.
>>1. *Is there a way to code this so the user doesn't receive all of the
messages prompting for a yes answer. *The default will always be yes.
>>2. *Instead of seeing all of the prompts, how would I put just one
message with an hour glass saying, "import process running" Then
another that says, import process complete?
>>Thank you for your help.

Docmd.SetWarnings False
docmd.openquery
Docmd.SetWarnings True

Thanks for your reply. If I turn the warnings off, is the default
answer always yes to the warning prompts?
There are some things you can do for yourself.
If you had taken just a moment to try this you would not have to wait
for an answer.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Aug 11 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.