Speedier Pick-List Lookups with XResultSet
Ever consider using XResultSet instead of XLookup to retrieve data from external databases? Here's a scenario where you could gain a lot in terms of ease of use and overall efficiency — particularly with large lookup databases — when using pop-up pick-lists to tell Sesame what you want. Sample application included in this month's download file.

Making an Abbreviated Copy of a Form for Another Database
Suppose you want to copy an existing form, remove some fields from it, then attach it to a new database in the same application. Not easy unless you know the ropes.

_______________You ask. We answer.

•  

• Align Text in Word Merge Documents — You need to WordMerge into perfectly aligned columns, as you would for an invoice or statement. How do you create those columns in your Word doc?

• Print Expanded Fields with WordMerge & Tables — When printing your records in Sesame, you'll loose any text that doesn't actually show when you look at the form. Here's a way to print your records so that all the text shows. Sample application included in this month's download file.

• Use Special Characters in Element Labels — How to use Ά, ’, © and other special characters in layout element labels.

• Conditionally Print Merge Fields — Did you know that a WordMerge merge document can print data conditionally? Here's how to create an If...Then...Else merge field in Word to augment your merge printing options.

• Copy a Database in Your Application — Follow these seven steps to copy a database along with all its forms and reports for use in the same application.

• Disappearing Records Or Carelessness? — If one day you should find you're missing some records and have duplicates of others, here's what you or your people did.

_______________Technical tidbits you can use today

 

• Update Your WordMerge Programming for New LE Type — The new Text Editor LE just introduced in Sesame won't WordMerge unless you know what to take care of first.
   

• How to Set a Default Sort Order for a Subform — Here's the trick.
   

• Locate that Mystery Layout Element — Does your spec window in runtime show a fieldname that you have no idea how it got there or what it's for? You can solve the mystery in about one minute.
   

• Find All Dates in a Particular Month — Need to find out who gets a birthday card in March? Is this a trick question? No, but it might be tricky retrieving all your contacts with a March (of any year) birth date. We simplify it.
   

• Retrieve Every 4th (or 10th) Record. Need to do a random sampling of your records for a test mailing? We show you how to retrieve every nth record.

(Insider password required)