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 |
|---|---|---|---|---|---|---|
| Rajesh Kinger | 11/18/09 | 10 | 10 | 10 | 10 | good thanX dude |
| 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 |
Recent Answers from Bob Heifler
2009-11-21 MS Access 2000-adding a new field to a form:
Tony, The recordsource of the form is probably a query that does not include these fields. Check out the form's record source property and see if it includes the two fields. Bob Heifler MyAccessProgram
2009-11-19 Coding in VBA:
Shermund, The form probably shows new records without the me.requery since it's probably bound to a table and gets automatically refreshed. I would store the last timer count in a variable at the end
2009-11-16 Mail merge Access 2007:
Mandy, In your query, add the tables that contain the lookup text and join on the IDs. This way the text will be available as a column in the query and the mail merge. I would use an outer join (Arrow
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
Answers by Expert:
©2009 About.com, a part of The New York Times Company. All rights reserved.