Backup data

S

skk

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"
 
M

Marshall Barton

skk said:
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"
Click to expand...


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

skk

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