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.. Read More...
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
Add a Reply
Small Glitch Link 
Gina T    
2 months ago
Hi Richard,

It's not a question regarding the video content, yet I just wanted to let you know:

I noticed a small glitch in the video at around 10:05. I think there went something wrong with cutting the video. There is the sentence beginning with "Now it doesn't happen often..." repeating once.
Richard Rost    
2 months ago
Which one of the videos? If so, you'll be the first student in 7 years to catch it. :)
Gina T   
2 months ago
It's in Access Expert 4 (2010-2019), Chapter 1 "Extended Info Tables"
Add a Reply
Error Related Record Link 
Joel Burroughs    
2 months ago
Hi Richard,  

I'm getting the following message when I get to just shy of the 5 minute mark in the 2nd video, Expert 4.

"You cannot add or change a record because a related record is required in table CustomerT" Read More...
Richard Rost    
2 months ago
If this were a VBA class I would tell you to check your spelling. You spelled "Extended" and "makeing" wrong. As you've seen in my videos, I can be horrible with spelling field names correctly too. However, this isn't VBA so you're not typing anything in.

The only thing I can really suggest without looking at your database is make sure the record in your CustomerT is SAVED to the table first before you try putting data in the ExtendedT. If it's still dirty (the pencil shows in the record selector bar) then it's not full committed to the table yet. I believe I mention this in the video. If not, let me know.
Richard Rost    
2 months ago
I accidentally moved your post to the wrong forum. This email should point you in the right direction. Sorry for the confusion.
Add a Reply
Microsoft Access Expert 4 Link 
Ida Hangen 
2 years ago
First off I LOVE these classes.  I went back and review Access Expert 4 and was trying to use an option group in another database. However, I do not have a Option Group button in my toolbar.  I do have the Wizard Controls turned on but can not seem to locate the Option Group Button in order to create control buttons.   I went through a repair on Access but still not Option Group.   Do I need to go through a manual process to add a group of toggle or option buttons?  I must have had it at one time as my training Database has these groups on the form per this lesson. Read More...
Add a Reply
Microsoft Access Expert 4 Link 
Chad M    
2 years ago
First, thank you for these courses as they have been extremely helpful.  I have two questions about toggles:  1.  Is it possible to create a 3-state toggle (e.g. Green, Yellow & Red options)?  2.  Are toggle buttons able to be printed on either forms or reports?  I've tried both and they disappear... using Access 2013.  Thank you for any insight. Read More...
Add a Reply
Vannak Hou     
4 years ago
at 26:05 -- you really confused.  some how I kept typing C:\photos\myfilename but it didn't take b/c I realized that the property is a Textbox not a OLEObject box.  It took me a while.  I was so confused for 30 minutes. Later I found out how to do it.
Add a Reply
VBA Link 
Vannak Hou     
4 years ago
Richard, i want to get start learning VBA; do you have anything like this? I have no knowledge in programming at all. Please advise.

Reply from Alex Hedley:

The advanced courses from 301 onwards cover VBA, they are Access 2003 but it hasn't changed much in that respect. Read More...
Add a Reply
pop up and modal Link 
Elizabeth R 
4 years ago
Nope. I did figure out a work around. I have multiple displays (3). I found a site that discussed issues that Access has with multiple display setups. They recommended that I set (form property) Auto Center = yes. That fixed the shift of the left shutter bar and the form doesn't disappear off screen (which is why I could see it, or access it.) Not sure if that is the correct work around because I am new and I don't know what auto center is supposed to do. Thanks. Elizabeth Read More...
Add a Reply
pop up and modal Link 
Elizabeth Roche 
4 years ago
(Video 6:21 on discussion about pop up and modal): I'm having 2 issues. 1st when I set "pop up" to yes for the customer extended form I cannot see the form and my system freezes up and I have to close access and re-open (form is not visible) and I hear a (Beep) when I try to navigate to anything. 2nd when I activate "Modal" for the customer extended form, my side shutter box (side shutter box open/close pane to the left of the programmer view) closes until I close the customer extended Thanks, Elizabeth Read More...
Add a Reply
concept of Debit and Credit Link 
Justin Bimbiga    
4 years ago
In accounting, there is a concept of Debit and Credit.  Which button from the Toolbox control do you use to capture those accounting figures?

Reply from Alex Hedley:

A text box can be used for data entry Read More...
Add a Reply

Show Older Comments...
View in Table Format

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