You are here:

Using MS Access/Experts

ExpertAverage RatingsExpertise

Richard Rost

U.S.
Available
I am happy to answer any kinds of questions about Microsoft Access - from basic table design to advanced VBA programming. Also, please feel free to check the Access Tips & Tricks section of my web site.

Bob Heifler

U.S.
Available
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.

Julie Misson

Available
My area of expertise is Microsoft Access 2000. I have been building microsoft databases for the past three years. I would be competent in answering questions from novice Access 2000 users. I have some experience SQL and normalisation.

Scottgem

Available
I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.

Mark Kaphle

U.S.
On Vacation
returns 02/14/2010
I can answer most questions on database design using Access. I can help with VBA too. I can integrate engineering and business needs in the database design.

Bob Alston

U.S.
On Vacation
returns 02/14/2010
I can answer general Access questions and also specific ones about Replication. I am not a good person to ask Access 2007 specific questions. For free online Access tutorials, look here: http://webpages.charter.net/bobalston/AccessDB.htm#Free_Access_Online_Tutorials

Recent Answers

2010-02-08 SendMail Macro:

Kevin, There is a bit more information I need on your Access database design. Since your question is a bit too complex for a simple short answer on AllExperts.com and requires a little clarification on

2010-02-08 Combo Box on Repor:

You include the linked table in your query and pull the value from there. For example; you have a field in your query that is a department code. But you want to display the department name. So you add

2010-02-08 VBA if:

Try: If NOT IsNull(Me.Sub_mon.Form.Hours) Then Also you need to change some of your field and control names. Hours and Date are reserved words in Access and shouldn't be used for object names.

2010-02-08 Date/Time data entry:

The DateAdd function can be used to add second, minutes or hours to a date/time value. You don't have to extract anything. For example, if you want to round up and add 4 hours you could use: DateAdd("n"

2010-02-08 Linking forms based on 2 criteria:

OK, I'm not sure what is happening but I'm getting funny characters. This is what I'm seeing: stLinkCriteria = "[ECR_NUMBER] = " %26 ECR_NUMBER %26 " AND [ECRIssue] = " %26 ECRIssue I'm wondering

All Answers


Answers by Expert:


Ask Experts

Volunteer


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