— A Case Study Data disasters happen. From a fire or natural disaster to Grand
Theft Computers or a ransomware attack that hits even the off-site
backups. It's hard to beat having an up-to-date copy of the database in
hand off-site on a portable medium. How about this: at the end of the
day you pop a thumb drive into your workstation, click a button, and
off you go with a fully functional up-to-the-minute copy of your
company's database in your pocket.
with Subrecord Data
The report that comes with the sample Charity Donors database
lists all the subrecords whether you want them all or not. No way to
specify a date range like the previous month, last year or year to
date. Jon McLaughlin's new report does the trick. And the technique is
adaptable to most any form/subform database. Sample application
included in this month's subscriber download file.
What's Up With the
Fonts? Sesame forms, fields, labels, buttons and reports are all
custom-fontable. But fonts differ from other design attributes — they
can be substituted by other (unwanted) fonts in ways that might never be seen by the
application designer. We show how to find out (under the hood) which
workstations have which fonts on them, along with a program that
scans all the forms in an application and comes back with a list of
the fonts used in them.
Q&A Crosstabs to Sesame
Totals-Only Sesame skips over any crosstab reports when translating a Q&A
database. But when they're fairly simple crosstabs, as they often are,
chances are good that they can be reborn in Sesame's Report Designer
with a similar summary format and the same totals.
How to Import XML files You know what plain ASCII or CSV files are — a more or less
universal export/import format. But a more modern type of plain text
export/import file format called XML is seeing increasing usage in
companies. Sesame's import facilities don't accommodate
XML, but an additional easy step will take care of that.
Importing Q&A Data — Q&A's
export options can be troublesome when the data is destined for a
non-Q&A application. Here are some tricks you might be able to use to migrate
data from a Q&A database to Sesame.
Round Up to $5 — An unusual
requirement to be sure. But it can be expertly done.
Sample application included in this month's download file.
Improving the Drop-Down List
— Sometimes drop-down Combo Boxes aren't the right tool for the
job. If you're after dropdown-like convenience with more
flexibility, check out
this replacement option.
Check Multiple Fields for
Similar Records — This technique combines the date and
purchase order number to flag two or more records with the same ID
Easy Scheduling System —
Find out which vehicles are already scheduled for a given block of
"I don't have a Thumbs
database, but there's one in my Sesame Data folder!"
Semicolons in Lookup Data —
Ouch! —What to check for if an XLookupSourceList
program is pulling in some, but not all, of the data, or some of the
data is landing in the wrong fields.
_______________Technical tidbits you can
Find Last Month's Records with a
Fixed Retrieve (plus how to make date-based retrieves run a whole lot
faster on large result sets).
Effortlessly Trash the Database ― A no-brainer. Just follow
these easy steps.
Avoid Special Characters in String
Arrays, Too — maybe you thought this was just for lookup
//Rem Your Retrieve Specs — Why
toss out a useful spec you might need again when you can just
temporarily disable it?
(Insider password required)
How to Copy Programming Code from
Inside Sesame to paste into Sesame's Program
You can copy programming code from Inside Sesame
Acrobat PDFs and paste it into your Sesame Program Editor.
Select the code with your mouse, then Right click
on the selected text and choose Copy to copy it to the
(If the program continues to another page, do that page separately.)
In Sesame's Program Editor, select Edit | Paste
(or press Ctrl-V) to paste
the copied code into the appropriate LE/Event slot.
Inside Sesame programming examples may
inadvertently contain styled
quotes. If these are present, you'll get a lexical error when you Test
the program. You'll need to replace these styled quotes with the plain straight quotes
the Program Editor requires.