E
enrico via AccessMonster.com
how do you use Debug.Print sSql on checking the error of your code?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Stefan Hoffmann
hi Enrico,
Dim SQL As String
SQL = "build your statement..."
Debug.Print SQL
CurrentDb.Execute SQL, dbFailOnError
And in the case of an error, I simply copy the SQL statement from the
immediate window, create a new query, switch to the SQL view, paste it
and troubleshoot it.
mfG
--> stefan <--
e.g.how do you use Debug.Print sSql on checking the error of your code?
Dim SQL As String
SQL = "build your statement..."
Debug.Print SQL
CurrentDb.Execute SQL, dbFailOnError
And in the case of an error, I simply copy the SQL statement from the
immediate window, create a new query, switch to the SQL view, paste it
and troubleshoot it.
mfG
--> stefan <--
E
enrico via AccessMonster.com
i already tried it but it still doesn't show on my screen
J
June7 via AccessMonster.com
Put a breakcode on the line following the Print.Debug. This will stop code
running and allow you to see in the Immediate window the string you built.
running and allow you to see in the Immediate window the string you built.
J
June7 via AccessMonster.com
Make sure you have the Immediate window on. Menu/View/ImmediateWindow