Search results

True, the PARAMETERS section is not needed, but I like to be complete. With defined and typed parameters, passing improper types to the parameters will fail in the code instead of during the query execution. With CurrentDb.CreateQueryDef(vbNullString, _ "INSERT INTO tblTransactions " &...

I always try to use parameters, they allow me to lock down the types and values being passed to the query. ' Using Value for TheName parameter to allow Null With CurrentDb.CreateQueryDef(vbNullString, _ "PARAMETERS " & _ "[AccountID] Long, [TheName] Value, " & _...

I may be late to this thread, but I got this simple code from the spreadsheet guru blog which works well. ' Copy StoreText if not emplty to clipboard and return vbnullstring ' Return clipboard text if StoreText is empty ' Early bind using ref to Microsoft HTML Object Library Public Function...

I graduated from UW Oshkosh with a computer science degree in 1985. Since then, I have been working in the family business handling ID, mechanical and electrical engineering and compliance. My professional experience started with DOS based programs using C, and AutoLisp to automate AutoCAD, then...