Recent content by Riya

I don't quite get that fname2 is picking up a file name. take a look at the codes below might give a better understanding. sorry i am not a coder.... Private Sub ImportLogs_Click() Dim a As Date, fname1, fname2, d As String, sqltxt As String DoCmd.SetWarnings False For a = Me.StartDate To...

I have a couple of queries & trying to import my log details into an access table. On running the following it stops at the point below & gives me the above error. DoCmd.TransferText acImportDelim, "Logs Import Specification", "tmp Temporary File", fname2, 0 please help!!!! Riya