ACCESS FEED: [MS_AccessPros] Re: how to get access to a form's recordset

Senin, 25 Maret 2013

[MS_AccessPros] Re: how to get access to a form's recordset

1c
Dear friends,

Thanks for your help. The key issue was that you should open the form.
I do that in hidden modus and can get the information I need now.
An answer to the "why"question from Duane, (see below):
I inherited a number of databases on which I need to proceed, but I do not kbnow about the history.
So I need a tool to have a quick scan of the contents.
That is also the reason why I can not rely on a strict naming system for underlying queries,
like Bill suggested. But, as I said the tool is now functioning as I like.

Thanks again,

Onno

Re: how to get access to a form's recordset <http://groups.yahoo.com/group/MS_Access_Professionals/message/103361;_ylc=X3oDMTJzZnR2ZHZmBF9TAzk3MzU5NzE1BGdycElkAzY0NDg5NzgEZ3Jwc3BJZAMxNzA1MTE1MzcwBG1zZ0lkAzEwMzM2MQRzZWMDZG1zZwRzbGsDdm1zZwRzdGltZQMxMzY0MDMxNDU1>
Fri Mar 22, 2013 7:05 am (PDT) . Posted by:
"Duane Hookom" dhookom <mailto:duanehookom@hotmail.com?subject=Re%3A%20how%20to%20get%20access%20to%20a%20form%27s%20recordset>
Onno,
I can't imagine what the significance of the number of records in forms.

I believe you would need to open the form in order to get the recordsource property value. You should be able to open hidden, get the recordsource and then close.

Again, why would you want to do this?

Duane Hookom MVP
MS Access

[Non-text portions of this message have been removed]