Results 1 to 5 of 5
  1. #1
    sYn is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2011
    Posts
    3

    Search records and return message.

    Hi,

    I am trying to create an AfterUpdate code for a text box. Basicly on the form the user selects a number from the combo box. They then type in the name of a person in a text box. What i want Access to do is search a database for records of people who have the number (selected in the combobox) with their name. If they do, i want the form to set the background of the textbox to green and display a label underneath. And if it dosen't then it sets the background of the textbox to red and also displays a label underneath.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    So what part are you having trouble with? What do you have so far?

  3. #3
    sYn is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2011
    Posts
    3
    I had someone code this correctly today. No need for any further help.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Since this thread does not include a solution I plan to delete it. If you want to post the solution so others can benefit, I will keep it.

  5. #5
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    Quote Originally Posted by sYn View Post
    I had someone code this correctly today. No need for any further help.
    well the only thing I would smile at is if you actually paid for it! I second the deleting of it.

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

Similar Threads

  1. Access not return the records
    By ashutoshNetsity in forum Access
    Replies: 1
    Last Post: 05-09-2010, 04:27 AM
  2. Return all records from Query
    By ysrini in forum Queries
    Replies: 1
    Last Post: 01-15-2010, 09:52 PM
  3. Return 0 if no records found
    By skwilliamson in forum Programming
    Replies: 1
    Last Post: 12-01-2009, 10:54 AM
  4. Records deleted with NO warning message.
    By evanscamman in forum Access
    Replies: 2
    Last Post: 12-14-2007, 11:18 PM
  5. Replies: 1
    Last Post: 03-28-2007, 09:18 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