Recent content by ailinglew

Hi RuralGuy, Could i have your code to generate Testing.12345678 without any error? Thank you.

I've tried to create a simple module to generate output file (eg: Testing.1234) from a table. I get an error and highlighted on statement below when debugging. DoCmd.TransferText acExportDelim, "", "Testing", "C:\Testing.1234" Error: Run-time error '3027': Cannot update. Database or object...

Hi All, Could anyone tell me that Access 2007 able to create this kind of file (eg:Testing.0912080108)? If it is cannot, then i need to think other solution. Thank you.

Hi boblarson, This is the output file "Testing.0912080108" that the Access application need to be generated. We are using Access 97 to generate output file with this file type ".yymmddhh08" for a few years. Recently my company want to upgrade to Access 2007 and i found the error after...

Thanks for your reply. Yes, in Trusted Location. I would like to check with you, is that possible to generate output file as Testing.yymmddhh08 (eg: Testing.0912080108) in Access 2007? Actually the same coding use for Access 97 and it is working fine. The error happened after converted into...

Hi All, I have recently converted a database from Access 97 to Access 2007 which used the TransferText command. DoCmd.TransferText acExportDelim, "Testing Export Specification", "Testing", "C:\Testing" & "." & Format(Now(), "yymmddhh") & "08" - which worked fine. However, when I try to...