?
Solved

Excel MSAccess Tricks  2003 and code

Posted on 2012-03-29
5
Medium Priority
?
276 Views
Last Modified: 2012-04-09
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!
0
Comment
Question by:leezac
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 61

Assisted Solution

by:mbizup
mbizup earned 668 total points
ID: 37782560
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
0
 
LVL 58
ID: 37782657
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.
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 1332 total points
ID: 37783532
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
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 1332 total points
ID: 37783548
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37825112
Besides, there are almost 2 million hits for "MS Access Tips and Tricks" when doing a Google search...
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question