Results 1 to 2 of 2
  1. #1
    sra2786 is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Oct 2017
    Location
    Cincinnati, OH
    Posts
    38

    3270 Property Not Found in command button to Save Changes

    I am getting the error 3270 Property Not Found in my command button to Save changes. If I click the "pencil" icon to save the changes in my form, I do not get the error. To bypass the error 3270, I have code "On Error Resume Next". I do not know how to determine which property Access is complaining about. Is it okay to ignore this error?

    Here is the code in my
    Private Sub cmdSaveRecord_Click()
    On Error GoTo cmdSaveRecord_Click_Error


    DoCmd.RunCommand (acCmdSaveRecord)


    cmdSaveRecord_Click_Exit:
    Exit Sub


    cmdSaveRecord_Click_Error:



    Select Case Err.Number
    Case 3022
    MsgBox "Record already exists for this Railcar and Arrive Date"

    Case 3021
    MsgBox "No record found in datasheet."


    Case 3270
    On Error Resume Next

    Case Else
    MsgBox Err.Number & ": " & Err.Description
    End Select


    Resume cmdSaveRecord_Click_Exit


    End Sub

    Thanks.
    Sandy

  2. #2
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    I don't use this method, but try removing the parentheses
    DoCmd.RunCommand acCmdSaveRecord

    I test the form .Dirty property and set to False to save a record if need be

    Well, had to test and it appears either way works. By any chance is this code being called from another procedure even though it appears here that it is a button click? If so, the error may be occurring upstream.
    Last edited by Micron; 01-13-2019 at 02:04 PM. Reason: added info
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 12-08-2014, 05:35 PM
  2. Replies: 1
    Last Post: 12-28-2013, 12:38 PM
  3. Replies: 13
    Last Post: 12-17-2012, 07:52 PM
  4. Help Me! Save Record Command Button issue
    By gszdwml in forum Programming
    Replies: 1
    Last Post: 04-24-2012, 09:53 AM
  5. Replies: 3
    Last Post: 09-15-2011, 09:06 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums