Form entry

The UK's most regular instructor-led training courses.
Training information: access 2000 training · Access training · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · Medium Priority · Version 2003

5 posts

ReplyThu 21 May 2009, 16:01Delegate Adele said...

Adele has attended:
Access Intermediate course
Access Advanced course
Access VBA course

Form entry

How do I make a field mandatory?

Version	Date	Location	Places available	Book	Next place rate (£)
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Tue 23 Mar 2010	Bloomsbury	3		£224	£225
2003	Tue 30 Mar 2010	Bloomsbury	6		£199	£204
2003	Thu 22 Apr 2010	Southwark	5		£195	£200
2007	Tue 27 Apr 2010	Bloomsbury	4		£224	£225
2003	Fri 28 May 2010	Bloomsbury	9		£156	£161
2003	Wed 16 Jun 2010	Bloomsbury	8		£95	£100
Full Schedule: See all 20 Access Intermediate course dates. Bookings currently available until 17th December 2010.

635 posts

ReplyFri 22 May 2009, 09:07Trainer Carlos said...

RE: Form entry

Hi Adele

One way to make a field mandatory is when creating the table. To do this:

1. Create the field in the table's design view
2. In the General design area for that field set Required to Yes

Then when you try and enter data through the form the table won't update until you have entered the required data.

Hope this helps

Carlos

5 posts

ReplyFri 29 May 2009, 08:16Delegate Adele said...

RE: Form entry

Hi Carlos,

Thanks for your answer - one more thing - can I then set up some text to show if this field is then missed in form entry? Today there's no warning, but the record is not saved.

Many Thanks,
Adele.

· How to Find a Third-Party Venue for Microsoft Access Training
· Build International Databases With Microsoft Access
· Material covered on a Microsoft Access Course
· User-Proofing Your Access Database: Part 1
· Quick Access Database Courses: A 10 Step Lesson in Encrypting and Decrypting an Access Database

Please browse our web site to find out more about
access 2000 training and other Microsoft training courses.