Search results

Cheers will have a look and post how I get on! Unforunately I am using Access 2007 lots of ribbons and no recognisable menus!

The number of columns IS set to 7 and the maths is dead on. Access still prints on line per page. Even if the maths was slightly off I could live with it... The problem isn't that the report is slightly off its simply printing one line per page...

Also I set the template to 7 across (in access) and it only prints one column admittedly to the end of the recordset.

I did try it but the label I am using (Avery L4731) is not in Access only in word. The custom selection doesn't quite work properly where as the Word template I am using does.

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 =...

Oh good lateral thinking there!

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...

I have been advised to use the following code: strSQL = "" strSQL = strSQL & " UPDATE Tbl_Paint_Order_Parts " strSQL = strSQL & " SET Qty = ( SELECT Qry_Sum_Paint_Order_Parts.Qty FROM Qry_Sum_Paint_Order_Parts WHERE Tbl_Paint_Order_Parts.Part = Qry_Sum_Paint_Order_Parts.Part_No )" strSQL =...

Yep do exactly that!

Go into every query, table, form etc that the form gets its information from see if the same error comes up.

Whats the VBA code in the background?

This is my current code strSQL = "" strSQL = strSQL & " UPDATE Tbl_Paint_Order_Parts " strSQL = strSQL & " SET Qty = " & [Qry_Paint_Order_Parts].[Qty] CurrentDb.Execute strSQL

Ah sorry Ken didnt notice you had changed it! The new line of code gives me the error: Run-time error '2465': Microsoft Access can't find the field '|' reffered to in your expression.

Any ideas what it should be?

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 =...

Also why does it expect 2 parameters? Why not 3?

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...

How would I Do that? I tried using ADO but Access 2007 doesnt seem keen on it!

I am trying to insert data into a table. The data generates an autonumber. The code I am having an issue with is meant to find the record I just inserted, get the autonumber and use it to populate a link (reference) table. Its not based off a query its just a SELECT statement. Would it help...

Thanks for the advice! I am also still desperately struggling with the object required error!