Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

how enable field

Forum home » Delegate support and help forum » Microsoft Access Training and help » How to enable a field

How to enable a field

ResolvedVersion 2003

Fiona has attended:
Access Intermediate course
Access Advanced course

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

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 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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.