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 T = Timeliness P = Politeness| User | Date | K | C | T | P | Comments |
|---|---|---|---|---|---|---|
| Marilyn | 10/29/09 | 10 | 10 | 10 | 10 | After troubleshooting and researching on my own ..... |
| Fred | 10/20/09 | 10 | 10 | 10 | 10 | Ok, short questions, got it. Thanks Anyway ..... |
| Richard | 09/23/09 | 10 | 10 | 10 | 10 | |
| TIAGO | 09/02/09 | 7 | 10 | 10 | 10 | |
| ralph | 08/31/09 | 10 | 10 | 10 | 10 | now THAT is a fast response. i ..... |
Recent Answers from Bob Heifler
2009-11-02 Help:
Code needs to be run by an event related to a form, or form control, or custom function you have entered in a query. Events start or trigger code to run. Your code will be either a subroutine or a function
2009-11-02 form fields:
The "#Name?" indicates that the form control needs the control source property to be set by you, which can be a table or query field name or an expression such as a calculation. Go to the form's design
2009-10-30 Paint Event procedure in Access 2007:
Julia, The Paint Event occurs when the section is redrawn (On the screen - not in printing). It is not fired when you are printing the report. It fires when you go to a Screen "Report View" to view your
2009-10-28 Expression Building in Access 2007:
Marilyn, You can nest an IIF inside another IIF: IIf([Total ORM] Between 0 And 20,"Low", IIf([Total ORM] Between 21 And 40,"Medium", IIf([Total ORM] Between 41 And 50,"High", "Very High"))) Or you
2009-10-28 Save value unbound textbox:
Sophie, On the AfterUpdate event of the combobox called "Categorypub", place this line of code: budgetcategory = Categorypub.Column(2) Glad to help, Bob Heifler MyAccessProgram.com DailyAccessTips
Answers by Expert:
©2009 About.com, a part of The New York Times Company. All rights reserved.