If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Filtering Records
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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/201005/1 |
#2
|
|||
|
|||
Filtering Records
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? lad5ko wrote: 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 -- Message posted via http://www.accessmonster.com |
#3
|
|||
|
|||
Filtering Records
" I know it is possible in datasheet view" Why would the same method not
work in a single or continuous form? -- Duane Hookom MS Access MVP "lad5ko via AccessMonster.com" u12006@uwe wrote in message news:a87f9e64e1ce8@uwe... 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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/201005/1 |
#4
|
|||
|
|||
Filtering Records
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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/201005/1 |
#5
|
|||
|
|||
Filtering Records
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 Duane Hookom wrote: " 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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/201005/1 |
#6
|
|||
|
|||
Filtering Records
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 |
#7
|
|||
|
|||
Filtering Records
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/For...arted/201005/1 |
#8
|
|||
|
|||
Filtering Records
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/For...arted/201005/1 |
Thread Tools | |
Display Modes | |
|
|