Hi,
Does anyone know if its possible to base a validation rule on the data that is already in the field in a table?
e.g. there are 10 records in a table each with an ID number starting at 1 and going up to 10. When new record added i need a validation rule that will prompt the user to enter a number greater than the previous number entered for the ID.
so they will not be able to enter 1 - 10.
hope thats clear
cheers.
I have tried several ways to validate my data with existing table I've developed.
Actually, I want the access to validate the data (Cellphone number) I've entered in the textbox by looking it in the existing table. So, if the data is there in the table, the message will pop up such as.. "Please continue". But if not, the message should be "this number was not registered yet.." and the textbox will be empty and ready for the new number...
I'm new to access so I thought this would be easier than it is. I have a list of cities in a simple table . I want use this list (or a query of it) to create a validation rule for a field in a second table "City". How, either with VBA or some other method do I use the Cities database to validate entry. These tables are both in the same project.
Any help is appreciated.
I am an absolute beginner and urgently need help with a validation rule. I need to know how to set a rule to set a minimum and maximum length for a text field record. I want minimum to be 4 and maximum to be 15 (I know I can set a max field size and set to not null but not sure how to make a minimum validation rule.
I am a teacher (not ICT!) having to cover for a sick colleague and students have asked me how to do this and although I am working my way through many of the great learning resources you link to here I have not yet worked out how to do this.
Would really appreciate any help you can give me so I can do my best by the kids.
J
What I have:
Table named: clients table
Form named: clients data form
The form has the client information. The client sends me a document. I review the document. If the document has the correct info needed, then I have a field named "Incomplete" that is a Yes/No field in the clients table.If the field is clicked, then I want the next date field to appear and then I can fill in the date that it was sent back to them.If the field "incomplete" field is not checked, then I don't want that date field to appear nor do I want to fill it out.
I have field (SupplierID) set as Text and the field limited to 5.
I want the users to enter the first three digits as text e.g "ABC" and the last 2 digits as numerics e.g "01", thus the input would be "ABC01", I can validate it to 5 digits but cannot get the validation working on the numerics, e.g users can enter "ABCDE", Am i correct in thinking its because my field is set as text ?, is there a simple way to do this, thankyou.
Hi
I have a form which people fill in (made up of fields from Table1) to record when sick days.
On the form, they have to enter the "week commencing" (which is set at Medium Date format); then they have to enter in a first day (which is set at Short Date format).
The First Day should be no more than 7 days from the date that they enter in the Week commencing field on the form.
I want an error message to pop up if they do this, for example:
Week commencing: 1st April 2007
First Day: 10th April 2007
(because the 10th April 2007 is more than 7 days from the 1st April). But it would be ok if they did this:
Week commencing: 1st April 2007
First Day: 8th April 2007
Help???
thanks!
Maria
This is pretty simple but I need to place a validation rule in my table for a field so that users can only enter data that starts with APB. What would the rule be?
View 1 Replies View RelatedHello, all.
I have a table that contains a field (list) for categories [Inquiry Type], and a field that tracks category of any follow-ups [FU Inquiry Type].
The rule is: If [Inquiry Type]="F", than [FU Inquiry Type] Is not null.
For some reason, when I'm entering data, the validation rule does not take any effect....does not notice when [FU Inquiry Type] - which is also a list box - remains empty when [Inquiry Type] is an F.
I have entered the rule this way in the table property validation rule field:
(([Inquiry Type]="F" AND [FU Inquiry Type] Is Not Null) OR ([FU Inquiry Type] Is Null)
I already have data in this table, but have ensured that it conforms to the above rule. Can anyone help?
I am wanting a text field in a table to accept only chars A - Z
In my validation rule I use
Like "a" Or "b" Or "c" Or "d" Or "e" Or "f" Or "g" Or "h" Or "i" Or "j" Or "k" Or "l" Or "m" Or "n" Or "o" Or "p" Or "q" Or "r" Or "s" Or "t" Or "u" Or "v" Or "w" Or "x" Or "y" Or "z"
Which works :D
Then validation text I use
Enter Alphabetical Letters only
Also works :D
Is there any short way to write Like A.....thorugh to Z without the long statement?
I cant figure out a fairly simple IIF statement I need for a table validation rule. I'll try to explain:
I have 2 fields in a table that are controlled through a form, which sets the fields either true (-1) or false (0). Lets call them Field1 and Field2. These fields need a validation rule which is dependent on FieldX and FieldY.
When FieldX = FieldY, I need Field1 to be either 0 or -1
if Field1 is 0 -> Field2 is -1 and the other way around.
if FieldX <> FieldY -> Field1 = 0 and Field2 = 0
I want to set a rule where employees cannot change the "Status" from "Active" to "Closed" if there is no date entered in the "Actual Closure Date" field.
The 2 fields I am trying to create a rule for are called 'Actual Closure Date' and 'Status'.When we raise an incident the 'Status' is set to 'Active' and the 'Actual Closure Date' field is left blank as it hasn't yet been closed.What I want to do is prevent people setting the 'Status' to 'Closed' when they havent entered a date in the 'Actual Closure Date' field.The Form name is called 'Issue Details' and the information is stored in a table called 'Issues'.
Hey I have a little problem, I have this assignment for school to make a simple database, I did all that but there's one little thing I can't seem to find.
I have to limit a Field's length to 15, but not through Field Size but thanks to a validation rule, and since I don't know a lot of validation rule commands I have no idea what the syntax is for the field length. How can I do this, it's pretty urgent actually, need to have this by tomorrow :s
Thanks!
Relatively new to access, just trying to create a range in a validation rule. What I have are 2 cells, Date_Taken and Date_Returned. I want Date_Returned to only accept values between: Date_Taken and equal to or less than the current date.
Between "Date_Taken" And <=Now()
is what I've got at the mo', yet it's not working. I'm gathering that I'm referring to the Date_Taken cell incorrectly. Any help? I don't see any tools to fix such a thing.
Hi
I need to know how to set a rule to a password field that the user
only be able to type english letters and numbers .
Any idea how?
Thanks
Hey guys, what is the easiest way to validate a field based on another.
I have 2 combo box, lets say cboOne and cboTwo. If cboOne = 1 then cboTwo must be blank/Null. Can I place this validation in the table validation properties. If so, how do I word the validation code.
Hi,I'm really struggling to try and find a solution to a problem.I need to find a validation rule that only accepts:letters, spaces and hyphens (-) in the field.I have tried for at least 14 hours today and most of yesterday afternoon, but I just can't get it.The furthest I've got is rejecting everything except from letters and spaces, with each these codes individually:(I've only listed a few so you could see just a fraction of what I'd already tried)Is Null Or Not Like "*[!((a-z) or (Chr(32),Chr(45)))]*"Is Null Or Not Like "*[!((a-z) or (Chr(32)) or (Chr(45)))]*"Is Null Or Not Like "*[!((a-z) and (Chr(32)) and (Chr(45)))]*"Is Null OR Not Like "*[!((a-z) or (( ),(-)))]*"Is Null OR Not Like "*[!((a-z) or ( ) or (-)))]*"Is Null OR Not Like "*[!((a-z) and ( ) and (-)))]*"Is Null Or Not Like "*[!((a-z), ,-)]*"However, it is also rejecting hyphens, which I need it to accept.Also, unfortunately it is accepting bracketsHopefully someone here will have a solution, because I'm stumped, :confused:James
View 14 Replies View RelatedQuestion about validation rules. I have a user who has set up a validation rule to allow certain values to be entered.
Something like if the value equals 4 or equals 5 then it would accept it. Now she would like the validation be set so they can put both 4 and 5 in together. How can this be done?
What would be the 'validation rule' to input into the properties window for a Client ID? - (validation rule would make sure that none of the Client ID's are the same). ;)
View 4 Replies View RelatedHere's my problem:
Table: PARAMETERS
Field: PARM1
Field: SYMBOL
Table: TRANSACTIONS
Field: DATE
Field: AMOUNT
Field: loads more...
What I want is a validation rule on the AMOUNT field, which says that the data entered cannot be greater than the number in the PARM1 field.
I can't get this to work, and I reckon it's becuase there's one record in the PARAMETERS table, but lots in TRANSACTIONS.
In solving this problem I do not want to add any more records to PARAMETERS. The idea of that table is that it is an easy way to customise the database, not a way of storing data.
I've putting this in the validation rule box (but it didn't work):
=<Tables![PARAMETERS]![PARM1]
Please help!
Thanks
hi i am new to access but i am trying my hands on it...i have a problem:i want to put some validation rule(constraints) on a field in the table such that user can only able to enter only 10 digit number and even if that number starts form "0" then it shows the starting zeros without concatenation.for ex if user put 0681482803 then it should not convert back to 681482803also one more thing i want to ask what is the best Field size for 10 digit number.. as long integer doesn't fulfill the requirement and double is very large
View 3 Replies View RelatedHi all,
I have a form that records a unique number which requires a full stop to be present. Is there anyway of ensuring a user has to enter a "." somewhere in this box?
Cheers:p
I almost read all posts about validation rules and I cant find solution for my problem.
I want to set that users must enter 13 numbers no more no less in form field,and if this condition is not satisfy I want to give warning to users with pop up massage.
Is it posible to make with validation rule or I must use code.
Please help me to resolve this problem.
Hello can anyone help me I am trying to make a validation rule for a field. It needs to be Between 0 And 28 OR "NA". When I use this in the validation property it works for the numbers and text but if you input say NJ or any other combination it issues a message box saying cannot evaluate the constraint, check Validation rules.
Am I missing some important syntax or something. Any help gratefully appreciated.
Barry
How do I set up a validation rule for a table where the rule checks two fields to see if combined they are unique...i.e.
Field 1 Field 2
John Doe 12345
therefore in field 2 12345 cannot be used again when John Doe is used in the same record.
Thanks...
Hello,
I want to restrict data entry to a three letter code. It must be letters and not numbers. I am entering the rule at table level so that should I pass the db onto someone else the rule remains in place even if somebody creates a new user interface. Thank you