Recent content by kebert111

Follow-up Question I tried the below, but am getting an Run Type error '13' - Type Mismatch error on the else statement. Any suggestions? Dim mVar As Date If Weekday(Now()) = 2 Then mVar = Format(Now() - 3, "yyyymmdd") Else mVar = Format(Now() - 1...

I am using the following VB Code to import a file into Access. The problem is that if we run this on Monday, the file we are trying to import in from Friday (and therefore is not Date - 1). Do you know how I would go about importing Friday's file? DoCmd.TransferText acImportDelim, "Test...

I am using the following VB Code to import a file into Access. The problem is that if we run this on Monday, the file we are trying to import in from Friday (and therefore is not Date - 1). Do you know how I would go about importing Friday's file? DoCmd.TransferText acImportDelim...