entering data
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Entering data

resolvedResolved · Low Priority · Version Standard

replyReply Thu 7 Feb 2008, 12:06Delegate Andrew said...

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?

For upcoming training course dates see: Pricing & availability

replyReply Mon 11 Feb 2008, 09:57Trainer David said...

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

 

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

Access tip:

Compact database automoatically

To ensure optimal performance, you should compact and repair your

Open the Access database or Access project that you want Access to compact automatically.
On the Tools menu, click Options.
Click the General tab.
Select the Compact on Close check box.

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard