Search results for query: *

Hi. I changed the code to the following and now working great!! If Not (Me.RLCatssubform1.Form.Recordset.EOF And Me.RLCatssubform1.Form.Recordset.BOF) Then If MsgBox("Are you sure you want to Delete?", vbYesNo) = vbYes Then SQ = "DELETE FROM dbo_COMPLIANCE_RESTR_CATEG WHERE ID = " &...

If Not (Me.RLCatssubform1.Form.Recordset.EOF And Me.RLCatssubform1.Form.Recordset.BOF) Then If MsgBox("Are you sure you want to Delete?", vbYesNo) = vbYes Then CurrentDb.Execute "Delete from dbo_COMPLIANCE_RESTR_CATEG " & _ "where ID=" & Me.RLCatssubform1.Form.Recordset.Fields("ID")...

ok, now I have a similar problem with the code below. If Not (Me.sfRULENOTE.Form.Recordset.EOF And Me.sfRULENOTE.Form.Recordset.BOF) Then If MsgBox("Are you sure you want to Delete?", vbYesNo) = vbYes Then CurrentDb.Execute "Delete from dbo_COMPLIANCE_ACCT_NOTE where ID=" &...

All the tables have primary keys... sorry. The problem with this was permissioning on the sql server. Thank you for your help.. it really is appreciated!!

Dim strSQL As String If IsNull(Me.Text18) Then MsgBox "Note not entered!" Cancel = True Exit Sub Else: End If strSQL = "Insert Into dbo_COMPLIANCE_ACCT_NOTE(ACCT_CD, ACCT_NOTE) Values ('" & Me.cboAcName & "','" & Me.Text18 & "')" Debug.Print strSQL...

adding dbseechanges corrected the problem thanks. What is TGML?

If Not (Me.sfCategory.Form.Recordset.EOF And Me.sfCategory.Form.Recordset.BOF) Then If MsgBox("Are you sure you want to Delete?", vbYesNo) = vbYes Then CurrentDb.Execute "Delete from dbo_COMPLIANCE_CATEG " & _ "where ID=" & Me.sfCategory.Form.Recordset.Fields("ID") Me.sfCategory.Form.Requery End...

I updated the code to add dbFailOnError + dbSeeChanges to the delete statement and it works...

run-time error 3622: You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an identity column. I have the following code and am getting the above error. I am accessing SQL Server Tables. (this worked when using local tables) Can anyone help...

Thanks! They just needed data...

no, not all of them.

If created an ODBC connection to some SQL Tables and created forms from the fields on these tables. When I select form view or even layout view the form appears totally blank. These forms worked when they were connected to local tables. I do see the tables in the 'tables' section in Access...

I"m not sure I understand the question then. I have a database that has no relationships or joins to the access database I am in. There is a stored procedure that I want to trigger to create a view from that database. The view is created put on the server where the access database has...

I want to run a stored procedure (already created) from another database server. This SP creates a view that will then kick off another SP (already created) that refreshes data in my access DB.

I want to be able to create a 'button' that, when clicked, will pull data from a view created from SQL Tables and update fields in Access. is this possible? It will always be the same fields from the View updating the same fields in the tables. thanks!!!

It was the use of the column name 'Note'. I changed the column name to 'RuleNote' and it works great! thank you!!

However, this works... CurrentDb.Execute "Insert Into RulesNotCrD(AccountName) Values ('" & Me.cboAcName.Value & "')

Thank you!! Just tried. Same exact error... wierd...

I can't for the life of me figure this out. The syntax looks good to me. Any help would be appreciated. thanks CurrentDb.Execute "Insert Into RulesNotCrD(AccountName, Note) Values ('" & Me.cboAcName & "','" & Me.Text18 & "')