Were do I find good info

  • Thread starter Thread starter Matt Reed
  • Start date Start date
M

Matt Reed

There is a lot of good information in these forums, but where can I find
information about how to actually use a docmd and a select statement?
Anyone recommend some good books, web sites, classes.
Maybe more like a reference document than a step by step build just this
sample database.

I have downloaded SQL Server Books Online from MS which helps some, but when
I do a search on docmd I get "No Topics" found.

What are some good references materials?

Thanks. Maybe if I get the reference material I could ask better or few
questions here.

Matt
 
You can't use DoCmd and Select in any way that I'm aware of. You can use
DoCmd.RunSQL with Action queries (Delete, Update, Insert Into), but not with
Select. You need to open a recordset and play with the recordset to use
Select queries programmatically.
 
---------- "Matt Reed said:
There is a lot of good information in these forums, but where can I find
information about how to actually use a docmd and a select statement?
Anyone recommend some good books, web sites, classes.
Maybe more like a reference document than a step by step build just this
sample database.
Click to expand...

Matt,

did you try the Access & VBA Help?

If you have A2K or AXP, best bet is to type in the VBE in some module
"DoCmd" resp. "Select case", then put the cursor in the resp. word and
hit F1.

Best regards
Emilia

Emilia Maxim
PC-SoftwareService, Stuttgart
http://www.maxim-software-service.de
 
Matt Reed said:
There is a lot of good information in these forums, but where can I
find information about how to actually use a docmd and a select
statement? Anyone recommend some good books, web sites, classes.
Maybe more like a reference document than a step by step build just
this sample database.

I have downloaded SQL Server Books Online from MS which helps some,
but when I do a search on docmd I get "No Topics" found.

What are some good references materials?

Thanks. Maybe if I get the reference material I could ask better or
few questions here.
Click to expand...

SQL Server Books Online will be of very limited help to you working with
Access, because SQL Server and Access are completely different products.
Even the dialects of SQL (Structured Query Language) that they use are
substantially different, though they have much "standard SQL" in common.

I'd suggest that you start with the Access help files. Since Access
2000, they haven't been much good for looking up some particular bit of
information, but if you start on the Contents tab and just read through
the topics you can learn a lot. Since it sounds like you're interested
in programming techniques, you'll want to pay special attention to the
sections on "Programming in Access" and "Programming in Visual Basic".
There's a *lot* of information in there, though it may not be organized
in the most tutorial fashion.

Also, there are quite a few good books out there on Access. If you use
Google Groups to search past newsgroup posting in the
microsoft.public.access.* hierarchy, you'll find lots of suggestions.
 
Back
Top