Recent content by Blakey100

I've done some furhter debugging and found that the NAMES table was the cause of the problem. By enclosing every reference to NAMES in square brackets, Access is no longer confused. As it's not my database so I can't rename the tables. USe of aliases may be OK too; I didn't try.

Thanks. Unfortunately ADOX is not installed on the server I'm using. I'll pursue that separately! Further investigation shows that there seems to be a fundamental problem every time I attempt any type of join between tables. Single table queries work OK. I created the code below and always...

Wow, that was a quick response! I've included all the code leading up to opening the recordset. Most of it is just fiddling around with form labels etc to make things look pretty. Thanks! Dim cnn As ADODB.Connection Set cnn = CurrentProject.Connection 'cnn.Open...

Do you have nay ideas why a query that works OK by itself, fails when opened as a recordset in VB? I have an MS Access query that references some fields on a form as criteria. When I run the query directly (as a query), with the form open, it performs perfectly. When I attempt to open the...