Recent content by anthonyk

I appreciate your guys time, and I knew the questions wern't difficult, but sometimes it easier to convice someone to take the time to write a nasty gram (that includes the help) then to simply help out. I took a chance and it worked. I hope I didn't upset anyone, and thanks again.

Thank You very much, that was exactly what I needed. You have a very nice day.

Okay, apparently I am asking questions that are too difficult to answer from persons in this forum, or simply, no one wants to answer my questions, but lets try a different one. Since I couldn't get an answer to the "Changing QueryDef with VBA in 2000" question, I went ahead and cheated. I...

I don't seem to be getting any replies on this, so let me see if I can help my self out a bit. Below is the exact Access 97 VBA code to make this work. Does anyone know the 2000 equivalent? Dim dbTest As Database Dim qdf As QueryDef Set dbTest = CurrentDb For Each qdf In...

I have an SQL Pass Through Query that I need to be able to changing the search parameter dynamically (this is Access 2000). I can not use the Access 97 code (does not work ) and the examples from Access 2000 also result in the same error (user-defined type not defined) Here is the SQL...