Guys, I really appreciate the help. Bear with me just a bit longer. I think I'm making some progress because I'm now getting a different error. It's happening at the...

Thanks for the response. I've run into a problem though. I'm getting this error and I don't know why. What's wrong.

ADODB.Recordset (0x800A0E78)

Operation is...

JeffB, and all the rest. Thanks for the help you all provided me in my efforts to understand using stored procedures. It's very much appreciated!

Okay, this is where I get confused. I thought that the parameters @UserName and @Password were all I needed. What value would I need to pass to adocmd.CommandType = adCmdStoredProc? Would...

Sorry about not responding sooner. I was away from my PC over the weekend. But thanks for the response you sent. It really proved helpfule. Using what you mentioned I'm...

Thank you very much for the reply!! Can I ask another question? You know how in access you can use the FORMAT feature in the query to change a date...