D |
• Exporting Q&A data for
use in Windows programs (Excel and Word mail merge) • Shortcuts for entering 21st century dates • Picklists generated from multiple search criteria • Sequential record numbering for multiple categories of records (a company with several branches) • Importing Special ASCII files • Document search/replace features • Printing sequential days of weeks as crosstab report headings • Statistical calculations (@Std, @Var, etc.) • Special database to simplify selecting records (from picklist) to include in mail-merge • Workaround for XPost "subtract" glitch • Getting help for severely damaged databases • Former Symantec printer driver expert builds drivers for new printers |
| N o v 97 |
• Simple category /
subcategory picklists • Everything you need to know about running Q&A in Windows 95, part 2 • "Post" on-the-fly to a sequential document file using @Shell to invoke a little-known DOS command (useful for tracking who changed a sensitive field, when, and what its previous value was) • Flag non-zero balances across multiple accounts with a report • Globally remove or replace specific characters in a field • Separating records into logical groups for mailings • XLookup the last record added to a database • Real-time inventory updating (including reversing out canceled transactions) |
| O c t 97 |
• Everything you need to
know about running Q&A in Windows 95, part 1 • @Shell routine that tells you if a file exists • All about the Userselect / XUserselect family of commands (picklists) • Solve mail-merge memory problems • Good mailing label management • Fonts in Q&A/Win reports • Creating "items sold" reports from a multi-lineitem database (such as an invoice or sales order) |
| S e p 97 |
• All about the
relationships between printer drivers, fonts, and documents (setting up documents with
correct margins, applying enhancements, assigning fonts, etc.) • Producing overall averages in a report • Converting text dates to true dates • When the Query Guide is most useful • Align objects on Q&A/Win forms • Cure for labels that print with gaps • Database that tracks condo reservations and usage • "Unseen" things that cause your database’s file size to grow • Creating and using macros - part 3 |
| A u g 97 |
• Get the right accounting
codes and subcodes by selecting their descriptions from picklists • What to do when Q&A has trouble on PC’s with very fast processors • Database jump-search technique (quickly jump to A, B, or C etc. records, or scroll between groups) • Creating variable report headers • Trapping data entry mistakes • A database of macros (technique to choose the macro you need to run from a simple picklist) • Tips for simplifying payroll data entry • Creating and using macros - part 2 |
| J u l 97 |
• Versatile fax-merging
using Q&A DOS data, a Q&A/Win merge document, and WinFax • How to program to force an auto-recalc (in a database record) when auto-recalc doesn’t trigger • Creating and using macros - part 1 • Simplifying data entry with selection lists (picklists) • Combining parts of dates to make a complete date • When reports don’t print in the fonts you assigned • Printing a calculated (variable) date in a report header • Rearranging report derived columns. |
| J u n 97 |
• Database corruption - how
it happens and what to do • Conditional merge fields in documents and labels • Spell-check a whole database record at one time • Automatic last name capitalization during data entry • Tips on using pop-up selection lists • Automatically add a record to database "A" while working in database "B" • Creating super-wide picklists • Adding an XLooked-up number to a date to create a new date • Creating database forms within forms (for a relational view of your data and multifile data entry), part 1 • Using Q&A’s typecasting functions (converting from one data type - number, text, date - to another) |
| M a y 97 |
• Creating database forms
within forms (for a relational view of your data and multifile data entry), part 1 • Easier ways to retrieve records • Variable report headers (make report headers conditionally change) (see editorial) • Control who can run an application’s macros in a multi-user environment • Ways to simplify date entry • Checkbook with a running balance • Print fields aligned at left margin • Create custom label codes ("Subtotal," "Weekly total," etc.) in reports • Import WordPerfect merge file into Q&A • Automatically transfer selected records to an archive database • Quickly search other databases for matching names |
| A p r 97 |
• Queue and print forms
on-the-fly (such as for a complex transaction requiring several different forms) • Make critical messages flash on the screen (then go away without having to press Enter) • Auto-clear auto-filled fields (such as when you make the wrong selection from a picklist) • Pass two variables simultaneously via Q&A’s clipboard • Track failed XPosts with a posting error log • How to quickly find a file • Lost characters during data export • What to do if you run out of report derived columns • How to print out programming • Tighten the range on range lookups (getting the most from the XUserselectR command) • XPost to text or keyword fields without overwriting the existing entries • Auto-fill keyword fields with multiple entries from a pick list (bang, bang, bang) • How to know which copy of Q&A 5.0 you’re working in |
| M a r 97 |
• Coloring your database
forms and fields (and using conditional @Color programming to change field colors during
data entry) • Technique for copying shared databases • Protecting sensitive database fields from changes without making them read-only or hiding them • Fix for Q&A 5.0’s buggy date formats • Print just the current record in a saved report • Using print offset to make your documents and reports line up correctly on the page • What to do when the spell-checker doesn’t work • Calculate total area from multiple areas with multiple dimensions • When long pathnames cause trouble in XLookup and similar commands • Faxing ptions • When the PageUp key behaves oddly on multipage forms |
| F e b 97 |
• Tracking file folders (in
a Q&A database) in a law office (includes technique that automatically copies
pertinent "files list" report to each corresponding case number subdirectory) • Combining a text message with a date field • Adding context sensitive help to a database • Using Graphic images in documents and forms • Running Q&A DOS under Windows 95 • Combining text and field data in @Askuser boxes • Program @Color conditionally to attract attention • Use ranges to get faster, smaller picklists • Create a duplicate-record report (to help decide which dupes to remove) • @Shell out to Windows 95 programs • Keeping your data current • How to sort a picklist in logical rather than alphabetical order (e.g Small, Medium, Large) • Building a lengthy text string a step at a time • Tips for sorting large databases |
| J a n 97 |
• Automatically print
multiple labels (with variable text) from any database record • Programming that lets you surf your hard drive (and insert a file) from inside a database record • Finding the earliest and most recent dates in a record • Using the current date and time to generate unique incident numbers • How XLookup and @XLookup react differently to a blank lookup field • Indenting report columns • Importing Fixed ASCII files • Tracking changes made to sensitive fields (when the field was changed, and its previous value) • How to find out which copy of Q&A 5.0 you’re in • Internal differences between how Q&A 4.0 and Q&A 5.0 sort records • Using the QEXTRACT utility to extract data from corrupted databases • Tips to ensure successful upgrade of Q&A 4.0 databases to Q&A 5.0 • Two types of multiline database fields and how to create them |