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  
Home > Courses > Access > Developer > D15 > D15 Lessons < D14 Lessons | D16 Lessons >
Access Developer 15 Lessons

Welcome to Microsoft Access Developer 15. Total running time is 1 hour, 45 minutes

 S  M  L  XL  FS  |  Slo  Reg  Fast  2x  Buy Now


Database Files



Please feel free to post your questions or comments below. If you have a questions about a specific lesson, please specify the lesson number and the time index in the lesson where the issue occurs. Thank you!


Transfer Button Upload Images   Link 
Joe Hood 
54 days ago
Hello Everyone,
I apologize in advance for the length of this question. I completed this lesson. Using the Customer template Before D15 L01. I was able to follow along, understand what was being done, and easily make everything work perfectly. However when I built the same form using the exact same techniques, (VBA Code), using the PC Resale database that I have building since Beginner level 1. It simply will not work. When I select multiple items and click the transfer button it only moves the first item selected. When I use the status box to see what has been selected, it does show multiple items have in fact been selected. Any idea what I am doing incorrectly its driving me a little crazy? Thanks Joe
Add a Reply
Lesson 1 Dev15 Upload Images   Link 
Abraham Breuer 
2 months ago
Passing a Control as a Parameter is explained very quickly and I can't understand it even I listened to it many times do you cover this method in future lessons?
thank you
Adam Schwanz
2 months ago
Passing a control is awesome. Its used in a lot of the more advanced stuff. A big advantage of it is you don't have to rewrite long code 50 times if you have a lot of buttons using it. What dont you understand? Do you have any questions about it?

What your doing in the button is saying i want to run the function and then i want it to replace the value with what im sending it wherever its at.

ChangeCustomerStatus is saying i want to use the function and then im sending ActiveCustomerList for the C value. Now if you go up to the function with all the code. Anywhere it says C it will now act as if C says ActiveCustomerList.
Abraham Breuer
2 months ago
Thanks, adam
can you explain what means ' I'm sending ActiveCustomerList for the c value '
Add a Reply
Value instead of true false Upload Images   Link 
Austin Ritner 
6 months ago
A little different for my database. currently, i have each unit listed as either "in service", "busy", or "out of service".

can I do an if/then statement based on that value?

if it says "in service" and i click the button, would it change the value to "out of service"
Alex Hedley
5 months ago
if / else if / else, switch, there's a few options
Add a Reply
Status Box Reference Upload Images   Link 
James Gray 
9 months ago

You showed us the status box method way back in Access 328, lesson 4 on making purchase orders.  I use it all the time as well so I can monitor variable values and what is going on with things.  Great tool.
Add a Reply

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:

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/22/2021Buy Access
7/21/202164-Bit Access
7/18/2021Splash Screen

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 developer 15 lessons  PermaLink