Microsoft Access Forms: Working With The KeyPreview Property

Microsoft Access Forms: Working With The KeyPreview Property

Working and managing data via Microsoft Access forms is only as good as the design and if the user becomes frustrated then don’t expect your database (and you) to receive any credit.

One element overlooked when form designing which is easily missed to be fair, is the lack of keyboard short-cuts should users wish to throw away that pesky ‘rodent’ mouse! After all, we end up enter and managing the data via the keyboard in any case.

microsoft access forms keypreview property

As you may have gathered by now, I’m a keyboard fan and only use the mouse for the obvious interactions and even though Continue reading “Microsoft Access Forms: Working With The KeyPreview Property”

How To Create A Form In Access 2010: Working With the Layout View

How To Create A Form In Access 2010: Working With the Layout View

This simple and quick 4 minute video tutorial on how to create a form in Access 2010 covers three basic elements of creating a form from a selected table object, adding additional fields and inserting a drop-down box control all with using the newer layout view (as introduced in Microsoft Access 2007).

httpvh://www.youtube.com/watch?v=TxQIiSkzplg

Using the quickest steps to creating a form removes the need to use a wizard and even visit the design view mode at all making this the quickest way to create a form.

Of course there are some limitations Continue reading “How To Create A Form In Access 2010: Working With the Layout View”

Access Form Controls: Coloured Tabs For Your MS Access Forms

Access Form Controls: Coloured Tabs For Your MS Access Forms

Working with Access form controls may not always be as flexible as one would like and a particular control that comes to mind is the Tab Control.

I have often been asked about if you can add a splash of colour and other formats to the Tab Control and the simple answer is not really as you are left with the empty and grey dull look and feel for tabs and their pages. The pages can be layered with boxes and formatted but the tab is a non-touchable element when adding colour.

However, you can always build your own version by adding and utilising other controls which include a Rectangle and as many Labels for each simulated tab required along with Text Box controls for your actual data.

access form controls

This Microsoft Access database tutorial will highlight the basic steps required and include the Continue reading “Access Form Controls: Coloured Tabs For Your MS Access Forms”

Microsoft Access Tutorial: Hiding Access Tables As 'USYS' System Tables

Microsoft Access Tutorial: Hiding Access Tables As ‘USYS’ System Tables

Hiding tables (or any object) in your Access database is a simple enough process. You only need to set the objects hidden property (to True) and reveal the ‘Hidden Objects’ setting from the navigation pane options screen.

But in this quick Microsoft Access tutorial here, there is another method of stopping your tables appearing in Navigation pane (or Database window) by renaming the table(s) with the prefix USYS. This will convert your table into a system object, which cannot be viewed in the normal environment.

microsoft access tutorial usys tables

In the Navigation pane’s options screen (Access 2007 & 2010), you have two display options the called Continue reading “Microsoft Access Tutorial: Hiding Access Tables As 'USYS' System Tables”

Working With Linked Tables In Access That Have A Password Applied To It

Working With Linked Tables In Access That Have A Password Applied To It

Working with linked tables in Access probably means you have engaged in the process of splitting your database between the tables which is deemed the back-end (BE) with the remaining objects making up the front-end (FE) database.

In some cases however, your BE database may have been protected with a basic encrypted password preventing general users any access directly or indirectly to it. If this password is modified, your linked tables will fail to open the tables via the FE database.

linked tables in access

To check what the current password is (and this is not a very secure system), you could Continue reading “Working With Linked Tables In Access That Have A Password Applied To It”