D |
• Troubleshooting mail
merge, part 1 • Importing text files into Write • Standard deviation across an entire database • Validating state and ZIP Code entries • Q&A's internal clipboard limitation • How to simulate a subroutine in a Q&A 3.0 database • Automatic Social Security Number formatting • Using a Keyword field in an unusual way to make searching records easier • Report derived columns, part 3 • A student history database • Rounding the cents portion of a dollar value up or down • Using Q&A's @Functions • How to display special ASCII graphics characters (such as the bullet, or smiley face) • When included records fail to show up in a report |
| N o v 90 |
• Create special form and
report layouts in Write • Using alternate Q&A configuration files • Report derived columns, part 2 • Using a macro to automating adding records to a database • Using fonts in Q&A • Printer and font files for the LaserJet III • Automatic phone number formatting • Moving portions of documents to separate document files |
| O c t 90 |
• How to make your database
know which address to use • Getting more information in report headers and footers • Report derived columns, part 1 • Time arithmetic fix • Designing a "most recent entry" transaction system • Checking for duplicate entries • Copy text from Document A to Document B without losing existing text in Document B • The programming execution options you have in telling Q&A when to execute a program • Forcing underlines to print in a document • Printing to laser printer postal cards • How to economize on programming statements • Out of memory message during macro recording • Creating a salutation field for imported files • How to make a macro select a specific printer • Why you should precede macros with the ESC key |
| S e p 90 |
• How to print in character
per inch in Write, File, and Report • How to print two copies of a merge in a side by side format • Using a lookup table for help with retrieving information from external databases • All about Q&A's @Number function (different ways you can use it) • Searching date and keyword fields • Creating text enhancement macros for use in Write • How to use @Number and @Date with existing records • Increasing your macro buffer automatically at startup • Special function fields (jump fields) for frequently updated records • Automatic city and state lookup from ZIP Code • Printing multiple copies of reports • Enhancing titles and headings with macros |
| A u g 90 |
• Generating invoice
lineitem totals • Organize, display, and launch your complex macros from a handy menu (designed in a database) • QACASE utility changes database fields to upper or lower case • Calculate a person's age based on current date and date of birth • Printing only the first screen from a multi-screen database record • Convert a lookup table to a database • Repeating field contents from a prior record in a different field • Filling out forms with mail merge • Numbering report lines • LaserJet printers and Q&A (questions and answers ) • Creating reports in Write • Printing quantities of the same label • Carrying balanced forward |
| J u l 90 |
• Combining font files for
use in Write • Difference between a programming "function" and "statement" • Restricting data entry with programming statements • Using printer control codes form reports that don't quite fit on the page • Manage expenses with expense-tracking database (includes expense report) • How to display helpful messages when an XLookup fails • Increasing the macro buffer's size • Underscoring blank report column entries • Having Q&A put the current date in a record • Quick function key reference for Q&A Write |
| J u n 90 |
Premier issue of The
Quick Answer • Words from Symantec • Setting printers up for the output you want (troubleshooting tips) • Smart Q&A subdirectory and printer setup • Turning off Expanded memory when it's causing problems in Q&A • Turning lookup tables into databases • Creating a simple macro • Test your new programming faster (using the menu bypass shortcuts) • Create a macro-driven label and letter generator to simplify mail merge tasks • Free-form vs. Coordinate Form Print Specs • QASPECS extracts programming to an ASCII file • Quick function key reference for Q&A File |