The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Form entry

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Form entry

Resolved · Medium Priority · Version 2003

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

Form entry

How do I make a field mandatory?

For upcoming training course dates see: Pricing & availability

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

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.

Access articles

· Working With Multiple Workbooks In Excel
· MS Access Top Tips: Takeaways From Microsoft Access Advanced Training
· What You Need To Know About New Security Features In Access 2007
· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses
· Access Corruption Avoidance Tip #2: Avoid Dangerous Data

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

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips

Hi

This is quite a straight forward request, but basically all I want to be able to do is change the colour of different individual cells.

I have made a table which has all the information relating to events i am organising. Within it i am using the..

» Forum post: Changing font colour in a table

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions