Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Setup / Configuration / February 2006

Tip: Looking for answers? Try searching our database.

Warning message with yes/no choice.  How to select yes automatical

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
John Melbourne - 25 Feb 2006 22:33 GMT
Dear user

I have a macro which contains a sequence of make table queries.  Whenever I
run the macro I have to select yes to a warning message choice for each make
table query.

The make table query involves deleting the old table before creating a new
one and it always asks if it is ok to do so?

I would like to be able to avoid answering yes or no to this manually.  I
have reason for using make table querys so I cant avoid the problem by not
using them.

I have looked for a macro action such as SetWarnings and SendKeys but to
resolved the problem but didnt find a solution there.

Suggestions are welcome.

Kind regards and thanks in advance
Signature

enruoblem

tina - 26 Feb 2006 04:22 GMT
you tried the macro action SetWarnings with the WarningsOn argument set to
No, and it didn't work for you? i tested it in an A2000 format db running in
A2003, and it suppressed the warning messages as expected. did you get an
error message of some kind? what version of Access are you using?

hth

> Dear user
>
[quoted text clipped - 15 lines]
>
> Kind regards and thanks in advance
John Melbourne - 27 Feb 2006 07:05 GMT
I'm using Access 2003 and I probably didnt use the SetWarnings action
properly when I tried it first.  Since then I did what you said and it
worked.  I also included another SetWarnings action at the end of the macro
to reset WarningsOn to yes again.

Thank you for your help
Signature

enruoblem

> you tried the macro action SetWarnings with the WarningsOn argument set to
> No, and it didn't work for you? i tested it in an A2000 format db running in
[quoted text clipped - 24 lines]
> >
> > Kind regards and thanks in advance
tina - 27 Feb 2006 17:53 GMT
you're welcome  :)

> I'm using Access 2003 and I probably didnt use the SetWarnings action
> properly when I tried it first.  Since then I did what you said and it
[quoted text clipped - 31 lines]
> > >
> > > Kind regards and thanks in advance
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.