I'm struggling with a validation rule that almost works but not quite.
I want to restrict the values in a feild by characters between 0-9, A-Z, _ and -
Using the following string works for all except the hyphen, which I assume is because it's an operator:
Is Null OR Not Like "*[!((a-z) or (0-9) or (_) or (-))]*"
Is there something I can do to make it recognise the - as text?
Hello, 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 split my database. Then got the bright idea to rename them. Now when I launch the front end (which contains the forms, etc.), I get a message saying that it can't find my backed. I've tried renaming the back end back to its original name, but its still not working.
What is the best way to fix this situation? I was thinking about opening the front end, and re-importing the tables from the back end, or, breaking the links between the front end and back end. If I re-import, should I move stuff from the front end to the back end or vice versa?
Thank you in advance for your help.
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
What would the validation rules be between two dates:
>01/09/07 however <01/09/11
and also
>01/09/07 however <present day
I am trying to create a validation rule for one of my fields.. i want it to be so that the user can not select a date to be on a Sunday..
View 2 Replies View RelatedI am building a scoring system for an Archery Tournament and am trying to add some extra validation between two fields.I want to check the contents of one field against another.So if Field A has an even value, then Field B must also be even, and if Field A has an Odd value, Field B must be odd.Would it also be possible to add an exception such that if Field B = 0 then the validation rule does not apply?I am only a very occasional user of Access, and don't have a very good grasp of the code structure in it, but am prepared to try and learn.
View 4 Replies View RelatedI have a table with 2 field:
1. StartDate (format : Short Date)
2. EndDate (format : Short Date)
How can I validate for field EndDate must occur after StartDate using Validation Rule?
Is there a way to add a validation rule in an access form on an unbound text box. This box is currently doing a calculation of others. If the figure is not between 0 And 0.3125 then I do not want the user to be able to move on. For some reason if I enter "Between 0 And 0.3125" in the validation rule it doesn't seem to do anything. I can only assume its because its an unbound text box. Data attached please see Frm_Input and text box total standard hours.
View 4 Replies View RelatedMany times I have appended tables. But now I am struggling even trying to append 4 fields defined as text.
View attached zip file.
I want to create a field validation rule that requires the user to input a policy number in a standard format. The format has a fixed length of 13 with three underlying components. The first 3 digits identify coverage, the next 7 are the policy number and the final three must always be "-00".
Example: GLO1234567-00
Is it possible to create a validation rule for this ? If so, can you provide the code based on the simple example above ?
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
What would I need to enter into the validation rule to change the field to alphanumeric only?
View 3 Replies View RelatedI have used the code below to send an email automatically when a new record has been created. However I recently added the If Then statement to the code as you can see. The problem is that the email wont send because it says "There must be at least one name or distribution list in the To Cc or Bcc box". It is most likely saying this because it doesn't recognize "IT" in the txtDeparment combobox. How can I get it to recognize IT in the department combobox? The reason I am using an If Then is because I will make it send to different email addresses depending on what is in txtDepartment by using ElseIf
Dim appOutLook As Outlook.Application
Dim MailOutLook As Outlook.MailItem
Set appOutLook = CreateObject("Outlook.Application")
Set MailOutLook = appOutLook.CreateItem(olMailItem)
With MailOutLook
.BodyFormat = olFormatRichText
If Me.txtDepartment = "IT" Then
.To = "my email"
End If
.Subject = "hi"
.HTMLBody = "hi"
.send
End With
I have two tables in Access 2010:
Tbl1 - Abbreviations: with fields (1) "Abbreviation" and (2) "Definition"
Tbl2 - Piping: with multiple fields one of which is "Unit"
In Design View of Tbl2, I'd like to set the "Validation Rule" for the "Unit" field so that it is restricted to values in field 1 of the Abbreviations Table (i.e. one of the listed abbreviations").
I tried variations of "[Tables]![Abbreviations]![Abbreviation]" in the "Validation Rule" portion of the Design View for Tbl2 (Piping) but, couldn't get this to work.
I upgraded to Access-2010 and the Text File Import function will not recognize dates in the format YYYY-MM-DD. The import dialogue sees enough to recognize the field as a date, but then every date encountered is written to the Import-Errors table. This is true whether the file has a .txt or .csv extension. The actual file format is .csv.
View 6 Replies View RelatedI have a query where these are the fields:
ProductRevType
RevLag
RevFlowThru
CloseMoYr
ProjRevDate
CurrentMRC
ProjRevMRC
The ProjRevMRC field is an expression that reads:ProjRevMRC: IIf([ProjRevDate]>=DateSerial(Year(Date()),Month(Date()),1),[CurrentMRC]*[qry303a_ SFADetailMRC_ONLY]![Rev Flow Through],0)
When I run the query, it works perfectly, but when I created a crosstab query to show totals by month, I wanted the totals to be zero for the months less than the current month. Is there a way for the crosstab query to execute the expression and put zeroes for those months?
I have been doing an exercise to split the data from the list of the information into column A, B & C. Unfortunately the data value that i have consist of several set of data format therefore it create an issue for me to separate the information in Access 2010 easily.
eg.
Original Data Field
FLRY-B-0.75-L-GY
FLRY-4.0-V-R
VTAC-GY 19X20
COT-F2-5-DL
Actual Data To Populate Into Column A, B & C should be the following :
A
FLRY-B
FRY
VTAC-GY
COT-F2
B
0.75
4
19X20
5
C
L-GY
V-R
(No data captured for this column)
DL
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 Related