A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Filtering Records



 
 
Thread Tools Display Modes
  #1  
Old May 24th, 2010, 09:28 PM posted to microsoft.public.access.gettingstarted
lad5ko via AccessMonster.com
external usenet poster
 
Posts: 14
Default 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  
Old May 25th, 2010, 05:06 AM posted to microsoft.public.access.gettingstarted
PieterLinden via AccessMonster.com
external usenet poster
 
Posts: 307
Default 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  
Old May 25th, 2010, 05:31 AM posted to microsoft.public.access.gettingstarted
Duane Hookom[_4_]
external usenet poster
 
Posts: 316
Default 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  
Old May 25th, 2010, 03:10 PM posted to microsoft.public.access.gettingstarted
lad5ko via AccessMonster.com
external usenet poster
 
Posts: 14
Default 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  
Old May 25th, 2010, 03:15 PM posted to microsoft.public.access.gettingstarted
lad5ko via AccessMonster.com
external usenet poster
 
Posts: 14
Default 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  
Old May 25th, 2010, 03:23 PM posted to microsoft.public.access.gettingstarted
John Spencer
external usenet poster
 
Posts: 7,815
Default 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  
Old May 25th, 2010, 06:34 PM posted to microsoft.public.access.gettingstarted
Linq Adams via AccessMonster.com
external usenet poster
 
Posts: 1,474
Default 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  
Old May 25th, 2010, 08:19 PM posted to microsoft.public.access.gettingstarted
lad5ko via AccessMonster.com
external usenet poster
 
Posts: 14
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:41 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.