Excel MSAccess Tricks  2003 and code

leezac
leezac used Ask the Experts™
on
I am looking for code examples from experts where the code has greatly helped a programming problem.  A particular trick that you can share that would be helpful with MSAccess or Excel.  Code that would be helpful.  Example and sample database appreciated.  Thank you!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
mbizupNerd
Most Valuable Expert 2012
Top Expert 2013
Commented:
Hav you browsed through EE Articles in the Access and Excel areas?

There are some great tips/tricks out there written by EE Experts.

I've got my own article with a sample included:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_19-BOM-parts-list-expansion.html

But there are many, many more out there.  For Access & Excel, explained in easy terms (with samples in many cases), I highly recommend looking at articles by TechMommy, harfang, matthewspatrick, JimDettman...


And this is a neat sample and solution provided by an "Asker" (I just shared this link in another question a couple of minutes ago):
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27512608.html
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
That's a firaly wide open question; I can think of lot's of things to do that would fill a small book.

  Did you have a specific area in mind or a specific problem?

Jim.
MIS Liason
Most Valuable Expert 2012
Commented:
I'm with Jim...

In addition, some people simply regard things that the recently learned as "Tricks or Tips", but theses things may have existed all along.

ex. instead of doing this:
txtCustID.ForeColor=255
(This syntax requires you to spell the name of the control correctly)

...you can use the ME. keyword and let intellisense "autoList" the members.
Me.txtCustID.ForeColor=255

So again, you need to be specific...


The best "Tip" I can think of is to not worry about VBA code if you do not have a solid foundation in database design.
Many members here try to use Automation to fix poor designs...

Another tip?:
Post your code
*Describe in detail what is doing, and why*
Ask Experts for advice on streamlining it.

And no matter how prestigious the expert, no matter what their ranking, ... *Always* ask for an explanation of any code you do not understand.
See the Rule #8  here:
http://www.accessmvp.com/djsteele/AccessTenCommandments.html
"Don't copy and paste other people's code without at least attempting to understand what it does. "

JeffCoachman
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012
Commented:
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
Besides, there are almost 2 million hits for "MS Access Tips and Tricks" when doing a Google search...

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial