Results 1 to 3 of 3
  1. #1
    RemonKoybito is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2011
    Posts
    10

    Modifying contacts search box

    Hi all, thanks for reading my thread. I'm making a volunteer database for my work. To do so, I'm just changing up the contacts database that came with my Access because I wanted to use its nifty search box without having to make my own.



    My problem is that I went into the embedded macro for the go button next to that search box and took out the filters for company, category, and job title (since I took those out from the main table whenever I tried to search a message box popped up asking for those values, and I didn't want that to happen). Now, whenever I try and run a search I get a message that says, "Object of class does not support the set of events." I've no idea what that means, can someone help? I need the search box since we'll be adding several hundred volunteers.

    Thanks so much!

  2. #2
    RemonKoybito is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2011
    Posts
    10
    I just noticed another problem. In the Open field on the contacts lists form, that used to open up that contacts form before, it now says "#Name?" and gives the same error message when I click it. I'm assuming that means these problems are related? When I click Okay on that error message it opens some macro single step window and lists the macro and the arguments as:

    Volunteer Details, Form, , ="[ID]=" & Nz([ID],0)

    I looked at the embedded macro and had no idea what to do. Thanks for your help!

  3. #3
    RemonKoybito is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2011
    Posts
    10
    Can anyone help me? I really don't want to start all over. I don't understand why taking out some of the "SetTempVar" bits of the search buttons macro messed it up. Any help would be greatly appreciated.

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

Similar Threads

  1. Contacts Database and Email system
    By steve1978 in forum Access
    Replies: 1
    Last Post: 02-16-2011, 09:42 AM
  2. linking contacts
    By jkorinek in forum Access
    Replies: 1
    Last Post: 06-11-2010, 03:55 PM
  3. Add new contacts
    By carstenhdk in forum Forms
    Replies: 8
    Last Post: 05-07-2010, 05:28 AM
  4. Contacts Database
    By karthikcoep in forum Access
    Replies: 0
    Last Post: 08-17-2009, 02:02 AM
  5. Outlook contacts
    By noidea in forum Access
    Replies: 0
    Last Post: 07-31-2009, 07:44 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