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 » How to enable a field

	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:

How to enable a field

Resolved · Urgent Priority · Version 2003

ReplyFri 15 May 2009, 12:57Delegate Fiona said...

How to enable a field

I want to be able to unlocked fields in a form when 'Yes' has been selected.

Example . Please tick 'Yes' If you are at Uni, this will then give you the permission to enter more details in the relevant fields.
If 'No' is selected the fields will be locked.

Thanks
Fiona

For upcoming training course dates see: Pricing & availability

ReplyTue 19 May 2009, 09:29Trainer Jacob said...

RE: How to enable a field

Hi Fiona

Thanks for your post on what you are trying to achieve.

To provide a working step-by-step solution that you can apply successfully to your database does fall outside the remit of this forum.

We can build this solution for you as a consultative exercise but there may be an associated cost in terms of trainer development time. Furthermore you won't have the core knowledge yourself to undertake similar work as your database grows and the needs arise.

A better solution will be for you to attend our 2 day Access VBA course, where amongst other areas you will also be able to learn what you need to achieve this solution. For more information on the course, please click here

Tue 26 May 2009: Automatically marked as resolved.

Access articles

· Guide To Adding A Text Box Form Control In Access 2010
· Why go on a Microsoft Access Training Course?
· How to Find a Third-Party Venue for Microsoft Access Training
· A Greater Understanding Of Your Business With Access Reports
· Microsoft Access as a Business's Database Management System

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

Access tip:

Create calculated fields that work out your age

You can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field

Age=Year(Now( ))-Year([DoB])

View all Access hints and tips

Hi
Why does my duration suddenly have decimals? (eg 24.66 days)

» Forum post: MS Project

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