Spell Checker for Microsoft® Access
Contents
1. Select Objects for Spell Checking Show Select Object Type Object Name E Table FMS_EmbeddedMacros r All Objects ee bee r Table _TAS TempFiles r E ER ET Table tblDocumentedProperties E Queries la Table tbIFMS_MULock In Eorms Rabot n Table tbIFMS_User n ToT 7 Table tblObjectinventory v Macros 2 n Table tblObjectTypes n User CmdBars Ir Table tblProperties Ir E Table tblReports m E Include C Query qry_SelectedObjects_TAS r Embedded E Query qry_SelectObjects_TAS ial Macros U Query qryChangesLinkedTable_TAS Ir a ObjectChanges_TAS a ine A leer ee TAS Invisible Query gryObjectChangesCount n Controls El Query qryObjectinventoryCount_TAS n C Query qryObjectsToChange_TAS E E query qryResultsSummaryCount_TAS F Object M 1 of 52 gt amp No F Beart Help select All Clear All Back Next Selecting Objects for Spell Checking For Jet databases MDBs and ACCDBs Total Access Speller spell checks the following objects e Tables and Table Fields e Queries and Query Fields e Forms and Form Controls e Reports Report Controls e Embedded macros Microsoft Access 2007 or later e Macros e User Command Bars For Access Data Projects ADPs Total Access Speller supports spell checking native Access objects e Forms Form Controls e Reports Report Controls e Embedded macros e Macros e2. Description Property List Sorted by Object Type and Property Name Property Description Form title bar Navigation Bar caption to override the default Records label A general purpose property that can hold any value Text on a form control or label Specifies the text that appears in a ScreenTip when you hold the mouse pointer over a control Specifies the Default Value for a control Specifies the text that is displayed in the status as defined by the AddMenu and Echo macro actions A general purpose property that can hold any value Text displayed when a ValidationRule fails A comment describing the macro line The name ofa menu as defined by the AddM enu macro action Specifies the message displayed by the MsgBox macro action Specifies the text forthe message for the SendO bject macro action Specifies the text that is displayed in the status as defined by the AddMenu and Echo macro actions Specifies the text forthe subject for the SendObject macro action Specifies the window title displayed by the MsgBox macro action Text describing the object Text displayed to the user Text describing the object HAE RS SS RI RI RR RE AA AA BAN f Program Options 3 Program Options Set general settings for how Total Access Speller behaves on two tabs e Paper Size e Linked Tables Paper Size for Reports The Paper Size tab allows you to specify whether you want the reports in Total Access Speller to use US Let
3. To add properties to the list click the Add Property button and the Add Property Form appears ZE Total Access Speller Add Property j Add a New Property to Spell Check This property applies to the following object type Form Control Note You cannot add properties for macros or command bars Total Access Speller automatically checks all macro and command bar properties that can contain text Property Name Description X Cancel Help Add Property Form To add a property select the type of object the property applies to from the drop down list 26 e Chapter 3 Using Total Access Speller Total Access Speller Total Access Speller Total Access Speller supports properties on the following object types e Tables and Table Fields e Queries and Query Fields e Forms and Form Controls e Reports and Report Controls There are several guidelines to note when adding a property to the list e You cannot add properties for macros or command bars By default Total Access Speller examines all applicable properties and settings for macros and command bars e Total Access Speller does not examine custom properties of ActiveX controls You should not add custom properties to the property list e When spell checking Access Data Projects ADPs you cannot add properties for objects that exist in SQL Server such as tables views and diagrams e Total Access Speller is designed to spell check properties that ap
4. Before you run Total Access Speller from your database there are a few simple steps to take 1 Close any open objects Because Total Access Speller needs to work with objects in design view you must close all open objects 2 Check all objects out of Microsoft Visual SourceSafe If your database is using Microsoft SourceSafe for version control check out all objects If objects are not checked out Total Access Speller cannot apply changes to it 3 Obtain appropriate permissions If you are using a secured Microsoft Access database you must be logged in as a user with sufficient permissions to view object designs and make changes 4 Don t use MDE ADE or ACCDE databases Because they are for production purposes only you should not spell check MDE ADE or ACCDE databases Instead spell check the original version of the database and then recreate the file Launch the Total Access Speller Add in Total Access Speller runs in Microsoft Access as an Add In To start the program open your database and open the Total Access Speller add in In Access 2016 2013 2010 and 2007 select Total Access Speller from the Database Tools Add Ins ribbon External Data Database Tools Database Documenter ss a pe So E i rm Analyze Performance 2 7 Relationships Object Access SharePoint Add ies EB Analyze Tabl i Dependencies BE Analyze lable Database ins gt Relationships Analyze Move Data Add In Manager Total A
5. CC c lt E ZZyKEDbIEI Spell Checker for Microsoft Access Total Access For Microsoft Access FMS www fmsinc com License Agreement Total Access Speller PLEASE READ THE FMS SOFTWARE LICENSE AGREEMENT YOU MUST AGREE TO BE BOUND BY THE TERMS OF THIS AGREEMENT BEFORE YOU CAN INSTALL OR USE THE SOFTWARE IF YOU DO NOT ACCEPT THE TERMS OF THE LICENSE AGREEMENT FOR THIS OR ANY FMS SOFTWARE PRODUCT YOU MAY NOT INSTALL OR USE THE SOFTWARE YOU SHOULD PROMPTLY RETURN ANY FMS SOFTWARE PRODUCT FOR WHICH YOU ARE UNWILLING OR UNABLE TO AGREE TO THE TERMS OF THE FMS SOFTWARE LICENSE AGREEMENT FOR A REFUND OF THE PURCHASE PRICE Ownership of the Software The enclosed software program SOFTWARE and the accompanying written materials are owned by FMS Inc or its suppliers and are protected by United States copyright laws by laws of other nations and by international treaties You must treat the SOFTWARE like any other copyrighted material except that you may make one copy of the SOFTWARE solely for backup or archival purpose and you may transfer the SOFTWARE to a permanent storage device Grant of License The SOFTWARE is available on a per license basis Licenses are granted ona PER USER basis For each license one designated person can use the SOFTWARE on one computer at a time Other Limitations Under no circumstances may you attempt to reverse engineer this product The SOFTWARE is licensed as a single product
6. Days First 30 Days DD A U Priority Response Time Senior Engineer Support i ee Team Chapter 4 Troubleshooting and Support e 33 Programmatic Code 5 Y v Assistance Major Upgrades for Current Version not between Additional Additional j fee fee Access versions Fee Per Cost Annual Fee Included Incident Response generally within two business days Actual resolution may take longer depending on complexity of the issue reported Custom Programming implementation is not provided in our Support Maintenance plans For products that include a programmatic interface we can provide instructions for using our programmatic interface and show examples but we do not implement this into your projects This service is available from our Professional Solutions Group Premium Subscription The Premium Subscription is the ideal option for customers seeking the highest level of support from FMS The annual fee entitles you to telephone and email technical support from a senior support engineer From time to time FMS may release new versions of existing products which add new features These are point releases e g from version 16 0 to 16 1 and are different from new builds that correct problems in existing features e g from version 16 00 0001 to 16 00 0002 These point releases are available for anominal upgrade fee to existing customers Premium Technical Support subscribers receive these upgrades autom
7. Speller does not include its own spell checker and uses the Microsoft Office spell checker to respect your own language and custom dictionary For this reason you must have Microsoft Office Proofing Tools installed Run the Microsoft Access Spell checker at least once If you ve never run it there is a chance it is not installed in your copy of Access Simply open a table go to a text field and press F7 to verify spell checking is installed and working 10 e Chapter 2 Installing Total Access Speller Total Access Speller Installing Total Access Speller Total Access Speller is installed using an automated setup program To install Total Access Speller follow these steps 1 Locate and run the setup program 2 When prompted enter your registration information and product key serial number 3 Specify whether you want to install it for just yourself or any user on your PC The latter requires administrative rights 4 Specify the destination directory for the files Be sure to read the README file for any late breaking news that is not included in this User Guide Using the Update Wizard If you are registered you should receive emails from FMS when updates are released for the products To verify you have the latest build you can use the Total Access Speller Update Wizard with an active Internet connection From the main Windows menu select All Programs FMS Total Access Speller Update Wizard Follow the pro
8. ValidationRule fails Query Description Text describing the object QueryField Caption Text displayed to the user QueryField Description Text describing the object Report Caption Report title bar Report Tag A general purpose property that can hold any value Report Control Caption Text on a report control or label Report Control Tag A general purpose property that can hold any value IT II IT IT AT TI SSS SSS Table scribing the obiect 1 of 21 gt gt I WW No Filter Search 4 tll 3 n 2 Help A Preview Bl Report view HY Add Property Delete Property E close Edit Properties Form Chapter 3 Using Total Access Speller e 25 Use this form to select or unselect specific properties To get the most benefit from Total Access Speller you should include every property in the default list you can always choose to ignore spelling suggestions on an individual basis Note that command bar and macro properties do not appear in the Edit Properties form This is because Total Access Speller automatically checks all applicable property values for the selected command bars and macros Total Access Speller reads the following property values from command bars and macros Macros Command Bars Comment Caption MenuName DescriptionText Message Tag MessageText StatusBarText ToolTipText Subject Title Adding Properties
9. and may not be separated by use for more than one user at a time You may not rent or lease the SOFTWARE You may not transfer any of your rights under the FMS Software License Agreement to other individuals or entities Without prejudice to any other rights FMS may terminate this FMS Software License Agreement at any time if you fail to comply with any of its terms In such an event of termination you must destroy and stop using all affected SOFTWARE copies License Agreement e i ii e License Agreement Transfer of License If your SOFTWARE is marked NOT FOR RESALE you may not sell or resell the SOFTWARE nor may you transfer the FMS Software license If your SOFTWARE is not marked NOT FOR RESALE you may transfer your license of the SOFTWARE to another user or entity provided that 1 The recipient agrees to all terms of the FMS Software License Agreement 2 You provide all original materials including software disks or compact disks and any other part of the SOFTWARE s physical distribution to the recipient 3 You remove all installations of the SOFTWARE 4 You notify FMS in writing of the ownership transfer Limited Warranty If you discover physical defects in the media on which this SOFTWARE is distributed or in the related manual FMS Inc will replace the media or manual at no charge to you provided you return the item s within 60 days after purchase ALL IMPLIED WARRANTIES ON THE MEDIA AND
10. checking 21 system requirements 10 T technical support 35 troubleshooting 32 Twitter 8 U un installing 11 update wizard 11 updates 7 11 V versions 10 Visual SourceSafe 14 W web site 7 32 write changes 22 24 Index e 37
11. plus version X 5 upgrades for earlier Access versions These versions include the following enhancements Support for Access Data Projects ADPs Total Access Speller now supports spell checking Access Data Projects ADPs just like in standard Databases More Automated Property Changes Property changes to command bars which previously required you to manually update them are now automatically updated Additionally spell checking of caption properties with hotkeys has been improved to preserve the hotkey unless the letter no longer exists General Enhancements e Option to specify whether properties on linked tables should be updated e Improved handling of databases under Visual Source Safe control e Property data is stored in a temporary database in your Application Data folder rather than in the add in Main Screen Redesign The main screen is redesigned with a new spell checking wizard the ability to view results from the most recently run spell checking additional program options and separate About form and Suggestion Box links Spell Checking Wizard Enhancements The Wizard is enhanced to allow column filtering in object and property selection screens and to display more streamlined and helpful information New Reports Five new reports are available to provide full detail about the spell checking results Additionally support is added for printing to A4 paper in addition to US Letter size Total Access Sp
12. the latest build Product Announcements and Press Releases Read the latest information on new products new versions and future products Press releases are available the same day they are sent to the press Sign up in our Feedback section to have press releases automatically sent to you via email Product Descriptions and Demos Detailed descriptions for all of our products are available Each product has its own page with information about features and capabilities Demo versions for most of our products are also available Chapter 1 Introduction 7 Technical Papers Tips and Tricks FMS personnel often speak at conferences and write magazine articles papers and books Copies and portions of this information are available to you online Learn about our latest ideas and tricks for developing more effectively Social Media Blog Facebook Twitter Keep in touch with us e Signup for our blog http blog fmsinc com e Like our Facebook page https www facebook com MicrosoftAccessProducts e Follow us on Twitter http www twitter com fmsinc Links to Other Development Sites Jump to other locations including forums user group home pages and other sites with news techniques and related services from our web site 8 e Chapter 1 Introduction Total Access Speller Chapter 2 Installing Total Access Speller Total Access Speller comes with an automated setup program to get you up and running as quickly as possibl
13. MANUAL INCLUDING IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE LIMITED TO SIXTY 60 DAYS FROM THE DATE OF PURCHASE OF THIS PRODUCT Although FMS Inc has tested this program and reviewed the documentation FMS Inc makes no warranty or representation either expressed or implied with respect to this software its quality performance merchantability or fitness for a particular purpose As a result this software is licensed AS IS and you are assuming the entire risk as to its quality and performance IN NO EVENT WILL FMS INC BE LIABLE FOR DIRECT INDIRECT SPECIAL INCIDENTAL OR CONSEQUENTIAL DAMAGES RESULTING FROM THE USE OR INABILITY TO USE THIS SOFTWARE OR ITS DOCUMENTATION THE WARRANTY AND REMEDIES SET FORTH IN THIS LIMITED WARRANTY ARE EXCLUSIVE AND IN LIEU OF ALL OTHERS ORAL OR WRITTEN EXPRESSED OR IMPLIED Some states do not allow the exclusion or limitation of implied warranties or liability for incidental or consequential damages so the above limitations or Total Access Speller Total Access Speller exclusions may not apply to you This warranty gives you specific legal rights you may also have other rights that vary from state to state U S Government Restricted Rights The SOFTWARE and documentation are provided with RESTRICTED RIGHTS Use duplication or disclosure by the Government is subject to restrictions as set forth in subparagraph c 1 ii of the Rights in T
14. User Command Bars Total Access Speller cannot spell check objects in SQL Server such as tables views and diagrams Filtering and Selecting Objects Select the objects you want to check by checking the Select column Filter the list by object type using the option group on the left The list of objects is displayed with the object type and name For tables if it s a linked 18 e Chapter 3 Using Total Access Speller Total Access Speller Total Access Speller table the Linked Table column is checked You can also filter the list by clicking on the column header The Select All and Clear All buttons behave as expected for the currently displayed list of objects Option to Include Embedded Macros Microsoft Access 2007 introduced embedded macros in forms and reports Like regular macros embedded macros can include actions that display text to users Since embedded macros are not separate objects you can optionally include or exclude them from spell checking with this option z Include Embedded Macros If selected this option only applies to your selected forms and reports Since embedded macros are not available prior to Access 2007 earlier versions of Total Access Speller do not include this option Option to Include Invisible Controls By default all form and report controls are included for spell checking There s an option to exclude invisible controls by unchecking this option 4 Include Inv
15. arly the RecordSource property should not be spell checked since it contains SQL strings rather than text values your users see Total Access Speller contains a default list of properties for you to spell check There may however be cases where you want to add additional properties to this list or turn off certain properties for certain databases To edit the list of properties for spell checking use the Edit Properties form From the main menu click the Properties List button Property List You can turn properties on or off or add new properties to be considered while spell checking Note that CommandBar and Macro properties are checked automatically and cannot be un selected Because of this they do not appear in the following list For a list of properties checked in CommandBars and Macros consult online help Object Type Property Name Property Description Caption Form title bar NavigationCaption Navigation Bar caption to override the default Records labe Form Tag A general purpose property that can hold any value Form Control Caption Text on a form control or label Form Control ControlTipText Specifies the text that appears in a ScreenTip when you hol Form Control DefaultValue Specifies the Default Value for a control Form Control StatusBarText Specifies the text that is displayed in the status as defined t Form Control Tag A general purpose property that can hold any value Form Control ValidationText Text displayed when a
16. atically and for no additional charge during their subscription term NOTE Upgrades between versions for instance going from Access 2010 to Access 2016 are not considered Point Release Upgrades and are not included in the Premium Subscription Subscriptions are available for a twelve month period and may be purchased at any time You must be the registered owner ofthe product to purchase a subscription and the only person contacting FMS for support under the subscription Please ensure you have purchased the Subscription you need for Total Access Speller 34 e Chapter 4 Troubleshooting and Support Total Access Speller Per Incident Our Per Incident package is available individually or by purchasing multiple incidents in advance The Per Incident support package provides telephone and email technical support from a Senior Technical Support Engineer for resolving one incident An incident is defined as a single question related to one of our products The Per Incident period is from start to finish report of the incident to resolution for a single incident If you anticipate multiple questions for a single product we recommend purchasing the Premium Subscription Standard Subscription Our Standard Subscription comes with every product purchased for no additional cost The standard subscription comes with access to our FAQs and forums and responses to bug reports and feature requests for that version Please note that the per
17. ccess Analyzer Total Access Speller Starting Total Access Speller from the Microsoft Access 2016 and 2013 Ribbon 14 e Chapter 3 Using Total Access Speller Total Access Speller Usersand Replication Permissions Options Add In Manager Administer Ta 4 Switchboard Manager i gr 2 FE Set Database Password Template Designer Web Total Access Analyzer Total Access Emailer Total Access Statistics Total Access Detective Total Access Detective Prepare Starting Total Access Speller from the Microsoft Access 2007 Ribbon In earlier versions of Microsoft Access select Total Access Speller from the Tools Add Ins menu Database Utilities Security gt Add In Manager Customize Total Access Detective Options Total Access Emailer Total Access Speller Total Access Statistics Total Access Analyzer Total Access Detective Prepare Access 2003 and Earlier Starting Total Access Speller from the Tools Add Ins Menu Microsoft Visual SourceSafe Warning If your database is under Microsoft Visual SourceSafe control a warning message appears reminding you that your objects must be checked out in order for Total Access Speller to apply the changes to your objects Total Access Speller Chapter 3 Using Total Access Speller e 15 This database is under Visual SourceSafe control Total Access Speller will not be able to make changes to objects that are not
18. checked out If you have not checked out all objects you want to change close Total Access Speller check out the objects and restart the program ED not show this page again Microsoft Visual SourceSafe Warning Check the box to avoid seeing this warning again on any future database Main Menu When you launch Total Access Speller the main screen appears f H H H H V al Start Spell Checking Spell Checker for Microsoft Access Program Options m about Help ogne Suggestion Box g Exit Total Access Speller Main Menu 16 e Chapter 3 Using Total Access Speller Total Access Speller E Tetal Access Speller Spell pel Start Spell Checking P List roperty Program Options Gp About Help Suggestion Box Exit E3 Total Access Speller 2003 or earlier Main Menu This screen lets you e Spell Check your database objects e See the results of the last spell checking you ran e Edit the list of properties to spell check e Set program options Start Spell Checking Press the Start Spell Checking button to begin spell checking the objects in your database Select Objects A list of objects is presented for you to select Total Access Speller Chapter 3 Using Total Access Speller e 17 r EE Total Access Speller Select Objects 8
19. ding developer of products for Microsoft Access Visual Basic and SQL Server In addition to Total Access Speller we offer a wide range of products for Microsoft Access developers administrators and users e Total Access Analyzer database documentation e Total Access Admin real time database monitoring e Total Access Components ActiveX controls e Total Access Detective difference detector e Total Access Emailer email blaster e Total Access Memo rich text format memo fields e Total Access Statistics advance data analysis e Total Access Startup version launcher e Total Visual Agent database maintenance and scheduling e Total Visual CodeTools code builders and managers e Total Visual SourceBook source code library e Total Zip Code Database city and state lookup lists e EzUpData share your data reports and files over the internet Visit our web site www fmsinc com for more information We also offer Sentinel Visualizer an advanced data visualization program that identifies relationships among people places and events through link charts geospatial mapping timelines social network analysis etc Visit our Advanced Systems Group at www fmsasg com for details Please make sure you sign up for our free email newsletter This guarantees that you will be contacted in the event of news upgrades and beta invitations Once again thank you for selecting Total Access Speller Luke Chung President Chapt
20. e This chapter explains the versions of Total Access Speller that are available system requirements installation steps and instructions for uninstalling Topics in this Chapter gt Available Versions gt System Requirements gt Installing Total Access Speller gt Using the Update Wizard gt Uninstalling Total Access Speller Total Access Speller Chapter 2 Installing Total Access Speller 9 Available Versions Due to the different properties and behaviors of each version of Access a separate version of Total Access Speller is required for each Microsoft Access version e Version 16 for Access 2016 e Version 15 for Access 2013 e Version 14 for Access 2010 e Version 12 for Access 2007 e Version 11 for Access 2003 e Version 10 for Access 2002 e Version 9 for Access 2000 e Version 8 for Access 97 Databases that can be opened by an Access version are supported by its version of Total Access Speller For instance version 14 supports these Access databases ACCDB ADP and MDB 2000 and 2002 2003 formats Support for ADPs ended with Access 2013 System Requirements Total Access Speller has the following system requirements e Microsoft Access You must have the version of Access that corresponds to your version of Total Access Speller e Hardware and operating system supported by Microsoft Access e 20 MB free disk space e Microsoft Office Proofing Tools Microsoft Office Proofing Tools Total Access
21. echnical Data and Computer Software clause at DFARS 252 227 7013 or subparagraphs c 1 and 2 of the Commercial Computer Software Restricted Rights at 48 CFR 52 227 19 as applicable Manufacturer is FMS Inc Vienna Virginia Printed in the USA Total Access Speller is copyright by FMS Inc All rights reserved Microsoft Microsoft Access Microsoft Office Access Microsoft Word Microsoft Vista Microsoft Windows and Visual Basic for Application are registered trademarks of Microsoft Corporation All other trademarks are trademarks of their respective owners License Agreement e iii Acknowledgments We would like to thank everyone who contributed to make Total Access Speller a reality We would like to thank the entire community of developers who have supported FMS over the years for providing valuable feedback and suggestions We truly appreciate the people who trust our work to solve their development problems We would also like to thank our beta testers for their diligence and feedback in helping us to make this the best product possible Many people at FMS contributed to the creation of Total Access Speller They include e Product Design and Development Luke Chung and Molly Pell e Quality Assurance and Technical Support John Litchfield Molly Pell and Madhuja Vasudevan e Documentation Luke Chung and Molly Pell Table of Contents Chapter 1 Introduction 3 About Total Access Speller J keke kek
22. eller 2007 Supports New Access 2007 Features In addition to the new features above Total Access Speller 2007 supports the new functionality and features introduced with Microsoft Access 2007 e Supports the new ACCDB database format in addition to Access 2000 2002 2003 MDB database formats Total Access Speller e Object selection screen has an option to spell check embedded macros in forms and reports e Spell checks the new Navigation Caption of datasheet views e Displays the Office 2007 Vista XP look and feel and transparent buttons with graphics e Supports tabbed or traditional window views depending on your current database s setting under Access Options Visit Our Web Site Total Access Speller FMS is constantly developing new and better developer solutions Total Access Speller is part of our complete line of products designed specifically for the Access developer Please take a moment to visit us online at www fmsinc com to find out about new products and updates Product Registration Register your copy of Total Access Speller on line Be sure to select the email notification option so you can be contacted when updates are available or news is released You must be registered to receive technical support Product Updates FMS is committed to quality software When we find problems in our products we fix them and post the new builds on our web site Check our Product Updates page in the Technical Support area for
23. er 1 Introduction Discover how Total Access Speller can help you deliver more professional applications by catching typos and spelling errors in your Access objects This chapter introduces the product and highlights key features and concepts you should know when using the product Topics in this Chapter About Total Access Speller Product Highlights gt gt gt Enhancements in This Version gt Enhancements from Previous Versions gt Visit Our Web Site Total Access Speller Chapter 1 Introduction 3 About Total Access Speller No matter how much time and effort you spend designing and testing your applications a typo or spelling error in the interface can make a professional application appear unprofessional Before delivering an application it is important to ensure that the user interface is free of spelling errors Although Microsoft Access has had spell checking available for some time its functionality applies only to data in tables and not to the object design properties that affect what the user sees Until now there has been no way to spell check these object design property values automatically Examining them manually can be time consuming and error prone and your user will take notice if you overlook even one mistake Total Access Speller is the first product for Microsoft Access that allows you to spell check your object designs Product Highlights Total Access Speller examines the object propertie
24. he Microsoft Access Spell Checking tool to check the Property Value field Changed Property Name Property Value Object Type Spelling English United States Not In Dictionary Nexxt Suggestions Ignore All Change All AutoCorrect Dictionary Language English United States Options Spell Checking Dialog Use the spell checker just as you would in Access to spell check your data accept or ignore the suggested spelling changes You can also enter your desired value As you make your changes only the table is updated and not your objects That happens in the next screen This gives you the ability to cancel your changes if you decide not to proceed and your objects remain unchanged Hotkeys on Control Captions On forms hotkeys can exist on control captions or associated labels to controls Hotkeys are defined by using a amp key before a letter so that the control can be selected by pressing the Alt and letter The letter could be at the beginning or middle of a word Because having a amp in the middle of a word would flag the word as a typo Total Access Speller includes text parsing to remove the amp before you spell check the Chapter 3 Using Total Access Speller e 21 text If you change the property value Total Access Speller resets the amp to the same hotkey before updating the property in the actual object If you change
25. isible Controls If unchecked all the properties of controls with its Visible property set to No are ignored Additionally labels associated with controls that are not visible are also excluded The purpose of this option is to avoid the time to review text that users would never see However a control that may be invisible in design mode could become visible if your program changes the setting when it runs Moving Forward After you select the objects you want click the Next button for Total Access Speller to build the list of property values for all the objects you selected Chapter 3 Using Total Access Speller e 19 eS BRE RAS Building Property List i Please wait while Total Access Speller builds the list of property values to spell check Building the Property List This process is typically fairly fast but depends on how many objects you selected If you find that it s taking too much time you can click the Cancel button to return to the Select Objects wizard page Spell Checking Your Text For your selected objects Total Access Speller builds a list of text values for the properties to spell check This is the page where you do your work This Spell Checking page is where you perform the actual spell checking Spell Checking Press the Spell Check button to start spell checking Once you are done press Next to continue Changed Property Name Property Value v ObjectType Men
26. k 4 Product AE MI sn Se N DD r E 4 Enhancements in This Version A kk kk kk 4 Enhancements from Previous Versions ne 5 VETOU WebSite wessen 7 Chapter 2 Installing Total Access Speller 9 Available Versions a een 10 System Requirements nassen nl avka Sad ben an SN dae 10 Installing Total Access Speller kk kek 11 Using the Update Wizard 11 Uninstalling Total Access Speller e 11 Chapter 3 Using Total Access Speller 13 Starting Total Access Speller u kek k 14 Main Mensen 16 Start Spell Checking cisrenan 17 Spell Checking Your Textile 20 Wele Mena ST ma rm 22 Editing the Property List see une 25 Program Options ea 28 Chapter 4 Troubleshooting and Support cccssssssceeceeeeeesees 31 SUPPOFE RESOUFCES nee 32 Web Site SUD DONE 4n yee en E A 32 Technical Support ODpUlO S a y i k2 n 5kneny iion MIn ER V k dR N 33 Contacting Technical SUPPO su 35 WAGON sama a ne n Ra k n n SR Da b H KONE ER DEK O HH REH D KUR DERO E DR O HO NE BERN RUNE D KONAN 37 Total Access Speller Table of Contents e vii Welcome to Total Access Speller Thank you for selecting Total Access Speller This valuable development tool makes it easy to spell check the objects you design in Microsoft Access Total Access Speller is developed by FMS Inc the lea
27. mpts on the form to check for the latest update Uninstalling Total Access Speller Total Access Speller supports the standard Windows installation protocol so uninstalling is similar to uninstalling other programs Start the Uninstall Process From the Windows Start Menu select Control Panel then Windows Vista Windows 7 8 and Windows 10 e Inthe Programs section select Uninstall a Program Windows XP e Select Add Remove Programs Total Access Speller Chapter 2 Installing Total Access Speller e 11 Select Total Access Speller for Removal e Select Total Access Speller from the list of installed programs e Click on Uninstall from the menu e The installation program loads Choose Remove and follow the prompts After a few moments the Total Access Speller program files and its registry entries are deleted 12 e Chapter 2 Installing Total Access Speller Total Access Speller Chapter 3 Using Total Access Speller Now that Total Access Speller is installed you may want to jump right in and start it While we have designed the product to be easy to use you should read the material in this chapter to understand important tips and concepts for getting the most out of the program Topics in this Chapter Starting Total Access Speller Main Menu Start Spell Checking Spell Checking Your Text Y VV V WV Apply Changes Total Access Speller Chapter 3 Using Total Access Speller e 13 Starting Total Access Speller
28. pear in your application s user interface This design includes properties that do not affect your application s functionality Although you can add any Access property to the list you should NOT add properties that affect an object s operation For example do not try to spell check the Name property of an object or the ControlSource property of a control Changing these property values may adversely affect your application Once you select the object type enter the property name and add a description for your own reference Click OK to save your changes or Cancel to discard them and Total Access Speller takes you back to the Edit Properties form Deleting Properties While you cannot delete properties in the built in property list you can delete properties that you have added by selecting the property and clicking the Delete Property button If you want to disable a property without deleting it just uncheck its checkbox in the form Property Report A report is available listing all the properties in the list and if they are selected The report can be previewed or opened in report view Chapter 3 Using Total Access Speller e 27 Total Access Speller Property Name Form Caption NavigationCaption Tag Form Control Caption ControlTipText DefaultValue StatusBarText Tag ValidationText Macro Comment MenuName Message MessageText StatusBarText Subjed Title Query Description QueryField Caption
29. r 2010 and 2013 each includes two programs in one to support the 32 and 64 bit versions of Microsoft Access 2010 and 2013 Microsoft does not allow 32 and 64 bit versions of the same version of Access to be installed on one machine The Total Access Speller 2010 and 2013 setup programs detect the appropriate version and installs it on your machine Machine and User Installation Options The setup program and add in supports installation for the machine or user This allows Total Access Speller to run for users with or without administrator permissions as set under Windows User Account Control UAC Improved Spell Checking of Macros Spell checking has improved for documenting macros including comments and message boxes New Option to Ignore Invisible Controls A new option is available to exclude controls with Visible property set to No This avoids spell checking controls that users never see Labels associated with controls that are invisible are also excluded This option is set when selecting objects to spell check Property List Shows Built In Status On the Property List a new checkbox column shows whether the property is a built in property or one added by you Total Access Speller Chapter 1 Introduction 5 6 e Chapter 1 Introduction Total Access Speller 2007 12 0 and Total Access Speller X 5 In conjunction with the release of Access 2007 FMS released a new version of Total Access Speller for Microsoft Access 2007
30. s chapter provides information about troubleshooting problems that arise and obtaining support for Total Access Speller Topics in this Chapter gt Support Resources gt Web Site Support gt Technical Support Options gt Contacting Technical Support Total Access Speller Chapter 4 Troubleshooting and Support e 31 Support Resources There are many resources available to help you resolve issues you may encounter Please check the following Readme File Check the README file for the latest product information The README file is located in the directory where you installed the product Product Documentation We ve spent a great deal of care and time to make sure the Total Access Speller manual and help file are very detailed Check the Table of Contents and Index for your question and read the appropriate pages Web Site Support The FMS web site contains extensive resources to help you use our products better Resources include product updates frequently asked questions FAQs forums information on new versions betas and other resources Web Site The FMS web site is located at www fmsinc com News and important announcements are posted here Support Site The main support page is located at http support fimsinc com From this page you can quickly locate the other support resources Product Updates FMS takes product quality very seriously When bugs are reported and we can fix them
31. s that appear on your application s user interface and allows you to spell check them It supports spell checking for tables table fields queries query fields forms form controls reports report controls macros including embedded macros built in command bars and user command bars You decide which objects to spell check which property values to examine and which spelling suggestions to apply Total Access Speller is integrated with your Office Access spell checker so it supports your own language and custom dictionary For most objects changes are made to your application automatically For situations that cannot be updated automatically Total Access Speller provides a reference report so you can make the corrections manually Enhancements in This Version 4 e Chapter 1 Introduction Total Access Speller for Microsoft Access 2016 Version 16 0 This version of Total Access Speller is the ninth version of the product since its debut in 1993 It includes a new version for Microsoft Access 2016 plus continued support for earlier Access versions Total Access Speller Enhancements from Previous Versions Total Access Speller for Microsoft Access 2010 Version 14 0 Total Access Speller for Microsoft Access 2013 Version 15 0 It includes a new version for Microsoft Access 2010 and 2013 plus continued support for earlier Access versions Support for 32 and 64 bit Versions of Access 2010 and 2013 Total Access Spelle
32. se source table properties are not reflected on the linked table This may or may not be what you want To spell check the actual table s properties you should spell check the source database rather than the linked database That applies changes at the source which may be used by multiple linked databases Due to permission issues Total Access Speller only examines your current database and does not apply changes to the source database By default it does not apply changes to linked tables If you uncheck this option changes are applied to your local linked tables Just realize that will cause them to be permanently different from their source table 9 Do not apply changes to Linked Table Properties E7TBEr IE 3 Option to Update Local Properties of Linked Tables By default this option is checked and changes are NOT applied to linked tables They show up in the results report without the Applied box checked By un checking this option changes are applied to your local linked tables So if you modify the description property of a linked table the change is made in the local database s link to the table and NOT in the actual table as it exists in the linked database That means other databases that are linked to that table would not see your change This may or may not be what you want 30 e Chapter 3 Using Total Access Speller Total Access Speller Chapter 4 Troubleshooting and Support Thi
33. son requesting support must also be the registered user of the product Registration is required and will be requested by our Technical Support professionals Contacting Technical Support Total Access Speller If the troubleshooting suggestions and other support resources fail to resolve your problem please contact our technical support department We are very interested in making sure you are satisfied with our product Contact Us The best way to contact us is to submit a ticket on our support site http support imsinc com Please provide detailed information about the problem that you are encountering This should include the name and version of the product your operating system and the specific problem If the product generated an error file please submit that as well Our ticketing system will let you track the progress of your issue and see the entire thread of communications and file attachments Chapter 4 Troubleshooting and Support e 35 Please bear in mind that a unique issue may involve meetings between the technical support staff and product developers so your patience is appreciated Registering Your Software You must be registered to receive technical support If you purchased our software directly from us you should already be registered If not submit your information in your ticket e Product Name and Version e Serial Number e Contact information name address email Registration also en
34. t be updated Help X Preview Changes B Report View Changes Back el if a Confirmation Page Last Step before Applying Changes Automatically Applying Changes For MDB and ACCDB databases Total Access Speller writes changes back to your objects for the following types e Tables and Table Fields 22 e Chapter 3 Using Total Access Speller Total Access Speller Total Access Speller e Queries And Query Fields e Forms and Form Controls e Reports and Report Controls e Command Bars For ADP databases Total Access Speller writes changes to these object types e Forms and Form Controls e Reports and Report Controls e Command Bars Click the Apply button to update your objects Afterwards the results page appears F Access Speller Results X A Results C Program Files Office12 Samples Northwind accdb Total Access Speller applied the changes to your objects at 10 8 2008 3 16 07 AM Summary of Changes Total Changes Requested 23 G Changes that require you to manually make them vs updates by Total Access Speller Manual 3 Automated 20 Gig Of the automated changes that were attempted Successful 17 gg Failed E 3 Of the successfully updated form control captions these controls lost their hotkey assignments Hotkeys Lost 2 k Spell Checking Results The Results form displays a summary of the changes you requested and how man
35. te the change to the property If Total Access Speller encounters problems updating a property the Failed Attempted Changes report is available listing the changes were not made Carefully examine this report and make the changes manually to see why it failed Losing HotKeys If a form control s caption originally had a hotkey e g amp Next and the new caption no longer has that letter the hotkey is lost The change was made to your property but the hotkey could not be preserved The Lost Hotkey report lists these and you will need to manually set a new hotkey for them by adding an ampersand amp character Spell Checking Complete After you click the Close button you return to the main menu If you want to see the results again and view the reports they are available under the Last Results button 24 e Chapter 3 Using Total Access Speller Total Access Speller Total Access Speller Total Access Speller reviews property values in your database objects that could potentially contain typographical errors Access supports thousands of properties across many object types but only a small set are relevant for spell checking To make the process of spell checking easier Total Access Speller only examines properties that are potential locations of typographical errors For example it would make no sense to look at the BackColor property on a form control since this property only supports numerical values Simil
36. ter or A4 paper sizes 28 e Chapter 3 Using Total Access Speller Total Access Speller Total Access Speller 3 Total Access Speller Options Options Paper Size Linked Tables Paper Size for Reports vo X Cancel Help Option to set Paper Size Linked Table Properties Properties for linked tables can exist in two places By default the properties of the back end source table are used by the front end linked table However the linked table can override the properties defined by the source table When this happens future changes to properties on the source table are not reflected on the front end table This is usually not what you want to do since you usually want to keep them in sync To spell check the actual table s properties you spell check the source database rather than the linked database This applies changes at the source which may be used by multiple linked databases Due to permission issues Total Access Speller only examines your current database and does not apply changes to the source database You have this option Chapter 3 Using Total Access Speller e 29 Options Linked Tables Properties for linked tables can exist in two places By default the properties of the back end source table are used by the front end linked table However the linked table can override the properties defined by the source table When this happens future changes to tho
37. the text so the hotkey no longer exists the property is still updated but this is flagged in the hotkey report so you are aware the hotkey disappeared Finishing When you finish spell checking click the Next gt button to move to proceed You need to make at least one update to proceed Canceling If you click the lt Back button Total Access Speller returns to the Select Objects wizard page You are prompted to confirm your choice since any spelling changes you made are lost when you go back Apply Changes You are now ready to tell Total Access Speller to apply the changes you made to the property values A confirmation page appears gE Es Total Access Speller Confirm Changes Confirm Changes Total Access Speller can apply changes you made to Tables and Table Fields Queries and Query Fields Forms and Form Controls except embedded macros Reports and Report Controls except embedded macros Command Bars and Command Bar Controls Due to limitations in Access Total Access Speller cannot write changes to the following objects You must make these changes manually Macros embedded macros on forms and reports Linked Tables changes are made in the local database not the backend database What to do next 1 Press the Apply button to update your objects with your changes 2 Upon completion a summary of results is displayed including items that you need to manually update and those which could no
38. titles you to free product updates notifications information about upcoming products and beta invitations You can even receive free email notification of our latest news Microsoft Technical Support FMS only provides technical support for its products If you have questions regarding Microsoft products please contact Microsoft technical support 36 e Chapter 4 Troubleshooting and Support Total Access Speller Index 3 32 and 64 bit versions 5 A ACCDE databases 14 Access Data Projects 18 27 ActiveX Controls 27 add property 26 ADE databases 14 ADPs 18 27 apply changes 22 24 blog 8 build property list 19 C changes 22 24 apply 22 24 automatic 22 linked tables 29 macros 24 manual 24 custom dictionary 4 10 D delete property 27 demos 7 E embedded macros 24 Total Access Speller F Facebook 8 filter objects 18 21 FMS web site 7 32 installing 9 10 Internet Home Page 7 L language settings 4 10 license agreement i iii linked tables 29 M macros 24 manual changes report 24 MDE databases 14 Microsoft Visual SourceSafe 14 15 O objects filter 18 21 select 17 Office Proofing Tools 4 10 P permissions 14 Proofing Tools 4 10 property list 25 28 add 26 build 19 delete 27 edit 25 select 26 spell check 21 R registration 7 35 S select objects 17 select property 26 social media 8 SourceSafe 14 spell
39. uName addmenu menuname Macro StatusBarText addmenu statusbartext Macro Message msgbox messagefoobar Macro Title msgbox titlefoobar Macro All Objects StatusBarText echo statusbartext Macro Tables rr MessageText sendobject messagetextfoobar Macro 5 Queries j Subject sendobject subjectfoobar Macro Eorms Comment How to send an email from thiscomment Macro Reports Macros 5 User CmdBars Property M 1of8 b k No Filter Search Help j A Preview Changes E Report View Changes List of Properties to Spell Check The Property Value column contains the current property s value which may be overwritten manually or when you spell check it If the value is modified the Changed column becomes checked 20 Chapter 3 Using Total Access Speller Total Access Speller Total Access Speller Using the Object Filter You can filter the list of properties by object type using the option buttons on the left Select the All Objects option button to turn the filter off You can also filter the datasheet at the column header or by right clicking on the grid itself This lets you filter on a variety of criteria Start Spell Checking Press the Spell Check button to spell check the values in the Property Value column for the list of displayed filtered properties A sell Check QAnnnnnnnnnnnnnnnnnnnnnnnnnna The Spell Check button launches t
40. we make the updates available on our web site If you are encountering problems with our product make sure you are using the latest version 32 e Chapter 4 Troubleshooting and Support Total Access Speller Product updates can also be checked using the update wizard See Using the Update Wizard on page 11 for details Frequently Asked Questions FAQs Common questions and additional information beyond what is in the manual is often available from our FAQs Microsoft Patches Our support site also includes links to Microsoft patches that are related to our products Make sure you re using the latest versions by checking here or visiting the Microsoft site Technical Support Options Total Access Speller FMS is committed to providing professional support for all of our products We offer free access to our online FAQs and forums Bug reports feature requests suggestions and general pre sales questions related to our products are always available at no cost Additional maintenance plans are available to provide subscribers with enhanced technical support This is the best way for you to stay current with the rapidly changing technologies that impact project development and to ensure you are getting the maximum return from your software investment Please visit our web site www fmsinc com for the most up to date information Features amp Benefits Premium Incident SEIT ELK Minor Upgrades Bug Fixes v d v First 30
41. y were implemented and if there were any problems Reports are available for each category including e The entire list of requested changes e Those that require you to manually update them e Those that were attempted to be applied automatically e Those that were successfully applied automatically e Those that failed to be applied e Those that were updated but lost their hotkey Chapter 3 Using Total Access Speller e 23 Applying Manual Changes Unfortunately for certain object types Total Access Speller is unable to apply changes automatically For these objects you need to apply the changes manually by opening the object in design view changing the property value and saving it Total Access Speller lists all properties that it can t change in the Manual Changes Report You can preview this report on the screen but it is best to print this report so you have a hard copy reference to use when applying manual changes Total Access Speller cannot make changes for the following object types Macros and Embedded Macros Due to Access security limitations Total Access Speller cannot apply changes to macros including embedded macros Invalid Property Values Total Access Speller cannot apply changes that are invalid by Microsoft Access s rules For example if the length of the value exceeds Microsoft Access s limitations or if your change includes a character or value not allowed by Access Total Access Speller does not wri
Download Pdf Manuals
Related Search