G
Guest
I know that you can export a report as a .snp using OutputTo, but is there a
way to have Access save the file to a specific location, but with a different
name for each file? I need to make backups of statements sent to customers in
case they don't receive them or dispute them, so I'm wanting to save a copy
of the statement as a .snp every time one is printed. But I want Access to do
this on it's own, using the account number of that customer as the filename
for the save. (I can do it manually, but I go through anywhere from 5 to 20
statements a day in addition to my other duties, plus I'm trying to make this
process easier in case someone has to do it when I'm not here.) I'm assuming
that I could use a function in the OutputTo statement to get the name, the
only question is how? My VBA skills are severely lacking, so any help is
appreciated.
way to have Access save the file to a specific location, but with a different
name for each file? I need to make backups of statements sent to customers in
case they don't receive them or dispute them, so I'm wanting to save a copy
of the statement as a .snp every time one is printed. But I want Access to do
this on it's own, using the account number of that customer as the filename
for the save. (I can do it manually, but I go through anywhere from 5 to 20
statements a day in addition to my other duties, plus I'm trying to make this
process easier in case someone has to do it when I'm not here.) I'm assuming
that I could use a function in the OutputTo statement to get the name, the
only question is how? My VBA skills are severely lacking, so any help is
appreciated.