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 Advanced 2
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   4 years ago

Microsoft Access Advanced 2I actually released Access Advanced 2 a month ago, but I never got around to posting the full outline on the web site, so only people on the Waiting List knew about it. For the rest of you, here goes...

Access Advanced 2 continues our in-depth study of Macros and Event Programming. This is the 2nd class in the Access Advanced series. If you're serious about building quality databases with Access, and you want to learn how to automate your database with Macros and Events, which is a good pre-cursor to VBA programming then don't miss out on this course. Contents include:

- Open a Form to a New Record
- GoToRecord Command
- Adding Child Records Before Parent
- GoToControl, RefreshRecord Commands
- Quote / Invoice Toggle Button
- SetValue v. SetProperty Commands
- On Click Event, RunMacro Command
- Change Caption Property with Macro
- On Current Event
- Lots more

Click here for more information on Access Advanced 2, including a course outline, sample videos, and more. This course was recorded using Access 2016, but most of the topics covered are valid for all versions of Access from 2007 on. This class follows Advanced Level 1. The next class in the series is Access Advanced 3.

New Order button not working Upload Images   Link 
Keith Stanton 
4 months ago

Having trouble getting the New Order button to work from the Order List Form when the customer form is not open.  It'll open the order form and prepare it for a new order entry.  However, it is not pulling a Customer ID over to the order form.  There are orders in the Order List form, the order list forms record source is the OrderListQ which does contain the CustomerID.  I have double and triple checked my spelling.   Read More...
Keith Stanton
4 months ago

Kevin Robertson
4 months ago
The first Where Condition can be removed as there will be no CustomerID if you are on a new customer record. For the Order Form to get the current CustomerID, set the Default Value in the Property Sheet.
Add a Reply
Set Property in External Macro Upload Images   Link 
Abraham Breuer 
7 months ago
In lesson 3 you try to run the external Macro to add the Properties of the toggle button which seems that it doesn't work (you explain that it only works within an embedded macro) so then you change it into an unsafe Macro "set value" to Forms!orderF!QuotationToggle.Caption Read More...
Add a Reply
Relationship Upload Images   Link 
Dennis O 
4 years ago
I found my problem from the other question I just sent you about the convention. I notices that I had in the OrderDetailQ the criteria for convention (2016,2017, etc) was set at 2017 after removing the criteria, it works. Sorry about that. Read More...
Add a Reply
Relationship Upload Images   Link 
Dennis O 
4 years ago
Access Advance 2 #1 Add new order button
I have in my order form a sub-form that gets its record source from OrderDetailQ.The sub-form is where I list the products, qty, etc. (Add Product - button) Background- I run a convention that meets every year so each order is for that year 2016 now ordering 2017. When I bring up the order and enter the 2017 convention when I go back to my 2016 it shows everything from 2016 but no info from the sub-form (my products) How do I fix it? and when I do fix it, will I automatically recover the 2016 records that I already added the 2017 orders. (27 new 2017 records added so far). Read More...
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:

9/17/2021Overlapping Windows
9/10/2021Benefits of Access
9/10/2021Access on a Phone
9/5/2021Prevent Deletion
9/4/2021Booklet Template
9/4/2021Inspections Template
8/29/2021What is Microsoft Access?
8/27/2021Union Query

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 macros events gotorecord gotocontrol setvalue  Page Tag: whatsnew  PermaLink