Backup data

  • Thread starter Thread starter Guest
  • Start date Start date
G

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"
 
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") . . .
 
Thanks Marshall. I've try the "Now" too but without the Format(Now,
"yymmddHhNnSs"). Works Great! Thanks again.
 
Back
Top