VB Programing support Access Database Microsoft Office VB.Net & SQL Server nev@NevVB.com.au Sydney, Australia (02) 9453-0456 Contact Details 28/01/2012
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 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:
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 Unbound form provides a better and more professional 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: