replace query message prompts?

[WPW07]

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.

[Salad]

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

[WPW07]

On Aug 11, 12:29*pm, Salad <[e-mail]:

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?

[fredg]

On Mon, 11 Aug 2008 10:02:17 -0700 (PDT), WPW07 wrote:

On Aug 11, 12:29*pm, Salad <[e-mail]:

>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