May 2007
Intermediate to advanced
1152 pages
30h 53m
English
book
Access™ 2007 VBA Programmer's Reference
by Teresa Hennig, Rob Cooper, Geoffrey Griffith, Armen Stein
Content preview from Access™ 2007 VBA Programmer's Reference
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
J.1. Access Wizards
As you can tell from the extensive list of enhanced wizards, Access is more user-friendly and automated with each version. The following table describes 57 wizards, including 11 that were replaced or removed from Access 2007. The status column indicates changes between Access 2003 and 2007. Although there is some overlap, the main difference between enhanced and improved is that enhanced is used to denote changes to the wizard including the user interface while improved denotes that the target feature/process—such as the import or export process—has improved. The Replaced status indicates that, although the particular wizard is no longer available, its function is provided elsewhere, as explained in the description.
| Wizard | Description | Status |
|---|---|---|
| AutoDialer | Adds an AutoDialer to a control on a form, datasheet, or toolbar. It incorporates modem information and dials the number. | Enhanced so that the autodialer function can be called from an embedded macro instead of using VBA. |
| AutoForm | The AutoForm was replaced by the selection of forms available in the Forms group of the create tab, as shown in Figure J-1. Any of the forms are automatically created based on the selected record source. The traditional form wizard is also available. | Replaced. |
| AutoFormat | Applies a predefined style and format to a form or report, and allows creation of custom styles. This has been enhanced by additional auto formats (displayed as styles in the Form and Report wizards). | Enhanced with additional ... |
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.