Recent content by kk45

Now I get your point :). To be honest I'm getting confused when I need to use variables and controls in SQL statement because of " and ' position. I think I learned the lesson anyway so do not go too hard on pr2... and thanks to you too for trying. I promise your efforts won't go wasted :D...

Thanks a lot indeed pr2-eugin!!! I lost a lot of time trying to move/add " and ' arond the statement without any result and it was so..... clean & easy. Thanks a lot again for your time!! kk

Sorry plog but I do not get your point. The exact SQL is what it is written in the string: delete all the record from the table <<tblCheckDoubles>>. As far as I can see the difference is just this part of the code << & "'" & strTempTbl & "'">> which means the variable which identify the table...

Hi, I'm trying to run this very very simple code but I get a Run-time error '3450' Syntax error in query. Incomplete query clause. For sure the problem is the variable I used as Table parameter but I cannot understand where my error is :banghead:: Private Sub cmdRunCheck_Click() Dim strSQL...

Hi, I've been using Access for years but I'm quite new to VBA and now I've decided to improve this side of me :confused::banghead: Hope to get some help from you without being a nuisance!!:D Please do not be too hard on me;) Thank you! kk