Febuary 1998 Symantec Q&A Database Monthly Guide
Contents
1. When your document is finished pull down the Tools menu select Mail Merge then click Merge Select Merge to New Document and Word will create a new document consisting of all the faxes with the data all nicely merged Review the faxes If they re okay you can go ahead and send them this way 1L Pull down the Tools menu and select Macr 2 From the Macro list choose DDEFaxMerge In Word 97 choose DDEFaxMerge Main 3 Click Run A DDEFaxMerge Macro dialog box will appear 4 Select Don t Show WinFax Send Dialog then click OK In eaning Up Your Fax Merge Document You dont have to sacrifice the appearance of your faxes for the sake the specialystyled WinFax merge fields For example the merge document must contain a Whestyled fax number field yet for aesthetic reasons you might not want the fax number to appear in it Heres a trick you can use to make the fax number and any other WinFax merge fields invisible Pace the field on aline by itself assign the correct Wx style to i then do this 1 Select highlight the entire line 2 Puli down the Format menu and choose Font 3 Choose the smallest font size and line spacing you can so the line wont take up much space in the document 4 Change the color of the font to White so it wont print You cant Hide the merge field because then WinFax wont be able to see it if your word processor is set to not print hidden fields Repeat these steps with any other2. SurfDrve la Q amp A isk drive reader and Fax a QA faning database allaf which are available trom Marble Publications e ee cim EE Figure 2 A representation of the invoice database with additional fields for selecting various rosa specifcationz Postable Records contnued fom page3 3 Imports the AAALASC file as a Standard ASCII file into the Donates database adding 60 new blank records with AAA in the Form field 4 Returns to the Donor record by pasting the Donor ID into the Donor ID field at the Donordt Retrieve Spec 5 Moves the cursor into the donation lineitems area so the user can now perform the post Depending on how you use the post to database there might a small liability connected with having blank records in it you have to remember to exclude them during retrieval operations In this case you d have to be sure to exclude any records that contain anything in the Form field You can do this by placing the equals sign in it at the Retrieve Spec for any report you re designing When you have a quick and easy way to keep enough blank records in your post to database as in the two examples ye shown you ll never have to do double data entry again or interrupt your work flow to add a mew record to post to Tom Fetitsthe owner of DataBase Systemsin Indianapolis indiana He hasbeen designing custom Q amp A applications fora variety of businesses for 12 years 3172510541 m
3. The custom interface shown in Figure 2 is actually a graphic representation of the data entry database form shown in Figure 1 but with a twist I lets users enter record selection criteria into any of the fields just as though they were running the report directly from the Crosstab Spec It also provides fields for the user to select a row field a column field a summary field along with the output device all from picklists These four additional text fields are shown in Figure 2 Keep in mind that with a technique like this you can always eliminate any fields that wouldn t be used for record selection The first interface field Start along with the last two Check and Run are needed for programming and macro execution as you ll see in the next installments At this point the interface design is done All the various report characteristics are on one screen instead of three providing a complete picture of the report How users work within the interface will be next month s topic Ina nutshell the user fills in the fields using a combination of picklists and basic data entry The next task is to program the fields in a way that gives users all the flexibility they need to create the kinds of report they want That s where the real fun begins Jef Nitka develops Microsoft Accessand Q amp A applications f r Epoch Software 10020 2156compuserve con ffs the author ofthe Program Evaluator a Q4 program debugging uty
4. WinFax Pro 8 0 start Word and select File Open Navigate to your WinFax Macros subdirectory and open the appropriate Word document Word60 doc for Word 6 0 Word70 doc for Word 7 0 Word 95 or Word97 doc for Word 97 Depending on your default settings in Word Word might ask you to confirm that you want to open a document containing a macro In addition to installing Word WinFax Fax Merges vA Starting Windows Apps Via External Programs When you use Q amp A 5 05 Alt F9 Extemal Programs feature to start Windows applications you have to make sue the command line is property set up For example a command line to start Microsoft Word and run an autostart Word macro might look ike this your path might be different Ci irotfice Minword iinvord exe mit As shown in this example you first specify the path to Word You then follow it with a space and the m Word macro startup switch Finally you tack on the Se parameter to pick up the value of the current Q amp A database field which in this case contains the name of the Word macro you want to run Ifyou wanted avoid having to press Alt F9 and select Word you could record a Q amp A macro to do it for you You could then have an Macro command run the macro from the field that contains the Word macros name The macro would simply press AltF to display the External Programs menu then select Microsoft Word from it ifthe name of the Word macro you wanted to run was a
5. This free back issue of THE Quick ANSWER is provided courtesy of S same The Monthly Newsletter for Sesame Database Manager AND L SOFTWARE LLC Makers of Sesame Database Manager Compatible with Symantec Q amp A http iwww lantica com Creating Postable Records On the Fly When you need to creste records you can post to fora reports orarcive database heresaneasyang efficent aytodo GI Tom Petit was a non profit organization that sometimes received multiple jonations from the same donor The client wanted the donor s record to show each donation date and amount but he also wanted some donation recap reports that would show brakdowns by date ranges or the various projects donors supported The Donors database was a multi incitem database See Figure 1 With the donation dates amounts and other information stored in the donor records as lineitems the reports posed a problem For example a February 5 donation from donor Jones might be entered on the first donation line of his record whereas a donation on the same day from donor Smith might appear on the second or third donation line of her record How could 1 create a report sorted by any criteria and hope to include the two donations in the same column R aient requirements posed an interesting challenge It The first step I started out by copying each donation in the donor s record to a separate donations database FI refer to the original database as D
6. Well arent possibi printing ad tah Dui change he doe separ when pining med tne Preig fols on mu igs Cote Sever hrc 9 1ish my custom main menu which I display by pressing Alt could have more than nine selections know can use other key combinations to call other menus Alt A Alt 1d so forth but t prefer having more selections on my one main menu Needs More Cutom Menu Selections Daraus Bridgeport Nine selections is the limit on a custom menu but you can have your custom main menu call other menus giving you fast access to as many selections as you need For instance a custom main menu when viewed at the Application Menu Options screen Shift F2 M Create Menu might look like the sample menu in Figure 1 The macro names listed on the right side ofthe screen are actually menu names The six selections take you to six other menus each of which can include up to nine choices Those choices can either run macros or call other menus This custom main menu is designed to return to Q amp A s Main menu when the Esc key is pressed To have your submenus return to your custom main menu just enter the name of the main menu in the On Escape Show Menu line Bi Halper and Gordan Meigs own Professional ComputerTechnology Associates PCT in Newtown Pennsylvania PTA specializesin data management and supporting systems and serves 215508840 71023 86compusevecom genre Figure 1 A custom Main menu with se
7. Whxstyled merge fields you dant want to appear in the fax Word 97 Just lick OK When the faxes have been sent a WinFax icon will appear in the lower left hand corner of your screen You see we can still use our favorite database manager to store and manipulate our information and at the same time take advantage of the power and flexibility that Windows 95 programs offer Bl Halpern is president of Professional Computer Technology Associates in Newtown Pennsylvania Hs frm speciales n data management and supporting stems and services 225 598 8440 71023 386gcompuserecom Letters Making the Autodialer Work When trying to implement Bill Halpern s Q amp A 5 0 phone autodialer featured in the May 1996 Quick Answer I couldn t figure out why the variable the phone number in field 10 wasn t being passed to the ial bat batch file It turns out that it must be passed to the batch file as a number not text So for anyone trying to use this great little custom feature the part of the program that invokes the batch file should read as follows shel C QAS DIAL BAT giam 10 The field containing the program was formatted for text to accommodate the Dial label so the GNum function is required to pass the variable correctly James Pocany Onxviite Onranto Canana The Quick Answer February 1998 Simplify Record Selection III Erika YoxaLL Fling out a Retrieve Spec canbe frustrating bec
8. ad a client who wanted employees to have the freedom to create whatever crosstab reports they needed The problem was that most of them weren t Q amp A savvy enough to deal with the steps a crosstab requires Having to figure out which records to include which fields should be used for the row column and summary then which type of output it involved just too much Rather than train all the employees on how to deal with the various crosstab report specs the client wanted me to design a custom interface that would simplify crosstab setup It had to provide the following features Picklists of available fields for the Row Column and Summary field and a picklist for the type of output The ability to provide flexible record selection criteria Onscreen help to guide users through the process My solution met the client s requirement for ease of use but it took some doing First there was the interface itself what the users saw Then there was the programming to make it functional Finally macros to handle report printing FII show you how I did it in several installments over the next few months First deal with the starting point the interface design Interface design Consider a simple invoice database like Figure 1 pact ett ripe enr sper 3 amis Total aty creto Figure LA simple mutti ineitem invoice database for data entry The Quick Answer February 2008
9. ause you haveto tell QBA precisely what you want amp Wouldrtitberice yu could choose your retrieval criteria trom popup selection Iss You can NE of the things that bugs me about using a Retrieve Spec in QUA is that I can t get a list of values to choose from for a given field I have to try to remember how to spell something or use a wildcard that might not get me exactly what I want It also makes it difficult for anyone other than the person who does the data entry to figure out what to search for There had to be a way to create a point and shoot method to find records without having to deal with the Intelligent Assistant so I came up with what I call a Query Builder The key to making the Query Builder work is Q amp A s ability to evaluate a programming expression to retrieve a set of records For example if you have a number field named Apples and another number field named Oranges you can get the records where the total of both fields is greater than 50 by placing Apples Oranges gt 50 in any Retrieve Spec field If you have a LastName field and you want to retrieve the records where LastName Yoxll rather than typing Yoxall into the LastName field you can type LastName Yoxall into any field This means that as long as you use correct syntax you can write your retrieval expression anywhere you want and simply paste it into the first Retrieve Spec field Sample application To illustrate the te
10. body Suppressing these involves using special commands For a Customer Name field for example you might use a simple Column Sort Spec code of 10 AS To suppress the heading add H a backslash followed by a space To suppress the separator line add HS to the column s spec The resulting spec would read 10 AS H Y HS You can suppress a derived column s heading by placing the H code on the Heading line and suppress the separator by placing the HS code on the Column Sort Spec line If you want something besides a dashed line as the separator simply specify the character to use A few other examples HS uses the underscore character as the separator HS uses an asterisk HS creates a continuous double underline using ASCII character 205 To type it hold down the Alt key and type 205 on the numeric keypad Appendix H of the Q amp A User Manual provides a table of ASCII characters and their codes Here are some other codes you can use to create custom separator lines SL suppresses the single separator line on subcalculations and breaks SL changes the single separator line on subcalculations and breaks to the plus sign Choose whatever character you like DL Suppresses the double separator line when jur Q amp A questionsto Help The Quick Answer Marble 927A Harbor Blvd Costa Mesa CA 92627 or email jur name address phone and adetaled d vidual interest cription of the problem
11. chnique I created a simple Query Builder database Querybld dtf See Figure 1 Is a one record database I use to find records in an external database named Shipment dt Querybld dtf contains the following fields Tet E Date Date ent accessible by clicking ViewRecords Tere Set to cotum claro Palette Spec to ook like a button nal Value View Records Ateste only by clicking Programming Clear Customer Partuamber Reginshipbata nagnipoute Recelaveapecl This onrecord ext statement clears al the elds in preparation for the next query The Quick Answer February 2998 _ witha Query Builder j u J Offersa selection list of customer names to choose from Beginshipoat Makes sure EndShipDate isnt empty if a Begin ShipDate is entered Goes to the RetrieveSpec field when clicked Mirievetpae The RetrieveSpec field s program is where all the work gets done It takes the selected and entered values Figure 1 The Quy database lets you choose the company and part number to query om pop up selection ists from the other fields and strings them together into an expression suitable for use in a Retrieve Spec See Figure 2 GT t is used to determine if a field is blank before adding its elements to the expression This way it works regardless of whether some fields are left blank GChr M is the ASCII character code for a double quote mark The last thing the program does is
12. e Field WinFax style Faxnumber characters max W fodium Recipient name 31 characters max Wiecpent Transmit time AM SStmefoma WisTime Transmit date MJDDIYY dateformat Whate Company 42 hacer max Whcempany Subject 79 characters max Wissibject Keywords 53 characters max Wkeynors Biting code 26 characters max WbBliCose You don t have to use all these merge fields and their corresponding styles Just remember that those you don t use won t appear in your WinFax Send log Word styles affect the entire paragraph so make sure that any line containing a Ws style contains only one merge field and nothing else For example you can t have something like Fax Number lt lt Fax gt gt on the same line because WinFax will try to dial the literal string and fail If you want to include a label to identify merged data place it above the field like this Tip You can place Whestyled merge fds ina Word table and aly your Wixstyles to the appropriate ali leaving adjacent cels unstyled This way you can place a WinFax merge fied along with text and non MWinFax merge fields on the same line the same row of the able you ike you can format thecal and table borders not to print See Figure 2 Figurez ou an mark around the one syle perde restriction by placing your ements ina ors table Make sure Fax Preview is turned off in your WinFax Setup or you ll have to manually click the Send button to fax each document
13. es needs some more blank records to post to The macro which Il show you later takes care of adding the blank records then returns to the originating Donor record to perform the post The final XPost command blanks the Form field to prevent the record from being posted again Once the post is complete an x is placed in the Pst field to prevent reposting The other three Post fields Pst Pst3 and Pst4 contain the same program except that their references are to the fields on the same donation line such as D2 A2 P2 and Pst for the second donation lincitem The record adding macro The program we looked at earlier contains an GMacro Add records to Donates command that triggers if the target database contains no blank records Here s what the macro looks like These are the steps the macro performs 1 Moves to the Donor ID field in this case the first field on the form and copies the ID to the Clipboard with FL 2 Saves and exits the Donor record Continuesonpage12 Using Your Q amp A Data in i WiLLIAM HALPERN instep tom Mol ard Sacs Winton anytaxmodem scary GD pesonized emere ig your Qc din two ways to automate the process of creating a Q amp A Jexport file for Microsoft Word and having Word run a mail merge with it Both ways use an Shell technique to create the export file on the fly and start Word with an autorun macro You can also use Q amp A 5 0 s External Programs featu
14. g on the file s structure Make the part number field Speedy Now you can Mass Update your main parts database using the temporary database as a lookup source Use an Update Spec program like the following to lookup the price and cost on each part number match a 1 XLookup Tempo Follow these steps each time you receive an updated ASCII file and your prices will be current with very little effort Just remember that this will work only if the part numbers are unique in both databases Update a portion of a part number Ifthe 47 occurs anywhere in the part number and you want to change it to 48 you can Mass Update the database using 47 in the part number field at the Retrieve Spec In your Update Spec you can use the Replace function to change the 47 to 48 and leave the rest of each part number unaffected If the part number field were 10 the Update Spee would look like this Hosgnepiace 10 f Stumped your Q amp A version number and whether D 7 publish those questions we feel cen cam zu Tre Quick Answer February 2998 Publications Inc to mallboxGquickanswercom Inc IER raise ont E Isthere any way to create a Q amp A report without column headings and the dashed lines undemeath them Justin Bratnober S Pau Minnesota Eliminate Report Headings Yes By default Q amp A uses the field name for the column heading and a dashed line as the separator between the heading and report
15. lections that cal other menus onir Userselect and XUserselect lists always appear near the upper right comer ofthe screen one line below the top I place an Instructions field on the top line defined with angle brackets lt and gt so it doesnt show This way whenever I display a selection list can fil the field with custom instructions ike this 1 Cartone dxUrerselect Curtomez Nana y You can set the Instructions field to a contrasting color using the Change Palette Spec and place it so the right angle bracket isat the far right side of the screen with the text justified right You can also make your instructions blend in wlth the list Ike they re part of the list as shown in Figure 1 Erika Yexall 330 527 4018 hammerapk net 10 Add Custom Instructionsto the Tops of Your Selection Lists Figure Lou make the instructions eld 23 characters wide center usted and use the Color command to temporarily set ts background to hita ana tert to black you ca make your custom mutton ine laokctke spat afthe pct The QuickAnawer February 1998 The Program Sp gt 4 Designinga Custom Report Interface Part 1 Jerr Nitka If there one thing that can frustrate a novice user its designing a report But you can simplifying the process with a custom report design interface amp NE of Q amp A s great strengths is its easy interface Sometimes though it isn t easy enough I h
16. lways Mergel you could use an Extemal Programs command line like this instead Ci izotfice Winword Winvord exe mvergel This would let you start Word from the External Programs menu from anywhere in QSA and would always invoke the Mergel Word macro To retum to Q amp A automatically after quitting Word you must be running Q amp A in a Window Also Q amp AS Shortcut properties must include both Expanded and Extended memory set to 1024 and Q amp A must not be set to prevent it from detecting Windows To find out how to change Q amp AS shortcut properties see David Dvorin s articles in the October and November 1997 issues The Quick Answer February 1998 the macro and a set of required WinFax styles the document contains instructions you should read Once you ve installed the WinFax macro any future Word documents you create can be made fax mergeable To make an existing Word document fax mergeable you ll ave to copy its text into a new Word document then take it from there Using Word s Mail Merge Helper The following instructions for setting up a Word WinFax fax merge are distilled from a Symantec document available at www symantec com To read and optionally download the document go to symantec com and choose Technical Support Knowledge Base Select WinFax Pro 80 from the Products list and search for the keywords Microsoft Word The document you want is Hou to Use Microsoft Word Mail Merge with WinFax PRO 7
17. ly add a bunch of new blank ones And I do itin a way that s fast and efficent and doesn t interrupt the normal flow of data entry Adding the elements to the Donates database Ladded a text field named Form to the end of the Donates database I made it three characters long and Speedy so it s value can be the matching key value for the XPost commands in the Donors database Next I added a quantity of records to Donates with AAA in the Form field leaving all the other fields empty To do this I created a Standard ASCII file in Write with 60 lines containing AAA like this This way when it s time to add some new blank records I can have my program in Donors run a macro that imports this file AAA ASC into Donates The Merge Spec for the import includes a 1 in the Form field so that s the field in all 60 new records that gets the AAA Programming the Donors database In my case the Donors database included a Donor ID field along with the following lineitem donation fields at the bottom of the form The Quick Answer February 1998 Date check Anount Project added the following program to the PstI field When a new donation has been entered Q amp A looks for a Donates record with AAA in the Form field It it finds one no error it posts the Donor ID plus the line 1 fields DI CI Al and PI toi 16 on the other hand the first post attempt generates an error it means Donat
18. onors dH and the second database as Donates dif This separate database contained a record for each donation with the following fields With each donation stored in the separate database this way one record per donation it would be easy to generate reports by donor donation date range amount levels or project The Figure The Donors database has a mult snetem structure atthe Bottom ofthe form enat int wal auted for repons ick swer The Independent Guide to QSA Expertise February 1998 1 Crete PostableRecordsOnthe Fly Tompe 2 Tipi Two Tricky Date Calculations 4 Q6ADatain Word Winfax Fax Merges Viliam Hape 7 Simpy Searches with a Query Builder Enia Yol 3 TpeEnsure Corect Form Navigation 3 ghep Estet by Halpen amp Gordon Meigs Update Parcs roman Scie Eliminate por Column Headings 1 Get More Custom Menu Selectors 10 Ti Ad Custom Picks instructions 22 Design a Custom Report Interface Part 1 Jerta MARB question was how best to copy a new donation from the Donor s record to a new record in the Donates databace looked at several options Jeff Nitka s article on how to create reports from a multi lineitem database in the October 1997 Quick Answer offered an interesting approach that exports the records from the original database into a second database designed for reports What needed though was a way to copy each donation to the second database as soon as it toa
19. onth field to get the LastDateOfMonth Bayatemontn ign todice tate Diae 5 value and vice versa For a current month calculation you can aite monen yoaten v1 e 7701 H 2 dump the MyDate fil and replace itin the program with Date B The Quick Ansuer February 1998 Postable Records continue om pagel Eventually I decided to use Q amp A 5 0 s XPost command because it would post a new donation to the second database on the fly in real time But this introduced a new problem XPost can t create new records to post to would have to make sure a target record existed in the Donates database for every XPost from the Donors database In the March 1996 issue Tom Marcellus showed how to use Shell to launch a second copy of Q amp A add a new record to the target database then return to the original record in the first copy of Q amp A to execute the post This seemed like a good solution for situations where an occasional new target record was needed In my case though a new target record was needed every time a donation was received I wanted an easier way to get the same result The simplest way it seemed to me was to pre fill the target database Donates with a quantity of blank records This way I could execute an XPost from Donors and have Q amp A simply pick a blank Donates record to post the donation data to Fine so far but what happens when all the blank Donates records have been used up I simp
20. plete Back Issue Index 1990 1997 Comprehensive Topic index 1990 1998 Find Out About Online Subscription Benefits Visit The Quick Answer s Web Site at http www quickanswer com Using This Technique in Non Lineitem Databases For non lineltem databases you can use this same technique to create new records to post to Suppose your Orders database displays an XUserslect picklist of customer names from a customer database You start to enter a new order when you find that the customers name isnt on the list With some blank records in the customer database you could create a new customer record from the Orders database using a program along these lines When you XPost using this technique Q amp A will post all the data to the first AAA record it finds The final post command will then blank the Form field to prevent the record from being posted again And the next time the pickiist of customer names displays in the Orders database the new custamer will beon i Qh OnlineTip of the Month QA Brain Teaser Copy and Paste Web Ste Programs Downloadable Freebie Fies Database Applications for Sale OGA Consultants Directo Links to Useful Web Sites amp More MARREK Dated material Please Rush US Foge 19274 ator 3 pur ToranceCA permit Ne 333
21. re to start Windows 95 programs and run macros in them to automate procedures See the Sidebar So there s no problem mail merging your Q amp A data with Word documents in order to take advantage of the powerful formatting font and graphics capabilities of a Windows word processor But what if you want to run a Word fex merge using your Q amp A data Since version 3 0 Q amp A has supported plain Jane fax merges via a SatisFAXtion fax modem but your faxes can t contain fonts or graphics Now with Q amp A 50 Word and WinFax Pro 8 0 you can perform a fax merge to multiple recipients with each fax as personalized as any merge letter What s more your faxes can contain attractive fonts tables graphics and features that just come natural to a Windows word processor like Word What makes it possible are special Word macros that come bundled with WinFax Pro 8 0 and Q amp A s ability to run external programs in the Windows 95 environment Using Microsoft Word to illustrate WinFax comes with similar macros for WordPerfect and Ami Pro IL show you how to set up a Word WinFax fax merge using your Q amp A data Tom covered the finer points of designing a Word merge document and merging the Q amp A data with it so ll cover only what you need to know about using the resulting merge document in a fax merge E the December 1997 issue Tom Marcellus showed Getting started I you haven t installed the Word macro that comes with
22. reating reports E This application is available for dwonload from The Quick Answer s Web site at http Aownaquickanstercom Bi Sometimes clients users outsmart the usual form navigation rules A clever user finds out he or she can move through a form more rapidly by pressing the Down Arrow key rather than the usual Tab or Enter key This can bypass feds and defeat critical on field entry or on field exit programming We dont like to hard code strict cursor movement because it requires a navigation program in virtually every field and makes it difficult forthe DB administrator or programmer to quickly move through a form when necessary So what we sometimes do in cases like this is redefine the Down Arrow key Please read all ofthis tip before attempting what Im about to suggest You might also want to clear your regular macro file Shit F2 Clear Macros and ater defining the new macro save it to afle other than your default gamacro as fle Press Stift F2 Define macro When Q amp A prompts forthe macro identifier press the Down Arrow key Q amp A wll respond Ensure Correct Form Navigation 9 with a message saying That key isalready used by QSA Do you want to redefine t Y N Answer Yes press the Tab key then press SufeF2 to save the macro You can name it New Down Arrow then save it to a new macm file One of thefirst things you ll notice sthat you can no longer navigate QEAS menus o List of Files screens using the Do
23. rs Each month around the 5th well send each Online subscriber an email notification with a hyperlink in the message This way they simply click on the hyperlink to go to the Web site to pick up their new issue This month Bill Halpern and Gordon Meigs take over the Help column from TJ Shuflin whose professional obligations in the forensic tatu yun te ea ng field he directs a crime lab have placed increasing demands on his cng ota ee available time Good luck TJ and don t work to hard fanr aparun punea Noe ctor Erika Yoxall and Jeff Nitka show how to create custom interfaces that esatto m pureraa ar ny he make Q amp A easier than ever to use And Tom Petit in his first Quick Answer appearance shows how he makes Q amp A automatically create on the fly the new records he can then post to ij d Tricky Date Calculations Los ploriasitanercom Two tricky date calculations are Re annaas can fren required to determine Paysan Tae Quick Ananer biling cyces and thelike the Sana MS A number of daysin a month and the date of its last day PAO Using MyDate Date DaysinMonth Text or Numbe and mem grodate itate oaut 5 LastDateOfMonth Date fields you can find the two nth variables with the following program in the MyDate field Pat ocio arare oiyoata 8 30 via Sf wii iay sheer seat ney The two parts of the program work independentiy That is you ete ee dont need the DaysinM
24. run a simple macro that exits Querybld dtf opens Shipment df in Search Update mode and pastes the programming statement into the Retrieve Spec Figure2 The retrieval expression created bythe programming appears long enough far themacra to copy itto thecipboari ta paste nto the target databases Retrieve Spec You can use this technique to create a highly customizable form to allow you and your users to find exactly what they need in a database The programming expression you create can be used in any Retrieve Spec including Report and Print Specs I use this method to create executive report menus record selection forms of all kinds anything where my client can benefit from being able to quickly select a set of records without having detailed knowledge of the data or knowing how to use a Retrieve Spec Erika Yoal owns Hammer Data Systemsin Gaeta Oto specializing in OSA and Microsoft Access Phone Fax 330 527 4018 hammergapknet QA evaluates a retrieval expression against every record in the database without using any available indexes So expect record retrieval times to correspond roughly to the number and sie of the records in the database and your PC s speed Fora custom interface technique tha s similar in some respects see Jeff Nita s Selective Mail Merge Made Easy in the December 1997 Quick Answer Also se Jeff s article in this issue where he uses a specialized database as an interface to simplify c
25. s entered in the Donors database Continueson page Now We re Cookin Tom ManctLLus Y the time you read this The Quick Answer s Web site should be jp and running If you have an Internet connection set your wser to htp www quickanswer com and give ita look see Bene You ll get the best viewing results with Internet Explorer 30 or higher mbes or Navigator 3 0 or higher For more on the benefits of subscribing to The Quick Answer Online edition see Upgrading to the Online Edition at pay eee ae eee the Web site or on page 11 in last month s issue iso su ven TU Speaking of the Online edition you ll see this icon at ucc the top of two of this month s articles pages 1 and 7 pm atraente nus and in upcoming issues as well It indicates that the icine he oni E sample databases featured in the article complete with programming and macros ready to use as is or modify are included with the Online edition You can download a sample isue of The Quick Answer preces Online edition from our Web site apris com yale de Here s a comment from a reader who recently took a Iook at the HABEAT new Online edition Riiie iir Got Acrobat Reader 3 01 downloaded and installed Opened the Jan 1998 issue Amazing Looks great Printed darn good on the lowest quality setting on my inkjet Great job Meanwhile at another reader s suggestion we re considering a plan to better serve Online subscribe
26. s the first WinFax merge field Other Q amp A merge fields such as those for the name and address can be above it Place your cursor on an empty line where you want to insert the fax number click the Insert Merge Field button and select the fax number field from the list To make the fax number invisible so it doesn t print in the fax see the sidebar Cleaning Up Your Fax Merge Document 2 With the cursor on the fax number field pull down the styles list on the left side of the screen just below the toolbar it should contain Normal by default and select WisFaxNum from the styles list Word will apply the style to the line and WinFax will recognize the data merged here as the recipient fax number 3 Place your cursor on another empty line where you want to add the next WinFax merge field insert t then use the Styles list to apply the appropriate style to it Gee Table 1 4 Insert the rest of the merge fields from the Q amp A data source to your document A merge field can appear in a document more than once but a Wx style cat be applied more than once The macro that performs the fax merge scans the document from top to bottom for WEx style markers so the WEx styles must appear in the document in the precise order listed in Table 1 Table 1 Available WinFax Wix tes You dont have ta vse them al Those you do wil appear in your WinFax Send log Each style can appear oniy anceinthe document Merg
27. wn Arrow key Therefore you as the DB Administrator might want to define a secret Down Arrow key one this isnt normally used such asthe right square bracket Do this before you redefine the Down Arrow key Otherwise when you record the keystroke to assign to the right square bracket key the real Down Arrow key wont be available After defining your Secret Down Arrow key dont tell anyone about t With the Down Arrow key redefined as Tab users can press Tab Enter ar Down Arrow to move through forms correctly helping to ensure that your field programming will be executed Gorpon Moos 215 598 8440 GMaics courusenve com Tre Quick Answer February 2998 Eniten Bv BiLL HALPERN AND Gorpon Meics Updating Fieldsfrom an ASQI Fie ij ireguary receive an ASCI file containing updated parts price information and I want to use it to update the list price and cost fields in my main parts database ke Q amp A to find matching part numbers in both files and update the price and costin my parts database only if they ve change Also can QUA do a mass part number change If Ihave 50 records with 47 in the part number can I change itto 48 Mehel King ine Q amp A can do both Let s take your questions one at a time Update prices on matching part numbers First create a temporary database with a field for each field in the ASCII file Import the file into it using File Utilities Import ASCII Standard or Fixed dependin
28. x or 8 0 W s also available by return fax as Fax On Demand Document 404240 01142 Word has a Mail Merge Helper To sar it pull down the Tools menu and select Mail merge To start a new merge document from a blank screen select Crete Form Letters Active window See Figure 1 The Helper will then prompt you to specify the data source for the merge You can specify your existing exported Q amp A data in a form such as dBASE or ASCII If you export as an ASCII file you ll have to create Word header file containing the field names that correspond to and are in the same order as the data in the export file You can avoid this by using Q amp A s dBASE export format then selecting the dBASE fle as your data source in Word With a valid data source Word will let you select the records recipient to include in the fax merge per SII 3 8 bagata Danina Bonne aeg pom proc o Figure Words ai Merge Helper Wen the merge document and data source have been defined asin hs example the Merge button under Step 3 wil be salable The Quick Answer February 2998 Once you ve defined your data source you can add your merge fields t the document Creating the merge document First type the document s boilerplate text the text that will appear unchanged in each merged fax Then follow these steps to add and apply the proper WinFax styles your merge fields L The document must contain the fax number a
Download Pdf Manuals
Related Search