|Back in the Saddle||Back 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...|
|Microsoft Access Forum||Barcoding 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? |
|Microsoft Access Forum||Convention 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...|
|Microsoft PowerPoint Forum||Live 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...|
|Back in the Saddle||Back 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...|
|Access Calendar Seminar||I 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...|
|Microsoft Access Forum||Yes 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]
This resulted in a run time error '2465' access cannot more...|
|Microsoft Access Forum||Changing 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...|
|Microsoft Access Forum||Print 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...|
|Microsoft Access Forum||Work 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...|
|Issues With Customer Service Emails||Issues 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.|
|Microsoft Access Forum||Access 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!|
|Microsoft Access Forum||SQL 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" |
|Microsoft Access Forum||Parking 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? |
|Microsoft Access Forum||Indexing 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...|
|Back in the Saddle||Back 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...|
|Asset Management Seminar Part 1||Part 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! |
|Microsoft Access Forum||Missing 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...|
|Back in the Saddle||Back in the Saddle by Leroy D: How about a budget seminar|
|Back in the Saddle||Back 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 |