I have code that is saving my Access report as a PDF on local disk space.
Currently, when a user presses the save proposal button it overwrites any PDF that already has it's same file name. The user does not get the option to change the file name.
I would like to add some code that checks to see if the output file name already exists and if it does, ask the user if they'd like to overwrite the file or create a copy of it. If they choose copy it would concatenate a "copy of" to the beginning of the file (just like windows). I've provided my variables below.
dim outputfile as string
dim destinationpath as string
destnationpath = "c:\files"
outputfile = destpath & Forms!frmtabs!txtFilename & ".PDF"