About > AllExperts  
Search for
  Main Menu Ask a Question Browse Past Answers Meet Top Experts Be an Expert Login (Experts Only)
About Us  ·  FAQ  ·  Tell Friends About Us  ·  Link To Us  ·  Free Encyclopedia  ·  Disclaimer  ·  Tech Support   
  You are here:  AllExperts > Computing/Technology > Business Software > Using MS Access

Expert Profile: Bob Heifler

Expertise:  ALL MICROSOFT ACCESS DESIGN AND PROGRAMMING QUESTIONS - Free 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

Publications:
Web Article published - See Microsoft Access Tips & Best Practices are available to you at my web site. Web Site Page of 'Microsoft Access Tips & Best Practices'

Education/Credentials:
UCLA GRAD, Member of Association of Database Developers

Past/Present Clients:
Bob Heifler's Clients

Ask a Question       View Past Answers       View Ratings            
What do you still hope to achieve/learn in this field?  Even more clever ways to use Microsoft Access.
What do you like about this subject?  I enjoy empowering users with this great software by showing them how to do it themselves.
Something interesting about this subject that others may not know:  Microsoft Access is the most used database on the planet, by volume of applications created with it.
Something controversial or provocative about this subject  Microsoft Access, with a few days of one on one mentoring, can create very able Access programmer who can program a small business application.
Average Ratings
Prestige Points: 3580
Knowledge   9.85   Best of the best
Clarity of Response   9.55   Best of the best
Timeliness   9.91   Best of the best
Politeness   9.90   Best of the best
Number Of Questions
(in Past 24 Hours)
1
Max Questions to be Asked
(in 24 Hour period)
3
Total Questions
(since joining AllExperts)
1144
Recent Reviews from Users
KnowlClarityTimePolitenessDate
1010101011/17/08
1010101011/17/08
1010101011/12/08
10/28/08
1010101010/21/08
User Comments
Thank you for your good help!
(Gaye on 11/12/08)
Thank you! I was trying to make this more difficult than it was.
(Sherri on 10/21/08)
View All Comments
Ask a Question       View Past Answers       View Ratings            

Recent Answers from Bob Heifler
2008-11-19  Problems in Splitting date and time Swaroopkumar, For time there might be none so the lenght is probably less than 10 therefore (len([RECEPD])<10) Time:iif(len([RECEPD])<10,[RECEPD],Mid([RECEPD],InStr([RECEPD]," ")+1)) Bob Heifler...
2008-11-19  Custom Primary Key Natalia, Keep it one to many 1 family to many students. FamilyID - autonumber in Family table and same field FamilyID is a foreign key field (just long integer) in the Student table. Bob Heifler MyAccessProgram...
2008-11-17  joint queries Use the UCase and Format functions: SELECT UCase([Ingredient]), [Unit], Format([cost], "$##,##0.00") FROM [Name of First Query] UNION SELECT UCase([Ingredient]), [Unit], Format([cost], "$##,##0.00")...
2008-11-17  joint queries You need a union query. Here is an example of the SQL that you will need to past in a SQL view of query (It can not be done in the regular view): SELECT [Ingredient], [Unit], [cost] FROM [Name of First...
2008-11-14  Selecting a value in a subform Try adding the word Form: Forms!Soldier_Information!History_Subform![Form]![Reason] = "1a;2a;3a;4a" Bob Heifler MyAccessProgram.com Find example files at: http://www.myaccessprogram.com/Download...
More Answers for "Using MS Access"


Advertise on This Site | User Agreement | Privacy Policy | Kids' Privacy Policy
Copyright  © 2008 All rights reserved. AllExperts is a property of About, Inc.
The About logo, About and About.com are registered trademarks of About, Inc.