Filtering Records

[lad5ko via AccessMonster.com]

Hi,
Problem :
I have a DB table with 56 fields and form is on 1 screen. If I filter records
I need result of filter to display in form view. I know it is possible in
datasheet view - but it is not good for me because I need see all fields and
in datasheed view with 56 fields it is a very long row an I have to use
scroll bar for meny filds..
Any suggestion?

Thank you in advance.

lad5ko

 

[PieterLinden via AccessMonster.com]

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?

 

[Duane Hookom]

" I know it is possible in datasheet view" Why would the same method not
work in a single or continuous form?

 

[lad5ko via AccessMonster.com]

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.

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

 

[lad5ko via AccessMonster.com]

I used OpenQuery method (may be it is a wrong metod to achive my goal) and in
this method is not possible to see result from query in form view.
If you know something better - please write.

Than you in advance.

lad5ko

" I know it is possible in datasheet view" Why would the same method not
work in a single or continuous form?

Hi,
Problem :

[quoted text clipped - 10 lines]

lad5ko

 

[John Spencer]

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
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.

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

 

[Linq Adams via AccessMonster.com]

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)."

 

[lad5ko via AccessMonster.com]

Yes John, your suggestion was correct. Evriting is OK.

Thank you.

lad5ko

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