Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Problem with Combo Box Why?

Discussion in 'Information Technology' started by JOM, Nov 12, 2005.

Tags:
  1. JOM

    JOM
    Expand Collapse
    Guest

    I have always put a combobox using the combox wizard on my form that search a
    record on the form, but this time, its telling that the expression after
    update you entered as the event property setting produced the following
    error: A problem occurred while Proffesional Database was communicating with
    the Ole Server or ActiveX Control.

    I checked the references and there is nothing missing, and I have checked
    the right references, so what could be the problem....
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Sikhs Face Problems While Carrying Kirpans In Khyber-Pakhtunkhwa - SikhSiyasat.Net Breaking News Jul 29, 2016
    "Dasam" Granth - A Look At The Core Problems Dasam Granth Oct 21, 2015
    Problems In Life Sikh Sikhi Sikhism Apr 13, 2015
    How can I make decent and useful friends and from where ?? most people have a problem with me Sikh Youth Oct 23, 2013
    The Problem with Taking Too Many Vitamins Health & Nutrition Oct 18, 2013

  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    If the references are fine, and the code compiles okay, it sounds like the
    database has begun to corrupt.

    Try this sequence:

    1. Uncheck the boxes under:
    Tools | Options | General | Name AutoCorrect
    Explanation of why:
    http://allenbrowne.com/bug-03.html

    2. Compact the database to get rid of this junk:
    Tools | Database Utilities | Compact

    3. Close Access. Make a backup copy of the file. Decompile the database by
    entering something like this at the command prompt while Access is not
    running. It is all one line, and include the quotes:
    "c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
    "c:\MyPath\MyDatabase.mdb"

    4. Open Access, and compact again.

    5. Open a code window.
    Choose References from the Tools menu.
    Uncheck any references you do not need.
    For a list of the ones you typically need in your version of Access, see:
    http://allenbrowne.com/ser-38.html

    6. Still in the code window, choose Compile from the Debug menu.
    Fix any errors, and repeat until it compiles okay.

    At this point, you should have a database where the name-autocorrect errors
    are gone, the indexes are repaired, inconsistencies between the text- and
    compiled-versions of the code are fixed, and reference ambiguities are
    resolved.

    If it is still a problem, the next step would be to get Access to rebuild
    the database for you. Follow the steps for the first symptom in this
    article:
    Recovering from Corruption
    at:
    http://allenbrowne.com/ser-47.html

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "JOM" <JOM@discussions.microsoft.com> wrote in message
    news:376BE390-8894-4265-9181-2F2CD58DC3FB@microsoft.com...
    >I have always put a combobox using the combox wizard on my form that search
    >a
    > record on the form, but this time, its telling that the expression after
    > update you entered as the event property setting produced the following
    > error: A problem occurred while Proffesional Database was communicating
    > with
    > the Ole Server or ActiveX Control.
    >
    > I checked the references and there is nothing missing, and I have checked
    > the right references, so what could be the problem....
     

Share This Page