dailymeat
asked on
Snapshot Format rename
I have this report "CustomerSalesmanCompariso nWeekly" that I file in a folder in Snapshot Format
DoCmd.OutputTo acReport, "CustomerSalesmanCompariso nWeekly", "SnapshotFormat(*.snp)", "\\Server1\Daily\salesweek ly\salesma nreport3.s np", False, "", 0
Instead of having to write the code to name each salesman report number(e.g. 3) , I will like to change the name according to the number in :
[Forms]![CustomerSalesmanC omparisonW eekly]![Te xt37]
DoCmd.OutputTo acReport, "CustomerSalesmanCompariso
Instead of having to write the code to name each salesman report number(e.g. 3) , I will like to change the name according to the number in :
[Forms]![CustomerSalesmanC
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you