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

This is the fourth Microsoft Access video tutorial in the Expert series. It picks up where Expert Level 3 left off.

This class is 1 hour, 48 minutes long and focuses primarily on new types of form controls including option groups, toggle buttons, the image control, and more. We'll also learn about one-to-one relationships, and practice more with one-to-many relationships. You will learn:

- Additional Form Controls
- Option Groups, Tab Control
- Toggle Buttons, Enhanced Formatting
- List Box, Image Control
- Display Image Without Storing
- One-to-One Relationships
- Extended Customer Details
- More One-to-Many Relationships
- Track multiple family members

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

Customer Picture Link 
Ron Fischer    
37 days ago
Richard, by working though Lesson3 in Expert 4 setting up the Query CustomerPictureQ to get a report with the customer Picture, uses the setup you describe in the lesson, using "CustomerT" and "CustomerExtendedT", setting the Join properties to "2" or "3" will run to an SQL Error and Access want me to run a it in a separateQuery first ... and than combine it..
what did I do wrong?
Richard Rost    
35 days ago
I don't understand the error you're getting. If you follow the video exactly, it should work. What's the SQL you end up with?
Ron Fischer   
34 days ago
Richard this is the reply from system when I run the query "CustomerPictureQ" setting exactly akin Lesson 3 Expert4, link between CustomerT and CostomerExtendedT on option "2":
SQL statement could not be executed because it contains ambiguous outer links. In order for one of the joins to be executed first, you need to create a separate abrege that executes the first join and then include this query in the SQL statement
Richard Rost    
34 days ago
You shouldn't get that error if you're following along with my video exactly. Did you change anything? Double-check your spelling.
Alex Hedley   
34 days ago
Which order are the tables dragged into the view? Which one is on the left; which is one the right?
When you drag the join and it gives you the option for the JOIN type what does it say?
It might be that you are using the wrong join your for the fields on each side.
Ron Fischer   
30 days ago
Well Richard, you are right, just started over build it from scratch according to the video and this time it worked as expected,
thanks and sorry for the confusion I may have caused, :-))
Richard Rost    
29 days ago
No problem, Ron. That's why you're here: to learn. I don't mind helping out.
Add a Reply

Show All Comments

Post a New Comment or Question
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:

11/21/2020Shortcut Keys Ctrl-Period Ctrl-Comma
11/19/2020Hide Page Footer on First Page
11/19/2020Single-Field Search Button
11/19/2020Get Username WScript
11/18/2020Access Developer 19
11/18/2020Access Developer 19 Lessons
11/18/2020Access Developer 19
11/18/2020DateAdd to Add Months
11/16/2020Properly Calculate Age
11/13/2020myNetWorkDays Function

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
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 The Site
Waiting List
Production Schedule
Code Vault
Collapse Menus
Live Chat
Customer Support
WalkThru Tutorials
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
MYOLP Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Live Chat
General Info
Support Policy
Contact Form
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

YouTube Channel    LinkedIn

Blog RSS Feed   
Keywords: access expert 4 form controls one to one image option groups toggle buttons tab controls  Page Tag: whatsnew  PermaLink