D
e
c

98

 • Graphics printing in Q&A for DOS. How to print letterhead, photos, signatures, and merge print to complex business forms in your Write documents on LaserJets and compatibles
• How to automatically pass variables to a second copy of Q&A
• How to recognize, repair, and prevent database corruption, part 2
• How to configure WinClip to copy Q&A DOS Write documents to the Windows Clipboard
• How to prevent errors when using Booleans to compare calculated numeric values with decimal places
• How to sum a group of numbers in a field
• Two ways to lock selected fields once a record has been saved in a database
• Keeping macros from running wild
• Q&A programming space limitations
• Setting up network security
• Acrobat Reader PDF files available for Quick Answer starting from January 1995 issue
N
o
v

98		 • How to "normalize" your data so you can produce reports on it (for line-item databases like invoices)
• Normalizing a database for crosstab report analysis
• How to create a normalized database (making Q&A work like a relational database)
• Using Q&A's Bypass Menu to navigate Q&A more easily
• Fix unexpected changes to Q&A screens after Windows 98 upgrade
• Using the Windows toolbar at the top of the Q&A for DOS window
• Changing database color schemes on-the-fly
• What to do when Q&A for DOS reports "Not enough memory..."
• Use PartitionMagic to repartion large hard drives. (Q&A needs a 2G or smaller partition)
• A Q&A database that manages your favorite Web sites and to takes you to them with a mouse click
• How to recognize, repair, and prevent database corruption, part 1
• How to "modernize" an older Q&A printer driver to work with a newer printer
O
c
t

98		 • Columns within columns in reports (technique that groups multiple fields to fit across a report page)
• How to print just the first page (first three screens) of a record when printing with F2, F10
• XPosting on networks (how to avoid corruption in the target database)
• Scanning barcoded product data into Q&A database records
• More on using the SpeedFix patch for Q&A 5.0 on Pentium II PCs
• Tips on importing data that contains commas, semicolons, tabs, and carriage returns
• Troublshooting misbehaving custom menu macros
• Using DTFDATA to create screenwide picklists in all versions of Q&A
• Creating screenwide picklists using Q&A 5.0 alone
• Automatically control, add, remove and sort multiple keyword field entries
• How to reclaim Q&A for Windows disk space (and why you'd want to)
S
e
p

98		 • Review of SPEEDFIX, a patch that lets Q&A 5.0 run on the fastest Pentiums
• Switching custom menu systems (and macro files) on-the-fly
• Hiding sensitive reports so users can't run them
• New add-in gives Q&A 5.0 for DOS-like features to Q&A for Windows
• How to reformat imported dates so Q&A recognizes them as valid dates
• Upgrading from Windows 3.x to Windows 98 (Don't!)
• Databases becoming inexplicably locked after first user accesses them
• @Play slows down program execution
• Adding a click-on "button field" to your Q&A 5.0 database form
• What to do about really big hard disks (so Q&A will run on them)
A
u
g

98		 • Making Q&A invisibly run file conversion utility operations (to convert data between programs)
• Fast Pentium fix for Q&A 5.0
• Merge-printing invoices and other complex Q&A database forms in your favorite Windows word processor
• When Q&A 5.0 can be slower than Q&A 4.0
• Preventing network users from "playing around" in the system
• Using LESSPACE.COM (a TSR) so you don't have to repartition a large hard disk
J
u
l

98		 • Easy monthly billing statements in Report. (Open invoice or time & services types.) Inlcudes technique for placing variable (changing) information in report headers and footers.
• Autonumbering fields (for filling out Merge Specs)
• Why you shouldn't use Q&A's generic bold and italic enhancements with proportional fonts
• How to create a phone log database with an auto-dialer
• @Help: Running concurrent Q&A sessions; Q&A and Windows 98; Q&A 5.0 and Novell Network oddities; Magic Windows 95 speed-up key
• Review of DTFPASWD, a utility that lets database administrator change multiple passwords
J
u
n

98		 • How to use a database to schedule future payment dates based on a starting date
• Make a Keyword field Speedy so it performs as fast as any Speedy field
• A really easy way to swap macro files in and out of memory from a picklist
• @Help: Displaying military time in a consistent four-digit format; Expanded memory for multiple copies of Q&A 5.0; How faulty programming logic can make an @Macro macro appear to run wild; How to find a persons age in years and days; How to run a quick comparison to find out who's older.
• Special Q&A-compatible third-party utilities designed especially for network/database administrators
• How to get totals-only reports to sort on calculated values (such as by descending total dollar volume)
• Some handy undocumented Table View features
• Using Moslow.com with Windows 95 and a Q&A shortcut
M
a
y

98		 • All about Keyword fields: How this "magic" relational field type can boost your productivity
• Two ways to calculate a person's age
• @Help: Exporting data to Quicken; Q&A 5.0's date patch; Solving Q&A startup problems on a network
• Creating and copying a name and address block (to the Windows Clipboard) using WinClip for Q&A
• How to implement point-and-click automation (with a "menu" database) to simplify complex procedures.
• Q&A Program Spec quirks and how to workaround them
• Two macro "hot-keys" you should never use and why
A
p
r

98		 • Alternate ways to run Q&A DOS in Win 95. Create shortcuts for instant access to all your applications
• Using your mouse to enhance text faster in the Write word processor
• Dates: A potpourri of tips and tricks to help you make short work of date-related calculations & tasks
• Review of WinClip, the utility that copies Q&A DOS database field contents to the Windows Clipboard
• @Help: Separating parts of names; Special record retrieval codes; When and why @Number skips numbers; Solving power glitches that lock databases; printing The Quick Answer Online Edition on HP DeskJet printers
• Creating a custom report interface, part 3
• How to print 3-up, page-wide mailing labels (such as renewal notices) on 8½ x 11-inch paper
• How to create a Eudora (email program) email address book using your Q&A data
• The Future of Q&A: An Essay
M
a
r

98		 • A fast and convenient way to check for open databases before running sensitive automated procedures (those that require "exclusive-mode" access to databases)
• How to auto-copy a key value to Q&A 5.0's Clipboard to use for a related task (such as a retrieve)
• How to check your reports and other Specs for potential Year-2000 problems
• Why Q&A won't run on some new Pentium PC's and how to solve the problem
• Is Q&A Year-2000 compliant?
• How to restrict picklists to display only the selections you need to see
• Outputting Lookup Table data to screen, to a printer, or for use in another database
• Designing a custom report interface, part 2 (a single-screen crosstab report designer)
• When writing a macro is easier than recording it
• How to access foreign keyboard setups in Windows 95
F
e
b

98		 • Creating postable records on-the-fly (auto-create new records to post to)
• Date calculations that find the number of days in any month and the date of the month's last day
• Using your Q&A data in Microsoft Word for Windows / WinFax Pro fax-merges (fax mail-merge)
• Starting Windows applications using the Alt-F9 External Programs menu
• Simplify record selection with a custom query builder (for users who can't fill out a Retrieve Spec)
• Making the telephone autodialer work
• How to ensure correct form navigation (so on-field-entry and on-field-exit programs execute properly)
• Updating database fields from an ASCII file
• Update a portion of a part number
• How to eliminate report column headings and the separator lines under them
• How to get more custom menu selections
• Add custom instructions (such as "Choose a Vendor") to the top of your selection lists (picklists)
• Designing a custom report interface, part 1 (a single-screen crosstab report designer)
J
a
n

98		 • Using @Shell to make Q&A interact with DOS and external programs (loads of @Shell tricks)
• How to have a macro-driven task back up the database(s) first
• Using Q&A to index books and magazines, and outputting the index for publication
• A fast way to access and view documents from a database record
• Checking a field's contents from another field
• How to really refine and add new dynamics to your XUserselectR selection lists (picklists)
• Automatically move to the end of an expanded field's contents
• Customizing Table View columns
• Technique for auto-updating telephone area code changes