Hello,
I have added a command to a form to open and close a query-make table but
when I run it, warning messages pop up. How can I remove those messages.
Please help
I have added a command to a form to open and close a query-make
table but when I run it, warning messages pop up. How can I
remove those messages.
Look at the code behind that command button (design view; select the command
button, View...Properties, Event tab. Click the build button(...) beside
the property named On Click that currently has [Event Procedure] in it.
Change the code
....
DoCmd.SetWarnings = False
<whatever code there is to run the query>
DoCmd.SetWarnings = True
....
If that isn't clear enough, post the code that you currently have.
--
Joan Wild
Microsoft Access MVP
Jay said:Hello,
I have added a command to a form to open and close a query-make table but
when I run it, warning messages pop up. How can I remove those messages.
Please help
Jay said:There are no codes behing the command I am trying to run. The warning
messages pop up when opening a make-table query. I want to use the
comand
on the form to run the query behind scenes but I do not want the users to
see
the warning messages because I am using the upated table to run a new
query.
Joan Wild said:Look at the code behind that command button (design view; select the
command
button, View...Properties, Event tab. Click the build button(...) beside
the property named On Click that currently has [Event Procedure] in it.
Change the code
....
DoCmd.SetWarnings = False
<whatever code there is to run the query>
DoCmd.SetWarnings = True
....
If that isn't clear enough, post the code that you currently have.
--
Joan Wild
Microsoft Access MVP
Jay said:Hello,
I have added a command to a form to open and close a query-make table
but
when I run it, warning messages pop up. How can I remove those
messages.
Please help
Joan Wild said:You said 'I have added a command to a form to open and close a query-make
table'
How exactly are you running this query from the form?
--
Joan Wild
Microsoft Access MVP
Jay said:There are no codes behing the command I am trying to run. The warning
messages pop up when opening a make-table query. I want to use the
comand
on the form to run the query behind scenes but I do not want the users to
see
the warning messages because I am using the upated table to run a new
query.
Joan Wild said:Look at the code behind that command button (design view; select the
command
button, View...Properties, Event tab. Click the build button(...) beside
the property named On Click that currently has [Event Procedure] in it.
Change the code
....
DoCmd.SetWarnings = False
<whatever code there is to run the query>
DoCmd.SetWarnings = True
....
If that isn't clear enough, post the code that you currently have.
--
Joan Wild
Microsoft Access MVP
Hello,
I have added a command to a form to open and close a query-make table
but
when I run it, warning messages pop up. How can I remove those
messages.
Please help
Jay said:I meant to say no visual basic code, I am running the query from the form
using a macro.
Joan Wild said:You said 'I have added a command to a form to open and close a query-make
table'
How exactly are you running this query from the form?
--
Joan Wild
Microsoft Access MVP
Jay said:There are no codes behing the command I am trying to run. The warning
messages pop up when opening a make-table query. I want to use the
comand
on the form to run the query behind scenes but I do not want the users
to
see
the warning messages because I am using the upated table to run a new
query.
:
Look at the code behind that command button (design view; select the
command
button, View...Properties, Event tab. Click the build button(...)
beside
the property named On Click that currently has [Event Procedure] in
it.
Change the code
....
DoCmd.SetWarnings = False
<whatever code there is to run the query>
DoCmd.SetWarnings = True
....
If that isn't clear enough, post the code that you currently have.
--
Joan Wild
Microsoft Access MVP
Hello,
I have added a command to a form to open and close a query-make
table
but
when I run it, warning messages pop up. How can I remove those
messages.
Please help
Joan Wild said:OK, then open your macro and use the SetWarnings Action (no), followed by
running the query, followed by SetWarnings Action (yes).
--
Joan Wild
Microsoft Access MVP
Jay said:I meant to say no visual basic code, I am running the query from the form
using a macro.
Joan Wild said:You said 'I have added a command to a form to open and close a query-make
table'
How exactly are you running this query from the form?
--
Joan Wild
Microsoft Access MVP
There are no codes behing the command I am trying to run. The warning
messages pop up when opening a make-table query. I want to use the
comand
on the form to run the query behind scenes but I do not want the users
to
see
the warning messages because I am using the upated table to run a new
query.
:
Look at the code behind that command button (design view; select the
command
button, View...Properties, Event tab. Click the build button(...)
beside
the property named On Click that currently has [Event Procedure] in
it.
Change the code
....
DoCmd.SetWarnings = False
<whatever code there is to run the query>
DoCmd.SetWarnings = True
....
If that isn't clear enough, post the code that you currently have.
--
Joan Wild
Microsoft Access MVP
Hello,
I have added a command to a form to open and close a query-make
table
but
when I run it, warning messages pop up. How can I remove those
messages.
Please help
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.