Search results

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...