468,103 Members | 1,229 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,103 developers. It's quick & easy.

Creating "Smart" validation rule.

How can i do something like this:

i have a form with

A percentage : ______
B percentage: ______
C percentage: ______

I want that the sum of these 3 fields *will never* be more than 100
(so user won't be even able to fill it).

how can i do something like that? i don't care if it's on the form/
query/table level.

Thank you for you help.
Alex.

Jun 28 '07 #1
3 2032
Use the before update event instead of a validation rule.

"Alex.Sh" <gr****@gmail.comwrote in message
news:11**********************@m36g2000hse.googlegr oups.com...
How can i do something like this:

i have a form with

A percentage : ______
B percentage: ______
C percentage: ______

I want that the sum of these 3 fields *will never* be more than 100
(so user won't be even able to fill it).

how can i do something like that? i don't care if it's on the form/
query/table level.

Thank you for you help.
Alex.

Jun 28 '07 #2
On Jun 28, 6:03 pm, "paii, Ron" <p...@pack.comwrote:
Use the before update event instead of a validation rule.

"Alex.Sh" <gre...@gmail.comwrote in message

news:11**********************@m36g2000hse.googlegr oups.com...
How can i do something like this:
i have a form with
A percentage : ______
B percentage: ______
C percentage: ______
I want that the sum of these 3 fields *will never* be more than 100
(so user won't be even able to fill it).
how can i do something like that? i don't care if it's on the form/
query/table level.
Thank you for you help.
Alex.- Hide quoted text -

- Show quoted text -
Thanks for the reply, but i managed to do it using a validation rule
in the form level - works pretty nice.

I have an extra question: Is there a way to automatically backup
access accdb let's say - every day in specific folder. For example,
tommorow at 6AM the accdb will be auto backuped called:

DBKUP-6.29.07.accdb

thank you for your help,
Alex.

Jun 28 '07 #3

"Alex.Sh" <gr****@gmail.comwrote in message
news:11**********************@g4g2000hsf.googlegro ups.com...
On Jun 28, 6:03 pm, "paii, Ron" <p...@pack.comwrote:
Use the before update event instead of a validation rule.

"Alex.Sh" <gre...@gmail.comwrote in message

news:11**********************@m36g2000hse.googlegr oups.com...
How can i do something like this:
i have a form with
A percentage : ______
B percentage: ______
C percentage: ______
I want that the sum of these 3 fields *will never* be more than 100
(so user won't be even able to fill it).
how can i do something like that? i don't care if it's on the form/
query/table level.
Thank you for you help.
Alex.- Hide quoted text -
- Show quoted text -

Thanks for the reply, but i managed to do it using a validation rule
in the form level - works pretty nice.

I have an extra question: Is there a way to automatically backup
access accdb let's say - every day in specific folder. For example,
tommorow at 6AM the accdb will be auto backuped called:

DBKUP-6.29.07.accdb

thank you for your help,
Alex.
I have a Access DB that moves other MDB files to a new directory, then
Compact and Repair back to the original which backs up and cleans the files.
This is run once a week using the built-in windows scheduler. Daily backups
are handled by the server backup system but the application could be run
daily.
Jun 28 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Martin Goldman | last post: by
2 posts views Thread by Tim Hochberg | last post: by
14 posts views Thread by David B. Held | last post: by
3 posts views Thread by red floyd | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.