Basing a form on a RecordSet Instead of a Table/Query

Basing a form on a RecordSet Instead of a Table/Query - MC

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MChrist - 12 Jul 2005 14:11 GMT

Is it possible to base a form on a recordset instead of a table or query, and
if so, could someone point me to a good example. The VBA Help on my PC is
not very good (not all the pages appear), so I'm looking more for an
web/external source.

Thanks In Advance

Mark

Reply to this Message

Klatuu - 12 Jul 2005 14:37 GMT

Your question is unclear. All recordsets are either queries or tables. The
can be external by linking to a data source such as an Excel spreadsheet, a
FoxPro database, text files, etc. When you say web, what do you mean? What
form is the data in?

> Is it possible to base a form on a recordset instead of a table or query, and
> if so, could someone point me to a good example. The VBA Help on my PC is
[quoted text clipped - 4 lines]
>
> Mark

Reply to this Message

Marshall Barton - 12 Jul 2005 17:16 GMT

>Is it possible to base a form on a recordset instead of a table or query, and
>if so, could someone point me to a good example. The VBA Help on my PC is
>not very good (not all the pages appear), so I'm looking more for an
>web/external source.

I agree with Klatuu, most any time you you open a recordset,
you could use that as the form's RecordSource.

Since A2K, forms have had the Recordset property that you
can set. If you do have one of those rare situations where
this really is needed, see if you can find it in your Help
system.

Signature

Marsh
MVP [MS Access]

Reply to this Message

MChrist - 12 Jul 2005 18:34 GMT

Marshall,

If finally found where you can base a form on a recordset without a table or
query in the Help, now however, when I run the form, I see the proper amount
of records, but there are no fields to display in design view.

Any suggestions?

Mark

> >Is it possible to base a form on a recordset instead of a table or query, and
> >if so, could someone point me to a good example. The VBA Help on my PC is
[quoted text clipped - 8 lines]
> this really is needed, see if you can find it in your Help
> system.

Reply to this Message

Marshall Barton - 12 Jul 2005 19:08 GMT

You'll have to work without the field list in the form's
design view. The field list comes from the form's
RecordSource table/query and without that you will not have
a field list to work with.

You are taking a very unusual approach and you have not
provided any background info that might allow someone to
come up with an alternative design or even suggestions on
how to work with whatever situation you're trying to deal
with. At this point we would just guessing about what might
help you out here.

Signature

Marsh
MVP [MS Access]

>If finally found where you can base a form on a recordset without a table or
>query in the Help, now however, when I run the form, I see the proper amount
[quoted text clipped - 12 lines]
>> this really is needed, see if you can find it in your Help
>> system.

Reply to this Message