Access RunTime 2010 security settings - "The RunCommand action was canceled"

[dblaron419]

How can I change the security settings of Access RunTime 2010? We have an access database that users had successfully used when they had the full version of the Access program. They are now using Access 2010 RunTime, and when they click on a specific button (which runs a few different macros) in the database, they receive a message that says "The RunCommand action was canceled." Are there any settings in Access 2010 RunTime that I can change (possibly in the registry) that will allow the RunCommand action to work and not be canceled?





Thank you for your help.

[Rawb]

The RunCommand isn't getting cancelled solely because the users have the RunTime. There's got to be something else going on behind the scenes. . .

What is the VBA code behind the Command Button?

[dblaron419]

Thank you for your reply.

Here is the code that runs when the user clicks the button to open the form. From what I can understand, the code runs after the form opens.

Private Sub perform_filter_Click()
On Error GoTo Err_changepart_Click
    Dim DocName As String, LinkCriteria As String
    
        
    DocName = "frm_filter_part"
    DoCmd.OpenForm DocName, , , , acFormEdit
    DoCmd.RunCommand acCmdFilterByForm
Exit_changepart_Click:
    Exit Sub
Err_changepart_Click:
        MsgBox Err.Description
        Resume Exit_changepart_Click
End Sub

Thank you again for your help.

[Rawb]

From what I see here, it's most likely a problem with the "On Open" or "On Load" events of the Form frm_filter_part. If the Form encounters an error while loading, it can cancel the remaining actions of the script, thus generating your error.