Results 1 to 3 of 3
  1. #1
    nashr1928 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Apr 2010
    Posts
    146

    Command Button


    I am using access 2003 and for some reason I am having problems with a command button working correctly that I put on a form. I used the wizard and selected command button, Put it in place , then selected misc and then run query. I saved it and opened the form, selected the button and instead of opening the query, it opens Microsoft notepad. ?? I have never had this problem or seen this. Is there something known that causes this?

  2. #2
    nashr1928 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Apr 2010
    Posts
    146

    command button

    Private Sub Command51_Click()
    On Error GoTo Err_Command51_Click
    Dim stDocName As String
    stDocName = "Tax Information Query"
    DoCmd.OpenQuery stDocName, acNormal, acEdit
    Exit_Command51_Click:
    Exit Sub
    Err_Command51_Click:
    MsgBox Err.Description
    Resume Exit_Command51_Click

    End Sub

  3. #3
    nashr1928 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Apr 2010
    Posts
    146

    command button

    I found the problem. The command was duplicated and there was also a seperate commant for notepad. Not sure how that happened. Thanks for your response.....

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

Similar Threads

  1. Command Button
    By lannoe in forum Forms
    Replies: 1
    Last Post: 07-01-2010, 01:48 PM
  2. Command Button Question
    By Desstro in forum Forms
    Replies: 12
    Last Post: 05-06-2010, 06:17 AM
  3. how to disable command button
    By archie in forum Access
    Replies: 1
    Last Post: 08-27-2009, 11:11 PM
  4. Command Button Help!
    By arthura in forum Programming
    Replies: 3
    Last Post: 06-30-2009, 12:55 PM
  5. Command button issue
    By sloppysly in forum Forms
    Replies: 8
    Last Post: 06-15-2009, 12:07 PM

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