Results 1 to 7 of 7
  1. #1
    tcd2004 is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2009
    Posts
    3

    Receiving error on contact database

    I'm trying to help out a friend who is creating a contact list in Access 2007
    for a hair salon and we are running into an error message. The error comes
    up when we do a search, and then click the show all button next to the search
    box. The first dialog box pops up with this error message:

    "contact management database"
    "you can't disable a control while it has the focus."

    When Ok is clicked, this error box shows up:

    "action failed"

    Macro Name:
    Contact List : cmdShowAll : OnClick : Embedded Macro

    Condition:
    True

    Action Name:
    SetValue

    Arguments:
    [Forms]![Contact List]![cmdShowAll].[Enabled], 0

    Error Number:
    2950



    On the second error box, the only option available to click is "stop all
    macros" It is strange because sometimes we would run a search for a persons
    name, then click the show all button to get back to the entire list, and
    there would be no error. More times than not though the error will show up.
    As I said, it is a list for a hair salon so it is important that this be
    error free by the time it goes to them. Any idea what would be causing this?
    Thanks

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Did you start with one of the MS Templates? It looks to me like you are trying to disable the cmdShowAll button. Why?

  3. #3
    tcd2004 is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2009
    Posts
    3
    To be honest, I'm not positive. I started helping out in the the middle of it. I am assuming he did start with a template though. The only thing I did was click the show all button so that all of the contacts would show up instead of the ones that came up do to the search. As soon as I click that button, the error comes up

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    If that macro is running when you click the "ShowAll" button then the error should be expected. Can you remove just the disable part? Maybe convert the embedded macro to code so we can see what is going on.

  5. #5
    tcd2004 is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2009
    Posts
    3
    I wish I was more proficient in access, however I can't say that I am. How would I go about doing that?

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Clink on the link I gave you and it shows how to do it, with picturers even.

  7. #7
    Join Date
    Mar 2010
    Posts
    1
    This is a bug in the Template, i guess but you say the error is expected. how would i remove the disable part? very annoying error, kills usability.

    do you consult?

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

Similar Threads

  1. Database Connection Error
    By pgabell in forum Access
    Replies: 1
    Last Post: 01-17-2009, 07:24 AM
  2. Access Contact Database
    By gpeterson82 in forum Access
    Replies: 0
    Last Post: 10-30-2008, 09:38 AM
  3. Replies: 1
    Last Post: 10-15-2008, 01:25 PM
  4. Database Login Error
    By narasareddy in forum Access
    Replies: 0
    Last Post: 08-30-2008, 12:00 AM
  5. Replies: 0
    Last Post: 06-19-2007, 09:45 AM

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