Prev: Combine number in a Table field
Next: Query joining two tables with different dates
From: John Spencer on 25 May 2010 10:23
It sounds as if you need to design a form in continuous view with your query
as the form's record source. Then you open the form (which will automatically
execute the query).

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

lad5ko via AccessMonster.com wrote:
> May be I wrote my problem not correctly. I need to display answer from my
> query in form view, becouse if I display it in datasheet view every filtered
> record have 56 field and i have to use scroll bar to see all fields. I
> applied OpenQuery Method (in this method I can not use form view)- may be
> another method is better but I do not know it. I am novice in databas design.
>
> Thanks for your time.
>
> PieterLinden wrote:
>> Not sure what to tell you... you can't view 56 columns of a spreadsheet on a
>> single screen either, so what makes you think you can do it in a database?
>>
>>> Hi,
>>> Problem :
>> [quoted text clipped - 8 lines]
>>> lad5ko
>
From: Linq Adams via AccessMonster.com on 25 May 2010 13:34
A query. when opened, is only going to display data in what you're calling a
"datasheet" view. To have the data displayed as a "form" view, as John said,
you need to "design a form in continuous view with your query as the form's
record source. Then you open the form (which will automatically
execute the query)."

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/201005/1

From: lad5ko via AccessMonster.com on 25 May 2010 15:19
Yes John, your suggestion was correct. Evriting is OK.

Thank you.

lad5ko

John Spencer wrote:
>It sounds as if you need to design a form in continuous view with your query
>as the form's record source. Then you open the form (which will automatically
>execute the query).
>
>John Spencer
>Access MVP 2002-2005, 2007-2010
>The Hilltop Institute
>University of Maryland Baltimore County
>
>> May be I wrote my problem not correctly. I need to display answer from my
>> query in form view, becouse if I display it in datasheet view every filtered
>[quoted text clipped - 11 lines]
>>> [quoted text clipped - 8 lines]
>>>> lad5ko

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/201005/1

First  |  Prev  | 
Pages: 1 2
Prev: Combine number in a Table field
Next: Query joining two tables with different dates