Command Button - Date stamp

[learning_codes]

Hi,

I am able to export the data to DBASE file that create "Date stamp,
Time and the name of the file".dbf

TEXT83 = Time()

Me.cbo_Upload_DT & " ( " & Me.Text83 & " ) " & "- ( " & Me.CBO_TYPE &
" )" & " - type_1000.dbf", False

The result is: 11_05_2007 - 10_30_04 AM - ( Q ) - TYPE_1000.DBF
************************************************************************************************

I tried to do the same thing with excel spreadsheet but it won't allow
because of "/", ":", etc. Is there a way to convert similar idea as
dbf file.

Your help would be much appreciated.

Thanks

 

[Douglas J. Steele]

Use the Format function to present the date and time in a manner that's
acceptable. For example, you can format the time as Format(Time(),
"hh\_nn\_ss")