By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,414 Members | 2,919 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,414 IT Pros & Developers. It's quick & easy.

Displaying information in Access - general question

P: n/a
Hello Accessors

I have some reports created in Access that are very good for what they do.
However, it seems to me that when you are displaying information you don't
need to print out that a printer-friendly report is not the best way to go.
So, I tried converting one of my Access reports to an Access form. I
selected the continuous view to allow displaying multple records but when I
went to define my sorting and grouping there was none available, making it
pretty much impossible to convert my report to a form without adding coding.
Looks like I'm going to stick with the orginal report and forget about the
form. Has anyone felt the same way or know of another way of displaying
complex reports in a true display manner in Access?

Robert
Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
That was one of the things that Data Access Pages were supposed to do.
They've never really taken off, though. I'm not recommending them, but
they're there, if you want to check them out.

Personally, I'd rather do the work to get what I wanted with a form than
mess with Data Access Pages.

--
Brendan Reynolds
"Robert" <pr**********@yahoo.com> wrote in message
news:10*************@corp.supernews.com...
Hello Accessors

I have some reports created in Access that are very good for what they do.
However, it seems to me that when you are displaying information you don't
need to print out that a printer-friendly report is not the best way to go. So, I tried converting one of my Access reports to an Access form. I
selected the continuous view to allow displaying multple records but when I went to define my sorting and grouping there was none available, making it
pretty much impossible to convert my report to a form without adding coding. Looks like I'm going to stick with the orginal report and forget about the
form. Has anyone felt the same way or know of another way of displaying
complex reports in a true display manner in Access?

Robert

Nov 12 '05 #2

P: n/a
In message <10*************@corp.supernews.com>, Robert
<pr**********@yahoo.com> writes
Hello Accessors

I have some reports created in Access that are very good for what they do.
However, it seems to me that when you are displaying information you don't
need to print out that a printer-friendly report is not the best way to go.
So, I tried converting one of my Access reports to an Access form. I
selected the continuous view to allow displaying multple records but when I
went to define my sorting and grouping there was none available, making it
pretty much impossible to convert my report to a form without adding coding.
Looks like I'm going to stick with the orginal report and forget about the
form. Has anyone felt the same way or know of another way of displaying
complex reports in a true display manner in Access?


You need to change the data source so that the data is sorted the way
you want. Create query that sorts the data before it is displayed. To
introduce groups you need to use subforms.

Alternatively you can create a report and open it in preview mode.

--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.

Nov 12 '05 #3

P: n/a

"Bernard Peek" <ba*@shrdlu.com> wrote in message
news:m9**************@shrdlu.com...
In message <10*************@corp.supernews.com>, Robert
<pr**********@yahoo.com> writes
Hello Accessors

I have some reports created in Access that are very good for what they do.However, it seems to me that when you are displaying information you don'tneed to print out that a printer-friendly report is not the best way to go.So, I tried converting one of my Access reports to an Access form. I
selected the continuous view to allow displaying multple records but when Iwent to define my sorting and grouping there was none available, making itpretty much impossible to convert my report to a form without adding coding.Looks like I'm going to stick with the orginal report and forget about theform. Has anyone felt the same way or know of another way of displaying
complex reports in a true display manner in Access?


You need to change the data source so that the data is sorted the way
you want. Create query that sorts the data before it is displayed. To
introduce groups you need to use subforms.

Alternatively you can create a report and open it in preview mode.

--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.


That's what I'm doing. Opening the report in preview mode.

I thought subforms were used for a one-to-many relationship in tables.
Nov 12 '05 #4

P: n/a
In message <10*************@corp.supernews.com>, Robert
<pr**********@yahoo.com> writes

"Bernard Peek" <ba*@shrdlu.com> wrote in message
news:m9**************@shrdlu.com...
In message <10*************@corp.supernews.com>, Robert
<pr**********@yahoo.com> writes
>Hello Accessors
>
>I have some reports created in Access that are very good for what theydo. >However, it seems to me that when you are displaying information youdon't >need to print out that a printer-friendly report is not the best way togo. >So, I tried converting one of my Access reports to an Access form. I
>selected the continuous view to allow displaying multple records but whenI >went to define my sorting and grouping there was none available, makingit >pretty much impossible to convert my report to a form without addingcoding. >Looks like I'm going to stick with the orginal report and forget aboutthe >form. Has anyone felt the same way or know of another way of displaying
>complex reports in a true display manner in Access?


You need to change the data source so that the data is sorted the way
you want. Create query that sorts the data before it is displayed. To
introduce groups you need to use subforms.

Alternatively you can create a report and open it in preview mode.

--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.


That's what I'm doing. Opening the report in preview mode.

I thought subforms were used for a one-to-many relationship in tables.


They are used on forms to display data where there is a 1:m
relationship. If you want to display data from more than one table you
can create a view or you can display records from the 1: side on a form,
and the :m side on a subform.

The fact that you were asking about grouping suggested to me that you
were working with data from more than one entity, whether it is in
multiple tables or not. A form with a subform is one way of displaying
that sort of data. It's not necessarily the best way, but it is an
option.
--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.

Nov 12 '05 #5

P: n/a

"Bernard Peek" <ba*@shrdlu.com> wrote in message
news:HC**************@shrdlu.com...
In message <10*************@corp.supernews.com>, Robert
<pr**********@yahoo.com> writes

"Bernard Peek" <ba*@shrdlu.com> wrote in message
news:m9**************@shrdlu.com...
In message <10*************@corp.supernews.com>, Robert
<pr**********@yahoo.com> writes
>Hello Accessors
>
>I have some reports created in Access that are very good for what they

do.
>However, it seems to me that when you are displaying information you

don't
>need to print out that a printer-friendly report is not the best way to
go.
>So, I tried converting one of my Access reports to an Access form. I
>selected the continuous view to allow displaying multple records but
whenI
>went to define my sorting and grouping there was none available,
makingit
>pretty much impossible to convert my report to a form without adding

coding.
>Looks like I'm going to stick with the orginal report and forget about

the
>form. Has anyone felt the same way or know of another way of

displaying >complex reports in a true display manner in Access?

You need to change the data source so that the data is sorted the way
you want. Create query that sorts the data before it is displayed. To
introduce groups you need to use subforms.

Alternatively you can create a report and open it in preview mode.

--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.


That's what I'm doing. Opening the report in preview mode.

I thought subforms were used for a one-to-many relationship in tables.


They are used on forms to display data where there is a 1:m
relationship. If you want to display data from more than one table you
can create a view or you can display records from the 1: side on a form,
and the :m side on a subform.

The fact that you were asking about grouping suggested to me that you
were working with data from more than one entity, whether it is in
multiple tables or not. A form with a subform is one way of displaying
that sort of data. It's not necessarily the best way, but it is an
option.
--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.

I am working with reports which use a query or a table as input. The
reports are fine. The only problem is that they must be displayed as a
print preview.
Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.