Search results

If I understand right, your "UniqueId" is a string. Thus, the last part of the line should be ... "UniqueId = '" & intUniqueId & "'". That's a single quote, ' , inside the double quotes. Also, good coding practice says the variable should be strUniqueId. As written, using an int prefix for...

Have worked with Access for years, mostly Access 97, some Access 1.0, 2.0, 2000, 2002, and now 2010. New to 2010, not having used Access much for several years. (C++ for the last 7) Discovered a few surprises with 2010. Some may be because I've got Ansi-92 switched on for SQL.