Results 1 to 6 of 6
  1. #1
    Emad is offline Novice
    Windows 8 Access 2003
    Join Date
    Sep 2013
    Posts
    2

    The open form action was canceled _ from emad

    I write this small code in open form event
    (Private Sub Form_Open(Cancel As Integer)
    DoCmd.Maximize
    End Sub)

    I got the error “ The open form action was canceled

    Error No 2501

    The detail of the error :


    ‘the expression on open you entered as the event property setting produced the following error;A poroplem occurred while Factory DB wsa communicating with the OLE server or Active X Control

    • the expression may not result in the name of a macro, the name of a user-defined function or [Event Procedure]
    • There may have been an error evaluating the function, event, or macro


    He DB was working and still working good in windows 7 but I got this error in windows 8
    Thanks

  2. #2
    mrojas is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Sep 2013
    Location
    Concord California
    Posts
    72
    What's with ( around the sub?
    I tried this and it worked.
    Private Sub Form_Open(Cancel As Integer)
    DoCmd.Maximize
    End Sub

  3. #3
    Emad is offline Novice
    Windows 8 Access 2003
    Join Date
    Sep 2013
    Posts
    2

    reply from emad

    yes it works good in windows 7 but it doesn't work in windows 8
    thanks

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows XP Access 2003
    Join Date
    Aug 2013
    Posts
    7,862
    Quote Originally Posted by Emad View Post
    yes it works good in windows 7 but it doesn't work in windows 8
    thanks
    Considering this statement by itself. It sounds like you have a reference issue. Access 2003 version of DoCmd must depend on something W8 does not have.

  5. #5
    TG_W is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2010
    Location
    Manvel, TX
    Posts
    299

  6. #6
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows XP Access 2003
    Join Date
    Aug 2013
    Posts
    7,862
    What do you have running on the W8 machine to open your 2003 DB? Are you opening a 2003 file using a later version of Access? Do you have 2003 runtime on the W8 machine?

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

Similar Threads

  1. runtime error 2501 openform action was canceled
    By rumenrs in forum Programming
    Replies: 2
    Last Post: 04-11-2013, 04:29 AM
  2. Replies: 6
    Last Post: 11-28-2012, 03:43 PM
  3. Replies: 15
    Last Post: 07-26-2012, 02:06 PM
  4. Replies: 7
    Last Post: 07-18-2012, 07:53 AM
  5. Error: The OpenReport action was canceled
    By francisdm@state.gov in forum Reports
    Replies: 1
    Last Post: 12-14-2011, 01:45 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