Macro Question - Set Warnings (1 Viewer)

[durdle17]

Hi,

I have a macro setup that exports excel files to a network path. Each day when I run the macro its asks me to over-write the previous days file, I was wondering is there a way to prevent this prompt from appearing.

Thanks
Chris

 

[ColinEssex]

Check out the "kill" statement in Access help.

Col

 

[durdle17]

Hey,

The kill statement looks good but my command button is based on a Macro, so I am unsure on how and where to actually write the code?

chris

 

[ColinEssex]

Write the Kill statement in a function and call it first in the macro - then export the file.

Col

 

[durdle17]

hey colin,

I don't want to sound stupid, but how do you write the function, is it a module?
if yes, would you write the code in a module and then in the macro use the "OpenModule" option?

chris

 

[Mile-O]

You would write the function in a module.

To run it with a macro you would use the RunCode command.

And in the "code to run" box you call the function by name while also passing parameters (if any)

i.e

Code to run: FindBirthday(dteDateOfBirth)

where FindBirthday is the function name and dtDateOfBirth is an variable we are sending to it for the function's use.

 

[durdle17]

got it to work
thanks