Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. daveinchicago

    Run-Time Error 3622

    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")...
  2. daveinchicago

    Run-time error '3155' ODBC--insert on a linked table ... failed

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

    Run-Time error '3265' Item not found in this collection

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

    run-time error 3662

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

    Forms not displaying in 'Form View' with ODBC connection to SQL Table

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

    Accessing a 'View' to update tables in access

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

    Runtime Error 3134 Syntax Error in INSERT INTO statement

    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 & "')

Part and Inventory Search

Back
Top