DAO.Recordset

[Mal]

I have the following line of code in VB6:

Dim rst As DAO.Recordset

The compiler doesn't like the DAO prefix. Does anyone
know what could be the cause of this.

[Cor]

Hi Mal,
Did you set a reference to DAO?
Cor

[Herfried K. Wagner [MVP]]

* "Mal" <an*******@discussions.microsoft.com> scripsit:

I have the following line of code in VB6:

Dim rst As DAO.Recordset

The compiler doesn't like the DAO prefix. Does anyone
know what could be the cause of this.

This is a VB.NET group. Please turn to this group:

<news://news.microsoft.com/microsoft.public.vb.database.dao>

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>

[Cor]

Herfried,

<news://news.microsoft.com/microsoft.public.vb.database.dao>

Is that a dotnet group?

Cor

-----Original Message-----
Hi Mal,
Did you set a reference to DAO?
Cor

Thanks for you help Cor. I'm just learning VB. I am
taking this code from a resource book that is explaining
how to create a "dialog box to go to a specific record".
What am I missing to set the reference to DAO? This is the
code they give me:

Private Sub ShowRecord_Click()
'find the selected record, then close the dialog box

Dim rst As DAO.Recordset

'Store the recordset for teh Master Form
Set rst = Forms!Master.RecordsetClone

'Locate the record for the slected account number
rst.Findfirst" "AccountNumber=" " & List0

'Set the form's Bookmark property to move to the record
Forms!Master.Bookmark = rst.Bookmark

'Close the dialog box
DoCmd.Close acForm, "GoToRecordDialog"
End Su

[David Straker]

Mal,
Regardless of the right newsgroup ...

In your Project/References from the VB6 menu, you need to add a reference to
"Microsoft DAO 3.6 Object Library" (or 3.51 or 2.5 or whatever is registered
on you PC).

hth,
David Straker
"Cor" <no*@non.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

Herfried,

<news://news.microsoft.com/microsoft.public.vb.database.dao>

Is that a dotnet group?

Cor

[Cor]

Hi Mal,

I only know it in VB.net, if you need it in VB6 I thought it was almost the
same.

You open Project, add reference and with VB.net Com, then you search in the
list for the DAO object libary you need and select that..

Cor

[David Straker]

Hi Mal,

Some confusion in terminology here. The code sample you are following is VB.
But it's VB written to be used in Microsoft Access (most people call it VBA
just to make it clear). You have to be coding inside a Microsoft Access mdb
to be able to use your code. Microsoft Access automatically creates the
reference to DAO for you. You can't use your code sample from VB 6 without
some modification.

David Straker.

<an*******@discussions.microsoft.com> wrote in message
news:08****************************@phx.gbl...

-----Original Message-----
Hi Mal,
Did you set a reference to DAO?
Cor

Thanks for you help Cor. I'm just learning VB. I am
taking this code from a resource book that is explaining
how to create a "dialog box to go to a specific record".
What am I missing to set the reference to DAO? This is the
code they give me:

Private Sub ShowRecord_Click()
'find the selected record, then close the dialog box

Dim rst As DAO.Recordset

'Store the recordset for teh Master Form
Set rst = Forms!Master.RecordsetClone

'Locate the record for the slected account number
rst.Findfirst" "AccountNumber=" " & List0

'Set the form's Bookmark property to move to the record
Forms!Master.Bookmark = rst.Bookmark

'Close the dialog box
DoCmd.Close acForm, "GoToRecordDialog"
End Su

[Armin Zingler]

"Cor" <no*@non.com> schrieb

Herfried,

<news://news.microsoft.com/microsoft.public.vb.database.dao>

Is that a dotnet group?

No
--
Armin

[Herfried K. Wagner [MVP]]

* "Cor" <no*@non.com> scripsit:

I only know it in VB.net, if you need it in VB6 I thought it was almost the
same.

You open Project, add reference and with VB.net Com, then you search in the
list for the DAO object libary you need and select that..

It's pretty similar, but not topic of this group.

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>

[Herfried K. Wagner [MVP]]

* "Cor" <no*@non.com> scripsit:

<news://news.microsoft.com/microsoft.public.vb.database.dao>

Is that a dotnet group?

No, but the OP mentioned VB6 in his post.

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>

[Cor]

Herfried,
This time you win,
Cor

[Herfried K. Wagner [MVP]]

* "Armin Zingler" <az*******@freenet.de> scripsit:

<news://news.microsoft.com/microsoft.public.vb.database.dao>

Is that a dotnet group?

No

It's a dotnot group.

;-)

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>

[Herfried K. Wagner [MVP]]

* "Cor" <no*@non.com> scripsit:

This time you win,

:-)

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>

[Armin Zingler]

"Herfried K. Wagner [MVP]" <hi***************@gmx.at> schrieb

* "Armin Zingler" <az*******@freenet.de> scripsit:

<news://news.microsoft.com/microsoft.public.vb.database.dao>

Is that a dotnet group?

No

It's a dotnot group.

;-)

Is dort a dotnot oder is det net a dotnet.NET?

;)

--
Armin