What is a good book to learn advanced programming

[Steve in MN]

I have the basics of VB skills and can design a descent DB using basic
coding, forms, queries, etc. But I want to learn about public call procedures
and more advanced programming. What book would you recommend. I need
examples in the book to see how to apply things rather than just an
explanation.
I know this site is awesome to look up and get questions answered, but i
figure i can always have the book for reference as well.

Thanks in advance.

 

[Daniel Pineault]

For a listing of good ressources check out

http://www.devhut.net/index.php?lang=en&id=0000000008
http://www.accessmvp.com/JConrad/accessjunkie/resources.html#Books
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[John W. Vinson]

I have the basics of VB skills and can design a descent DB using basic
coding, forms, queries, etc. But I want to learn about public call procedures
and more advanced programming. What book would you recommend. I need
examples in the book to see how to apply things rather than just an
explanation.
I know this site is awesome to look up and get questions answered, but i
figure i can always have the book for reference as well.

Thanks in advance.

The Access <version> Developer's Handbook by Getz, Litwin et al. is the gold
standard. I have not heard if they have a 2007 version yet, but the older
versions are still goldmines.

 

[pietlinden]

The Access <version> Developer's Handbook by Getz, Litwin et al. is the gold
standard. I have not heard if they have a 2007 version yet, but the older
versions are still goldmines.

I like the Access Cookbook by Ken Getz too... has some answers to
common problems... mostly covered in ADH, though.

 

[Klatuu]

Don't know where I heard it, but I heard that 2002 was the last of the
books. Too sad because I use it as my pillow.
(But if I use both volumes, I get a crick in my neck)

 

[Dale Fye]

Dave,

The key to the crick in the neck problem is to keep one volume at home and
take the other one to work.

--
Dale

email address is invalid
Please reply to newsgroup only.

Don't know where I heard it, but I heard that 2002 was the last of the
books. Too sad because I use it as my pillow.
(But if I use both volumes, I get a crick in my neck)

 

[Klatuu]

lol, it is two different topics, Desktop, and Enterprise
you need them both.

I hope they change their mind and do a 2007 version. Right now, I am using
Access 2007 Inside Out. It is good, but I really liked the style of the
ADH.

Dave,

The key to the crick in the neck problem is to keep one volume at home and
take the other one to work.

--
Dale

email address is invalid
Please reply to newsgroup only.

 

[Tony Toews [MVP]]

I hope they change their mind and do a 2007 version.

AFAIK the main authors of ADH have moved on from Access to other areas
such as .NET.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Steve in MN]

I just ordered the book! Thanks for the help.

btw, the other web sites listed are saved in my favorites for reference also.

 

[Klatuu]

Then I need to get their .NET book. If I stay where I am now, I will have
to get educated on C# and .NET pretty soon.

 

[Dale Fye]

I know it's two topics, I keep the Enterprise version at work and use the
Desktop version at home.

I really liked the ADH as well (have the 97 and 2002 editions). Have a
co-worker that bought 2007 Inside Out, but I don't care much for it . I've
also been doing a lot with Sharepoint and Access integration lately, so I've
been looking at the MOSS 2007 handbook, but I have yet to find a good
reference on integrating Access and Sharepoint, despite Microsofts claims
that they are tightly integrated. I've worked around the lack of
referential integrity (with a lot of extra coding), but am concerned about
the lack of record locking, and am working on solutions for that.

I would prefer to use Access with a SQL Server backend, but getting our IT
guys to let people through the firewall is almost impossible. On the other
hand, our MOSS site has digital sign-on, so it is quite secure, and since
I'm not storing any "sensitive" or "classified" information on the portal,
I've been given the go-ahead to work on this.

 

[Tony Toews [MVP]]

Then I need to get their .NET book. If I stay where I am now, I will have
to get educated on C# and .NET pretty soon.

I also think they've each moved to different areas too. I do not know
that they are collaborating any more. (Kind of like the Beatles
splitting up.)

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Klatuu]

Sad events, both.

I also think they've each moved to different areas too. I do not know
that they are collaborating any more. (Kind of like the Beatles
splitting up.)

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Klatuu]

So once you have it figured out, you write the book.
Put me down for a copy