You are here:

Using MS Access/Experts

Expert	Average Ratings	Expertise
Richard Rost U.S. Available View Profile Ask A Question View Past Answers	Knowledgeability 9.82 Clarity of Response 9.71 Timeliness 9.13 Politeness 9.91 Total Questions 3507	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 View Profile Ask A Question View Past Answers	Knowledgeability 9.85 Clarity of Response 9.64 Timeliness 9.93 Politeness 9.92 Total Questions 2043	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 View Profile Ask A Question View Past Answers	Knowledgeability 9.84 Clarity of Response 9.87 Timeliness 9.59 Politeness 9.95 Total Questions 675	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 View Profile Ask A Question View Past Answers	Knowledgeability 9.86 Clarity of Response 9.76 Timeliness 9.95 Politeness 9.93 Total Questions 15567	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 View Profile View Past Answers	Knowledgeability 9.84 Clarity of Response 9.81 Timeliness 9.81 Politeness 9.96 Total Questions 454	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 View Profile View Past Answers	Knowledgeability 10.0 Clarity of Response 9.47 Timeliness 10.0 Politeness 9.76 Total Questions 284	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

Volunteer to be an expert in this category

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