Useful code Snippets (1 Viewer)

[Uncle Gizmo]

If you spot any code which you think is very useful, then please add it to this thread. This thread is a Sticky in the Modules & VBA Section

 

[Uncle Gizmo]

This Function "SQLFix()" is an excellent piece of code from ArnelGP. It takes a variant, and this can be anything I understand and then converts it into a string suitable for putting into an SQL Statement.

HELP! - Run-time error '3034': Syntax error in insert into

Can anybody eyeball something that I can't see??? MySql = "INSERT INTO All2 (LoanType, Street, Unit, City, State, Zip, Borrower, Vendor, DateRecd, Wholesaler, Processed, " & _ "UploadID, Result, Latitude, Longitude, ZillowID, Zestimate, ZRestimate...

www.access-programmers.co.uk