documentation
.HELP!
Microsoft Office Access 2003 Documentation
Create a table from another table with a query
Microsoft Office Access 2003
previous page
next page
Create a table from another table with a query
Create a table from another table with a query (MDB)
Create a make-table query (ADP)
previous page
start
next page
Menu
Homepage
Table of contents
Startup and Settings
What's new in Microsoft Office Access 2003
Get started with Access 2003
Ways to get started if you've used other database or spreadsheet applications
Ways to get started if you're using a database for the first time
Access Glossary
Access specifications
About product activation in Microsoft Office System products
What's new in Microsoft Office 2003
Disclaimer: Use of Fictitious Names
Terms of Use
Getting Help
Ways to get help on writing code
About getting help while you work
Get Help for Visual Basic for Applications
Get help on Access events and properties
About getting Access product help while in the Visual Basic Editor
Icons in the Search Results task pane
About getting help on SQL Server (ADP)
About getting Help on Microsoft Jet SQL
Change the appearance of a Help topic
Get Script Editor help in a data access page
Print a Help topic
Sample databases included with Access
About the sample XSL transforms that come with Access
Troubleshoot Help
Tips for better search results
The Office Assistant
About tips and messages from the Office Assistant
Select a different Office Assistant
Display tips and messages through the Office Assistant
Hide or show the Office Assistant
Turn the Office Assistant sound on or off
Show or hide the Office Assistant in wizards
Other Resources
Complete an Office Web-based training course
Get help from Microsoft Product Support services
Automatically update this list from the Web
Microsoft Office Online
About Office Communities
Search for help, templates, and additional online content on Microsoft Office Online
Give feedback for Microsoft Office Online or an Office program
Accessibility
About accessibility for people with disabilities
About creating accessible Office documents
Accessibility features in Office Help
Using accessibility features in Access
Using screen readers with Help
Keyboard Shortcuts
Keyboard Shortcuts
Assign or change a keyboard accelerator
Installing and Customizing
What's installed with Access 2003
Which wizards are installed in Access 2003
Change Office's appearance
Components and Add-Ins
Install or remove individual components in Office
Install or uninstall menu add-ins
Wizards, builders, and add-ins in Access 2003
Register an ActiveX control (OLE custom control)
Warn about installed templates and add-ins
Customizing the Desktop
Show or hide actual fonts in the font list
Show or hide the Type a question for help box
Show or hide multiple program buttons on the Windows Taskbar
Change the screen resolution
Show or hide toolbar ScreenTips
Show or hide shortcut keys in ScreenTips
Show the Tip of the Day when an Office program starts
Customizing Access
Customize the Access environment by setting defaults
Set command-line options for starting Access
Startup command-line options
Show or hide the task pane at Access startup
Show or hide the status bar
Turn Microsoft Office Online featured links on or off
Change the default folder for new Access databases, Access projects, or pages
Change the default behavior for selecting or opening database objects
Change default behavior for find or replace operations
Set OLE/DDE preferences
Specify how the insertion point behaves
Turn confirmation messages on or off
Specify the default language sort order (MDB)
Display four-digit years in all fields and controls containing dates
Create your own wizards, builders, and add-ins
Set Access run-time options
Change the font in SQL and query Design View (MDB)
Set the number of files shown in the list of recently used files
Tips for improving the performance of Microsoft Access and your system
Toolbars and Commands
About menus and toolbars
Designate a global menu bar or shortcut menu
Create a toolbar
Add a button, menu, or command
Assign a hyperlink to a toolbar button or menu command
Delete a toolbar, button, or command
Add or delete a shortcut from the My Places bar
Move or copy a button, menu, or menu command
Rename a toolbar, command, or button
Add a submenu to a menu
Show only Web toolbar buttons
Customize a shortcut menu
Group related buttons and menus on a toolbar
Move a submenu anywhere on the screen
Show or hide a toolbar
Add a function to a button or command
Add an access key to a menu, command, or button
Convert a previous-version menu macro to a menu
Import menus and toolbars
Move a toolbar
Restore original toolbar, button, and command settings
Show all buttons or commands
Animate menus
Resize a toolbar
Add, change, or delete sounds used with buttons and menu commands
Change a picture on a button
Change the size of a toolbar button or drop-down list box
Create a custom toolbar
Display an icon, text or both on a menu command or button
Attach a menu or toolbar to a form or report
Display palettes permanently while designing a form or report
Add a button to dial a selected phone number
Control the display of all built-in toolbars and menus
Control whether some or all of the built-in menus are displayed
Prevent or allow the changing of toolbars, buttons, or commands
Troubleshoot toolbars
Customizing an Access Application
About startup options
Ignore startup options
Control how an Access file looks and behaves when it opens
Display a form or data access page at startup
Control the display of the Database window
Display a specific title in the application window title bar
Display a custom icon for an application
Turn on or off Windows theming for form controls
Set ANSI SQL query mode (MDB)
Change the default data type and text size (ADP)
Specify the default language sort order (MDB)
Display four-digit years in all fields and controls containing dates
Restricting Special Keys
Special keys that can be turned on or off at startup
Prevent users from stopping the retrieval of records from the server (ADP)
Prevent or allow access to the Visual Basic Editor or the Immediate window
User Profiles
About customizing your application's environment with user profiles and run-time options
Create an Access user profile
Windows Registry Settings
Customize driver settings
Customize Jet database settings (MDB)
Adding Custom Help
About creating custom Help
Create custom Help
Create help text for a button or command
Troubleshooting Installing Office
I can't activate Microsoft Office
About Office Safe Mode
Enable items that were disabled by Office Safe Mode
Automatically repair Office programs
Troubleshoot installing an Office program
Using Microsoft Office
About the default working folder
Office programs you can use to create an online or printed form
Get information about your program and computer
Set the default working folder
Automatically start an Office program when you turn on your computer
Change the program that starts when you open a file
Office programs you can use to create a table
Connect to a network drive
Create a network place
What happened to the Office Shortcut Bar?
Minimize a window
Minimize all program windows on the Windows desktop
Restore a minimized window
Show all windows on the Windows desktop
Format a disk
Office Clipboard
Move or copy information between programs
About collecting and pasting multiple items
Collect and paste among programs
Copy the window or screen contents
Display the contents of the Office Clipboard
Clear items from the Office Clipboard
Turn off the Office Clipboard
Turn Office Clipboard command options on or off
Troubleshoot collecting and pasting
Using Microsoft Outlook to Enhance Office Applications
About sending e-mail messages
About tracking work and finding files with Microsoft Outlook
Track work and find files with Outlook
Managing Files
Working with Files
About places to save files
About finding files
Save a file
Find a file
Select multiple files
Save an Office document as a TIFF file
Copy a file
Delete a file
Move a file
Rename a file
Troubleshoot saving files
Prompt to open a file as read-only
File Properties
About file properties
View file properties
Change file properties
Create custom file properties for the active document
Remove personal or hidden information
View all hidden file types and file name extensions
Handwriting and Speech
Handwriting Recognition
About handwriting recognition
Install handwriting recognition
Use handwriting recognition
Handwriting recognition toolbars
Change handwriting recognition options
Change the handwriting recognition language
Correct handwriting
Troubleshoot handwriting recognition
Handwriting in East Asian Languages
About handwriting recognition in East Asian languages
Use handwriting recognition in East Asian languages
Change handwriting recognition options in East Asian languages
Handwriting recognition toolbars in East Asian languages
Troubleshoot handwriting recognition in East Asian languages
Speech Recognition
About speech recognition
Show or hide the Language bar
Getting started with speech recognition
Things you can do and say with speech recognition
Use speech recognition
How to speak to a computer
Position the speech recognition microphone
Turn on or off the speech recognition microphone
Switch between using Dictation and Voice Command modes
Change speech recognition engines
Language bar speech recognition messages
Troubleshoot speech recognition
Installing and Training
Install and train speech recognition
Create and use speech recognition user profiles
Add to or delete from the speech recognition dictionary
Correct speech recognition errors
Printing
Print a record, datasheet, or database object
Print mailing labels
Print the design of a database or a database object (MDB)
Print part of a string as group header
Print and preview a database diagram (ADP)
Print a Help topic
Printer Setup
Set up a new printer
Set the default printer
Print Options
Select a paper source
Set page setup options for printing
Set default print margins
Cancel printing
Check the progress of your print job
Donât print page header and footer on first and last pages of a report
Cancel printing if a report doesn't contain any records
Print the group header on the same line as the first detail record
Repeat a group header on another page
Set the option to print each record, group, or section on a separate page
Creating and Working with Databases and Objects
About Access databases
About designing a database
Create an Access database
Improve performance of an Access database
Use the Performance Analyzer to optimize an Access database
Working with Access Files
Open an Access database
Open a sample database or project
Troubleshoot opening files
Create a shortcut to open an Access file or database object
Open a file
Copy or move an Access file
Change the default file format
Delete an Access file
Rename an Access file
Troubleshoot finding files
About setting a hyperlink base for an Access file
Set a hyperlink base for an Access file
View the attributes of an Access file
Remove personal or hidden information
Document the summary information of an Access file or page
Create custom properties for use in finding an Access file
Modify or delete custom properties of an Access file
Graphic filters and file formats Microsoft Access can use
About how Access searches for reference libraries
Back up and restore an Access database (MDB)
Set the number of files shown in the list of recently used files
Compacting and Repairing an Access File
About compacting and repairing an Access file
Compact and repair an Access file
Troubleshoot compacting, repairing or recovering an Access file
Converting Access Databases
About converting an Access file
Convert an Access file
Access 2002 or later features that aren't available in Access 2000
About using an Access file with multiple versions of Access
Use an Access file with multiple versions of Access
Change the default file format
About the Conversion Errors table
Troubleshoot using an Access 2000 file with multiple versions of Access
Database Objects
Tables
Troubleshoot tables and field properties (MDB)
About tables (MDB)
Opening and Viewing Tables
Open a database object
Switch between views of a database object
Creating Tables
About creating a table (MDB)
About customizing a table (MDB)
Create a table (MDB)
About the Table Analyzer's query (MDB)
Convert a linked table to a local table
Split a table into related tables (MDB)
Adding and Deleting Fields
Add a field to a table (MDB)
Guidelines for naming fields, controls, and objects
Copy a field and its properties (MDB)
Delete a field from a table (MDB)
Field Data Types
About data types and field sizes (MDB)
Field data types available in Access (MDB)
About changing a field's data type (MDB)
Set or change a field's data type or size (MDB)
Fields That Look Up Values
About creating a field that looks up or lists values in tables (MDB)
Create a field that looks up or lists values in tables (MDB)
Customizing Fields
Move a column (MDB)
About renaming a field in a table (MDB)
Rename a field in a table or datasheet (MDB)
Set the display format for data in a field or control (MDB)
Set the default control type for a field (MDB)
About setting the number of decimal places to display in a field or control (MDB)
About property sheets
Set the number of decimal places to display in a field or control (MDB)
Change the starting value of an AutoNumber field (MDB)
Set a property in Design view
Default Values in Fields
About defining a default value that is automatically entered in a field or control (MDB)
Set a default value for a field or control (MDB)
Examples of default values in fields (MDB)
Fields With Blank Values
Distinguish between Null values and zero-length strings (MDB)
About blank values in fields
Make a field accept zero-length strings (MDB)
Set properties that control blank values (MDB)
Restricting or Validating Data
About restricting or validating data (MDB)
Examples of field validation rules (MDB)
Validate or restrict data entry in tables (MDB)
Require users to enter data in a field (MDB)
About creating input masks to control how data is entered in a field or control (MDB)
Input mask syntax and examples
Create an input mask (MDB)
Primary Keys and Indexes
About primary keys (MDB)
Set or change the primary key (MDB)
Prevent entry of duplicate values (MDB)
Remove the primary key (MDB)
View or edit indexes (MDB)
About indexing fields and records in an Access database (MDB)
Create an index to find and sort records faster (MDB)
Delete an index (MDB)
Relationships and Referential Integrity
View existing relationships (MDB)
Edit an existing relationship (MDB)
Remove a table from the Relationships window (MDB)
Print the design of a database or a database object (MDB)
About relationships in an Access database (MDB)
About table relationships (ADP)
Define relationships between tables (MDB)
Create a relationship between tables (ADP)
Delete a relationship (MDB)
Set or change the join type (MDB)
Forms
About forms
Ways to work with data in a form
Troubleshoot forms
Opening and Viewing Forms
About views of a form
Open a database object
Switch between views of a database object
Creating Forms
Create a form
About using a template to create a form or report
Set the default template for forms and reports
Use a predefined format
Create, update, or delete an autoformat
Bind a blank form or report to one or more tables or queries
Customizing Forms
Ways to customize a form
Change the record source or connection information
About creating a form with tabs or page breaks
Examples of expressions for page numbers
Add a tab or page break control to a form
Display a Web page on a form
About themes
Apply, change, or remove a theme
Show title and other informational text
Show current date and time
Show page numbers
Set the size and position of a form or report
Customize a form or report window
Show or hide shortcut menu
Prevent a data-entry form or page from showing existing records
Working in Design View
Show or hide the field list
Show or hide the grid
Change the distance between dots on a grid
Open or close the toolbox
Lock or unlock a toolbox tool
About property sheets
Set a property in Design view
Form Sections
About sections of a form
Select a section
Add or remove a section
Show or hide a section
Resize a section
Keep the contents of a section together
Change the background color of a control or section
Creating Subforms
About subforms
Work with subforms
Create a subform
Change the layout of a subform
Make a subform look like a datasheet that displays a header and footer
Move between a main form and a subform in Form view
Calculating Totals
Calculate a total or other aggregate values
Calculate a value
About calculating a total in a subform and displaying it on a form
Validating Data or Restricting Data Access
Validate or restrict data in a form
Disable a view for a form
Make a form or data access page read-only
Specify whether a user can set form properties
Specify whether a user can add, edit, or delete a record
Specify whether a user can move or resize a form or report
Prevent a data-entry form or page from showing existing records
PivotTable Forms
About PivotTable forms
Edit a PivotTable form
Refresh the data in a PivotTable form
Save a copy of a PivotTable form's data
Switchboard Forms
Create, customize, and delete a switchboard form (MDB)
Specify the default switchboard
Pop-Up Forms and Custom Dialog Boxes
About pop-up forms and reports
Create a pop-up form or report
Create a dialog box
Property settings for pop-up forms and reports
Specify a border and title for a pop-up form or report
Temporarily open a form as a dialog box
Reports
About reports
Troubleshoot reports
Opening and Viewing Reports
About views of a report
Open a database object
Switch between views of a database object
Creating Reports
Create a report
About using a template to create a form or report
Set the default template for forms and reports
Use a predefined format
Create, update, or delete an autoformat
Bind a blank form or report to one or more tables or queries
Customizing Reports
Ways to customize a report
Change the record source or connection information
Use a predefined format
Create, update, or delete an autoformat
Specify whether a user can move or resize a form or report
Show title and other informational text
Show current date and time
Set the size and position of a form or report
Customize a form or report window
Working in Design View
Show or hide the field list
Show or hide the grid
Change the distance between dots on a grid
Open or close the toolbox
Lock or unlock a toolbox tool
About property sheets
Set a property in Design view
Report Sections
About sections of a report
Select a section
Add or remove a section
Show or hide a section
Resize a section
Keep the contents of a section together
Change the background color of a control or section
Page Breaks and Page Numbers
Add a page break to a report
Reset page numbers for each group in a report
Examples of expressions for page numbers
Show page numbers
Calculating Totals and Using Expressions
About combining and manipulating text values
Calculate a total or other aggregate values
Calculate a value
Count the number of records in each group or report
Example of a report that calculates running sums
Calculate a running sum
Number each detail record in a group or report
Print part of a string as group header
Combine text values
Creating Mailing and Other Labels
About creating and customizing mailing labels
Create mailing labels
Customize labels created with the Label Wizard
Print mailing labels
Advanced Reports
Create a form to enter report criteria
Display report criteria in a report
Hide duplicate data in a report
Examples of reports that start each group in a new row or column
Subreports
About subreports
Create a subreport
Work with subreports
Multiple-Column and Crosstab Reports
Create a crosstab report
Customize a multiple-column report
Create a multiple-column report
Pop-Up Reports
About pop-up forms and reports
Create a pop-up form or report
Property settings for pop-up forms and reports
Specify a border and title for a pop-up form or report
Report Snapshots
About report snapshots and Snapshot Viewer
Create a report snapshot
Open a report snapshot
Publish a report snapshot to the Web
Automate sending a report snapshot in e-mail
Troubleshoot report snapshots
Queries
Opening, Viewing, and Running Queries
About updating data
Open a database object
Switch between views of a database object
Set the default view of a database object
Stop a query (MDB)
Run a query (MDB)
When can I update data from a query? (MDB)
Troubleshoot queries (MDB)
Creating Queries
About designing a query (MDB)
About types of queries (MDB)
Show only the high or low values in a query (MDB)
Save the SQL statement for a form or report as a query (MDB)
About select and crosstab queries (MDB)
Select and Crosstab Queries
Create a select or crosstab query (MDB)
Action Queries
Update one table based on another table (MDB)
Create a table from another table with a query
Delete duplicate records from a table (MDB)
About action queries (MDB)
Create a delete query (MDB)
Create a table from another table with a query (MDB)
Create an append query (MDB)
Create an update query (MDB)
Parameter Queries
About parameter queries that prompt for criteria (MDB)
Create a parameter query (MDB)
Customizing Queries
Working in the Query Design Grid
Change a column's width in the design grid (MDB)
Move a column (MDB)
Add a column in the design grid (MDB)
Add all fields in a table to a query in the design grid (MDB)
Working with Tables or Queries
Add or remove a table or query in the query design grid (MDB)
Show or hide table names in the query design grid (MDB)
Customize the table and query names in a query (MDB)
Prevent showing duplicate records in a query (MDB)
Working with Fields
About using criteria to retrieve certain records (MDB)
About using wildcard characters
About working with blank fields in queries (MDB)
Select fields to add in the design grid (MDB)
Move a field in the design grid (MDB)
Show or hide a field in a query's results (MDB)
Change a field name in a query (MDB)
Customize the display of fields in a query (MDB)
Display a combo box from a table as a text box in a query (MDB)
Enter criteria to affect when calculations are performed (MDB)
Add or remove a field in the design grid (MDB)
Setting Properties and Default Options
Change a query's permissions (MDB)
Set multiuser query options (MDB)
About property sheets
Set a property in Design view
Using Multiple Tables in Queries
About joining tables or queries in a query (MDB)
Create a lookup column
About AutoLookup queries that automatically fill in data (MDB)
Enable or disable automatic joins in queries (MDB)
Join tables and queries in a query (MDB)
Create an AutoLookup query (MDB)
Delete a join line in a query (MDB)
Change the type of join in a query (MDB)
Using Criteria and Expressions to Retrieve Data
Enter criteria to retrieve certain records (MDB)
Examples of expressions
Use the asterisk (*) in the query design grid (MDB)
Insert or delete a criteria row in the design grid (MDB)
Use expressions in a query (ADP)
Where to enter expressions in queries and filters (MDB)
Performing Calculations
About calculations in a query (MDB)
Create a calculated field in a query (MDB)
Total records in a query (MDB)
Enter criteria to affect when calculations are performed (MDB)
SQL Queries
About SQL queries (MDB)
Create an SQL-specific query (MDB)
View, modify, or copy a query's SQL statement (MDB)
Create tables from the results of a pass-through query (MDB)
Examples of union queries (MDB)
Examples of data-definition queries (MDB)
ANSI SQL Query Mode
About ANSI SQL query mode (MDB)
About avoiding the mixing of queries created under different ANSI SQL query modes (MDB)
Set ANSI SQL query mode (MDB)
Microsoft Jet SQL Reference
Glossary
What's New
What's New in Microsoft Jet 4.0
What's New with Jet 4.0 Data Definition Language
What's New with Jet 4.0 Data Manipulation Language
What's New with Jet 4.0 Windows Registry Settings
About Microsoft Jet 4.0 Service Packs
Overview
SQL Aggregate Functions
SQL Expressions
SQL Reserved Words
SQL Data Types
SQL Subqueries
ODBC Scalar Functions
Calculating Fields in SQL Functions
Comparison of Microsoft Jet SQL and ANSI SQL
Equivalent ANSI SQL Data Types
Using Wildcard Characters in String Comparisons
Data Definition Language
CREATE TABLE Statement
CREATE INDEX Statement
CREATE PROCEDURE Statement
CREATE USER or GROUP Statement
CREATE VIEW Statement
ADD USER Statement
DROP USER or GROUP Statement
ALTER TABLE Statement
ALTER USER or DATABASE Statement
DROP Statement
GRANT Statement
REVOKE Statement
Data Manipulation Language
SELECT Statement
SELECT...INTO Statement
INSERT INTO Statement
UPDATE Statement
DELETE Statement
EXECUTE Statement
TRANSACTION Statement
TRANSFORM Statement
INNER JOIN Operation
LEFT JOIN, RIGHT JOIN Operations
UNION Operation
PARAMETERS Declaration
WITH OWNERACCESS OPTION Declaration
Clauses
CONSTRAINT Clause
FROM Clause
GROUP BY Clause
HAVING Clause
IN Clause
ORDER BY Clause
PROCEDURE Clause
WHERE Clause
Functions
Avg Function
Count Function
First, Last Functions
Min, Max Functions
StDev, StDevP Functions
Sum Function
Var, VarP Functions
Operators and Predicates
ALL, DISTINCT, DISTINCTROW, TOP Predicates
Between...And Operator
In Operator
Like Operator
Windows Registry Settings for External Data Sources
Customizing Windows Registry Settings for Microsoft Jet
Creating a Portion in Your Application's Registry Tree to Manage the Settings
Using Regedit.exe to Overwrite the Default Settings
Initializing the dBASE Database Driver
Initializing the Lotus Driver
Initializing the Microsoft Excel Driver
Initializing the Microsoft Exchange Data Source Driver
Initializing the Microsoft Jet 4.0 Database Engine Driver
Initializing the Microsoft Jet 3.5 Database Engine Driver
Initializing the Microsoft Jet 2.5 Database Engine Driver
Initializing the Paradox Database Driver
Initializing the Text Data Source Driver
Configuring the Microsoft Jet Database Engine for ODBC Access
Using the Connection Properties in the Microsoft OLE DB Provider for Jet
Using the SetOption Method from DAO
Data Access Pages
About data access pages
Troubleshoot data access pages
About securing a data access page
Differences between forms, reports, and data access pages
Differences in page support between Internet Explorer 5.01 with Service Pack 2 (SP2) and 5.5 or later
System requirements for sending and viewing a data access page
Publish Web pages
Default names for data access page supporting folders
About sending a data access page in e-mail
Data Access Page Basics
Creating Data Access Pages
Open a database object
Switch between views of a database object
Strategies for creating data access pages
Create a data access page
Convert an existing Web page into a data access page
Convert a previous-version data access page
Connecting to Data
About using connection files
Create a connection file
Specifying absolute path in the connection string of a page
Open a data access page on a Web server in Access
Open an Access data file on a network by using a UNC address
Set or change the connection information of a data access page
Set or change the record source of a data access page section
Working in Design View
About adding data to a data access page by using the field list
Show or hide the field list
Refresh the field list of a data access page
Show or hide the grid
About the data outline
Change the distance between dots on a grid
Open or close the data outline
Open or close the toolbox
Lock or unlock a toolbox tool
About property sheets
Set a property in Design view
Saving Data Access Pages
About saving an object as a data access page
About saving a password in a data access page
Save a copy of a data access page to a Web server
Save a copy of a data access page to a Web server in Windows Explorer
Work with FTP
Designing Data Access Pages
Changing a Page's Overall Appearance
Customize a data access page in Design view
Set alternate row color for a data access page
Set the section indent for a data access page
Show or hide the record selector
Remove the placeholder text at the top of a data access page
About themes
About working with graphics on a data access page
Format the body text of a data access page
Add or delete an expand control
Apply, change, or remove a theme
Change the background color of a control or section
Customize the expand control on a page
Add or delete a record navigation control
Customize a record navigation toolbar
Calculating Values and Totals
Calculate a total or other aggregate values
Change the aggregate function of a calculated control
Calculate a value
Working with Settings
Specify whether a group is expanded or collapsed by default on a page
Specify default settings for new data access pages
Make a form or data access page read-only
Set the default control type for a data access page
Set the bound span as the default control for a data access page
Specify whether a user can add, edit, or delete a record
Specify which record source of a page supports edits
Define or edit a relationship between record sources in a data access page
Set the encoding for a Web page
Prevent a data-entry form or page from showing existing records
Working with Data Access Pages in Page View
Work with data in Page view
Get help on working with a data access page in Page view
Add, change, or delete the path to a bound picture in Page view
Show or hide records in Page view
Using Microsoft Office Web Components
About Microsoft Office Web Components
About installing, licensing, and distributing Office Web Components
About View-only mode for Office Web Components
Create a PivotTable list on a data access page
Activate a PivotTable list, spreadsheet, or chart on a data access page
Change the external connection information for a PivotTable list
Create a chart for the Web on a data access page
Add a spreadsheet to a data access page
Make a spreadsheet look like a text box
Working with Offline Pages
About offline data (ADP)
Make a data access page available offline (ADP)
Make an offline data access page online (ADP)
Switch between offline and online modes of a page (ADP)
Synchronize an offline data access page with source data (ADP)
Working with Files and Links
Show or update the link to a data access page
About working with graphics on a data access page
Troubleshooting
I get a message when I attempt to enter data in Page view.
I get the message
Troubleshoot data access pages
I get the message
I get the message
Troubleshoot HTML formatted files
I get the message
I get the message
Working with Database Objects
Open a database object
Switch between views of a database object
Set the default view of a database object
About copying a database object
Copy a database object
Delete a database object
Rename a database object
Preview a database object
View a list of database objects
Save a database object
Save a database object as another object type
Show or change the general properties of a database object
Set or change the description of a database object
Show or hide shortcuts for creating new database objects
Show or hide database objects
Grouping Database Objects
About groups of database objects
Group database objects
Add a database object to a group
Remove a database object from a group
Rename a database object in a group
Delete or rename a group of database objects
Controls and Charts
About types of controls in Access
Add a field to a form, report, or data access page
Troubleshoot controls
Labels and Text Boxes
Create a label
About blank values in fields
Create a text box
Attach a label to a control
Set defaults for labels attached to new controls
Change text in a label or command button
Set the margins within a label or text box
Display text vertically on a form or report
Create and customize a scrolling text control
Examples of text boxes that grow or shrink when printing forms and reports
Make a text box grow or shrink to fit data when printing a form or report
Check Boxes, Option Buttons, and Option Groups
Create a check box, toggle button, or option button
Create an option group
Move a control to an option group
List Boxes, Combo Boxes, and Drop-Down List Boxes
About creating a list box, combo box, or drop-down list box that looks up values
Create a list box, combo box, or drop-down list box
Specify which row is the default value in a list box or combo box
Find a record by selecting a value from a list
Properties of list boxes, combo boxes, drop-down list boxes, and Lookup fields
Customize a list box, combo box, or drop-down list box
Command Buttons
Work with command buttons
About command buttons
Create or modify a command button
Create a script for a command button on a data access page
Change text in a label or command button
Make a command button the default button in a form or custom dialog box
Make a command button the Cancel button
Tab Controls
Customize a tab control
Creating Controls
About creating controls
About setting defaults for a control type
Guidelines for naming fields, controls, and objects
Bind a control to a field
Create a bound span control
Set tab order
Assign an access key to a control
Add an ActiveX control (OLE custom control)
HTML elements and classes for controls on a page
Draw a rectangle or line
Use a grid of grouped lines as a table for displaying data
How control properties relate to properties in their underlying fields
Show or hide the Property Update Options button
Propagate changes in field properties to bound controls
Customizing Controls
About customizing a control
About display formats for fields or controls (MDB)
Add or remove scroll bars
Move a control to an option group
Align controls to each other
Change the appearance of the border of a control
Change a control to another control type
Show or hide a control
Change the background color of a control or section
Turn on or off Windows theming for form controls
Make a control transparent
Show a tip when the pointer moves over a control
Show instructions for a control in the status bar
Select one or more controls
Customize the appearance of text in a control
Move one or more controls
Make a control appear raised, sunken, shadowed, chiseled, or etched
Make a control read-only
Change default properties for a control type
Change the spacing between controls
Resize a control
Copy formatting from one control to another
Base the value of a control on another control
Create custom colors
Turn Snap To Grid behavior on or off
Set a color property to a system color
Groups of Controls
Group or ungroup controls
Select a control that is part of a group
Add or remove a control in a group
Move or resize a control in a group
Pictures and Objects
About adding a picture or object
Add a picture or object
Delete a picture or object
Edit a picture or object
Make a picture or object read-only
Show an icon in place of a picture or object
Resize a picture
Show alternate text for a picture
Update a link to a picture or object
Add a picture to a command or toggle button
Convert an OLE object to a different version
Using Charts in Forms and Reports
About charts
Add a chart to a form or report
About making changes to a chart in a form or report
Change the data for a chart in a form or report
Change the look of a chart in a form or report
Add the Chart button to a toolbar
Save disk space with a chart in a form or report
Troubleshoot charts in a form or report
Conditional Formatting
Apply or change conditional formatting on a control
Copy the conditional formatting of a control
About applying conditional formatting to a control
Viewing Dependency Information
About object dependencies (MDB)
About ignored objects (MDB)
View dependency information (MDB)
About using Name AutoCorrect to fix errors caused by renaming (MDB)
Automatically repair errors caused by renaming (MDB)
Troubleshoot Name AutoCorrect (MDB)
Troubleshoot viewing dependency information (MDB)
Checking for Errors in Forms and Reports
About error checking in forms and reports
Turn error checking on or off
Circular reference
Duplicate keyboard shortcut
Duplicate option value
Expressions must begin with an equal sign (=)
Invalid sorting and grouping
New unassociated label
No such field in the field list
Report width is greater than page width
Spacebar is not a valid keyboard shortcut
Unassociated label and control
Unassociated label with keyboard shortcut
Working in the Database Window
About ways to use the Database window
Refresh the Database window
Change the appearance of objects in the Database window
Display multiple database objects on the Windows taskbar
Control the display of the Database window
Troubleshooting Databases
Troubleshoot converting an Access file
Troubleshoot undefined functions and references to projects or libraries
Fix a reference to a library
Working with Data
About analyzing data
Adding and Modifying Data
Add or edit data
Save a record
Delete a record
Undo changes
About compressing the data in a Text, Memo, or Hyperlink field (MDB)
Expand a field, property box or text box to make it easier to edit
Insert a default value in a field
Repeat the value from the previous record
Indicate nonexistent data with a zero-length string
Turn on or off automatic correction of text and data
Type ¢, £, ¥, & ®, and other characters not on the keyboard
I can't display my records again after using the Data Entry command. (MDB)
Move between records or fields
Record selector symbols
About working with data in a datasheet
Troubleshoot editing data in a field in Datasheet or Form view
Select fields and records
Cutting and Copying Data
Copy or move data
Copy or move a control or other item
About pasting data from another application
Delete a control or another item
Troubleshoot problems when pasting data
Finding, Sorting, and Grouping Data
Finding and Replacing Data
About finding or replacing data
Find or replace a value in a field
Find a record in a datasheet or form
Troubleshoot finding and replacing data
Filtering Data
About Filters (MDB)
Apply a filter (MDB)
Create a filter (MDB)
Modify a filter (MDB)
Remove a filter (MDB)
Delete or remove a filter (MDB)
Switch between filter windows (MDB)
Create a database object from filtered records (MDB)
Enable or disable filtering records in a form (MDB)
Troubleshoot filters (MDB)
Sorting Data
About sorting records (MDB)
Sort records (MDB)
Delete a sort (MDB)
Troubleshoot sort (MDB)
Grouping Data
About grouping records
Group records
Promote or demote a field, table, or query
Merge groups
Set the number of records to display in a group
Keep a group of records together on a page
Change sorting and grouping levels
Examples of grouped reports
Hyperlinks
About hyperlinks
Change a hyperlink
Change the default formatting of hyperlinks
Create a field to store hyperlinks (MDB)
Create a hyperlink
Create a picture or command button that works as a hyperlink
Delete a hyperlink
Enter a hyperlink into an existing hyperlink address
Troubleshoot hyperlinks
Check Spelling
Check spelling
Choose a custom dictionary for checking spelling
Set spelling options
Set the language for checking spelling
Troubleshoot spelling
Viewing Data
Datasheets
Changing the Appearance of a Datasheet
Set defaults for the appearance of datasheets
Change font, or font style, size, and color in a datasheet
Change the gridline style and background color in a datasheet
Freeze and unfreeze columns in a datasheet
Show or hide columns in a datasheet
Resize a column or row
Troubleshoot datasheets and subdatasheets
Subdatasheets
About subdatasheets
Insert or modify a subdatasheet
Remove a subdatasheet
Expand or collapse a subdatasheet
Show or hide the foreign key in a subdatasheet
PivotTable and PivotChart Views
About designing a PivotTable or PivotChart view
Examples of chart types in PivotChart view
Elements of a PivotTable or PivotChart view
Select an element in PivotTable or PivotChart view
Show or hide the Properties dialog box in PivotTable or PivotChart view
Troubleshoot PivotTable or PivotChart view
Customizing the Layout
About customizing the layout of a PivotTable or PivotChart view
View information about a field or item in PivotTable view
Add, move, or remove a field in PivotTable or PivotChart view
Change the chart type in PivotChart view
Display multiple charts in PivotChart view
Change PivotChart view series to categories, or categories to series
Show or hide elements of a PivotTable or PivotChart view
Add or change captions, labels, and titles in PivotTable or PivotChart view
Formatting a PivotTable or PivotChart View
About formatting a PivotTable or PivotChart view
Format an element in PivotTable or PivotChart view
Format the contents of a PivotTable view to read right to left or left to right
Add, remove, or change axes in PivotChart view
Add, remove, or change error bars in PivotChart view
Add, remove, or change a trendline in PivotChart view
Add, remove, or change a legend in PivotChart view
Number formats available in PivotTable or PivotChart view
Working with Settings
Allow multiple selection in a filter field
Automatically show items or details in PivotTable view
Prevent users from making changes in PivotChart view
Working with Data
About calculating totals in PivotTable view
Customize a total field in PivotTable view
Functions available in PivotTable or PivotChart view of a form
Summary functions available in PivotTable or PivotChart view
Edit a calculated field in PivotTable view
Show data as hyperlinks in PivotTable view
Plot direct record values in PivotChart view
Sharing Data
About sharing an Access database on a network (MDB)
About saving design changes to a shared Access database (MDB)
Share a database (MDB)
Split an Access database (MDB)
Refresh or requery data
Set options for a shared Access database (MDB)
Troubleshoot a shared database (MDB)
Set OLE/DDE preferences
External Data
Automate importing, exporting, or linking data
About XML data and Access
About connections
Exporting Data or Objects
About exporting data and database objects
Export data or database objects
Merge tables or queries into Word mail merge files
Set options and send objects in electronic mail
Data formats you can export to
Troubleshoot exporting in Access
Export Access data as XML
About XSL transformation files
Importing and Linking Data or Objects
About importing and linking data and database objects
Data sources you can import or link
Import or link data and objects
About using the MSysConf table to optimize your linked SQL database (MDB)
View, refresh, or change the file name and path for linked tables (MDB)
Create a field to store paths to pictures
Refresh the data in a linked picture or object
Update a link to a picture or object
Use custom colors from another application
Delete the link to a linked table in an Access database
Troubleshoot importing and linking
ODBC and Built-in Drivers
About ODBC data sources
Set up or change ODBC data sources
Differences between ODBC drivers and built-in drivers for external data
Expressions
About the Expression Builder
About expressions
About Microsoft Jet Expression Service sandbox mode
Functions that are blocked in sandbox mode
Troubleshoot expressions
Glossary
Creating Expressions
Create an expression
Refer to objects in expressions
About referring to an object or its properties in expressions
Enable the use of an ActiveX control in expressions
Examples of Expressions
Examples of expressions
Examples of referring to controls in expressions
Examples of expressions for page numbers
Functions
Arrays
LBound Function
UBound Function
Conversion
Asc Function
Chr Function
DateSerial Function
DateValue Function
Day Function
FormatCurrency Function
FormatDateTime Function
FormatNumber Function
FormatPercent Function
GUIDFromString Function
Hex Function
Hour Function
Minute Function
Month Function
Nz Function
Oct Function
Second Function
Str Function
StrConv Function
TimeSerial Function
TimeValue Function
Type Conversion Functions
Val Function
Weekday Function
Year Function
Database
CodeDb Method
CreateControl Method
CreateForm Method
CreateGroupLevel Method
CreateObject Function
CreateReport Method
CreateReportControl Method
CurrentDb Method
CurrentUser Method
DeleteControl Method
DeleteReportControl Method
GetObject Function
HyperlinkPart Method
IMEStatus Function
Partition Function
SysCmd Method
Date/Time
Date Function
DateAdd Function
DateDiff Function
DateSerial Function
DatePart Function
DateValue Function
Day Function
IsDate Function
MonthName Function
Now Function
Time Function
Timer Function
WeekdayName Function
Hour Function
Minute Function
Month Function
Second Function
TimeSerial Function
TimeValue Function
Weekday Function
Year Function
DDE/OLE
DDE Function
DDEInitiate Function
DDERequest Function
CreateObject Function
LoadPicture Method
GetObject Function
Domain Aggregate
DAvg Function
DCount Function
DFirst, DLast Functions
DLookup Function
DMin, DMax Functions
DStDev, DStDevP Functions
DSum Function
DVar, DVarP functions
Error Handling
CVErr Function
Err Object
Error Function
IsError Function
Financial
DDB Function
FV Function
IPmt Function
IRR Function
MIRR Function
NPer Function
Pmt Function
PPmt Function
PV Function
Rate Function
SLN Function
SYD Function
General
CodeDb Method
Command Function
DeleteSetting Statement
DoEvents Function
Environ Function
FileDateTime Function
FileLen Function
FreeFile Function
GetAllSettings Function
GetSetting Function
QBColor Function
RGB Function
SaveSetting Statement
Shell Function
NPV Function
Version Property
Input/Output
CurDir Function
Dir Function
EOF Function
FileAttr Function
GetAttr Function
Input Function
Loc Function
LOF Function
Seek Function
SetAttr Statement
Spc Function
Tab Function
Inspection
IsArray Function
IsEmpty Function
IsMissing Function
IsError Function
IsNull Function
IsDate Function
IsNumeric Function
IsObject Function
TypeName Function
VarType Function
Math
Abs Function
Atn Function
Cos Function
Exp Function
Int, Fix Functions
Log Function
Rnd Function
Round Function
Sgn Function
Sin Function
Sqr Function
Tan Function
Messages
InputBox Function
MsgBox Function
Program Flow
Choose Function
IIf Function
Switch Function
SQL Aggregate
Avg Function
Count Function
First, Last Functions
Min, Max Functions
StDev, StDevP Functions
Sum Function
Var, VarP Functions
Text
Asc Function
Format Function
Chr Function
InStr Function
InStrRev Function
LCase Function
Left Function
Len Function
LTrim, RTrim, and Trim Functions
Mid Function
Replace Function
GUIDFromString Function
Right Function
Space Function
StrComp Function
String Function
StrReverse Function
UCase Function
StrConv Function
Access Projects
Understanding a Microsoft Access Project
About an Access project (ADP)
About offline data (ADP)
About differences between data types in an Access database and Access project
About SQL Server 2000 Desktop Engine
Install and configure SQL Server 2000 Desktop Engine
Ways to deploy an Access project
Comparison of functions between Visual Basic for Applications and SQL Server Transact-SQL (ADP)
About getting help on SQL Server (ADP)
About OLE DB and Data Links
Troubleshoot Access projects (ADP)
Improve performance of an Access project
Change the default data type and text size (ADP)
Creating an Access Project
Basic Tasks
Open an Access project
Create an Access project
Connect an Access project to a Microsoft SQL Server database (ADP)
Install and configure SQL Server 2000 Desktop Engine
Link tables in an Access project by using the Link Table Wizard (ADP)
Show SQL Server properties (ADP)
Drop a database (ADP)
Create a lookup column (ADP)
Create an input mask (ADP)
Back up and restore a database or Access project (ADP)
Create a column to store hyperlinks (ADP)
Filtering and Sorting Data
About filters (ADP)
About sorting records (ADP)
Apply a filter (ADP)
Create a filter (ADP)
Delete a local sort (ADP)
Delete or remove a filter (ADP)
Modify a filter (ADP)
Sort records (ADP)
Troubleshoot filters (ADP)
Troubleshoot sort (ADP)
Upsizing from an Access Database
About upsizing a Microsoft Access database
Upsize your Microsoft Access database
Use the Upsizing Wizard
Troubleshoot the Upsizing Wizard
Designing a Database
Columns and Tables
About columns and column properties (ADP)
Set column properties (ADP)
Troubleshoot tables and columns (ADP)
Change a columnâs identity properties (ADP)
About Table Designer (ADP)
Add tables to a database diagram or database (ADP)
Change a table view in a database diagram (ADP)
Hide a table in a database diagram (ADP)
Change which properties appear in a database diagram (ADP)
Copy columns from one table to another (ADP)
Copy a table across database diagrams (ADP)
Delete a table from the database (ADP)
Delete columns from a table (ADP)
Duplicate a table (ADP)
Insert columns into a table (ADP)
Move columns from one table to another (ADP)
Save your work in Table Designer (ADP)
Rename a column (ADP)
Rename a table (ADP)
Resize property columns (ADP)
Create a column to store hyperlinks (ADP)
About tables (ADP)
Constraints, Keys, Indexes, and Triggers
Replace a global default value with a default value (ADP)
Troubleshoot keys, relationships, and indexes (ADP)
Constraints
About constraints (ADP)
Create a constraint (ADP)
Create constraint validation text (ADP)
Delete a constraint (ADP)
Disable a constraint (ADP)
Modify or rename a constraint (ADP)
View foreign key constraint attributes (ADP)
Keys
About keys (ADP)
Delete an index (ADP)
Indexes
Rename an index (ADP)
Specify a fill factor for an index (ADP)
Update an index (ADP)
About indexes (ADP)
Create an index (ADP)
Triggers
About triggers (ADP)
Create a trigger (ADP)
Delete a trigger (ADP)
Open a trigger (ADP)
Rename a trigger (ADP)
Database Designer
About Database Designer (ADP)
About Database Designer considerations for SQL Server databases (ADP)
Discard changes made in Database Designer or Table Designer (ADP)
About large database projects (ADP)
Database Diagrams
Add labels to relationship lines in a database diagram (ADP)
Adjust the table size in a database diagram (ADP)
Annotate database diagrams (ADP)
Arrange tables automatically in a database diagram (ADP)
Create a database diagram (ADP)
Interactions among database diagrams and table design windows (ADP)
Interactions between database diagrams, table design windows, and the database (ADP)
Merge subdiagrams into a master database diagram (ADP)
Print and preview a database diagram (ADP)
Reconcile a database diagram with a modified database (ADP)
Save an entire database diagram (ADP)
Save selected tables on a database diagram (ADP)
Select multiple objects in a database diagram (ADP)
Subdivide a database diagram (ADP)
Zoom a database diagram (ADP)
Joins and Relationships
How the Query Designer represents joins (ADP)
About joining tables automatically (ADP)
Check existing data when creating a relationship (ADP)
Copy primary key column properties to a foreign key column (ADP)
Create an outer join in a query (ADP)
Create a self-join in a query automatically (ADP)
Create a self-join in a query manually (ADP)
Enforce referential integrity between tables (ADP)
Draw a reflexive relationship (ADP)
Troubleshoot keys, relationships, and indexes (ADP)
Rename a relationship (ADP)
Map many-to-many relationships in a database diagram (ADP)
Modify a join operator in a query (ADP)
Create a join between tables on multiple columns in a query (ADP)
Create a join between tables, views, or functions in a query manually (ADP)
Remove a join in a query (ADP)
Delete a relationship (ADP)
Queries
Troubleshoot queries (ADP)
Query Designer
About the Query Designer layout (ADP)
About summary and grouping behavior in the Query Designer (ADP)
About using the Query Designer with international data (ADP)
About creating queries (ADP)
Add columns to a query (ADP)
Basic Query Tasks
About Query Designer considerations for SQL Server databases (ADP)
Add a comment to a query (ADP)
Add tables, views, and functions to a query (ADP)
Create column aliases in a query (ADP)
Create a subquery (ADP)
Verify a query (ADP)
Create table aliases in a query (ADP)
Exclude duplicate rows in a query (ADP)
Remove tables, views, or functions from a query (ADP)
Reorder output columns in a query (ADP)
Include user-defined functions in a query (ADP)
Run a parameter query (ADP)
About different query types (ADP)
Create a query (ADP)
Modify an indexed view (ADP)
Create and use a parameter query (ADP)
Execute a query in the Query Designer (ADP)
Create a make-table query (ADP)
Create an append query (ADP)
Create an update query (ADP)
Create a delete query (ADP)
Search Conditions
Rules and grid-pane conventions for combining search conditions (ADP)
Comparison operators (ADP)
Logical operators (ADP)
Select rows that do not match a value in a query (ADP)
Rules for entering search values (ADP)
Specify search conditions (ADP)
Examples of using wildcard characters (ADP)
Expressions and Calculations
About aggregate functions (ADP)
About expressions in queries (ADP)
Group rows in query results (ADP)
Summarize or aggregate values for all rows in a query (ADP)
Summarize or aggregate values using custom expressions (ADP)
Use HAVING and WHERE clauses in the same query (ADP)
Transact SQL scalar functions for expressions (ADP)
Count rows in a query (ADP)
Sharing and Updating Data
About handling concurrent updates (ADP)
Set the number of records retrieved in an Access project (ADP)
About copying data and databases in an Access project (ADP)
Ways to deploy an Access project
Copy or transfer a SQL Server database (ADP)
Troubleshoot copying, transferring, and linking to a SQL Server database (ADP)
Troubleshoot updating data (ADP)
About updating data in an Access project
Making an Access Project More Secure
About securing an Access project (ADP)
About securing Visual Basic for Applications code in Access projects
Protect a Microsoft Access project (ADP)
Selecting the type of security validation used when logging on to SQL Server (ADP)
About enabling the System Administrator (SA) user name in an Access project
Enable or disable the System Administration (SA) user name in an Access project (ADP)
Change an encrypted view in an Access project (ADP)
About ADE files (ADP)
Query, Table, and Database Designer Reference
Summary of dialog box Help in Microsoft Access Project Designers
Summary of extended properties in a Microsoft Access Project
Summary of messages in Microsoft Access Project Designers
Similarities between Access Databases and Projects
About filters
About indexes
About keys
About queries
About sorting records
About table relationships
About tables
Add columns to a query
Apply a filter
Backup and restore an Access file
Create a delete query
Create a filter
Create a join in a query
Create a relationship between tables
Create an append query
Create an index
Create an input mask
Create an update query
Create and use a parameter query
Delete a join in a query
Delete a relationship
Delete a sort
Delete an index
Delete or remove a filter
Exclude duplicate rows in a query
Modify a filter
Modify a join in a query
Run a query
Sort records
Total records in a query
Troubleshoot filters
Troubleshoot queries
Troubleshoot sort
Database Replication
Understanding Replication
Changes made to your database when you use replication (MDB)
About choosing a tool for replication (MDB)
About changing the design of a replicated database (MDB)
About the replica set retention period setting (MDB)
About AutoNumber field size and replicated databases (MDB)
Troubleshoot replication (MDB)
Replicating a Database
Create a replicated database (MDB)
Methods and properties used to programmatically replicate a database (MDB)
Make a replicated database a regular database (MDB)
Replica Visibility
About replica visibility (MDB)
A comparison of global, local, and anonymous replicas (MDB)
Synchronizing Data
About choosing a synchronization method (MDB)
About synchronization conflicts (MDB)
Synchronize and resolve conflicts in a replica set (MDB)
About setting replica priority (MDB)
Security and Privacy
Security
Overview of Access security (MDB)
Troubleshoot security (MDB)
About making connections to external data sources more secure
Making an Access File More Secure
About distributing a security-enhanced application (MDB)
About user-level security (MDB)
Remove user-level security (MDB)
Help protect an Access database and its objects with user-level security (MDB)
Security Zones in Access
Create, join, or fix workgroup information files (MDB)
Manage user and group accounts (MDB)
Types of permissions (MDB)
About securing a replicated database (MDB)
Making an Access Project More Secure
About securing an Access project (ADP)
About securing Visual Basic for Applications code in Access projects
Protect a Microsoft Access project (ADP)
Selecting the type of security validation used when logging on to SQL Server (ADP)
About enabling the System Administrator (SA) user name in an Access project
Enable or disable the System Administration (SA) user name in an Access project (ADP)
Change an encrypted view in an Access project (ADP)
Protecting Code
About securing Visual Basic for Applications code in Access databases (MDB)
Troubleshoot Visual Basic code security (MDB)
About securing Visual Basic for Applications code in Access projects
Remove a Visual Basic for Applications code password
About MDE and ADE files
About MDE files (MDB)
Passwords
About passwords (MDB)
Create, change, or remove passwords (MDB)
About linking tables from a password-protected database (MDB)
Troubleshoot passwords (MDB)
Digital Signatures
About digital signatures
Add a digital signature to macro project
Remove a digital signature
Create your own digital certificate
Review digital certificates for a macro project
Macros
About helping protect files from macro viruses
Macro security levels
Change the security level for macro virus protection
Modify the list of trusted publishers for macros
Troubleshoot macro security
Troubleshoot macro security and warnings
Macros
Troubleshoot modifying the list of trusted publishers for macros
Warn about installed templates and add-ins
Privacy
Microsoft Office Access 2003 Privacy Statement
Microsoft Office Activation/Registration Privacy Statement
Access and the Web
About the types of Web pages Access creates
About where to save on the Web
Turn off automatic completion of file names and URLs
Troubleshoot HTML formatted files
Online Meetings
About online meetings
Accept a request for an online meeting
View a list of participants in an online meeting
Control an Access database, Access project, or data access page in an online meeting
Remove a participant from an online meeting
Open Chat in an online meeting
Use the Whiteboard in an online meeting
End an online meeting
Troubleshoot online meetings
Data on the Web
Speed up downloading Web pages by using Vector Markup Language
Set the language encoding for a Web page
Cancel the display of a Web page or hyperlink
About managing Web files and links
About single file Web pages (MHTML)
Refresh the display of the active file or Web page
Go back to the previous drive, folder, or Internet location
Language-specific names for Web page supporting folders
Optimize Web pages for a specific browser
Troubleshoot Web page options
Graphics on the Web
About working with graphics on Web pages
About Portable Network Graphics (.png) format
Save graphics in .png format
Working with Scripts
About creating and editing a Visual Basic script on a Web page
About Visual Basic scripts in a Web page
Create a script on a Web page
Working with Smart Tags
About Smart Tags
About the smart tags supplied by Microsoft
Add a smart tag to a control
Show smart tags
Hide smart tags
Access and Windows SharePoint Services
Link a table to a Windows SharePoint Services list
How Access converts between Access and SharePoint data types
Import from a Microsoft Windows SharePoint Services list
Export a table or query to a Windows SharePoint Services list
Sharing Information
With Other People
About Microsoft Office Document Imaging
With Other Programs
About applications that work with Access
Programmability
Actions
A-F
AddMenu Action
ApplyFilter Action
Beep Action
CancelEvent Action
Close Action
CopyDatabaseFile Action
CopyObject Action
DeleteObject Action
Echo Action
FindNext Action
FindRecord Action
G-N
GoToControl Action
GoToPage Action
GoToRecord Action
Hourglass Action
Maximize Action
Minimize Action
MoveSize Action
MsgBox Action
O
OpenQuery Action
OpenDataAccessPage Action
OpenDiagram Action
OpenForm Action
OpenFunction Action
OpenModule Action
OpenQuery Action
OpenReport Action
OpenStoredProcedure Action
OpenTable Action
OpenView Action
OutputTo Action
P-R
PrintOut Action
Quit Action
Rename Action
RepaintObject Action
Requery Action
Restore Action
RunApp Action
RunCode Action
RunCommand Action
RunMacro Action
RunSQL Action
S
SendObject Action
Save Action
SelectObject Action
SendKeys Action
SendObject Action
SetMenuItem Action
SetValue Action
SetWarnings Action
ShowAllRecords Action
ShowToolbar Action
StopAllMacros Action
StopMacro Action
T-Z
TransferDatabase Action
TransferDatabase Action
TransferSpreadsheet Action
TransferSQLDatabase Action
TransferText Action
Events
About events and event procedures
About setting the value of a control or property in response to an event
Set the value of a property in response to an event
Example of setting the value of a property in response to an event
Order of events for database objects
Macros
About macros and macro groups
Troubleshoot macros
Creating and Customizing Macros
Create a macro or macro group
Modify macros
Open the Macro window or the Visual Basic Editor
Convert macros to Visual Basic
Using Conditions in Macros
Examples of macro conditions
Using Macros to Work with Forms
About synchronizing records between two forms
Synchronize two forms by using the Form Wizard
Examples of synchronizing two forms programmatically
About printing a report from a form
Data Validation
About validating data programmatically
Validate data programmatically
Order of validation for controls and fields
Running and Debugging Macros
Run macros
Find problems in a macro by single stepping through it
Making Key Assignments
Assign an action or set of actions to a key
Basic Programming Concepts
Should I use a macro or Visual Basic?
Open the Macro window or the Visual Basic Editor
Secure Visual Basic for Applications code in Access databases (MDB)
Using Help
Ways to get help on writing code
Copy Visual Basic code examples from Help to the Code window
Get help on Access events and properties
Working with Modules
About modules
About procedures
Working in the Visual Basic Editor
Ways to get help on writing code
About working with data and database objects by using Visual Basic code
Change the display of your Visual Basic code
Create a Visual Basic procedure
Example of using Visual Basic to change a query's SQL statement
Get information about the objects used in your Visual Basic code
Guidelines for naming Visual Basic procedures, variables, and constants
Require variable declarations for Visual Basic code
Run Visual Basic code
Use arguments in Visual Basic
Debugging, Troubleshooting, and Optimizing
About errors in Visual Basic code
Debug your Visual Basic code
Improve Visual Basic code performance
Troubleshoot Visual Basic code
Setting Programmatic Operations
Create a message box programmatically
Navigate between controls, records, and form pages programmatically
Validate data programmatically
Examples of synchronizing two forms programmatically
Save a database object programmatically
Show or hide warning messages programmatically
Synchronize records between two forms programmatically
View the latest records for a form programmatically
Registry Settings
Customize driver settings
Customize Jet database settings (MDB)
Language-Specific Features
About Microsoft Proofing Tools
About multilingual features in Office
Troubleshoot working in a different language
Language Setup
About the global interface and Microsoft Office Multilingual User Interface Pack
Check spelling in a different language
Install system support for multiple languages
Requirements for specific languages
Enable editing of multiple languages in Office programs
Locale identification numbers for language-specific files
Remove commands and controls for languages you don't use
Change the default country/region
Change the default language setting
Use a keyboard layout for a specific language
Change the language of the user interface or Help in Office programs
Enable editing for multiple languages
Automatic Language Detection
About automatic font switching
Encoded Text Files and Unicode
Install the universal font for Unicode
East Asian
Reconvert Japanese, Traditional Chinese, or Simplified Chinese text
Review a file by using Reconversion
Japanese
About Japanese sort order
Specify IME behavior
Korean
Convert Hangul and Hanja
Add or delete Hanja in a custom dictionary
About Correct Keyboard Setting
Turn on Correct Keyboard Setting
Input Method Editors (IME)
About Input Method Editors (IMEs)
Install an Input Method Editor (IME)
Specify IME behavior
Set the default Input Method Editor (IME)
Add a word to an Input Method Editor (IME) dictionary
European
Work with euro currency symbols
Indic
About Indic language features in Office
About automatically checking the correct sequence of characters in Indic languages
South Asian
About South Asian features in Office
About South Asian databases
About using numbers and dates in South Asian databases
Specify the initial keyboard language in a text box or combo box
Specify the appearance of numbers in a text box or other control
Specify dates in dual calendar databases
Delete diacritics, ligatures, and special marks in South Asian text
Thai
Justify Thai text
About SQL Server 7.0 Support
Specify dates in dual calendar databases
Right-to-Left
About right-to-left features in Office
About finding and replacing characters in Indic, South Asian, or right-to-left languages
About right-to-left behavior in forms and reports
About right-to-left feature compatibility
About right-to-left language features
Use right-to-left features in forms and reports
About bidirectional fonts
Select diacritics or ligated characters
Set the default direction for new tables, queries, forms, reports, and pages
About global text direction
Change global text direction settings
About right-to-left control properties
About the hierarchy of setting right-to-left features
About bidirectional properties of the user interface
Examples of printing orders
About checking the spelling of bidirectional text
About using right-to-left sort orders
Set insertion point behavior
About code page and text layout support for right-to-left HTML files
About importing, exporting, and linking right-to-left tables in text formats
About creating macros in right-to-left applications
Change the default for a right-to-left feature
About using bidirectional text in expressions
About creating modules in right-to-left applications
Arabic
About Arabic sort order
About the Arabic code page
Specify the appearance of numbers in a text box or other control
Set language-specific spelling options
Hebrew
About Hebrew sort order
About the Hebrew code page
Set language-specific spelling options
Specify the appearance of numbers in a text box or other control
Calendars
About using different calendars
Switch database calendars
Controls
Summary of right-to-left properties for controls
Set right-to-left properties in controls
Specify alignment behavior in text fields
Specify the direction of a control on a data access page
Specify text alignment in a text box or other control
Specify text reading order for a text box or other control
Specify where you want scroll bars in a text box or other control
About attaching labels to controls
Specify the initial keyboard language in a text box or combo box
Converting Bidirectional Text
About converting reports saved as text files from ANSI characters
Convert bidirectional text files from ANSI
Convert bidirectional text files to ANSI
Data Access Pages
About right-to-left features in data access pages
Use right-to-left features in data access pages
Specify the direction of a data access page and its controls
Queries
About right-to-left behavior in queries
Change query direction
Change individual query direction
Tables
About right-to-left behavior in tables
Change table direction
Change individual table direction
Get in touch
Submit feedback about this site to:
[email protected]