Compliments For Those Who Help

[Guest]

This is a general compliment to each and every one of you that reads and
responds to the pleas and inquiries posted by so many of us that cannot find
help anywhere else.

I've been trying to get to an Access specific Visual Basic class for months
and either don't have enough (3) folks to sign up or no $ in the budget. Now
I'm told maybe next year. It is a 3 day class and would SO help me take the
next step.

Rather than bemoan my state of affairs, my true purpose here is to thank all
of you for any and all comments and advice. For taking your own valuable
time to help others. Please know that you are appreciated.

Thank you each and every time,

Bonnie

 

[M.L. Sco Scofield]

Bonnie,

Where are you located?

I teach Access specific VBA classes and I don't have a minimum.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Vice President www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

 

[Guest]

I must add my thanks as well. The folks of these message boards have been a
great help to me. I would probably be confused, stuck, and majorly frustrated
with Access if it were not for these folks. In these boards, it seems you
almost always get a respsonse, and it is almost always right away. I only
wish I could answer people's questions too. I have been lucky enough to be
able to help out a few times, but I'm still not expert enough to help with a
lot of the questions. Maybe someday.

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy

 

[Guest]

Cincinnati, Ohio

(crossing my fingers here, stranger things have happened XXXXX :|)

 

[Van T. Dinh]

I am aware that everyone has a different learning style but I find the most
cost-efficent method is to pick a suitable book (not too advanced) and then
read and try from the beginning to the end of the book. It may take more
time than a training course but I find I remember much more in details. I
find training courses glossing through the materials in broad concepts
without presenting relevant details and I end up reading books anyway.

Perhaps you should try reading an Access book and see if it suits your
learning style.

 

[Guest]

Good morning Mr. Dinh,

Thank you for your response. I have enjoyed your help and direction many
times over the last few years. You are one that I hoped to thank with my
original post.

I have learned Access from books and what classes I could find. While
reading/studying does impart more lasting memory of details and provide
softly glowing lamps for later rediscovery, I'm afraid the newer concepts
(functions, conditions, loops, ifs, etc.) just don't explain at all let alone
not well. I cannot relate what I need to the Northwind DB and I had zero
understanding of code and procedures. Now I know enough to be dangerous as
well as be aware that I have landed on a small island that belongs to a huge
continent. A wonderful co-worker just brought in Access VBA Programming for
Dummies and I plan to read it cover to cover.

There is just such a leap from 'creating' tables, queries, forms and reports
to making them jump through hoops for you and I am SO anxious to learn.

Thank you again for giving of yourself and your time in these newsgroups.

 

[Van T. Dinh]

Have you tried Roger Jennings' Using Access {your version}?

Roger Jennings uses NorthWind as the main example in the book explaining
things in NorthWind and then developing extra "features" for NorthWind. The
VBA code section is light (there are only 5 chapters on VBA in the A97
version I used) but the explanations are fairly clear and precise,
especially about Recordsets which is probably the most useful object in VBA.

 

[M.L. Sco Scofield]

Cincinnati is not too far from Denver. I have people fly here from much
farther away to take my Access classes.

Let me add my suggestions for a book. I like "Beginning Access 2002 VBA" by
Robert Smith, et al from Wrox. (I do not like the 2003 version because it
was rewritten by a different author.) Except for a few minor things, VBA is
virtually the same in Access 2000, 2002, and 2003.

I also like "Access 2003 VBA Programmer's Reference" by Patricia Cardoza, et
al from Wrox. Even though they call it a reference, it does have some good
tutorials.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Vice President www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

 

[Guest]

I'll check it out. Thanks for the advice.
--
Bonnie

Have you tried Roger Jennings' Using Access {your version}?

Roger Jennings uses NorthWind as the main example in the book explaining
things in NorthWind and then developing extra "features" for NorthWind. The
VBA code section is light (there are only 5 chapters on VBA in the A97
version I used) but the explanations are fairly clear and precise,
especially about Recordsets which is probably the most useful object in VBA.

 

[Guest]

I'm going to check out the books you mentioned. Thanks for the advice!!!

 

[Jeff Conrad]

I'll second Sco's recommendation on the "Access 2003 VBA Programmer's Reference" book:

http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764559036.html

Very good book to have.
--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message: