think I might be onto the problem..... in researching the error with currentproject.connection I'm seeing that it "might" have something to do with the connection to the database. I found...

just as an aside, I attempted to do this through pure SQL with this:

Public Sub Doit()

Dim strSQL As String

strSQL = "SELECT requests.lastname, requests.firstname, requests.star, requests.seniority_dt, requests.reqdate,...

wow...

I can't begin to tell you how much I appreciate the time you must have spent figuring this all out.

If this is what it takes to accomplish the task I...

and as I stare at that code I see it is nowhere near doing what I thought.

And I then tried this:

Public Sub Run_Click()

Dim strSQL As String

strSQL = "SELECT Requests.REQDATE, Requests.REQTIME " & _

"FROM Requests;"

...

arghhh.... so since I apparently can't call a module from inside an On-click sub I decided to insert the two routines into the same sub:

Public Sub Run_Click()

Dim strSQL As String

strSQL...

ok that got me closer!

It attempts to run but I get a Compile error:

Expected variable or procedure, not module.

Ok, still a bit stymied. I have 2 Modules:

FindTop2:

Public Sub FindTop2()

Dim strSQL As String

strSQL = "INSERT INTO Assignments " & _

...

taking a break... I'm tryin' to do as much of this as I can without bothering you guys to design specific code for me.

I now have two modules, one that...

Hey thanks for taking a look.... if I understand your first link correctly you want to see the SQL for the table creation, some sample data and what I need...