You are here:
Using MS Access/Expert Profile
Expertise
ALL MICROSOFT ACCESS DESIGN AND PROGRAMMING
QUESTIONS
Free Microsoft Access Tutorial Videos are available to you at
my web site. Fifteen years of Microsoft Access experience allows me to
answer most of your questions. Common question example files available
here.
Experience in the area
Microsoft Access programming since 1994. Support for all versions.
Publications
My Microsoft Access articles are published at:DailyAccessTips.com
Education/Credentials
UCLA GRAD, Member of Association of Database Developers
Awards and Honors
AccessToExcel.com has won several shareware awards for assisting analysts in moving data from MS Access to Excel.
Past/Present Clients
See some of my past clients here.
What do you like about this subject?
I enjoy empowering the users of this great database software.
What do you still hope to achieve/learn in this field?
Even more clever ways to use Microsoft Access.
Something interesting about this subject that others may not know:
Microsoft Access is the most used database on the planet, based on the volume of applications created with it.
Something controversial or provocative about this subject
Microsoft Access one on one help, within a few days of mentoring, can create a very able Access programmer who can program a small business application. Find out more at:MyAccessProgram.com/contact.html
Average Ratings
Recent Reviews from Users
K = Knowledgeability C = Clarity of Response P = Politeness| User | Date | K | C | P | Comments |
|---|---|---|---|---|---|
| Alex | 01/05/12 | 10 | 10 | 10 | Thats great cheers Bob! |
| John | 11/27/11 | 10 | 10 | 10 | What a rapid response! |
| Lesia | 10/21/11 | 10 | 10 | 10 | Bob, thank you so much! It worked ..... |
| sara | 09/03/11 | 10 | 10 | 10 | Thanks!! |
| Garo | 06/12/11 | 10 | 9 | 10 |
Recent Answers from Bob Heifler
2012-01-05 Auto update date field:
You will want to put this code on me on current event of the form. This event is triggered every time you go to a different record. The else portion should be changed to 2 double quotes Rather than not
2011-11-15 MS Access to track Inmates:
Eric, This is not a question that I can quickly answer in this email because it requires some steps that you may not be familiar with and some skills that you may not have acquired yet. It would be
2011-10-14 MS ACCESS form update/refresh:
Here is how you keep the current form records refreshed with the latest data and showing the latest records. The recordsource property of the form controls the data you see on the form. The code required
2011-10-13 Access 2007:
Mike Place the cursor in the bottom control. Select conditional formatting on the ribbon. You'll only need to add one condition. He lacked expression for the type of condition formula. Place the name
2011-10-11 Block Deletion of Used Records:
Keith I never tried linking to tables During a delete query, However you could add a sealed call flaged for deletion. You then could use an update query to flag true all the records that needed to leading
Answers by Expert:
©2012 About.com, a part of The New York Times Company. All rights reserved.