Search results

Thanks, single quotes as in ' ? After I change these to single quotes then it is no longer a valid sql code in access..... are there ways to work around it? I appreciate it.

thank you!

I'm trying to compile the below code, however something seems wrong and I can't tell what... can some one tell me whats wrong? The error I'm receiving is "end of statement error". Update: sqlqry points to a sql code here, which is copied from an Access query and the code itself runs fine in...

Thanks for the quick response, for the "INSERT INTO...." code would I do the same for "JohnDoe_field" part as well? ie. is " & prs & "_field the correct way to replace JohnDoe here?

I would really appreciate it if anyone could help me with the below task. I have some experience in VBA but very little with Access. The challenge I face right now is to use an index of names (in excel field) to repeatedly create reports and queries with each of these names. The reports and...