Access solutions: tips, tricks, and secrets from Microsoft Access MVPs
by Meyer, Arvin
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.
Read More ↓Title Statements
- Full title :Access solutions : tips, tricks, and secrets from Microsoft Access MVPs / Arvin Meyer, Douglas J. Steele.
Summary
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.
Read More ↓Edition Statements
- Publication Date:2010.
Publication Statements
- Publisher(s):Wiley
- Place of Publication:Indianapolis, Ind
- Language:eng
- Publication Date:2010.
The Physical Object
- Description:1 online resource (xxviii, 541 pages) : : illustrations
Edition Identifiers
- ISBN:9780470947548, 0470947543, 9780470947562, 047094756X, 9780470946626, 0470946628, 0470591684, 9780470591680, 9786612817540, 6612817542
- oclc:ocn694142732
- LC Classification:QA76.9.D3
- Dewey Decimal:005.7565
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 ; I…
Read More ↓Subjects
Writers
No reviews yet. Be the first to rate this work.
Rate & Review