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.
3  2226 
Use the before update event instead of a validation rule.
"Alex.Sh" <gr****@gmail.c omwrote in message
news:11******** **************@ m36g2000hse.goo glegroups.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.
On Jun 28, 6:03 pm, "paii, Ron" <p...@pack.comw rote:
Use the before update event instead of a validation rule.
"Alex.Sh" <gre...@gmail.c omwrote in message
news:11******** **************@ m36g2000hse.goo glegroups.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.
"Alex.Sh" <gr****@gmail.c omwrote in message
news:11******** **************@ g4g2000hsf.goog legroups.com...
On Jun 28, 6:03 pm, "paii, Ron" <p...@pack.comw rote:
Use the before update event instead of a validation rule.
"Alex.Sh" <gre...@gmail.c omwrote in message
news:11******** **************@ m36g2000hse.goo glegroups.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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Martin Goldman |
last post by:
Hello all,
I've been struggling for a few days with the question of how to convert
"smart" (curly) quotes into straight quotes. I tried playing with the
htmlentities() function, but all that is doing is changing the smart
quotes into nonsense characters. I also searched the web for quite a
while and was unsuccessful in finding a solution.
...
|
by: Tim Hochberg |
last post by:
During the recent, massive, painful Lisp-Python crossposting thread the
evils of Python's whitespace based indentation were once again brought
to light. Since Python' syntax is so incredibly brittle, and failure
prone, it's amazing that we don't have more editor support for our
feeble minds. To help reduce the severity of this crisis, I...
|
by: David B. Held |
last post by:
I wanted to post this proposal on c.l.c++.m, but my news
server apparently does not support that group any more.
I propose a new class of exception safety known as the
"smart guarantee". Essentially, the smart guarantee
promises to clean up resources whose ownership is
passed into the function, for whatever defintion of "clean
up" is most...
|
by: Ron |
last post by:
Hello, I'm having an aggravating time getting the "html" spewed by Word
2003 to display correctly in a webpage.
The situation here is that the people creating the documents only know
Word, and aren't very computer savvy. I created a system where they
can save their Word documents as "html" and upload them to a certain
directory, and the...
|
by: BobAchgill |
last post by:
Is there a way to let the User click on a button on a web
site and have that download and install my prepackaged
compressed data directory and place it nicely under my
existing VB .Net Form application on the User's computer?
Maybe another way of asking the question is. Can I build
a smart .msi "data" installer that will when clicked on
as...
| | |
by: red floyd |
last post by:
I've got some code where somebody cut&pasted some comments from MS Word,
and so these comments have "smart quotes" (in particular apostrophes)
embedded.
The apostrophe is character hex 0x92.
2.1 indicates that characters not in the source character set are
converted to the universal character name that designates the character.
So far,...
|
by: Noozer |
last post by:
I'm looking for a "smart folder" program to run on my Windows XP machine.
I'm not having any luck finding it and think the logic behind the program is
pretty simple, but I'm not sure how I'd implement this. I've done some VB6
programming and dabbled in VS.Net.
Can someone share some pointers in how I could implement the following?
...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
| | |
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
