New user of Access 2000 and I need help.

[keats]

I know how to create a form in Access 2000. I am trying to use a Dropdown list to link all the info together. Does anyone know where I can go to learn more about how to use these features in Access 2000?

 

[thornmastr]

You ask a good question at the worst of times for me. I am in the process of boxing up my office as I will be moving in a few weeks. However, much to my wife’s chagrin, there are certain reference books that do not leave my desk until I disconnect my development system and hand carry that stuff to my car. These are the reference books I consider essential for good coding. Unfortunately, none of these deal with theory and/or history; something you might want to investigate as well. If you are interested in the entire library, post back in about a month.
Having said all that, my most basic reference list is, in order of use; and these books are ragged with use:

1 Access <your version> Developer’s Handbook. Litwin/Getz/gunderloy. Sybex boks
2 VBA Developer’s Handbook Getz/Gilbert. Sybexbooks
3 Microsoft Access Developer’s Guide to SQL Server Chipman/Baron. SAMS
4 SAMS Teach Yourself TRANSACT-SQL. Lowell Mauuer, et all. SAMS
5 Programming Visual Basic 6.0. Francesco Balena. Microsoft Programming Series
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[xcalibrecore]

If you are programming in Access 2000, a good manual to use (and I should know) is The Complete Reference: Access 2000 by Virginia Andersen. It can show you how to set it up, streamline it, maintain it, and even how to share it with other users through intranet/internet. It even has a small tutorial on SQL. I also like it because it has a reference section and even serves as a study guide for the MOUS exam for Access 2000.

Good luck.

 

[JPeters]

Or you could just do what I do. Pester, Bug, Bother, Call, annoy, whatever Robert with your problem until he helps you... joking .. only joking (innocent look).

Keats,
I'm a pretty decent programmer at VBA, I'm not rockstar style like oharab, thornmastr, RickSprague, etc... but I'm pretty snazzy at it, and I eventually get the database to do whatever I want it to via code - it just takes me a few minutes longer to figure it out.
Tek-tips can literally teach you how to code VBA. Browse faq's, do advanced searches for everything. Tek-Tips users LOVE writing code - they post it for kicks and giggles. So whatever you want done, someone's already done it, it's been posted here, and you can copy/paste it into your module and just edit/manipulate it until it fits your application perfectly. Also, if it hasn't been written someone will eventually write it for you ;-).

You can learn tons just by studying pre-written code and figuring out how it works. I own 0 books on VBA. I've taught myself all of it just by scrolling through lines of pre-written code, coffee in hand (sometimes I drink those mountain dew slushies you can get from the gas station ), and I love every second of it.

So there's another idea. Use the advanced search function of tek-tips. It works, I've never had a question unanswered.

-Josh ------------------
-JPeters
Got a helpful tip for Access Users? Check out and contribute to 'How to Keep Your Databases from becoming Overwhelming!'
thread181-293590
jpeters@guidemail.com
------------------