Search results

Hi! This will have a simple solution (hopefully). I have a word document with bookmarks and VBA code to export records and place them within the bookmarks: Private Sub Labels_Click() Dim MyWord As Word.Application Dim PathDocu As String Set MyWord = New Word.Application PathDocu =...

Hi, I have code which sucessfully copies rows from a query to a table. What I want to do is update records in a table based on a query in another table. Can anyone convert the following SQL to do this: INSERT INTO Tbl_Paint_Order_Parts ( Paint_Order_ID, Part, Qty ) SELECT...

Hi, I simply want to copy the field Qty from Qry_Paint_Order_Parts to the field Qty in Tbl_Paint_Order_Parts where the records are joined by Part_No in both tables I use the following code: strSQL = "" strSQL = strSQL & " UPDATE Tbl_Paint_Order_Parts " strSQL = strSQL & " SET Qty =...

Hi, I am trying to copy records from an access query to a table. This is my code: strSQL = "" strSQL = strSQL & " INSERT INTO Tbl_Paint_Order_Parts (Paint_Order_ID, Part, Qty) " strSQL = strSQL & " SELECT Paint_Order, Part_No, Qty FROM [Qry_Sum_Rpt_Paint_Order]; " CurrentDb.Execute strSQL...

Hi, I have looked for solutions to this but can't find one that exactly matches it so here goes. With the following code I get the error 3061 - Too few parameters. Expected 2: Private Sub Command22_Click() Dim lngPaint_Order_ID As Long Dim strSQL As String Set rs = New ADODB.Recordset...

Sorry if this has been asked before I searched these forums and found nothing so hopefully I am not wasting anyones time! I am using Access 2007 and my problem is that I am trying to insert data into a table from both another table and a form using VBA. The Table in question is a link or...