Recent content by curscascis

Haha, TempVars are good indeed. MissingLinq, it seems as though you were the missing link in this problem.

I always backup everything I do, even the unimportant things. And I discovered how to delete duplicates after come clicking around. Thanks alot you have been very helpful!

Don't forget to either make the variable Public or make the module Explicit when declaring it another module.

Not sure if this helps, but can you just add an Exit Loop after the if? --------------------------- msdn dot microsoft dot com/en-us/library/t2at9t47.aspx Here is some sample code that may help 'This function Exports the Staging table as a Hobsons Load File with an increment to prevent...

I am no expert, but updating a table with those values and holding them there till the application is closed could also help. Another more difficult solution is to export the data to a temporary file and access the information whenever needed, and later the file could be erased using KILL i...

Alright well let me explain something else. So there are two tables dealing with the records (plus one for errors). One of the tables is the main storage of the imported files. Then there is another table the has the same fields but is temporary and only holds the current "run" of files...

Hey guys I need some suggestions. I am new to the world of VBA and access but I've gotten a more than adequate grasp over the last two months. I currently need a way to check to see if a a field already exists. To be exact I have an access application that imports data from multiple sources and...