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

Onno

I just remembered Crystal has code to get the recordsource of forms and reports. It's in our Files>Crystal and is named bas_crystal_Document_SQL_FormRpt_RecordSource_090703.zip

She has some other utilities you might find helpful, too.

Bill

--- In MS_Access_Professionals@yahoogroups.com, "Knol, Onno" <onno.knol@...> wrote:
>
>
> 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@...?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]
>