Prev: Combine number in a Table field
Next: Query joining two tables with different dates
From: lad5ko via AccessMonster.com on 24 May 2010 16:28
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/Forums.aspx/access-gettingstarted/201005/1

From: PieterLinden via AccessMonster.com on 25 May 2010 00:06
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

From: Duane Hookom on 25 May 2010 00:31
" 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(a)uwe> wrote in message
news:a87f9e64e1ce8(a)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/Forums.aspx/access-gettingstarted/201005/1
>
From: lad5ko via AccessMonster.com on 25 May 2010 10:10
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/Forums.aspx/access-gettingstarted/201005/1

From: lad5ko via AccessMonster.com on 25 May 2010 10:15
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/Forums.aspx/access-gettingstarted/201005/1

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