Search results

Hi, I have a table with login info, and i'm trying to find the latest login per account. table Ex. AccNum UserID Login_Time 123 m 7/19/2010 123 v 7/20/2010 111 a 1/2/2010 222 q 7/20/2010 333 b...

Hi, I use a madule to import multiple txt files... Is there a way to import a file and at the same time extract part of the file name to populate a column? All the files i'm working with have the following format: FileNameMM-DD-YY.txt ex. XYZ07-19-10.txt XYZ07-20-10.txt XYZ07-21-10.txt...

Hello, I'm using a module i had for an access 2003 DB using ".FileSearch" property, but my computers at work have upgraded to access 2007. Could some body please help me convert this section of code to work on 2007? This is the error msg i get when i use my current code. "You entered an...

I have to import a txt file into a DB to track trends. Below is an example 1 (attached) of the layout of the file. When I import the file the data transfers without a problem. The only thing is that there is a “Batch” column which as the data which is different as the txt file loads. I have been...