Topics Search

SetWarnings macro command in Access 2010

SetWarnings macro command in Access 2010
Views: 162
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?
Sponsored Links:

More topics

 

Access 2010 Macro

Preview
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
 

Access 2007 macro RunCommand

Preview
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 in 2007 Macro

Preview
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?
 

Sendkeys replacement

Preview
I am trying to find an alternative to the sendkeys macro command. I am using this command to invoke the tab key (sendkeys {tab}) to move focus to the next object in a form. The template I developed worked fine in Access 2003 and 2007, but when I started using Access 2010, this command turns off the numeric locks (on a periodic basis). In reading results of Google searches, it is recommended to avoid the sendkeys command since it has known issues, but I have not found a good alternative. I use this macro in several places in several forms, so I prefer to continue to use a macro or VBA code I can refer to in the form instead of using another command that would be control specific such as the GoToControl command
 

2 things - SetWarnings? and Running a saved Import

Preview
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
 

View Macro Result in subform

Preview
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

Me!Child21.SetFocus
DoCmd.SetWarnings False
Me.Child21.SourceObject = MonthwiseRep
DoCmd.SetWarnings True
Me.Child21.Requery
 

2007 to 2010 macro won't work

Preview
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
 

Loop in access 2010 macro

Preview
I am trying to create a macro to loop through all the records in a form and replace a number field until it hits a record with a specific entry.
I am unable to find the command in the macro drop-down box. The command I am looking for is Do Until.
I would prefer to work through macros rather than in VBA as I don't know how to program using VBA
 

Access 2010 - Creating a Data Macro

Preview
Office 2010 Developer Training Course > Access 2010 > Building Solutions with Access 2010 Lab using the Contacts Web Database template.

I'm at Exercise 4: Creating a Data Macro and for whatever reason my macro is not working at all.

I created the macro and confirmed it matched to the guide and I had no errors when I saved it, so that has to count for something.

The macro is suppose to be invoked when the 'Status' variable is "Offer Outstanding" more than once in the database.

Yet I can select it multiple times without any instances of the macro displaying any warning message as it should.
 

SetWarnings Macro Action

Preview
You can use the SetWarnings action to turn system messages on or off.