A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

********************** Action Query Assistance ****************



 
 
Thread Tools Display Modes
  #1  
Old February 27th, 2009, 01:14 AM posted to microsoft.public.access.conversion,microsoft.public.access.gettingstarted,microsoft.public.access.queries
Jasmine
external usenet poster
 
Posts: 155
Default ********************** Action Query Assistance ****************

I have a some action queries within macro that I want to execute,
but when I fire off the macro there's some informational messages
that I want to supress.

I want to eventually automate this process by calling a Vbscript in a daily
scheduler
( So I don't want any messages to stop the macro from processing )

I have office 2007.

I went to Access Option\Advanced
In the Confirm Section - I've already unchecked the - Action Query
so I wouldn't get any informational messages.

I don't know where I can disable these messages if it's already unchecked.

Please Help


  #2  
Old February 27th, 2009, 12:27 PM posted to microsoft.public.access.conversion,microsoft.public.access.gettingstarted,microsoft.public.access.queries
Douglas J. Steele[_3_]
external usenet poster
 
Posts: 3,143
Default ********************** Action Query Assistance ****************

Try turning the warnings off (using SetWarnings) before you run the queries.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Jasmine" wrote in message
...
I have a some action queries within macro that I want to execute,
but when I fire off the macro there's some informational messages
that I want to supress.

I want to eventually automate this process by calling a Vbscript in a
daily scheduler
( So I don't want any messages to stop the macro from processing )

I have office 2007.

I went to Access Option\Advanced
In the Confirm Section - I've already unchecked the - Action Query
so I wouldn't get any informational messages.

I don't know where I can disable these messages if it's already unchecked.

Please Help




  #3  
Old February 27th, 2009, 02:59 PM posted to microsoft.public.access.conversion,microsoft.public.access.gettingstarted,microsoft.public.access.queries
Jasmine
external usenet poster
 
Posts: 155
Default ********************** Action Query Assistance ****************

I am a novice here so where exactly do you I do this.
could you send me a printscreen of this , as I do not see
this

I do not see this SetWarnings anywhere.

Please help



"Douglas J. Steele" wrote in message
...
Try turning the warnings off (using SetWarnings) before you run the
queries.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Jasmine" wrote in message
...
I have a some action queries within macro that I want to execute,
but when I fire off the macro there's some informational messages
that I want to supress.

I want to eventually automate this process by calling a Vbscript in a
daily scheduler
( So I don't want any messages to stop the macro from processing )

I have office 2007.

I went to Access Option\Advanced
In the Confirm Section - I've already unchecked the - Action Query
so I wouldn't get any informational messages.

I don't know where I can disable these messages if it's already
unchecked.

Please Help






  #4  
Old February 27th, 2009, 03:31 PM posted to microsoft.public.access.conversion,microsoft.public.access.gettingstarted,microsoft.public.access.queries
Jasmine
external usenet poster
 
Posts: 155
Default ********************** Action Query Assistance ****************

Why is everything so complicated to explain sometimes I do not know.

I've solved my own problem.

Apparently there was a hidden option on the Macro design page.
when you right click on the Macro Ribbon there's an
option that says - show all Actions.

It's in there that the Setwarning lives - now you can say True or False

I hope all those people looking for this answer will be redeemed and not
being confused by all those techies that
just don't listen to us the regular users.







"Jasmine" wrote in message
...
I have a some action queries within macro that I want to execute,
but when I fire off the macro there's some informational messages
that I want to supress.

I want to eventually automate this process by calling a Vbscript in a
daily
scheduler
( So I don't want any messages to stop the macro from processing )

I have office 2007.

I went to Access Option\Advanced
In the Confirm Section - I've already unchecked the - Action Query
so I wouldn't get any informational messages.

I don't know where I can disable these messages if it's already unchecked.

Please Help





  #5  
Old February 27th, 2009, 03:32 PM posted to microsoft.public.access.conversion,microsoft.public.access.gettingstarted,microsoft.public.access.queries
Douglas J. Steele[_3_]
external usenet poster
 
Posts: 3,143
Default ********************** Action Query Assistance ****************

Sorry, no I can't send you a printscreen.

I don't have Access 2007 installed on this machine, so I can't check whether
it's necessary to click on the Show All Actions button to get SetWarnings to
appear in the list of available actions. (See what Jeff Conrad has at
http://accessjunkie.com/faq_02.aspx for instructions)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Jasmine" wrote in message
...
I am a novice here so where exactly do you I do this.
could you send me a printscreen of this , as I do not see
this

I do not see this SetWarnings anywhere.

Please help



"Douglas J. Steele" wrote in message
...
Try turning the warnings off (using SetWarnings) before you run the
queries.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Jasmine" wrote in message
...
I have a some action queries within macro that I want to execute,
but when I fire off the macro there's some informational messages
that I want to supress.

I want to eventually automate this process by calling a Vbscript in a
daily scheduler
( So I don't want any messages to stop the macro from processing )

I have office 2007.

I went to Access Option\Advanced
In the Confirm Section - I've already unchecked the - Action Query
so I wouldn't get any informational messages.

I don't know where I can disable these messages if it's already
unchecked.

Please Help








  #6  
Old February 27th, 2009, 04:55 PM posted to microsoft.public.access.conversion,microsoft.public.access.gettingstarted,microsoft.public.access.queries
BruceM[_2_]
external usenet poster
 
Posts: 1,763
Default ********************** Action Query Assistance ****************

You should know, if you do not already, that this is a volunteer newsgroup.
Nobody is trying to confuse you. The only reply you received before sending
this message was a suggestion to try turning off SetWarnings. It was a
brief reply, but hardly misleading. You received the reply about a half
hour after saying you didn't know how to get at SetWarnings. If you expect
immediate, detailed responses you should engage the services of a paid
consultant. If you intend to use this volunteer newsgroup you will have to
be patient, and you certainly should avoid blanket criticisms of "techies"
who try to help. Douglas is one of many experienced Access users who
respond regularly, on their own time, to a wide range of questions. A quick
review of postings from the past week or two will confirm this, and may help
dispel your impression that he and other "techies" don't listen to "regular
users" and are out to confuse you.

"Jasmine" wrote in message
...
Why is everything so complicated to explain sometimes I do not know.

I've solved my own problem.

Apparently there was a hidden option on the Macro design page.
when you right click on the Macro Ribbon there's an
option that says - show all Actions.

It's in there that the Setwarning lives - now you can say True or False

I hope all those people looking for this answer will be redeemed and not
being confused by all those techies that
just don't listen to us the regular users.







"Jasmine" wrote in message
...
I have a some action queries within macro that I want to execute,
but when I fire off the macro there's some informational messages
that I want to supress.

I want to eventually automate this process by calling a Vbscript in a
daily
scheduler
( So I don't want any messages to stop the macro from processing )

I have office 2007.

I went to Access Option\Advanced
In the Confirm Section - I've already unchecked the - Action Query
so I wouldn't get any informational messages.

I don't know where I can disable these messages if it's already
unchecked.

Please Help






  #7  
Old February 27th, 2009, 05:22 PM posted to microsoft.public.access.conversion,microsoft.public.access.gettingstarted,microsoft.public.access.queries
BruceM[_2_]
external usenet poster
 
Posts: 1,763
Default ********************** Action Query Assistance ****************

I should have said "you received another reply about a half hour after you
said you don't know how to get at SetWarnings". My point was that before
you receivd that reply you said you had figured it out on your own. That is
a very good thing, and worth stating without criticism of the answer(s) you
did receive.


"BruceM" wrote in message
...
You should know, if you do not already, that this is a volunteer
newsgroup. Nobody is trying to confuse you. The only reply you received
before sending this message was a suggestion to try turning off
SetWarnings. It was a brief reply, but hardly misleading. You received
the reply about a half hour after saying you didn't know how to get at
SetWarnings. If you expect immediate, detailed responses you should
engage the services of a paid consultant. If you intend to use this
volunteer newsgroup you will have to be patient, and you certainly should
avoid blanket criticisms of "techies" who try to help. Douglas is one of
many experienced Access users who respond regularly, on their own time, to
a wide range of questions. A quick review of postings from the past week
or two will confirm this, and may help dispel your impression that he and
other "techies" don't listen to "regular users" and are out to confuse
you.

"Jasmine" wrote in message
...
Why is everything so complicated to explain sometimes I do not know.

I've solved my own problem.

Apparently there was a hidden option on the Macro design page.
when you right click on the Macro Ribbon there's an
option that says - show all Actions.

It's in there that the Setwarning lives - now you can say True or False

I hope all those people looking for this answer will be redeemed and not
being confused by all those techies that
just don't listen to us the regular users.







"Jasmine" wrote in message
...
I have a some action queries within macro that I want to execute,
but when I fire off the macro there's some informational messages
that I want to supress.

I want to eventually automate this process by calling a Vbscript in a
daily
scheduler
( So I don't want any messages to stop the macro from processing )

I have office 2007.

I went to Access Option\Advanced
In the Confirm Section - I've already unchecked the - Action Query
so I wouldn't get any informational messages.

I don't know where I can disable these messages if it's already
unchecked.

Please Help







  #8  
Old April 17th, 2009, 12:19 PM posted to microsoft.public.access.conversion,microsoft.public.access.gettingstarted,microsoft.public.access.queries
[email protected]
external usenet poster
 
Posts: 2



"BruceM" wrote:

You should know, if you do not already, that this is a volunteer newsgroup.
Nobody is trying to confuse you. The only reply you received before sending
this message was a suggestion to try turning off SetWarnings. It was a
brief reply, but hardly misleading. You received the reply about a half
hour after saying you didn't know how to get at SetWarnings. If you expect
immediate, detailed responses you should engage the services of a paid
consultant. If you intend to use this volunteer newsgroup you will have to
be patient, and you certainly should avoid blanket criticisms of "techies"
who try to help. Douglas is one of many experienced Access users who
respond regularly, on their own time, to a wide range of questions. A quick
review of postings from the past week or two will confirm this, and may help
dispel your impression that he and other "techies" don't listen to "regular
users" and are out to confuse you.

"Jasmine" wrote in message
...
Why is everything so complicated to explain sometimes I do not know.

I've solved my own problem.

Apparently there was a hidden option on the Macro design page.
when you right click on the Macro Ribbon there's an
option that says - show all Actions.

It's in there that the Setwarning lives - now you can say True or False

I hope all those people looking for this answer will be redeemed and not
being confused by all those techies that
just don't listen to us the regular users.







"Jasmine" wrote in message
...
I have a some action queries within macro that I want to execute,
but when I fire off the macro there's some informational messages
that I want to supress.

I want to eventually automate this process by calling a Vbscript in a
daily
scheduler
( So I don't want any messages to stop the macro from processing )

I have office 2007.

I went to Access Option\Advanced
In the Confirm Section - I've already unchecked the - Action Query
so I wouldn't get any informational messages.

I don't know where I can disable these messages if it's already
unchecked.

Please Help







  #9  
Old June 11th, 2009, 05:27 AM posted to microsoft.public.access.conversion,microsoft.public.access.gettingstarted,microsoft.public.access.queries
LaToya
external usenet poster
 
Posts: 2


"
wrote in message
...


"BruceM" wrote:

You should know, if you do not already, that this is a volunteer
newsgroup.
Nobody is trying to confuse you. The only reply you received before
sending
this message was a suggestion to try turning off SetWarnings. It was a
brief reply, but hardly misleading. You received the reply about a half
hour after saying you didn't know how to get at SetWarnings. If you
expect
immediate, detailed responses you should engage the services of a paid
consultant. If you intend to use this volunteer newsgroup you will have
to
be patient, and you certainly should avoid blanket criticisms of
"techies"
who try to help. Douglas is one of many experienced Access users who
respond regularly, on their own time, to a wide range of questions. A
quick
review of postings from the past week or two will confirm this, and may
help
dispel your impression that he and other "techies" don't listen to
"regular
users" and are out to confuse you.

"Jasmine" wrote in message
...
Why is everything so complicated to explain sometimes I do not know.

I've solved my own problem.

Apparently there was a hidden option on the Macro design page.
when you right click on the Macro Ribbon there's an
option that says - show all Actions.

It's in there that the Setwarning lives - now you can say True or False

I hope all those people looking for this answer will be redeemed and
not
being confused by all those techies that
just don't listen to us the regular users.







"Jasmine" wrote in message
...
I have a some action queries within macro that I want to execute,
but when I fire off the macro there's some informational messages
that I want to supress.

I want to eventually automate this process by calling a Vbscript in a
daily
scheduler
( So I don't want any messages to stop the macro from processing )

I have office 2007.

I went to Access Option\Advanced
In the Confirm Section - I've already unchecked the - Action Query
so I wouldn't get any informational messages.

I don't know where I can disable these messages if it's already
unchecked.

Please Help








 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:59 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.