BOOK ON VB

[SEAN DI''''ANNO]

Two questions in one. First of all. when you pose a question one here, how
do you know when it is still active. I asked a question called LOOP within a
LOOP and already has numerous replies and is almost answered but not quite.

Also and more importantly. I live in the UK...Can any one reccoment a book
which will tach me Access code start to finish simply and easily. I.e. This
is the code for a loop, this is how it would be used etc. ?

 

[Vincent Johns]

Two questions in one. First of all. when you pose a question one here, how
do you know when it is still active. I asked a question called LOOP within a
LOOP and already has numerous replies and is almost answered but not quite.

In your mail server, you could filter all the messages on this newsgroup
by subject or name, but it's easier to sort by message threads (and
according to whether you've read a given message, assuming you're using
your own computer -- I expect it doesn't work on a public-access computer).

Also and more importantly. I live in the UK...Can any one reccoment a book
which will tach me Access code start to finish simply and easily. I.e. This
is the code for a loop, this is how it would be used etc. ?

Different people like different writing styles. Have you considered
visiting a public library? The subject has been around long enough that
there should be a few books from which to choose. The "... For Dummies"
series does a pretty good job of explaining a wide variety of subjects,
though I'm not sure if VBA is specifically addressed. _Access 2003
All-in-One Desk Reference for Dummies_, according to the advertising,
contains over 140 pages on VBA programming; see
http://www.amazon.com/gp/product/07...ding=UTF8&me=ATVPDKIKX0DER&no=283155&st=books

That Amazon link also mentions some other books that may interest you.
Happy hunting.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.

 

[mscertified]

In my experience you will need several books! VB is a big subject and few
books cover the whole subject. ADO for instance is a subject in itself. Any
book can teach the syntax of a language but teaching how to apply the
language to solve problems is a whiole different matter. Few books have
anything beyond trivial examples. You will learn as much by coding and trial
and error as from books. Also, don't expect it to be simple. I've been
working with VB for years and I'm still learning.

Dorian.

 

[Chris2]

Two questions in one. First of all. when you pose a question one here, how
do you know when it is still active. I asked a question called LOOP within a
LOOP and already has numerous replies and is almost answered but

not quite.

Sean,

My newsreader let's me know which messages of a thread have been
read, and which haven't. I can also mark conversations to highlight
them if I think I might want to locate it again more than a day or
two later. When I load new messages each day, I scroll to the top
of the list, and use "next unread message" to jump down through the
newly posted messages.

I used a threaded view so I can see the exact "tree" of responses.
Your LOOP thread has more than one branch.

Also and more importantly. I live in the UK...Can any one reccoment a book
which will tach me Access code start to finish simply and easily. I.e. This
is the code for a loop, this is how it would be used etc. ?

Books: General: Beginner

Database Design for Mere Mortals by Michael J. Hernandez

SQL Queries for Mere Mortals by Michael J. Hernandez, John L.
Viescas


Books: General: Intermediate/Advanced

Advanced SQL Programming, For Smarties, 3rd Edition, by Joe Celko

SQL Puzzles and Answers, by Joe Celko


Books: Access : Intermediate

Access Cookbook by Getz, Litwin, and Baron
(Compilation of solutions, listed by task-category)


Books: Access: Advanced

Building Microsoft Access Applications, by John L. Viescas

Access Database Design & Programming by Steven Roman (2nd or 3rd
Edition)

Access Developer's Handbook (for your version of Access)



Websites:

http://www.mvps.org/access
http://allenbrowne.com/
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#Top


Sincerely,

Chris O.