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
Thu 12/7
7:42
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
9:32
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
7:28
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
1:16
Back in the SaddleBack in the Saddle by Leroy D: How about a budget seminar
Wed 12/6
0:24
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
Tue 12/5
14:51
Access Open Other Programs SeminarThis 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?
Sat 12/2
14:20
Microsoft Access ForumSQL 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...
Thu 11/30
17:59
Back in the SaddleBack 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.
Thu 11/30
15:06
Back in the SaddleBack in the Saddle by Richard R: Seminar idea: a solution for pivot tables and charts since they've been removed from Access 2016
Thu 11/30
14:59
Back in the SaddleBack in the Saddle by Richard R: Seminar idea: updating user FRONT-END database files automatically on database start.
Wed 11/29
13:46
Microsoft Access ForumCombo 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...
Wed 11/29
2:32
Microsoft Excel ForumMove 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...
Tue 11/28
16:38
Microsoft Access ForumSQL Query Creation by Brandon J: Hello sir, I have the following statement: CREATE VIEW PartNumberQ (PartNumber) AS SELECT PartNumber FROM PartNumberT 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...
Tue 11/28
13:16
Microsoft Access ForumParking 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? more...
Tue 11/28
8:36
Microsoft Access ForumYes 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...
Mon 11/27
21:35
Microsoft Access ForumValidation rule Access by Phill I: Thanks Alex for the advise cheers Phill
Mon 11/27
13:07
Microsoft Access ForumCalendar 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? Regards Masih Ostad Reply from Alex Hedley: Just add 7 boxes instead of the full month, just get the data for the  more...
Mon 11/27
8:54
Microsoft Access ForumOpening 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...
Sun 11/26
9:48
Microsoft Access ForumSearch 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
Sat 11/25
19:32
Microsoft Access ForumAccess 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...

See More Comments...


See Complete Blog History

Change Layout


News      User Comments     History     Notify Me
 
 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Gift CDs
Contact
 
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