Hi again everybody,
Thanks to a bit more Googling I was able to find a solution to this on The Access Web.
http://www.mvps.org/access/queries/qry0013.htm
In short my code now runs the Update query directly, instead of setting an SQL string in VBA.
Set qdf =...
Hi all,
Having an issue with runtime error 3061 when creating SQL in VBA. I've run
into this previously, where I need to pass parameters to my queries through
VBA and have overcome it in the past by recreating the SQL in VBA itself, so
that I can say "this is the value you want" and then use...