Access.2007.VBA.Bibl..

n Turn navigation buttons off.

n If your wizard has several forms, make sure that controls used on more than one form in

a series of wizard screens appear in the same place on each form.

n Make all the wizard forms dialog boxes by setting their Modal property to Yes, PopUp to

Yes, and BorderStyle to Dialog, so the user can’t move to the next box until the current

one has been filled in.

n Copy wizard images from the Access wizards, save them as image files, and place them on

your wizard forms.

The Extras Add-in Code ....................................................................................................

The code that implements the add-in’s functionality for creating backup copies of the database or
its back end, and for listing table and query fields, is listed in the next section.

Extras Options ........................................................................................................

The fdlgExtrasOptions form module contains the code behind the Extras Options dialog, where
you can set up your preferences for the backup save folder, or the prefixes to exclude when listing
fields:

Option Compare Database

Option Explicit

Private dbsCalling As DAO.Database

Private fd As Office.FileDialog

Private intChoice As Integer

Private prps As DAO.Properties

Private prp As DAO.Property

Private strBackupChoice As Integer

Private strBackupPath As String

Private strCallingDb As String

Private strPropName As String

Private strTable As String

Private tdfs As DAO.TableDefs

Private tdf As DAO.TableDef

Private txt As Access.TextBox

Private varPropValue As Variant

Private Sub cmdCancel_Click()

On Error Resume Next

DoCmd.Close acForm, Me.Name, acSaveNo

End Sub

Creating Access Add-ins 14