asked on Error 3065 - Cant execute a Select Query
Experts,
What is Error 3065? Not sure what is setting off the error if it Appends correctly.
Thank you
![Error3065]()
What is Error 3065? Not sure what is setting off the error if it Appends correctly.
Thank you
Private Sub cmdNewProject_Click()
On Error GoTo EH
Dim rs As DAO.Recordset
Set rs = CurrentDb.OpenRecordset("select * from Projects where 1=0")
With rs
.AddNew
![Created By] = Nz([TempVars]![CurrentUserID], 0)
![Status2] = 7
![Currency] = DLookup("CurrencyID", "tblCurrencyExchange", "[Currency] = '" & Me.txtCur & "'")
![ProjectNo] = Me.txtActivityCode
![Project Name] = "LC Ref: (delete it after appending if want): " & Me.txtLCRef & ", Project Name: " & Me.txtActivityDescription
![Start Date] = Date
![Notes] = "****APPENDED LC FROM CSM*****: " & Format(Date, "m\/d\/yyyy") & ", Beneficiary :" & Me.txtBeneficiary & ", Guarantor: " & Me.txtGtorDescrip
.Update
End With
rs.Close
CurrentDb.Execute "qryUpdateProjID_tblLC", dbFailOnError CurrentDb.Execute "qryUpdateProjID_CSM2", dbFailOnError
DoCmd.OpenForm "frmUpdateBU"
Me.Refresh
Exit Sub
EH: 'Add error handling here
MsgBox "Error " & Err.Number & ": " & Err.Description
End Sub
Microsoft Access
Last Comment
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Actually, Joe, there were two queries on that line (way out to the right) that might be at fault.
CurrentDb.Execute "qryUpdateProjID_tblLC", dbFailOnError
CurrentDb.Execute "qryUpdateProjID_CSM2", dbFailOnError
So, either of those queries could be the "select" query.
If the OP is anything like me, he/she was testing one of the queries and changed it to a select, and then forgot to change it back to an Update query.
CurrentDb.Execute "qryUpdateProjID_tblLC", dbFailOnError
CurrentDb.Execute "qryUpdateProjID_CSM2", dbFailOnError
So, either of those queries could be the "select" query.
If the OP is anything like me, he/she was testing one of the queries and changed it to a select, and then forgot to change it back to an Update query.
ASKER
<he/she was testing one of the queries and changed it to a select, and then forgot to change it back to an Update query.
==>that is exactly what I did. I now understand the importance of naming a update qry with the word Update in the name. I found 2 more I forgot to change from a select.
thank you
==>that is exactly what I did. I now understand the importance of naming a update qry with the word Update in the name. I found 2 more I forgot to change from a select.
thank you
So ... then I was right ... a was my post ??
I pointed out first that you cannot Execute a select query.
ms
I pointed out first that you cannot Execute a select query.
ms
pdvsa,
Agree with, Joe. He is the one that pointed it out, I just piled on. He should get these points.
Click "Request Attention", bottom right corner of your original post, and ask the moderators to reopen the question so that you can award points appropriately.
Agree with, Joe. He is the one that pointed it out, I just piled on. He should get these points.
Click "Request Attention", bottom right corner of your original post, and ask the moderators to reopen the question so that you can award points appropriately.
ASKER
Sorry about that Joe...I requested attention
Details, details :-)
Open in new window
Click debug when you get the error message and post the line of code in your next comment.