|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 |
|Access Open Other Programs Seminar||This ShellExec method is not working on my end for by Juan Diaz: This ShellExec method is not working on my end for pdf files. Reply from Alex Hedley: If you double click on a PDF what app opens?
If you check in Control Panel what is the default program to open PDFs? |
|Microsoft Access Forum||SQL Select Statement with Access VBA by Brad J: I'm attempting a simple SQL select query and would like to initiate it by running the VBA DoCmd.RunSQL command, but after trying a variety of different approaches, it appears that VBA SQL does not support the Select command. Is this the case? Reply from Alex Hedley: RunSQL expects an ACTION to be more...|
|Back in the Saddle||Back in the Saddle by Brandon J: I am all in favor of this! It would be nice to learn how to use crosstab queries in more advanced ways and learn how to build reports completely in VBA so a crosstab query can be used as the reports record source and be updateable.|
|Back in the Saddle||Back in the Saddle by Richard R: Seminar idea: a solution for pivot tables and charts since they've been removed from Access 2016
|Back in the Saddle||Back in the Saddle by Richard R: Seminar idea: updating user FRONT-END database files automatically on database start.|
|Microsoft Access Forum||Combo Box Updating One Record of Source Table by Jackie M: The field is unbound. The selection in the combo box populates 4 additional fields on the form from a single table. I am setting up a customer form to select a customer to be used when the contact button is selected. Much like the example provided in the tutorial. I have stepped through the more...|
|Microsoft Excel Forum||Move Row by Toine v: A have a schedule for my employs and when this work is done a put a value in een cel saying it is done. Then a want to move the whole row to a second sheet. All the others rows under this one will move up one row. Can this be done? Reply from Alex Hedley: How about trying this with the Macro Recorder, then you can look at what code is produced and amend more...|
|Microsoft Access Forum||SQL Query Creation by Brandon J: Hello sir,
I have the following statement:
CREATE VIEW PartNumberQ (PartNumber)
AS SELECT PartNumber
I keep getting the 3290 error when I try to run this code. Is there something wrong with this syntax? I can use CREATE TABLE without issue.
Thank you, sir.
Reply from Alex Hedley: Access doesn't more...|
|Microsoft Access Forum||Parking Citations by Carl W: I having a hard time building a data base that will house Parking citations. I want to be able to see how many citations each employee has. Can you point me in the right direction. Reply from Alex Hedley: Which courses have you taken?
What have your tried so far?
|Microsoft Access Forum||Yes No field auto filled by Karen R: I've listened to the free tutorial for AfterUpdate and it's really helpful. It doesn't cover how to make it work for a Yes/No check box though. My combo box is WorkTypeID and when Safety Check or Vehicle Service are selected, I want the Yes/No box for ServiceSheet to be automatically ticked. In after update for WorkTypeID and more...|
|Microsoft Access Forum||Validation rule Access by Phill I: Thanks Alex for the advise cheers Phill|
|Microsoft Access Forum||Calendar by Masih O: Hi!
I want to make a report with only seven list boxes to display 7 days of the week. Do I have to change the codes or is it enough to make a weekly form first and then a report from that? Do you have any addendum to the weekly calendar?
Masih Ostad Reply from Alex Hedley: Just add 7 boxes instead of the full month, just get the data for the more...|
|Microsoft Access Forum||Opening a Blank Record by Karen Rolstone: Hi Alex,
Can you kindly elaborate. I already use on open as a default for my Main Menu and don't want to alter that. I've looked online and just can't work out what to do. Many thanks.
Reply from Alex Hedley: If it's on open it will always do it, swap that code to the buttons on the other forms you wish to open a new more...|
|Microsoft Access Forum||Search not exactly but close by Otto: I understand that this works for characters. But how could I search for numbers that are close but not exact? Reply from Alex Hedley: Do you have examples |
|Microsoft Access Forum||Access Pivot Tables by Brandon J: I believe what you're saying is use either a table or query to get the necessary data from Access, then export that to Excel and have it perform the Pivot Table analysis? I'm trying to produce a scrap part matrix for a manufacturing facility. I tried using a crosstab query in Access, which works fairly well, but it does not give totals on more...|