Text Box Validation Question, Please Help!

Dec 4, 2005

At present I have existing data being displayed in text boxs. My requirement is to be able to view this data but not be able to edit it.(ok just lock the field) but the problem is that I need to be able to add new records and thus be able to input data into the text boxs which wont be allowed if it is locked.
So basically not allow editing to existing records but allow new records to be added. Not sure if that makes sense, it seems like some sort of validation issue, can anyone help. Cheers

View Replies


ADVERTISEMENT

Validation Rule/ Text

Mar 14, 2007

What do the validation rule and validation text in the properties box do?

Thanks

View 1 Replies View Related

Text Only Validation Rule

Oct 18, 2004

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

View 7 Replies View Related

Definiing Validation Rules/text In Vba

Apr 25, 2007

Hi, I have the following code which adds text and number fields as required, but I need to add validation rules and text as well within this code, but have no idea how to do this and have not found much help on the net.any help appreciated...tan

Dim db As Database
Dim tbl As TableDef
Dim fld As DAO.Field

Set db = CurrentDb()
Set tbl = db.TableDefs("4WeeksFollowUp")

Set fld = tbl.CreateField("text", dbText, 30) 'for text - 30 is field length
Set fld = tbl.CreateField("CO3", dbLong) 'for number
tbl.Fields.Append fld

View 1 Replies View Related

Forms :: Text Box Validation Based On A Query

Mar 5, 2014

I have a textbox on a subform to allow a delivery qty to be entered (to allow me to cater for part deliveries). I have a query which totals up the values of this field (so that I have a total of all the deliveries for this record) and compares that value against another field (to check that the total deliveries I have entered do not total more than the ordered qty). I am using this query within the "Validation Rule" of the textbox. My problem is that when I enter the values for the first time this works fine because the figures are not yet part of the query and therefore the check works fine, however if I try to modify a figure I've already entered it triggers the validation each time because it tries to add the new value to the query total.

View 3 Replies View Related

Validation Text For An Expiry Date On A Credit Card

Nov 20, 2005

Basically, i have a field where the expiry date of a credit card is input, but i want to set an input mask so that it loks something like this:

MM/YY but i cant find a way of doing this!

I then have validation text which makes sure that this value is either equal to or more than todays date! this looks like this:

>=int(now())

So the input mask has to accept this validation...

If you could help, i would be very greatful!

Cheers

View 1 Replies View Related

How To Make Validation Text Give Different Error Messages

Apr 13, 2006

In of my tables called Employee Payroll, I have several earnings fields, and in a previous post I mentioned that I have implemented a validation rule for them which is £2.50 or £2.75 or £3.10. I have also used an error message in Validation Text to help the user if they enter an invalid value.
How can I change this message to reflect what the user types in? For example, if they enter an erroneous value like £9.34, the error message would say, "You have entered an erroneous value" or if they type an extreme value like £3.40 or £0.01, the error message would say, "You have entered an extreme value".
I understand that I would need to state when the data becomes erroneous and when it becomes extreme- so I thought, anything above, £4.00 should be erroneous and any negative values too. Extreme data would be anything between £0.00 and £3.10.
Would I need to use some kind of code in VBA?
Thanks

View 2 Replies View Related

Forms :: Creating Two Text Boxes - Validation Value In Form?

Dec 18, 2013

I have little bit problem in access here, if i want to create two textbox... first textbox for time and second textbox for unit. When I type (time) in first textbox, second textbox will appear automatically the unit number...

Example

1textbox-----------2textbox

1<time<=60 ------- 1 unit
60<time<=120 ------ 2 unit
120 < time <= 180 ------- 3 unit

View 6 Replies View Related

Forms :: Text Box Data Validation Against A Field In Another Table?

Jun 15, 2013

I am working on a form that registers new training attendees. One of the fields in my form asks for dealer number.

I have a separate table where all the dealer information is stored. One of the fields is a Customer Number field

I want to ensure that entries in the Dealer Number textbox on my New Registration form matches a valid Customer Number in the Dealer Database Table

I would like this verification to occur either upon a Click event with a button or on an After Update event.

View 6 Replies View Related

Tables :: Validation Rule Doesn't Recognize Hyphen As Text

Feb 15, 2013

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?

View 2 Replies View Related

Forms :: Validation Rule In Access Form On Unbound Text

Jan 8, 2015

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 Related

General :: Append Validation Rule Errors (Using Text Fields)

Jul 27, 2015

Many times I have appended tables. But now I am struggling even trying to append 4 fields defined as text.

View attached zip file.

View 8 Replies View Related

Validation

Apr 25, 2005

how can i validate a field so that the data entered must be between the values of 1 and 10?
thanks in advance

View 2 Replies View Related

Validation

Dec 4, 2006

I have a table called Inspection, there are two fields:

- Damage To Property // data type is Yes/No
- Damage Comments // data type is text

How would i go about setting the validation - if Damage To Property is data type "No", disable the "Damage Comments" field. (ie grey it out).

any help would be greatly appreciated..

View 5 Replies View Related

Possible Validation

Apr 18, 2007

Hello!

Can someone tell me how to do a validation. The one I am trying to do is check Track No is not duplicated.

I have added my database if you may need it.

Can someone help me please!

Thanks

View 1 Replies View Related

Validation Or VB

Feb 7, 2005

Hey peeps,

I have a problem. I want my field to become "[field], An " etc. when I type "An [field]" For example, if I type "The Hundred Years War" for the field, it automatically updates to "Hundred Years War, The". I would be happy with a simple validation rule that prohibits the use of "The, A or An" in the beginning of the field but i don't think that is posibble. If this requires VB, I don't know how to use the language and never worked with it. I am completely a novice in VB, but would still love to learn how to make it. :) If you could start me out then, I would appreciate it greatly. :D

View 1 Replies View Related

Validation Help

Mar 30, 2005

Hi im new round here but am working on a database and sum of the validation rules are confusing me now.

Ok i got a couple of things to ask:

1) What rule do i use to make sure only text is entered into the field, i cant use input masks as the size of the text put into the field will vary, as its names of people.

2) Is there a way to check that all the fields on a form have been entered? So if there not all entered an error appears?

3) Finally, is there a way to reset Autonumbers? or do i have to delete all the records and start frm scratch as my autonumbers have gone abiit crazy as sum records have been deleted so my table looks rather strange.


Thank you, help greatly appreciated :)

View 10 Replies View Related

Validation

Apr 14, 2005

Need a a validation rule to allow only "a" or "p" to be entered as data into the relevant fields, can someone help?

View 2 Replies View Related

Iif In Validation

Oct 11, 2005

Is it posible to use a iif statment in a validation statment ?
i have one table project and i want to check the occurens.

IIF ([ProjectStatus] = 1 ,[ProjectCompletedDate] = NULL, [ProjectCompletedDate]<> NULL)

when the projectstatus is 1, the date cant be filled in.
is this possible in access ?
or can it only be done form based?

thanks for the reply :)

View 5 Replies View Related

Validation Help

Dec 7, 2005

I have 2 fields called confirmed and paid.

I want to have a validation which will only allow confirmed to be clicked when paid is selected. I put this validation "Confirmed"<"Paid" in the properties part of the table but it doesnt work.

Can anyone help?

View 4 Replies View Related

Validation Help

Jan 21, 2006

Hello,

For my Year 12 Computing course, I need to develop a database which will take bookings for a village hall. The database consists of a Bookings Table, a Customer Data Table and a Hiring Cost Table. It is in the Bookings Table that I am having the most trouble.

I believe I have already solved my double booking dilemma by making the Date of Event and Type of Event fields in the Bookings Table into a composite key, thereby prohibiting the entering of data where Date of Event and Type of Event are the same, making them unique.

Here is my main problem at the moment, I need a validation rule on the Date of Event or perhaps the Date of Booking field which means a booking must be made at least a week, and no more than two months in advance of the date of event. The thing is this validation rule is only needed for occasional bookings. Present, again on the bookings table is a Booking Type field which has a lookup consisting of the following “Regular” and “Occasional”, regular meaning bookings that are made at the start of the year, for the whole year.

Ideally, I would like to have it so that when the booking type field is set to regular, the validation rule for the date isn’t needed, and when the booking type field is set to occasional, the validation rule for the date is needed/present.

Could anyone help me with this? As any help would be much appreciated.

Many thanks
Daniel

If anyone would like any screenshots of the Bookings Table, email me at daniel_goodman@hotmail.com

View 1 Replies View Related

Validation

Mar 12, 2006

How can I set validation for a text field where I restrict the number of characters? For example, if I only want the user to be able to input 12 characters or less, and more than one. >=1 And <=12 would that be correct?

View 1 Replies View Related

Age Validation

Sep 19, 2006

Hello!

I'm really new to Access and need help with a validation rule

Right, i have a 'Date of Birth' field and what would the validation rule be if i only want people over the age of 12 to be able to go any further?

I've tried various other rules found online but some just don't work...

Any help would be great!

Thanks

View 4 Replies View Related

Validation

Dec 5, 2006

Hi all, Very new to using ACCESS. I am trying to set a validation criteria to ensure that a postcode is imported correctly. An example of a UK post code is SP10 3PB - it may be entered as SP103PB. I need to set a validation criteria to allow either two. What is the format of the criteria to achieve this? Any clues please. Thanks Mike

Are there any useful sites that set out examples of validation criteria?

View 1 Replies View Related

Age Validation

Apr 29, 2007

Hi

I have a field for date of birth, however I want to make sure that the person is older than 17.

This is what I have at the moment but it doesn't seem to work:
<=Date()-6720

So what's the best way to do it?

Can you help me?

View 2 Replies View Related

Validation Help

Apr 9, 2005

Hello,

I am currently making a system for a sports centre and I need some help, I have created several forms one of which is for the coach's details.
On the coaches table we have a combo box which has all the different qualifications in it, we have 5 of these boxes but we want to it so that when one has been entered it cannot be repeated in the other boxes, also we want it so that when level 4 Tennis has been entered - levels 3,2 and 1 cannot be entered.

Any help on this would be great,

Pam

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved