Recent content by panyd

Hey, I'm trying to add a search bar to a form which is linked to multiple tables. I've got it so that it will go to some records but not all of them when you select them. Anyone have any ideas? Code: Private Sub Combo89_AfterUpdate() 'Moves to Customer Name text box and 'finds the...

When I do that I get the error message: 'Run-time error '3075': Syntax error in string in query expression '[Master Query beta 1].[ID]= DATE() & " & DATE()-1;'. Any idea why? Thank you so much for the assistance

Is it possible for me to run more than one of these queries in a single module/button? If it is, how would I tell VBA that one query had ended and another one was going to begin?

It works! Please be assured that if you guys were here I would kiss you.

If I have the SQL as follows then I get the error message "Run-time error '3134' Syntax error in INSERT INTO statement" INSERT INTO [Merchant CCF]([Merchant Name][Merchant Type][Partner][Merchant Sector]) SELECT ([Merchant Name,[Merchant Type],[Partner],[Merchant Sector]) FROM [Main Table]...

Sorry scrap that again. Now it's telling me that I have an incomplete query clause

Sorry, scrap that. Now it says: "Error - 3134 Syntax error in INSERT INTO statement"

Now that I've done that I'm getting "runtime error = 3075 Syntax Error (missing operator) in query expression '([Merchant Name][Merchant Type][Partner][Merchant Sector])'." Thank you both so much for your patience in helping me deal with this. I really appreciate it.

Hey, I'm trying to create a code which selects some records from one table and posts them into another. I'm a complete beginner at this but I've managed to get this far: Private Sub Command83_Click() Dim strSQL As String Dim strCriteria As String strSQL = "" strSQL = strSQL & " INSERT INTO...