|
 |
access thread: Confused IF this is really ADO
Message #1 by "e n z o" <enzaux@y...> on Tue, 26 Feb 2002 23:44:44 +0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_03D7_01C1BF1F.9126E020
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi!! Below is a sample of my code on how I make recordset via coding:
dim db as Database
dim rs as Recordset
dim strSQL as string
set db =3D Currentdb()
strSQL =3D "SELECT * FROM tblsample"
set rs =3D db.OpenRecordset (strSQL)
.
.
.
I was wondering if this method is an ADO sample? If not what type of
method is this.... DAO? or anything else?
And also how could I put the resulting recordset of my ADO process to my
forms or reports just like setting the .RecordSource property of Form or
Report? Is it like this:
frmMain.Recordsource =3D rsMyRecordset
Is this possible?
Thanks,
Enzo :)
Message #2 by "Gerald, Rand" <RGerald@u...> on Tue, 26 Feb 2002 11:21:19 -0600
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C1BEEA.01719450
Content-Type: text/plain;
charset="iso-8859-1"
Here is the ADO equivalent:
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim strSQL As String
Cnn = CurrentProject.Connection
StrSQL = "SELECT * FROM tblSample"
Rs.Open strSQL, cnn
Rand E Gerald
Information Services / Operations
-----Original Message-----
From: e n z o [mailto:enzaux@y...]
Sent: Tuesday, February 26, 2002 9:45 AM
To: Access
Subject: [access] Confused IF this is really ADO
Hi!! Below is a sample of my code on how I make recordset via coding:
dim db as Database
dim rs as Recordset
dim strSQL as string
set db = Currentdb()
strSQL = "SELECT * FROM tblsample"
set rs = db.OpenRecordset (strSQL)
.
.
.
I was wondering if this method is an ADO sample? If not what type of method
is this.... DAO? or anything else?
And also how could I put the resulting recordset of my ADO process to my
forms or reports just like setting the .RecordSource property of Form or
Report? Is it like this:
frmMain.Recordsource = rsMyRecordset
Is this possible?
Thanks,
Enzo :)
Message #3 by "e n z o" <enzaux@y...> on Wed, 27 Feb 2002 01:46:41 +0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_048A_01C1BF30.9ADC2A60
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi Gerald!! I know how to use ADO but what confuses me is whether if
the said code from my post is also considered an ADO. And how to put it
on a recordsource property
Thanks,
Enzo
----- Original Message -----
From: Gerald, Rand
To: Access
Sent: Wednesday, February 27, 2002 1:21 AM
Subject: [access] RE: Confused IF this is really ADO
Here is the ADO equivalent:
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim strSQL As String
Cnn =3D CurrentProject.Connection
StrSQL =3D "SELECT * FROM tblSample"
Rs.Open strSQL, cnn
Rand E Gerald
Information Services / Operations
-----Original Message-----
From: e n z o [mailto:enzaux@y...]
Sent: Tuesday, February 26, 2002 9:45 AM
To: Access
Subject: [access] Confused IF this is really ADO
Hi!! Below is a sample of my code on how I make recordset via coding:
dim db as Database
dim rs as Recordset
dim strSQL as string
set db =3D Currentdb()
strSQL =3D "SELECT * FROM tblsample"
set rs =3D db.OpenRecordset (strSQL)
.
.
.
I was wondering if this method is an ADO sample? If not what type of
method is this.... DAO? or anything else?
And also how could I put the resulting recordset of my ADO process to
my forms or reports just like setting the .RecordSource property of Form
or Report? Is it like this:
frmMain.Recordsource =3D rsMyRecordset
Is this possible?
Thanks,
Enzo :)
$subst('Email.Unsub').
$subst('Email.Unsub').
Message #4 by "Leo Scott" <leoscott@c...> on Tue, 26 Feb 2002 09:41:18 -0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0027_01C1BEA9.BDBF5CF0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
It is not ADO, it is DAO. To put it as the recordsource property on a form just put the
SELECT * FROM tblSample
in the form's recordsource property.
-----Original Message-----
From: e n z o [mailto:enzaux@y...]
Sent: Tuesday, February 26, 2002 9:47 AM
To: Access
Subject: [access] RE: Confused IF this is really ADO
Hi Gerald!! I know how to use ADO but what confuses me is whether if the said code from my post is also considered an
ADO. And how to put it on a recordsource property
Thanks,
Enzo
----- Original Message -----
From: Gerald, Rand
To: Access
Sent: Wednesday, February 27, 2002 1:21 AM
Subject: [access] RE: Confused IF this is really ADO
Here is the ADO equivalent:
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim strSQL As String
Cnn = CurrentProject.Connection
StrSQL = ?SELECT * FROM tblSample?
Rs.Open strSQL, cnn
Rand E Gerald
Information Services / Operations
-----Original Message-----
From: e n z o [mailto:enzaux@y...]
Sent: Tuesday, February 26, 2002 9:45 AM
To: Access
Subject: [access] Confused IF this is really ADO
Hi!! Below is a sample of my code on how I make recordset via coding:
dim db as Database
dim rs as Recordset
dim strSQL as string
set db = Currentdb()
strSQL = "SELECT * FROM tblsample"
set rs = db.OpenRecordset (strSQL)
.
.
.
I was wondering if this method is an ADO sample? If not what type of method is this.... DAO? or anything else?
And also how could I put the resulting recordset of my ADO process to my forms or reports just like setting the
.RecordSource property of Form or Report? Is it like this:
frmMain.Recordsource = rsMyRecordset
Is this possible?
Thanks,
Enzo :)
Message #5 by "Gerald, Rand" <RGerald@u...> on Tue, 26 Feb 2002 11:08:35 -0600
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C1BEE8.3A148D00
Content-Type: text/plain;
charset="iso-8859-1"
NO, it is NOT ADO it is DAO!
Rand E Gerald
Information Services / Operations
-----Original Message-----
From: e n z o [mailto:enzaux@y...]
Sent: Tuesday, February 26, 2002 9:45 AM
To: Access
Subject: [access] Confused IF this is really ADO
Hi!! Below is a sample of my code on how I make recordset via coding:
dim db as Database
dim rs as Recordset
dim strSQL as string
set db = Currentdb()
strSQL = "SELECT * FROM tblsample"
set rs = db.OpenRecordset (strSQL)
.
.
.
I was wondering if this method is an ADO sample? If not what type of method
is this.... DAO? or anything else?
And also how could I put the resulting recordset of my ADO process to my
forms or reports just like setting the .RecordSource property of Form or
Report? Is it like this:
frmMain.Recordsource = rsMyRecordset
Is this possible?
Thanks,
Enzo :)
Message #6 by "e n z o" <enzaux@y...> on Wed, 27 Feb 2002 02:23:24 +0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_04A0_01C1BF35.BBA502D0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Can't I use the recordset to the recordsource property?
----- Original Message -----
From: Leo Scott
To: Access
Sent: Wednesday, February 27, 2002 1:41 AM
Subject: [access] RE: Confused IF this is really ADO
It is not ADO, it is DAO. To put it as the recordsource property on a
form just put the
SELECT * FROM tblSample
in the form's recordsource property.
-----Original Message-----
From: e n z o [mailto:enzaux@y...]
Sent: Tuesday, February 26, 2002 9:47 AM
To: Access
Subject: [access] RE: Confused IF this is really ADO
Hi Gerald!! I know how to use ADO but what confuses me is whether
if the said code from my post is also considered an ADO. And how to put
it on a recordsource property
Thanks,
Enzo
----- Original Message -----
From: Gerald, Rand
To: Access
Sent: Wednesday, February 27, 2002 1:21 AM
Subject: [access] RE: Confused IF this is really ADO
Here is the ADO equivalent:
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim strSQL As String
Cnn =3D CurrentProject.Connection
StrSQL =3D "SELECT * FROM tblSample"
Rs.Open strSQL, cnn
Rand E Gerald
Information Services / Operations
-----Original Message-----
From: e n z o [mailto:enzaux@y...]
Sent: Tuesday, February 26, 2002 9:45 AM
To: Access
Subject: [access] Confused IF this is really ADO
Hi!! Below is a sample of my code on how I make recordset via
coding:
dim db as Database
dim rs as Recordset
dim strSQL as string
set db =3D Currentdb()
strSQL =3D "SELECT * FROM tblsample"
set rs =3D db.OpenRecordset (strSQL)
.
.
.
I was wondering if this method is an ADO sample? If not what type
of method is this.... DAO? or anything else?
And also how could I put the resulting recordset of my ADO process
to my forms or reports just like setting the .RecordSource property of
Form or Report? Is it like this:
frmMain.Recordsource =3D rsMyRecordset
Is this possible?
Thanks,
Enzo :)
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
Message #7 by "e n z o" <enzaux@y...> on Wed, 27 Feb 2002 02:23:45 +0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_04AE_01C1BF35.C7F3F370
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Thanks
Enzo :)
----- Original Message -----
From: Gerald, Rand
To: Access
Sent: Wednesday, February 27, 2002 1:08 AM
Subject: [access] RE: Confused IF this is really ADO
NO, it is NOT ADO it is DAO!
Rand E Gerald
Information Services / Operations
-----Original Message-----
From: e n z o [mailto:enzaux@y...]
Sent: Tuesday, February 26, 2002 9:45 AM
To: Access
Subject: [access] Confused IF this is really ADO
Hi!! Below is a sample of my code on how I make recordset via coding:
dim db as Database
dim rs as Recordset
dim strSQL as string
set db =3D Currentdb()
strSQL =3D "SELECT * FROM tblsample"
set rs =3D db.OpenRecordset (strSQL)
.
.
.
I was wondering if this method is an ADO sample? If not what type of
method is this.... DAO? or anything else?
And also how could I put the resulting recordset of my ADO process to
my forms or reports just like setting the .RecordSource property of Form
or Report? Is it like this:
frmMain.Recordsource =3D rsMyRecordset
Is this possible?
Thanks,
Enzo :)
$subst('Email.Unsub').
$subst('Email.Unsub').
Message #8 by "Leo Scott" <leoscott@c...> on Tue, 26 Feb 2002 11:22:33 -0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0041_01C1BEB7.E2731510
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
Open a code window in Access, then open the object browser, then select the Access library. Under classes select Form
and in the "Members of Form" window right click on Recordset and select Help from the popup. It will tell you how to
use your DAO or ADO recordsets for a form. I use Access 2000 and it even has an ADO example.
-----Original Message-----
From: e n z o [mailto:enzaux@y...]
Sent: Tuesday, February 26, 2002 10:23 AM
To: Access
Subject: [access] RE: Confused IF this is really ADO
Can't I use the recordset to the recordsource property?
----- Original Message -----
From: Leo Scott
To: Access
Sent: Wednesday, February 27, 2002 1:41 AM
Subject: [access] RE: Confused IF this is really ADO
It is not ADO, it is DAO. To put it as the recordsource property on a form just put the
SELECT * FROM tblSample
in the form's recordsource property.
-----Original Message-----
From: e n z o [mailto:enzaux@y...]
Sent: Tuesday, February 26, 2002 9:47 AM
To: Access
Subject: [access] RE: Confused IF this is really ADO
Hi Gerald!! I know how to use ADO but what confuses me is whether if the said code from my post is also
considered an ADO. And how to put it on a recordsource property
Thanks,
Enzo
----- Original Message -----
From: Gerald, Rand
To: Access
Sent: Wednesday, February 27, 2002 1:21 AM
Subject: [access] RE: Confused IF this is really ADO
Here is the ADO equivalent:
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim strSQL As String
Cnn = CurrentProject.Connection
StrSQL = ?SELECT * FROM tblSample?
Rs.Open strSQL, cnn
Rand E Gerald
Information Services / Operations
-----Original Message-----
From: e n z o [mailto:enzaux@y...]
Sent: Tuesday, February 26, 2002 9:45 AM
To: Access
Subject: [access] Confused IF this is really ADO
Hi!! Below is a sample of my code on how I make recordset via coding:
dim db as Database
dim rs as Recordset
dim strSQL as string
set db = Currentdb()
strSQL = "SELECT * FROM tblsample"
set rs = db.OpenRecordset (strSQL)
.
.
.
I was wondering if this method is an ADO sample? If not what type of method is this.... DAO? or anything else?
And also how could I put the resulting recordset of my ADO process to my forms or reports just like setting the
.RecordSource property of Form or Report? Is it like this:
frmMain.Recordsource = rsMyRecordset
Is this possible?
Thanks,
Enzo :)
Message #9 by "Gerald, Rand" <RGerald@u...> on Tue, 26 Feb 2002 13:35:10 -0600
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C1BEFC.B44E2220
Content-Type: text/plain;
charset="iso-8859-1"
No, that particular recordset syntax is DAO. The first giveaway is that
there is no Database object in ADO, but there is one in DAO.
Second, to open a recordset, ADO uses:
Rs.Open strSQL, connectionID
while DAO uses:
Rs = dbID.OpenRecordset strSQL
The two syntaxes are not interchangeable. Calling a Ford a Chevrolet does
not make a Ford into a Chevrolet and Ford parts generally do not work on
Chevrolets.
Rand E Gerald
Information Services / Operations
-----Original Message-----
From: e n z o [mailto:enzaux@y...]
Sent: Tuesday, February 26, 2002 11:47 AM
To: Access
Subject: [access] RE: Confused IF this is really ADO
Hi Gerald!! I know how to use ADO but what confuses me is whether if the
said code from my post is also considered an ADO. And how to put it on a
recordsource property
Thanks,
Enzo
----- Original Message -----
From: Gerald, Rand <mailto:RGerald@u...>
To: Access <mailto:access@p...>
Sent: Wednesday, February 27, 2002 1:21 AM
Subject: [access] RE: Confused IF this is really ADO
Here is the ADO equivalent:
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim strSQL As String
Cnn = CurrentProject.Connection
StrSQL = "SELECT * FROM tblSample"
Rs.Open strSQL, cnn
Rand E Gerald
Information Services / Operations
-----Original Message-----
From: e n z o [mailto:enzaux@y...]
Sent: Tuesday, February 26, 2002 9:45 AM
To: Access
Subject: [access] Confused IF this is really ADO
Hi!! Below is a sample of my code on how I make recordset via coding:
dim db as Database
dim rs as Recordset
dim strSQL as string
set db = Currentdb()
strSQL = "SELECT * FROM tblsample"
set rs = db.OpenRecordset (strSQL)
.
.
.
I was wondering if this method is an ADO sample? If not what type of method
is this.... DAO? or anything else?
And also how could I put the resulting recordset of my ADO process to my
forms or reports just like setting the .RecordSource property of Form or
Report? Is it like this:
frmMain.Recordsource = rsMyRecordset
Is this possible?
Thanks,
Enzo :)
Message #10 by "e n z o" <enzaux@y...> on Wed, 27 Feb 2002 03:40:50 +0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_04FC_01C1BF40.8CE20780
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Thanks!!!
----- Original Message -----
From: Leo Scott
To: Access
Sent: Wednesday, February 27, 2002 3:22 AM
Subject: [access] RE: Confused IF this is really ADO
Open a code window in Access, then open the object browser, then
select the Access library. Under classes select Form and in the
"Members of Form" window right click on Recordset and select Help from
the popup. It will tell you how to use your DAO or ADO recordsets for a
form. I use Access 2000 and it even has an ADO example.
-----Original Message-----
From: e n z o [mailto:enzaux@y...]
Sent: Tuesday, February 26, 2002 10:23 AM
To: Access
Subject: [access] RE: Confused IF this is really ADO
Can't I use the recordset to the recordsource property?
----- Original Message -----
From: Leo Scott
To: Access
Sent: Wednesday, February 27, 2002 1:41 AM
Subject: [access] RE: Confused IF this is really ADO
It is not ADO, it is DAO. To put it as the recordsource property
on a form just put the
SELECT * FROM tblSample
in the form's recordsource property.
-----Original Message-----
From: e n z o [mailto:enzaux@y...]
Sent: Tuesday, February 26, 2002 9:47 AM
To: Access
Subject: [access] RE: Confused IF this is really ADO
Hi Gerald!! I know how to use ADO but what confuses me is
whether if the said code from my post is also considered an ADO. And
how to put it on a recordsource property
Thanks,
Enzo
----- Original Message -----
From: Gerald, Rand
To: Access
Sent: Wednesday, February 27, 2002 1:21 AM
Subject: [access] RE: Confused IF this is really ADO
Here is the ADO equivalent:
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim strSQL As String
Cnn =3D CurrentProject.Connection
StrSQL =3D "SELECT * FROM tblSample"
Rs.Open strSQL, cnn
Rand E Gerald
Information Services / Operations
-----Original Message-----
From: e n z o [mailto:enzaux@y...]
Sent: Tuesday, February 26, 2002 9:45 AM
To: Access
Subject: [access] Confused IF this is really ADO
Hi!! Below is a sample of my code on how I make recordset via
coding:
dim db as Database
dim rs as Recordset
dim strSQL as string
set db =3D Currentdb()
strSQL =3D "SELECT * FROM tblsample"
set rs =3D db.OpenRecordset (strSQL)
.
.
.
I was wondering if this method is an ADO sample? If not what
type of method is this.... DAO? or anything else?
And also how could I put the resulting recordset of my ADO
process to my forms or reports just like setting the .RecordSource
property of Form or Report? Is it like this:
frmMain.Recordsource =3D rsMyRecordset
Is this possible?
Thanks,
Enzo :)
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
Message #11 by PStreeter@C... on Tue, 26 Feb 2002 15:22:29 CST
|
|
On Tue, 26 Feb 2002 11:08:35 -0600 "Gerald, Rand" wrote:
> NO, it is NOT ADO it is DAO!
This is starting to seem like much ADO about nothing.
Paul
|
|
|
View Cart
