Recent content by tbiceps

Thank you Golom!

Is there a way to test a select query in vba or is design view/SQL view the way to go.

Thanks Golom and JerryKlmns, as usual, I try to overthink the problem.

How about this statement. I get a run-time error '2342' A RunSQL action requires an argument consisting of an SQL statement. DoCmd.RunSQL "SELECT t.[Report ID], f.[Full Field Name] FROM TESTTABLE t, TBL_FieldID f, TBL_Index i WHERE t.[Report ID]=i.[Report ID] AND f.[Field ID] = i.[Field ID]"

When I run the following SQL statement in the immediate window. I get the following error: The SELECT statement includes a reserved word or an argument name that is mispelled or missing, or the punctuation is incorrect. DoCmd.RunSQL " Select TESTTABLE t, TBL_FieldID f, TBL_Index i WHERE...

Thanks JerryKlmns, Using \\ServerName\Path is much simpler than what I had anticipated. Great help!

Thank you!

Here is another example: INTO TBL_Index ([Report ID],[Field ID]) VALUES " + "('" + RptValue + "') " + "('" + UniqueFieldID + "') "

I tend to have problems with syntax when mixing strings with variables. For instance, MsgBox "This is:" + variable gives me a type mismatch error or in a SQL statement. Can someone direct me to some Faq or other resource.

Thank you?

like this?

I notice when many members post code, they have a neat formatting trick which makes the code more readable on these post. Does anyone know how to perform that action.

Each solution works.

Thanks everyone!

This is SQL statement that I'm using in my code. RptValue, and X represent variable that I want to alter. This SQL statement will not put the constant into the SQL string. If I try to do something similar to the following ('RptValue','X')" then I get the words not values. Does anyone have a...