Topics Search

SetWarnings in 2007 Macro

SetWarnings in 2007 Macro
Views: 34
I want to use the "SetWarnings" action in a macro but I received a message of "The text you entered isn't an item in the list. Select an item from the list, or enter text that matches one of the listed items".
Any idea of an alternative way to do the same functions like SetWarnings in X2007?
Sponsored Links:

Similar posts...


2 things - SetWarnings? and Running a saved Import

2 things - SetWarnings? and Running a saved Import Icon
I'm using Access 2007 and two things I used to know how to do I have either forgotten or can no longer find.

From within a macro I used to "setwarnings" to off so I wouldnt keep having to click "yes" or "ok" - is there a different way of doing this from within a macro?

Secondly, I want to run a saved import from within the macro - any ideas?

Cant believe either of those is too hard

SetWarnings macro command in Access 2010

SetWarnings macro command in Access 2010 Icon
In Access 2010, while building a macro in design view, the SetWarnings action command is not available in the "Add New Action" drop-down menu. I can import a macro from an earlier version of Access and copy/paste the SetWarnings into my new macro, Is there a different command in Access 2010 or am I missingsomething?

2007 to 2010 macro won't work

2007 to 2010 macro won't work Icon
I had this problem (below) previously which you guys helped me with - the solution was SetWarnings to No - at the beginning of the macro. It worked in 2007 but I'm now on 2010 and I'm back to getting the "can't find the database file". Can anyone help please?
I have a macro that imports a number of files from one source and places them in a single table. Not all the files come in at the same time but I need to start processing the ones that I do receive as soon as I get them. Currently, if a file has not yet been filed into the source the macro stops. What I need the macro to do is . if x file isn't there - then continue. As I say the files come in over a period of days

Access 2007 macro RunCommand

Access 2007 macro RunCommand Icon
I have a Macro that in the old version I had several things going on like SetWarnings, Open and Close 2 queries then OpenModule and its command is MailMod and next statement was RunCommand with a command of Run

When I run the macro it loops through 20 times and give me a error that a Macro can only call itself a maximum of 20 times.

If I run the Bat file I get a error that The command or action “Run” isn’t available now.

SetWarnings Macro Action

SetWarnings Macro Action Icon
You can use the SetWarnings action to turn system messages on or off.

View Macro Result in subform

View Macro Result in subform Icon
I have created a macro name "MonthwiseRep" to view select query result in pivottable view which works fine when I run the macro.
But problem occurs,
if I wish to populate subform on a click of a button that I have on the main form with the same macro results as "MonthwiseRep" in pivottable view.

I tried the following code for click event of the command button but it didn't work

DoCmd.SetWarnings False
Me.Child21.SourceObject = MonthwiseRep
DoCmd.SetWarnings True

Access 2007 hates Access 2003 macros

Access 2007 hates Access 2003 macros Icon
I've made a database on access 2003 because I hate access 2007. I've put it onto our company server, and on an individual C:\drive on 1 pc to see if it s a server security message but it isnt.

Every time I run a macro, whether it be to move records or generate reports I get the message "RunMacro Action Was Cancelled". I've tried SetWarnings and obvioulsy I have a stop macro command built in, but I cant get rid of this message. Its more annoying than anything to be honest

Append query runs on its own but not in a macro

Append query runs on its own but not in a macro Icon
A database I created for a client some years ago has a macro which contains an append query. This macro repeats itself until a condition is met and has run thousands of times without any problem.

The client has asked that I make the database work for multiple factories. Without going into too much detail the same macro and append query are needed in the spin-off databases (one for each factory).

The problem is that the append query will not run in any of the spin-off databases as part of the macro although the macro itself is unchanged, but will run in isolation when it performs correctly and gives no error messages. I have run the macro with SetWarnings ON, but only get the warnings that you would normally expect.

I have pasted over the macro, the append query and the underlying select queries from the original database, but to no effect.

Access 2010 Macro

Access 2010 Macro Icon
I have an MS Access 2010 Database that will be run @ 6:00 AM Automatically. The Autoexec Macro has been created. the purpose of the Macro is to update a local table with data from SQL Server. In previous versions of Access I used setwarnings = off to accomplish this without user intervention. However in MS Access 2010 I don't find that option. Anybody know where it is or how I can accomplish this

SendObject in macro fails to open outlook

SendObject in macro fails to open outlook Icon
In one of my forms (access 2007) I have a button for sending emails to clients with outlook 2007. In the click event of the button I use a macro with the SendObject action. The macro works fine when it is used for first time. However, the next time I try to send an email the whole application (access 2007) freezes and I must use the task manager to close it.

All Office 2007 applications are fully updated