Using MS Access/Expert Profile


Ask A Question

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

Read More Comments

    K = Knowledgeability    C = Clarity of Response    T = Timeliness    P = Politeness
UserDateKCTPComments
Marilyn10/29/0910101010After troubleshooting and researching on my own .....
Fred10/20/0910101010Ok, short questions, got it. Thanks Anyway .....
Richard09/23/0910101010 
TIAGO09/02/09101010 
ralph08/31/0910101010now 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

 

Ask A Question

©2009 About.com, a part of The New York Times Company. All rights reserved.