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  
Access 2010 Beginner 9
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   9 years ago

This Microsoft Access video tutorial picks up where Level 8 left off. This class focuses on creating a contact history for our customers and designing reports from scratch.

- Tracking Contact History
- Data Integrity
- Report Design From Scratch
- String Concatenation
- Report vs. Page Header & Footer
- Can Grow / Can Shrink Properties
- Records from a Specific Date
- Explicit Query Parameters
- Report Formatting

Click here for more information on Access 2010 Beginner Level 9, including a course outline, sample videos, and more.

Forms Upload Images   Link  
Harold Sheats 
7 months ago
i open a report form & the source ContactQ & go to add fields contacts form the contact are not available
Adam Schwanz
7 months ago
So you have a report with a recordset of ContactQ but have no available fields to add?

Check your query and make sure you have the fields in there, sounds like it's a blank query.
Richard Rost
7 months ago
Check the Record Source property of the Report and make SURE you have it set to ContactQ. Sounds like you didn't set that. It's the ONLY reason the fields wouldn't show up.
Add a Reply
Report does not respond Upload Images   Link  
Emad Al-Baghli 
9 months ago
I have Query for Contact and it sorted by date Descending, If I run the Query itself it is working good, then I create Report based on that Query, If i run the report the report did not sorted by date. what do you think the problem is?
Adam Schwanz
9 months ago
Just change the report's sort by property. Report properties -> Data -> Order by
Emad Al-Baghli
9 months ago
Adam, kindly can write the code for me?
Add a Reply
Circular Reference Upload Images   Link  
Dianne Force  
12 months ago
Hi Richard,
I copied this from my Report Control Source, but it is giving me an error =[FirstName] & [LastName]
I've tried it different ways (with the the Space & with the Trim) and I keep getting an error which says: "This control has a reference to itself." I am using Access 365 Read More...
Dianne Force
12 months ago
I figured it out. When I was changing to make things work, I had not realized the Name had reverted back to FirstName instead of FullName, but now I know what a circular reference is:-)
Richard Rost
12 months ago
Yeah, they're fun, aren't they? :)
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.

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

12/3/2021Access Beginner 2
12/3/2021Access Beginner 2 Lessons
12/3/2021Access Beginner 2
11/30/2021Import Multiline Cells
11/30/2021Adam's Access Games
11/29/2021Prevent Close
11/22/2021Currency Symbols
11/13/2021Access Developer 36
11/13/2021Access Developer 36 Lessons

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

YouTube Channel    LinkedIn
Keywords: access 2010 beginner 9 contact history report design  Page Tag: whatsnew  PermaLink