where to find method reference, errors

[ykfc]

I want to write VBA codes in MS Access 2000 environment to access data in SQL server. How do we find a complete method reference to use with DAO or ADO?

For example, though VB6 is able is provide a hint that a DApenrecordset method requires parameters in the order:
name as string, [type],[ options], [lockEdit], but where could I find the options allowed for [Options] or what values of lockEdits I could supply for this openrecord method?

Also, if a program runs with an error, I do not receive any help even I click the "help" button in response to a dialog box with run-time error xxxx. What do I miss out?

 

[SkipVought]

ykfc,

In the VB editor, set a reference to the object library in question via Tools/References.

Also at

http://www.microsoft.com,

search on keywords like openrecordset, ado, dao, visual basic.

Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}

 

[VBslammer]

They are enumerations, and you can view them in the object browser, or by typing the proper prefixes first, such as:
[tt]
DAO.RecordsetOptionEnum.dbFailOnError
DAO.RecordsetTypeEnum.dbOpenDynaset[/tt]

VBSlammer

"You just have to know which screws to turn." - Professor Bob

 

[PHV]

Search your local hard drives for dao*.chm;ado*.chm

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244