entering data

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

Forum home » Delegate support and help forum » Microsoft Access Training and help » Entering data

Entering data

resolvedResolved · Low Priority · Version Standard

Andrew has attended:
Excel Intermediate course
Access Introduction course

Entering data

When entering data in our database at work, once you click in a field it will not allow you to come out or do anything else until you have filled in a value - how can this be changed?

RE: Entering data

Andrew,

This is achieved by additional program code that runs behind the scenes, most likely coded in either VBA or Visual Basic. It was created by the developers of your database to control how the program is used. Essentially this is not something that can be changed, as it is hard coded in the database.

The only solution would be to speak to your development team and ask them to change it, but this may not be successful if there is a specific reason for you database being designed this way.

Hope this helps
David


 

Access tip:

Prefixed Autonumbering

When using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter.

For example, P001, where P is the prefixed letter

Instructions
Step 1. Create Field Name
Step 2. Set Data Type to Autonumber
Step 3. Within Field Property General tabsheet,
enter Format property as [backslash]P000



View all Access hints and tips


Server loaded in 0.07 secs.