.Use the code in this text file in Access Forms and Reports to TRIM and CONCATENATE two portions of an Address field.
Blog
Useful Operators for Access Expressions
Use these resources to learn about the large variety of useful operators that can be used when building an expression in Microsoft Access. If you do not know about these operators, you are missing out! Microsoft Table of Operators for Read More …
Captivate Software Simulation: Changing Font Color in Word
For my Captivate students, below is a sample project created the “demo” mode of the software simulation ability of Captivate. Look for use of mouse objects, text captions, and highlight boxes.
Excel Skills Assessment Quiz
Take this short 20 question Excel assessment quiz to see if you know the fundamentals of using Excel. The questions apply for all recent Excel versions. If you would like to test yourself on higher level Excel topics, take one Read More …
Format Painter Tips to make it become your Excel power tool
Are you aware of the how far you can extend the use of Format Painter as a tool in Excel? Format Painter goes way beyond simply formatting cell properties from one cell to another cell! Expand your use of Format Read More …
Top Tips for Adobe Captivate Productivity
Have you ever found yourself endlessly repeating the same type of revisions on multiple Captivate slides? If so, then these top tips will come in handy for boosting your efficiency in Adobe Captivate. If you start using them in the Read More …
Field Validation Rules For Access Table Data
Field validation rules can help make sure that data you enter into Access tables has correct form and/or meets certain requirements. Validation rules prevent bad data from being entered by restricting user input. A couple of key things need to Read More …
Branding your SharePoint site with an alternate style sheet
Maybe the out-of-the-box composed looks that give you new look with “one click” (Site Settings > Look and Feel > Change the look) just don’t give you enough choice for brand customization. And maybe you just don’t want to spend Read More …
How to create a Word letterhead template with new page settings on Page 2
Often company letterhead templates are designed to contain pre-filled header and footer content with a company logo, sample starter text, and custom page settings like margins. These templates are typically no more than 1 page long since limited content is pre-typed Read More …
Using VBA to insert header and footer images in Word document Letterhead Templates
A company that was rebranding approached me with the desire to create one universal letterhead template file that would work for all office locations. When the file opened, they wanted a prompt to ask the end user which office they Read More …