If you can't explain it simply,
you don't understand it well enough.
-Albert Einstein
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  

News      User Comments     History     Notify Me
Wed 12/20
Back in the SaddleBack in the Saddle by Brandon J: I d like to learn some advanced charting features. For example, manipulating chart formatting and such through VBA. I use Access charts a lot and I d like to learn as much as possible about their controls and features. Reply from Alex Hedley: Have you taken Access  more...
Wed 12/20
Microsoft Access ForumBarcoding in Access by Kevin G: Is there a way access can create and track inventory for parts and systems Reply from Alex Hedley: There is a barcode seminar on the Waiting List. Barcode equipment is just a way of passing data into a text field, instead of a keyboard. What features are you wanting?
Mon 12/18
Microsoft Access ForumConvention by Dennis O: I am the registration director for a convention and the data entered is for that year. The convention is in November. I built the program for the 2016 convention and everything worked perfectly. These problems happened when I was preparing for the 2017 convention and I hope to fix them for the 2018 convention. The problem that I want to fix this time is the  more...
Mon 12/18
Microsoft PowerPoint ForumLive Excel data in presentation by Gioia: Greetings! We have a PowerPoint presentation that runs off a TV monitor that serves as an info "kiosk" for our warehouse personnel. I've created a nice presentation that runs on a continuous loop and I update slides frequently. Currently we embedded an excel slide that is updated when the presentation is opened and the  more...
Thu 12/14
Back in the SaddleBack in the Saddle by Brad J: Richard, welcome back and I hope you are doing well. Regarding an Access seminar. What would be very helpful would be an indepth discussion of programmatically traversing an Access database. For example, selecting a record, updating it, and then moving to the next logical record based on the current order. I noticed a number of for doing this, but  more...
Thu 12/14
Access Calendar SeminarI am having problems with the date calendar by Jimmm Manuel: I am having problems with the date calendar...There is no date calendar in Access 2016......It won't run the little script to set the first Monday Reply from Alex Hedley: There are loads of comments on this post about the issue, and even an more...
Thu 12/14
Microsoft Access ForumYes No field auto filled by Karen R: I inserted commas because I thought they meant "then" as in the IFF statements. Anyway, I followed the advice and tried the new lines like this: Private Sub WorkTypeIDCombo_AfterUpdate() ServiceSheet = 1 WorkTypeID = [Safety Check] WorkTypeID = [Vehicle Service] End Sub This resulted in a run time error '2465' access cannot  more...
Mon 12/11
Microsoft Access ForumChanging Hotel Prices by Stephen B: I've now completed the Access Expert series and my database is coming along nicely but I need your help with a little problem. I organise holidays for groups. Part of this involves making hotel reservations. I store the information for each hotel in AccommodationT. The reservation details are in a separate table, ReservationT. Each year  more...
Fri 12/8
Microsoft Access ForumPrint Website from Access by John H: I am very new to vba, and have not been able to figure out how to print a website from Access or how to save a website as a pdf to a file on my hard drive. Following are my failed attempts to do so. What do I need to do to get either method below to work? Also, there is an issue of pausing Access to allow time for the webpage to  more...
Thu 12/7
Microsoft Access ForumWork Order seminar Question by Shallena A: As I am going through the WorkOrder Seminar I have had no issues adapting things to my situation but I am looking for some advice before I make a total mess of things. My business makes personalized items. We do work for both businesses and the general public. I am trying to figure out how to set up the order form so that it  more...
Thu 12/7
Issues With Customer Service EmailsIssues With Customer Service Emails by William E: Richard Just wanted to say how fortunate I feel to have tripped upon this course. I couldn't imagine anything more perfect.
Thu 12/7
Microsoft Access ForumAccess Pivot Tables by Brandon J: Oh yeah. Those are really good ideas! I was over complicating things and didn t even think of that! Thank you, sir!
Thu 12/7
Microsoft Access ForumSQL Query Creation by Brandon J: Yes sir, I have taken all three SQL seminars. They re wonderful. Will this method work for all query types? Reply from Alex Hedley: Which method? The "CurrentDB.CreateQueryDef"
Thu 12/7
Microsoft Access ForumParking Citations by Carl W: Ive done all the beginners courses. Just Finishing the Expert 1. However, the database wont allow me to change or add a primary key. Reply from Alex Hedley: What error do you get?
Thu 12/7
Microsoft Access ForumIndexing by Marianne: Still learning. I can't seem to wrap my head around this indexing thing. I have an Interaction table where I want to keep notes for every interaction with a customer. My Customer table includes a SSN field. I want to be able to add multiple Interaction entries under one Customer ID, but that would create multiple SSN's. When I try to enter in a new  more...
Thu 12/7
Back in the SaddleBack in the Saddle by Alex Hedley: From the Production Schedule 1. Distributing Your Application (to people who don't have Access, use Runtime) 2. Barcode & Inventory (printing and scanning barcodes, inventory control) 3. SQL Server (using Access with SQL Server) 4. Personal Finance Seminar  more...
Wed 12/6
Asset Management Seminar Part 1Part 2 by AmericanFarmer: Part 1 was done in 2015. Its now almost 2018. Will there be a part 2? Reply from Alex Hedley: Back in the Saddle is asking for Seminar suggestions, cast your vote there!
Wed 12/6
Microsoft Access ForumMissing Libraries by Joya: Greetings! Our office will be migrating to Office 365 next year, until then we have users on both Office 2013 and 2016. Is there a way to load both 15.0 & 16.0 Office, Excel and Outlook reference libraries so I don't have to keep going in and fixing the MISSING references every time a person with Office 2016 opens the database? Reply from Alex  more...
Wed 12/6
Back in the SaddleBack in the Saddle by Leroy D: How about a budget seminar
Wed 12/6
Back in the SaddleBack in the Saddle by satish n: Please Complete Asset Management Seminar Reply from Alex Hedley: What items did you want covered? - Asset Management Seminar - Student Interaction

See More Comments...

See Complete Blog History

Change Layout

News      User Comments     History     Notify Me

Visual Basicindex
Account Login
Online Theater
Lost Password
Free Upgrades
Insider Circle
Student Databases
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Live Chat
Customer Support
WalkThru Tutorials
Consulting Services
About Us
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Gift CDs
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP