Ok. I am really starting to get into Microsoft Access VBA and am wondering
what book suggestions you all might have for developing Microsoft Access VBA.
I deal with what seems like a lot of fragmented VBA code all over the place.
And our Access Apps are pretty slick in terms of creating dynamic Excel
spreadsheets, generating e-mails, accessing Oracle thru ADO and the like.

So any suggestions you might have in terms of better organizing our VBA
Modules and any good web sites out there for accessing Sample Access Database
and applications would be GREATLY appreciated!

Thanks for your review and hopeful for some replies.

Thanks!

PSULionRP

There are tons of links to great Access websites. In addition to those in my
sig, you will find dozens at the other users listed there. These 2 are
especially good for links:

http://www.mvps.org/access

http://www.accessmvp.com

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"PSULionRP" <(E-Mail Removed)> wrote in message
news:007393E2-5870-4AF5-883D-(E-Mail Removed)...
> Ok. I am really starting to get into Microsoft Access VBA and am wondering
> what book suggestions you all might have for developing Microsoft Access
> VBA.
> I deal with what seems like a lot of fragmented VBA code all over the
> place.
> And our Access Apps are pretty slick in terms of creating dynamic Excel
> spreadsheets, generating e-mails, accessing Oracle thru ADO and the like.
>
> So any suggestions you might have in terms of better organizing our VBA
> Modules and any good web sites out there for accessing Sample Access
> Database
> and applications would be GREATLY appreciated!
>
> Thanks for your review and hopeful for some replies.
>
> Thanks!
>
> PSULionRP

On Tue, 5 Jan 2010 14:11:01 -0800, PSULionRP
<(E-Mail Removed)> wrote:

>Ok. I am really starting to get into Microsoft Access VBA and am wondering
>what book suggestions you all might have for developing Microsoft Access VBA.
>I deal with what seems like a lot of fragmented VBA code all over the place.
>And our Access Apps are pretty slick in terms of creating dynamic Excel
>spreadsheets, generating e-mails, accessing Oracle thru ADO and the like.
>
>So any suggestions you might have in terms of better organizing our VBA
>Modules and any good web sites out there for accessing Sample Access Database
>and applications would be GREATLY appreciated!
>
>Thanks for your review and hopeful for some replies.
>
>Thanks!
>
>PSULionRP

The best VBA reference (and far more) that I've ever seen is Getz and Litwin's
awesome _Access 2000 Developer's Handbook_, published by Sybex. It's huge and
it's not cheap, but I've gotten at least ten times its cost back in saved time
and improved applications.

See also the references in:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

--

John W. Vinson [MVP]