Access solutions : tips, tricks, and secrets from Microsoft Access MVPs

Access solutions : tips, tricks, and secrets from Microsoft Access MVPs / Arvin Meyer, Douglas J. Steele.

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.

Saved in:
Bibliographic Details
Main Author: Meyer, Arvin
Other Authors: Steele, Douglas J.
Format: eBook
Language:English
Published: Indianapolis, Ind. : Wiley, 2010.
Subjects:
Microsoft Access.
Microsoft Access
Microsoft Access (Computer software)
Database management.
COMPUTERS > Databases > Data Warehousing.
Database management
Online Access:Click for online access
Table of Contents:
  • Tables. Creating tables for web applications ; Alternative to the hyperlink data type ; Fill a table with numbers
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • Utilities. Drilling down to data ; Utility for renaming a form's controls ; Document management using access ; Ultra-fast searching.

Similar Items