Visual Basic Programming

Visual Basic Programmer

Access Database.
VBA Programming.
Visual Basic Programming.

Email: nev@NevVB.com.au
Website:     www.NevVB.com.au
Phone: (02) 9453-0456


Home Pages
Programming Services
Visual Basic Projects
Website Projects
Client Projects
All about VisualĀ Basic
Software Development
PC Tuning

Access Database support
Visual Basic Programming
Access Database support
Microsoft Office Software
www.NevVB.com.au


Email for Access development nev@NevVB.com.au


Phone for Access development
Sydney
(02) 9453-0456


Visual Basic Website
Website Optimisation
Effective Copywriting
Market Research
www.NevSEO.com.au




Website Build Date
7/09/2010

Access Database Programming

Microsoft Access Forms – Bound or Unbound?

Microsoft Access Forms - Bound or Unbound? Microsoft Access is designed for rapid application development. A form wizard allows fast and easy application development using Bound forms. The Bound form requires little or no programming, and is ideal for the amateur programmer.

Unbound forms require Visual Basic code to retrieve and update records. The Microsoft Access form can have a mixture of fields that are Bound or Unbound.

The Bound Form

The Bound form has bound fields that are linked directly to the database. Any changes made to a bound field are immediately updated in the corresponding field of the current record of a Table.

The features of the Bound form include:

  • Quick set up time
  • Find, Filter or Sort facility
  • Record number and a navigation bar
  • Spell Checking
  • Selecting, adding, deleting or modifying records

The drawbacks of the Bound Form

Access applications have a habit of growing in size and complexity. In order to add features to the Bound form, the logic can soon become complex. Some problems:

  • The default behaviour of Access may be unacceptable – such as automatically saving fields or records
  • There are performance issues when manipulating data from the Back-End Database
  • There is the need to explicitly control record locking
  • Error messages are not user friendly
  • Validation involving multiple fields is not user friendly
  • Cancellation of an update with the Esc key is not user friendly

The Unbound Form

The Unbound form is often a better solution. It is needed for greater efficiency, to extend user numbers and to provide better control of the application. The Unbound form involves the use of VBA (Visual Basic for Applications) and ADO (ActiveX Data Objects).

The advantages of the Unbound form are:

  • Greater control in reading and writing of records
  • Records are updated only when all fields are valid
  • User friendly error handling
  • Efficiency in accessing records
  • Elimination of concurrency issues
  • Control of saving and deleting records
  • Data integrity.