Access 2007-2016
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  

News      User Comments     History     Notify Me

3/17/2014 10:46:14 AM
Microsoft Access Expert 19
By Richard Rost   Richard Rost on Facebook Richard Rost on Twitter Richard Rost on Google Plus Richard Rost on LinkedIn Email Richard Rost

Microsoft Access Expert Level 19 is 1 hour, 40 minutes long. In this class we are continuing our work with Crosstab Queries. This class focuses primarily on advanced Conditional Formatting and Exporting Data from your Access Database to other formats, including Excel, Word (including Mail Merge), Text Files, Other Databases, XML, HTML, and more. Topics include:

- Conditional Formatting
- Advanced Conditional Expressions
- Exporting to Microsoft Excel
- Exporting to Microsoft Word
- Microsoft Word Mail Merge
- Exporting Text Files
- Fixed Width vs. Delimited Text
- Exporting to Other Databases
- Exporting HTML Files for the Web

Click here for more information on Access Expert Level 19, including a course outline, sample videos, and more. This course was recorded using Access 2013, but is also valid for Access 2007 and 2010 users. This class follows Expert Level 18.

Permanent Link
Course Link: Microsoft Access Expert 19
Keywords: access expert 19 conditional formatting export
Page Tag: whatsnew
Post Reply

Mail Merge Comment from Katheryn Hartig @ 3/31/2016
Richard - These lessons are amazing! Keep 'em coming! I want to give my users the ability to select names from a list on a form and then hit a button that opens WordMailMerge and feeds the selected names to Word for merge. Do you cover that? Thanks!

Reply from Alex Hedley:

This course explains the Mail Merge, just make sure you have a query based on the records you want before following the steps in Word.
Show Just This Thread        Post Reply
Entire line in yellow Comment from Trond L @ 1/26/2016
When choosing "Field has focus", is it possible to mark an entire line yellow, not just a single field at a time? (yellow or another color, of course)

Reply from Alex Hedley:

See this forum post.
Show Just This Thread        Post Reply
Conditionally format a control Comment from Brian Jensen @ 1/9/2016
Is it possible to conditionally format a control on a form based on value in a query that isn't linked in the control source?  I want a name to change color in one form if the person is away on a trip based on records from another table.

Reply from Alex Hedley:

You could try using a DLOOKUP in your Expression to get a value from another Table/Query and check that against your condition
Show Just This Thread        Post Reply
Mail Merge Comment from Stephen Orlans @ 9/12/2015
Hi Richard I would like to mail merge using the current record's name and address only into a preformated word template but it seems that you can only mail merge a list and deselect the records you don't want.  Can you merge a single record automatically?  Thanks Stephen

Reply from Alex Hedley:

You could make a Query of 1 Record and merge that.
Show Just This Thread        Post Reply
I was trying to have a field highlight on a report Comment from vicki H @ 5/3/2015
I am using the conditional formatting. I am not using code I had to change the background color to Automatic/Background 1 before it would highlight.  On to the next. Thanks Alex

Reply from Alex Hedley:

The joys of Themes, glad you sorted it out and thanks for sharing.
Show Just This Thread        Post Reply
I was trying to have a field highlight on a report Comment from vicki Hudson @ 5/3/2015
I was trying to have a field highlight on a report, only if a combo box on a form had a certain criteria. I can bold and underline it.

Reply from Alex Hedley:

How are you Bold/Underlining it at the moment?

You could look into either the OnFormat Event or Conditional Formatting.

  Me.[ControlName].BackColor = RGB(255,0,0)
  Me.[ControlName].BackColor = RGB(0,0,0)
End If

This MS Article maybe of use.
Show Just This Thread        Post Reply
Conditional Formatting Comment from vicki Hudson @ 5/1/2015
Does the conditional formatting work with a combo box when it is automatically filled from another field?

Reply from Alex Hedley:

Why not give it a go and see :)

If it doesn't add a Me.Recalc
Show Just This Thread        Post Reply
VBA Export Comment from Chris Thompson @ 3/19/2015
Access 2013 Expert 19 chapter 2 ~TS 15:00, we create an export. While I know we are presently avoiding VBA code, my question is - Once created, are we able to programmatically execute these saved exports from Access?

Reply from Alex Hedley:

Are you wanting to know how?
Show Just This Thread        Post Reply
Comment from Brian Farley @ 10/28/2014
Worth noting to prevent hair pulling out.  Your field must have a background in order for the conditional formatting to change the format.  If it's set to Transparent, the field will not change format until you click in it...

-signed the recently became bald guy
Show Just This Thread        Post Reply
Comment from Hassan Abadi @ 6/11/2014
Hi Richard:
What is the correct conditional formatting syntax to show the lowest price item in a form text box?

Show Just This Thread        Post Reply
Richard your lessons are addictive thank you Comment from AccessJunkie @ 5/8/2014
your lessons are addictive!!! thank you.
in your conditional formating, is there a way to create a blinking cell if, for example, a date gets out of the desired range??



Reply from Richard Rost:

Not without a timer event. Conditional formatting alone can't do that.

Show Just This Thread        Post Reply
Comment from Lucas Langerak @ 3/19/2014
Looking forward to the remote data entry information.  I should really be able to put that to good use.
Show Just This Thread        Post Reply

Add Your Comments or Subscribe
If you just want to subscribe to get email updates when the News is updated, then enter your name and email address and check the Notify Me box below. If you would optionally like to add your comments below to be posted, they are welcome.
  Your Name:  Required
  Your Email:  NOT Public


Sorry about this step. It's just to keep the spam bots away:
  Verify: What is 8+8:
  Notify me when the News is updated.
  Remember Me for my next comments
Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead.

I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be.
As always, I promise to never give away your personal information to anyone else, ever.

NOTE: If you don't leave your name and email address, DON'T expect a reply. I can't promise a personal reply to everyone who posts here. I TRY my best, but I cannot guarantee it. If you don't leave your real name and email address, I won't even bother. I usually just hit DELETE. -Richard



You may want to read these articles from the 599CD News:

6/20/2019TIP: Validation Rules in Access
11/20/2018Microsoft Access Developer 12
8/25/2018NEW: Access Dev 9, 10, 11
8/25/2018Microsoft Access Developer 11
8/25/2018Microsoft Access Developer 10
8/25/2018Microsoft Access Developer 9
8/23/2018Access Dev 11 is ONLINE
8/17/2018Access Dev 10 is ONLINE
8/15/2018Access Tip: Search Form
8/15/2018Access Tip: Locked v. Enabled

Visual Basicindex
Account Login
Online Theater
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Live Chat
Customer Support
WalkThru Tutorials
Consulting Services
About Us
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Gift CDs
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP