SetWarnings in 2007 Macro
Any idea of an alternative way to do the same functions like SetWarnings in X2007?
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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
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
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.
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.SourceObject = MonthwiseRep
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
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.
All Office 2007 applications are fully updated