Can I assign form's recordset to ADO's rst ?

[TC]

DO NOT MULTI-POST!

CROSS-post!

See: http://oakroadsystems.com/genl/unice.htm

TC

 

[TC]

Next time you should more careful before you blame someone.

Next time you should read the $#@!ing reference that was given to you.

I did not object to you posting to several newsgroups. I objected to you M U
L T I - P O S T I N G , as opposed to the correct method, which is C R O S
S - P O S T I N G.

Since you obviously didn't bother to read the reference that I gave you -
which explains the difference perfectly clearly - here it is:

When you CROSS-post to several newsgroups, a person who sees your post in
*any one* of those newsgroups, will see *all* replies that *anyone else* has
given you in *any of the other* newsgroups. So they can AVOID WASTING THEIR
FRIGGIN' TIME ANSWERING A QUESTION THAT HAS ALREADY BEEN ANSWERED.

When you MULTI-post, a person who kindly decides to answer your question -
using their own time, and for no real benefit to themselves - will spend 'x'
amount of time doing so - and will then find out, 30 minutes later, that
they have WASTED THEIR FRIGGIN' TIME, because someone elase has already
answered in some other newsgroup, to which you have MULTI-POSTED.

Bye,

Too right.

TC

Hi, Sorry to post in more than 1 newsgroups. But I think, I post because I
want to know what I don't know. I need replies/opinion from many persons.
You should blame to the subject about selling, dating or something else that
not relate to this newsgroups. Internet is open world, please open your mind
too.

Result of your reply but not answer anything about my question can skip
other person from reply me also. They may think, This post already has
someone reply. And finally, make me to post again if I can not get any
answer.

Actually, I should post my question in
microsoft.public.access.modulesdaovba.ado BUT if you visit there you will
see subject [ANN]: NNTP Server slow downs and there are no answer for many
days.

Next time you should more careful before you blame someone. Everyone (Most)
come here to ask what they don't know (including you) not because they have
a lot of time.

Bye,

DO NOT MULTI-POST!

CROSS-post!

See: http://oakroadsystems.com/genl/unice.htm

TC

 

[S.L.]

I found that if I use ADO I can not write like the following, it generates
Type Mismatch error. :

Dim rst as New ADODB.Recordset

Set rst = Form!MyForm.RecordsetClone

If I change ADODB.Recordset to DAO.Recordset, Everything is OK.

1) How to assign form's recordset to ADO's rst ?
2) Except syntax,method,property I ever used on ADO, Do I also have to
change the way I programming with form's recordset ? ex., Bookmark...

TIA

 

[S.L.]

Hi, Sorry to post in more than 1 newsgroups. But I think, I post because I
want to know what I don't know. I need replies/opinion from many persons.
You should blame to the subject about selling, dating or something else that
not relate to this newsgroups. Internet is open world, please open your mind
too.

Result of your reply but not answer anything about my question can skip
other person from reply me also. They may think, This post already has
someone reply. And finally, make me to post again if I can not get any
answer.

Actually, I should post my question in
microsoft.public.access.modulesdaovba.ado BUT if you visit there you will
see subject [ANN]: NNTP Server slow downs and there are no answer for many
days.

Next time you should more careful before you blame someone. Everyone (Most)
come here to ask what they don't know (including you) not because they have
a lot of time.

Bye,