Programming Forums - View Single Post

u2cannv · Oct 20th, 2007, 11:27 AM

Ive created a macro that should import/export a file based of certain criteria's: filename and filedate.
\\c\desktop\"johndoe" & Right("0" & Month(Date()), 2) & Right("0" & Day(Date()), 2) & Right(Year(Date()), 2) & ".txt
when i insert the code into the field "filename" using the action "TransferText" i receive the following errors: microsoft access cant parse the expression or filename has to end in .txt or .csv. can someone inform me as to whats wrong with the code?

Thanks

Oct 20th, 2007, 11:27 AM	#1
u2cannv Newbie Join Date: Oct 2007 Posts: 8 Rep Power: 0	Access Ive created a macro that should import/export a file based of certain criteria's: filename and filedate. \\c\desktop\"johndoe" & Right("0" & Month(Date()), 2) & Right("0" & Day(Date()), 2) & Right(Year(Date()), 2) & ".txt when i insert the code into the field "filename" using the action "TransferText" i receive the following errors: microsoft access cant parse the expression or filename has to end in .txt or .csv. can someone inform me as to whats wrong with the code? Thanks