Search results

Every table and form I have added have both but I inherited the db from someone else and its huge! I am slowly going through getting things sorted! I shall do so before posting a request for help though as I forget I only find it easy to read because I have been staring at it for months!

Youre right I am confusing myself! Right I have got the select statement working correctly as follows for anyone who is interested. One of the problems was I used ' instead of # for a date field! strSQL = "" strSQL = strSQL & " SELECT Paint_Orders.Paint_Order_ID, " strSQL = strSQL & "...

I had the table and fields the wrong way round! :o That fixed I still have the same error message but much tidier code: strSQL = "" strSQL = strSQL & " SELECT Paint_Order_ID.Paint_Orders " strSQL = strSQL & " , Paint_Order.Paint_Orders " strSQL = strSQL & " FROM Paint_Orders " 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...

Thanks! First block works a treat! Exactly what I wanted thanks!

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