just woundering wheather you can enter a rule in textbox properties to check the data entered is equal to any of the data in a field in a select table.
Is this possible? If so can you give me an example how?
the table i will be check is "deliveries" and the field will be "driver code no"
i know its possible in vb but im not after that.
hope you can help
Thanks
Dave:D
I’m trying to do something which should be very simple, I’ve added a new field to a table, but for some reason it won’t update the field when using the form. It’s quite a complex form and my Access abilities are limited so I would rather not create the form from scratch.
I’m trying to create a query that displays only entry’s which contain my new field. However since I have the above problem it doesn’t seem possible.
One way I see around this would be to create a rule in my query where only records were shown when the fields “price” divided by “number_of_players” = 12.5
Can someone please tell me how to write this validation into a query?
Many Thanks
Chris
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'm trying to create an Append Query in Microsoft Access to add some data from one table into another table. I checked all of the properties and fields to make sure there are no validations. I have allowed zero length, and have tested the validation rules under the tools section of the design tab on both of the tables. When I run the Append Query, I still get an error that says 0 records added due to validation rule violations.
View 1 Replies View RelatedHey 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
Hello All,
Here is a really simple question for someone who knows the answer, lol.
I want to enter a statement on my form that prevents the entry of specific text based on a previous entry.
For example:
One field named "Make" may have the entry "Toyota". If Toyota is typed in that field then the next field named "Model" must return an error message if someone types in Malibu.
Any suggestions?
Thanks in advance
Hi,
I have one field which set the validation Rule.
Validation Rule: >0
So, the value must be greater than 0.
I enter 5, then go to next field, and then go back to change 5 to Null (blank). Then the error message come out.
I want to allow the blank in the field after I change the value.
-------------------------------------------------------------------------
I tried to use another way:
Private Sub Invnum_AfterUpdate()
If ([Invnum] <= 0) Then
MsgBox "The value must be greater than zero.", vbInformation, "Message"
[Invnum].setforce
End If
End Sub
But, it doesn't work very well, because the setforce cannot go back to the [Invnum] field. And, if close the form, it cannot hold it.
How can I control it?
Please let me know, thanks.
I have set up a validation rule "Is Not Null" in the properties field of my form.
I have added validation text that I thought would appear when this rule was not met.
The field in the table is set to required "No"
I have a macro which OnClick closes the form and sends an email and when I click it, it does close the form and send the email with no regard for the fact that the field with the validation rule in is blank.
If I change the field in the table to required "Yes" I get the standard error message boxes and the form shuts itself down.
Please would somebody help me? I am a complete newbie so I need real idiot proof instructions!!
Hi I'm new to Access 2003 and I am creating a validation rule.
Both Reorder Quantity and Reorder Point are table fields.
If I am going to create a validation rule:
Reorder Quantity cannot be more than twice the reorder Point. How am I going to do this?
I tried:
< 2*[ReorderPoint]
but it didnt work. Please advice
I have a form that is used for initial entry of data as it is captured. On that form is a field called PROVCODE that is a pick-list from a provider dictionary with a bound column of the provcode value from the provdict table (e.g. - J07). On that same form a few fields down there is a DOS (date of service) text box. It is this box I want to add the validation rule to. Originally the validation rule was <=Date() so that the user couldn't enter a DOS value as a future date. Now I need to change this rule so that if the PROVCODE value is J07 that the validation rule should be (<=Date()-21) (meaning the value being entered must be at least 21 days ago in the past) otherwise is should be <=Date(). I thought it would be simple, but cannot get it to work in the Expression builder for the DOS field in the form.
View 6 Replies View RelatedI have been trying to use to a validation rule on 2 fields, and then using the OnError event to tell the program what to do if the validation rule fails. I could not get this to work and tried several different ways. I am thinking the best way to do this is to make this happen with VBA alone, and throw the validation rule from the table out.
Heres what I need to do:
I have 1 textbox in a form that needs to be monitored- MO_ID
If the user enters a number greater than 99999 and less than 999999, I need a pop up message box to appear, default the MO_ID text box to being blank, and then go to the control box MO_ID for re-entry.
Here's my best attempt at the code, but every time it sends the pop up box and never will go to the else statment, regardless of what was in the textbox:
Code:
If Me.MO_ID > 99999
MsgBox("You can not enter an employee number here!")
Me.MO_ID = ""
DoCmd.GoToControl(MO_ID)
Else
GoTo Main_Code
End If
End Sub
What do the validation rule and validation text in the properties box do?
Thanks
i need some help with a validation rule, i need a rule that permits only A to Z characters of any length. i searched but i could only find rules that allows A to Z but of a fixed length.
thanks
ashkan