You are here:
Using MS Access/Expert Profile
Expertise
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.
Experience in the area
I am the president of AccessLearningZone.com and 599CD.com. I specialize in Microsoft Access Tutorials. I have been teaching Access in the classroom since 1994, and online since 2002.
Education/Credentials
I am a self-taught Access expert. I have been building databases for clients since the early 90s. You can see a sample of my Access Tutorials on my web site at 599CD.com
Average Ratings
Recent Reviews from Users
K = Knowledgeability C = Clarity of Response T = Timeliness P = Politeness| User | Date | K | C | T | P | Comments |
|---|---|---|---|---|---|---|
| Adam | 10/21/09 | 10 | 10 | 10 | 10 | Thanks, got this working now. |
| Rich | 10/20/09 | 10 | 10 | 10 | 10 | He was quick to respond and gave ..... |
| Raz | 10/20/09 | 10 | 10 | 10 | 10 | |
| Catherine | 10/19/09 | 10 | 10 | 10 | 10 | Your advice helped me trouble shoot to ..... |
| Dendalee | 10/15/09 | 10 | 10 | 10 | 10 | Thank you for being so helpful and ..... |
Recent Answers from Richard Rost
2009-11-02 embedding and making PDF files searchable:
My recommendation for any database like this is always to save the scanned images as FILES in a folder that you can LINK to in your database. Access doesn't do well when you scan large images into it.
2009-11-01 automated email report sending via a button:
Yes, it's possible. You can use the DoCmd.SendObject command. I cover this in detail in my Access 329 tutorial: http://www.599cd.com/site/courselist/access/access329/?key=AllExperts Let me know
2009-10-30 Drop Down List/Look Up Table Question:
If I understand you correctly, you want to select a value in one combo box and have the values in the second combo box change based on the first value selected. If so, this tutorial should answer your
2009-10-29 embedding and making PDF files searchable:
If you're going to take the time to scan these in, does your scanning software have an OCR feature? If so, can you just scan this data right to text and store that in your database? That would be the BEST
2009-10-28 Save value unbound textbox:
Is the combobox bound? That should be what you use to save the value in the table. Otherwise, you'd have to use an AfterUpdate event for the combobox to save the value, and that's going to involve
Answers by Expert:
©2009 About.com, a part of The New York Times Company. All rights reserved.