Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

MS Access 2003 Validation Rules for Forms

MS Access 2003 Validation Rules for Forms

MS Access 2003 Validation Rules for Forms


I'm have a database setup for our wedding. I have a form to enter RSVP responded (checkbox), RSVPInvited(##), RSVPAttending(##).

1st question.

1. I want to be able to disable the RSVPResponded(Checkbox) after I close down the form so I don't accidently uncheck it the next time I come into the form.
  b)  How do I add a running total to my report of the numbe of people responded?

2nd Question.

2. I want to make a validation rule in the form to check and make sure when I input the RSVPAttending(##) it is equal to or less than RSVPInvited(##).
  b)  How do I make a running total of RSVPAttending and RSVPInvited and add that to a form?

I tried putting this into validation for the RSVPAttending:
=[RSVPAttending]=[RSVPInvited] Or [RSVPAttending]<[RSVPInvited]

But it doesn't work.

3rd question.
How to I add a search to my forms so I can input characters into the LastName spot and it will come close to the location of the person. (ie. just like when u use your address book in Outlook).



RE: MS Access 2003 Validation Rules for Forms

Question 2-b Addition:

I can make two querys one having all the FirstName, LastName, RSVPResponded, RSVPInvited, RSVPAttending, but I can't add the this "SumInvited: Sum(Addresses!RSVPInvited" ect.  But If I create a new query from Address.Table I can enter "SumInvited: Sum(Addresses!RSVPInvited)" ect. and it comes out with the totals.

The only problem is I don't know how to combine both querys with these values to use in a Report?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close