Backup data

[Guest]

Good Morning!

User wants to backup the data each time they open the application and keep 3
lastest data. I'm naming the file, plus the timestamp (date, hour, minutes,
seconds). The syntax is below but Timestamp (hour,minutes,seconds) displays
all zero. Since file name is not unique it overwrites into old file. Any
suggestions will be appreciated.

File name created "FileName070313000000.mdb"

strBkp = strDir & "FileName" & Format(Date, "yymmddHhNnSs") & ".mdb"

 

[Marshall Barton]

Good Morning!

User wants to backup the data each time they open the application and keep 3
lastest data. I'm naming the file, plus the timestamp (date, hour, minutes,
seconds). The syntax is below but Timestamp (hour,minutes,seconds) displays
all zero. Since file name is not unique it overwrites into old file. Any
suggestions will be appreciated.

File name created "FileName070313000000.mdb"

strBkp = strDir & "FileName" & Format(Date, "yymmddHhNnSs") & ".mdb"

Use Now instead of Date
. . . Format(Now, "yymmddHhNnSs") . . .

 

[Guest]

Thanks Marshall. I've try the "Now" too but without the Format(Now,
"yymmddHhNnSs"). Works Great! Thanks again.