Access solutions
Subtitle: tips, tricks, and secrets from Microsoft Access MVPs
By: Arvin Meyer, Douglas J. Steele
Contributors: Steele, Douglas J.
Publisher: Wiley
Published: 2010
Place of publication: Indianapolis, IN
Language: eng
Number of pages: 547
ISBN-13: 9780470591680; 9780470946626; 9780470947548; 9780470947562
Subjects: Microsoft Access (Computer software); Microsoft Access; Database management
Other titles: Microsoft Access solutions
Description: Presents a collection of tips and solutions for database problems of Access users, covering such topics as changing the sort order of reports, creating tables for SharePoint applications, implementing Soundex, using ActiveX controls, and adding custom types to forms.
Notes: Includes index.
Table of contents: title: Tables. Creating tables for web applications ; Alternative to the hyperlink data type ; Fill a table with numbers; title: Queries. A single query to do both updates and insertions ; Using a cartesian product to generate a calendar ; Using a multisect list box as a query parameter; title: Forms. Cascading combo boxes ; Cascading combo boxes on continuous forms ; Paired list boxes ; Marquees, scrolling messages, and flashing labels ; Custom tab controls ; Simulating web-style "hover" buttons ; Custom form navigation controls ; Calendar form ; Simulating drag-and-drop in access forms ; Providing visual feedback for drag-and-drop ; Control list boxes with drag-and-drop; title: Taking advantage of report capabilities. Page 1 of N for groups ; Always starting a group on an odd page for duplex printing ; Dynamically changing the sort order of a report ; Week-at-a-glance-type report ; Day-at-a-glance-type report; title: Using VBA. Useful string functions ; Useful functions ; Rethinking front-end databases to back-end databases in the same folder ; SaveAsText and LoadFromText : undocumented backup and anti-corruption tricks ; Reminders : building tickler forms and utilities ; Using disconnected recordsets ; Implementing soundex; title: Automating applications and ActiveX controls. Charting using Excel ; Using TreeView control ; Using the ListView control ; Adding images to the TreeView control ; Using the TreeView and ListView controls together; title: Access and the web. Building an access web application ; Embedding a web control in a form ; Building a time picker in a web form : an introduction to web macros ; RSS feeds ; Detecting whether you've got Internet connectivity; title: Utilities. Drilling down to data ; Utility for renaming a form's controls ; Document management using access ; Ultra-fast searching.