Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2006
    Posts
    3

    Unhappy Unanswered: problem in opening form in access i dont know the reason

    hi every one
    first problem

    i have create a database file that work fine on access 2003 on window
    xp but i have format my pc after that i begin to face my problem i have
    installed antivirus 2006 and reinstall access 2003 on my winows
    the suprize was that when i click the command button that is in the
    main i have a message said "the openform action was canceled" and when i
    try to open it from database window it opens but have a message either
    error in open event or change event or activate event
    such as
    "The expression On Open you entered as the event property produced the
    following error: A problem occurred while Microsoft Office Access was
    communicating with the OLE server or ActiveX


    i have checked the reference and i have disable the antivirus also i
    update the access specially the visual basic for application
    i m wondering what is the problem since it work fine with other
    computer and those message doesnt appear.


    if i unistall the antivirus then reinstall the office and then back to
    install anti does it help or just its a bad idea.


    second problem
    i also have other databasefile that have a code that used in two modal
    forms it worked in both fine but in one worked better than the other
    in the second form it pass the if statement (which check if we in
    begging of financal year it restart numbering)
    check refrernce check datatype check reserve word all those
    if the forms were modal does it effect the executing of the code


    please help me im waiting for you advice in those problem .im
    interested in first problem more than the second one.
    l really dont know what is the problem help me

    recently i have unistall the norton antivirus and reinstall office 2003 but im facing the same problem for the first problem
    i start to feel tired from this problem my all work stoped because of this problem please help if you could
    thanks alot
    Last edited by funfair; 03-21-06 at 14:27.

  2. #2
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    have you checked the macro security settings in access?

  3. #3
    Join Date
    Mar 2006
    Posts
    3
    Quote Originally Posted by rogue
    have you checked the macro security settings in access?
    what about it
    it's set to high but when i change it to low not all the form has been opened
    just two of them the reset didnt open untill now
    thanks alot

  4. #4
    Join Date
    Mar 2006
    Posts
    3
    Quote Originally Posted by funfair
    what about it
    it's set to high but when i change it to low not all the form has been opened
    just two of them the reset didnt open untill now
    thanks alot
    HI,MR.rogue
    THANKS ALOT
    HOWEVER I HAVE SOLVED MY PROBLEM
    BY MAKING UPDATE FOR OFFICE THEN COMPACT THE FOLDER

    BUT NOW IF IM GOING TO INSTALL ANY PROGRAM FOR ANTIVIRUS ISIT GOING TO EFFECT THE OFFICE
    THANKS

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •