Recent content by jackadams

I have found out that there are extreme highs and extreme lows when programming... where is the in between?

jdraw, fixed the issue! After hours of tooling around, I solved the issue. I had to change the following code in order for it to function properly... I will see if it works tomorrow! FROM SourceFile = Dir(strPath & "\SG*.txt") TO SourceFile = Dir(strPath & "\" & "*.txt")...

The database and the file are still in the same location that they were last night. I also put in a user select option so that if the files move, the user will select the directory where they put the SoureFile. The outer loop searches for all files starting with SG and ending in .txt. When I put...

jdraw, Thank you for the tips. First, this is a test database with all information backed up to a different location. Secondly, I turned off the warning messages because in the various SQL statements, it deletes all the information in my TEMPORARY tables and the rewrites information from a...

PLEASE HELP!!! Error 53 / File Not Found Hello everyone. I had this code working last night, but then I closed the database and now it will not open the appropriate file for processing... Here is the code that was working... The line where it states the error is in red font below...

Just wanted to introduce myself. I have been programming for a few years now... off and on for 15 years. I have been programming in Access for the last 4 years and now recently and been using SQL queries inside of the VBA code to manipulate data.