Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
 
 
Microsoft Access Expert 19
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   7 years ago

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.

Export multiple reports to 1 PDF Upload Images   Link 
Emy Ng Hang 
11 months ago
Is it possible to export multiples separate reports to one single pdf file?
Richard Rost
11 months ago
I don't believe so - unless you can make those all one report. There are third party utilities out there that can combine multiple PDF files. I suppose it might be possible to export to Word and then from there create a PDF file. I have done none of this personally, by the way. I don't do a lot with PDF files.
Austin Ritner
11 months ago
Emy, do you mean multiple reports from a customer? For example, if you wanted to see all invoices for that customer, is that what you mean?
Add a Reply
Export to RTF with images Upload Images   Link 
Emy Ng Hang 
11 months ago
Is it possible to export a report to a rtf file keeping the text formatting (background color, border color...) and the images (company logo)?
Richard Rost
11 months ago
I'm almost positive you can't export images. Colors, I'm not sure. It's been a few years since I've worked with that. I'd have to play with it. Might make a good video...
Add a Reply
Searching Upload Images   Link 
Katheryn Hartig 
5 years ago
Also, I want to give my users a menu to select a variety of criteria and then return a recordset (e.g., find by discipline and date range and ...). Can this be done w/o programming? If so, which lesson(s)? Thanks! Read More...
Add a Reply
Mail Merge Upload Images   Link 
Katheryn Hartig 
5 years ago
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! Read More...
Add a Reply
Entire line in yellow Upload Images   Link 
Trond L 
5 years ago
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. Read More...
Add a Reply
Conditionally format a control Upload Images   Link 
Brian Jensen 
5 years ago
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. Read More...
Add a Reply
Mail Merge Upload Images   Link 
Stephen Orlans 
6 years ago
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 Read More...
Add a Reply
I was trying to have a field highlight on a report Upload Images   Link 
vicki H 
6 years ago
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: Read More...
Add a Reply
I was trying to have a field highlight on a report Upload Images   Link 
vicki Hudson 
6 years ago
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? Read More...
Add a Reply
Conditional Formatting Upload Images   Link 
vicki Hudson 
6 years ago
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 Read More...
Add a Reply

Show Older Comments...
View in Table Format

Start a NEW Conversation
 
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.
 
Subscribe
 

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

7/28/2021Membership Database
7/27/2021Quick Queries #5
7/27/2021Loop Thru Fields in Table
7/26/2021First Monday
7/25/2021Missing Months
7/24/2021Center Vertically
7/23/2021DCount
7/22/2021Buy Access
7/21/202164-Bit Access
7/20/2021Relationships
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: access expert 19 conditional formatting export  Page Tag: whatsnew  PermaLink