D
e
c

01

 • Designing a bank deposit report that lists all your check numbers, amounts and gives a count of the total number of checks and the total deposit, along with a header and footer that shows your company name, address, and account number. Takes the place of a handwritten deposit slip.
• Announcement that THE QUICK ANSWER will henchforth be published in an electronic edition only.
• Optimizing XLookup programming in preparation for Sesame, the coming Q&A replacement product.
• How to duplicate records using Q&A's ditto feature without duplicating the record number (@Number) in the new records.
• Adding fields to a database without field labels.
• Creating reports from multi-line databases (databases with sections for lineitems, such as an invoice or sales order database).
• Review of a third party image viewer that lets you view photos or other images whose filenames are in the database records.
• Comparing Sesame Form and Subform capabilities with Q&A's "single view."
N
o
v

01		 • How to avoid common programming traps.
• Sesame Seeds -- Sesame ODBC and export options.
• Security for reports.
• Windows 2000 and Q&A printer drivers.
• Unexplained Q&A error messages
• All caps, no caps and initial caps (how to convert between them with programming).
O
c
t

01		 • How to standardize free text (move free text onto picklists for easier and error-free data entry).
• Sesame Seeds -- macros, scripts and Sesame.
• Print multiple report copies.
• Windows ME not for you.
• Tracking user time in a database.
• Does Q&A run in Windows XP?
• Setting graphics mode.
• Screen preview not working.
• Use macros to help program your database, part 3.
• Print lengthy report headers.
• Switch apps easily.
• Batch posting glitch.
S
e
p

01		 • Everybody's own to-do list (when several people share an application).
• Sesame Seeds -- Sesame date and time in a client/server environment.
• Simplified date range searches.
• Speedy fields revisited.
• Windows 2000 quirks.
• Fixing 'bad' pick-list values.
• Creating a formatted string message.
• Building a database 'time-bomb'.
• Problems with Windows ME.
• Use macros to help program your database, part 2.
• Add a PDF file viewer to your database.
A
u
g

01		 • Oddball ASCII export options.
• Sesame Seeds -- Sesame to bring new power to Retrieve and Sort Specs.
• Installing Q&A from diskettes.
• Get/Send data through serial ports (no can do).
• Skipping lines (or not) in reports.
• Converting Q&A DOS documents to MS Word for Windows
• Q&A and Windows O/S's revisited.
• Formview for Q&A for Windows.
• Sesame Seeds -- Sesame beta and release updates.
• Sesame Seeds -- Searchable pictures in your database.
J
u
l

01		 • Add a pop-up callback scheduler to your database.
• Date programming tricks for merge documents.
• The mechanics of speedy fields.
• When @Macro won't work.
• Date field problems.
• Deleted macros resurfacing
• Goto commands in Mass Updates?
• Auto-add new records to a history database.
• On the blink in full screen mode.
• Temporarily disable a block of programming code.
J
u
n

01		 • Hot-link a transaction file to your customer database. Easy-to-implement Q&A 5.0 technique that lets you go back and forth between a customer database and a transaction database (for your customers) with a single mouse-click.
• New default Retrieve and Sort Specs in the the coming Q&A-compatible database product from Lantica Software.
• How to use macros to help you program your databases.
• How to retrieve records dated the following, previous or current month without having to change your Retrieve Specs every month.
• The problem of unique values staying unique when you import records from an external file.
• Can't set page defaults in Q&A for Windows.
• Transferring files between PCs by email attachment. The right way to do it.
• Q&A and bar code scanning.
• How to create external export files on-the-fly containing selected data from the records you're viewing.
M
a
y

01

 • "Privatize Your Sensitive Reports." How to keep others from creating reports containing sensitive information.
• Database lifesaving techniques that  most people don't bother doing.
• Missing and Duplicate Records, and Strange Search Behavior.
• Utility for Q&A DOS that auto-fills the City and State fields when you enter the Zip Code.
• How to auto-fill Keyword fields from pop-up pick-lists.
• Windows "Invalid page exception" error messages when printing from Q&A for DOS and how to remedy.
• What can cause Q&A to run slowly on new PCs.
• A no-nonsense (shortcut) approach to validating the fields in your databases.
• What does Client-Server Mean? (The new Q&A-compatible database coming from Lantica Software will be Client-Server)
A
p
r

01		 • Doing the 'Double Lookup'. Creating pop-up pick-lists in Q&A 5.0 that let you drill down from a broad category to the exact item you want.
• Tricks, quirks and oddities when using Q&A's database search features. Valuable retrieval techniques for finding the records you might not be able to find by other means.
• Synchronizing Q&A database records, Part 2
• LaserJet printer hangs, won't eject the page. How to fix.
• Q&A for Windows doesn't have the "Print Specs" available in Q&A for DOS. But you have more powerful options.
• What to do when Q&A won't let you keep a desired format for dates in Date fields.
• When a Windows driver can cause Q&A for DOS printing errors.
• How to run Lesspace on a Windows ME PC.
• How to keep Saved Reports from getting changed by others.
• "Sesame" (the coming new Q&A-compatible database) Forms and Sub-Forms.
• Windows vs. DOS Interface (in Sesame) for Q&A Users.
M
a
r

01		 • Synchronizing Q&A database records, Part 1
• New patch lets Q&A for Windows run on Windows NT/2000 machines
• QABACKUP.EXE back to working in 2001
• How to delete the rightmost characters
• Crosstab report printing in the new century
• Why 'number' fields don't seem to sort properly and how to fix
• 'Divide' errors revisited
• Why Q&A for DOS causes Windows printing errors
• Why Q&A for DOS full screen inexplicably freezes
• Have Q&A press the keys for you, Part 2 (about macros)
• Q&A vs. Sesame - field types and data entry
• Start getting ready for Sesame
• Zero-fill leading spaces in a text field
• New utility simplifies creating Q&A data source files for Microsoft Word documents
F
e
b

01		 • Full Report on the International Q&A Users Conference (held January 2001)
• Using TL format code for email address fields
• How to round numbers to negative number of places
• Printing Extended ASCII characters in Q&A
• Converting money values to longhand text
• Using Q&A databases on CDs
• QA1.EXE vs. QA.COM
• Q&A and Windows ME
• Expanded Memory soon to be extinct?
• Which Q&A printer drivers to try with your HP DeskJet printer
• Fix date-related programming problems
• How to get dynamic picklists in Q&A 4.0
• Get a clean export file every time
• Have Q&A 'press the keys' for you, Part 1 (creating Q&A macros)
• Updated Q&A ZipCode database now available (see Free Downloads page)
J
a
n

01		 • A variant of Q&A 5.0's Expand Field Bug (causing font trouble in Reports and Print Specs)
• How to create a 'Running Balance' Report
• Q&A and WinClip - Your Virtual Secretary
• Q&A Video Crash problem solved
• Setting network database share mode
• Keyboard behaving oddly
• No more Table View (how to fix)
• ALLOW, SUBST, DOS and Windows confusion on networks
• How to Mass Update your Database Part 1
• Create a Hanging Indent Report