Data entry in form

Resolved · Urgent Priority · Version 2007

Thu 10 Nov 2011, 11:16 Delegate Salima said...

Salima has attended:
Access Advanced course

Data entry in form

hi
how can restrict a form so it will highlight the field that cannot remain blank. so if the inputter is keying in a data in form and forget to select customer name from dropdown list, form should prompt "please select cutomer"

Fri 11 Nov 2011, 13:32 Trainer Anthony said...

RE: data entry in form

Hi Salima, thanks for your query. That involves putting data validation on the field in question. You can do this on a table or on the form itself, but it's best practice to do so on the form. Here are a couple of links with further information:

http://office.microsoft.com/en-us/access-help/create-a-validation-rule-to-validate-data-in-a-field-HA010096312.aspx

http://allenbrowne.com/ValidationRule.html

Hope this helps,

Anthony

Fri 18 Nov 2011, 16:52 Delegate Salima said...

RE: data entry in form - validation rules not working for new re

Thank you for your reply
i have updated the validation rule and validation text at form level. now the problem is if i go to new record in the form, it will not prompt the validation message and let me through without filling in the mandatory fields but if i go back to existing record and delete the text in mandatory field then before going to previous or next record, it will prompt me to fill in the mandatory field. i really want it to prompt me when i am making a brand new entry in a form. can you please help me to achieve that?

Mon 21 Nov 2011, 10:08 Trainer Anthony said...

RE: data entry in form - validation rules not working for new re

Hi Salima. Ah, I see. I'm afraid that will involve some code in the background detecting the current status of controls on the forum and responding accordingly to what is being entered. Once you go beyond the out of the box functionality you're into the land of VBA!

Anthony

Sun 27 Nov 2011: Automatically marked as resolved.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips