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

entering data

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

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.08 secs.