Displaying information in Access - general question

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Robert
    #1

    Displaying information in Access - general question

    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


    Tags: None
    • Brendan Reynolds
      #2
      Re: Displaying information in Access - general question

      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" <projecttoday@y ahoo.com> wrote in message
      news:102pvnff21 4c41b@corp.supe rnews.com...[color=blue]
      > 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[/color]
      go.[color=blue]
      > 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[/color]
      I[color=blue]
      > 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[/color]
      coding.[color=blue]
      > 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
      >
      >[/color]


        Comment

        • Bernard Peek
          #3
          Re: Displaying information in Access - general question

          In message <102pvnff214c41 b@corp.supernew s.com>, Robert
          <projecttoday@y ahoo.com> writes[color=blue]
          >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?[/color]

          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.

            Comment

            • Robert
              #4
              Re: Displaying information in Access - general question


              "Bernard Peek" <bap@shrdlu.com > wrote in message
              news:m9P+wPFRrQ LAFwF3@shrdlu.c om...[color=blue]
              > In message <102pvnff214c41 b@corp.supernew s.com>, Robert
              > <projecttoday@y ahoo.com> writes[color=green]
              > >Hello Accessors
              > >
              > >I have some reports created in Access that are very good for what they[/color][/color]
              do.[color=blue][color=green]
              > >However, it seems to me that when you are displaying information you[/color][/color]
              don't[color=blue][color=green]
              > >need to print out that a printer-friendly report is not the best way to[/color][/color]
              go.[color=blue][color=green]
              > >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[/color][/color]
              I[color=blue][color=green]
              > >went to define my sorting and grouping there was none available, making[/color][/color]
              it[color=blue][color=green]
              > >pretty much impossible to convert my report to a form without adding[/color][/color]
              coding.[color=blue][color=green]
              > >Looks like I'm going to stick with the orginal report and forget about[/color][/color]
              the[color=blue][color=green]
              > >form. Has anyone felt the same way or know of another way of displaying
              > >complex reports in a true display manner in Access?[/color]
              >
              > 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.
              >[/color]

              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.


                Comment

                • Bernard Peek
                  #5
                  Re: Displaying information in Access - general question

                  In message <102q8bss74nt77 b@corp.supernew s.com>, Robert
                  <projecttoday@y ahoo.com> writes[color=blue]
                  >
                  >"Bernard Peek" <bap@shrdlu.com > wrote in message
                  >news:m9P+wPFRr QLAFwF3@shrdlu. com...[color=green]
                  >> In message <102pvnff214c41 b@corp.supernew s.com>, Robert
                  >> <projecttoday@y ahoo.com> writes[color=darkred]
                  >> >Hello Accessors
                  >> >
                  >> >I have some reports created in Access that are very good for what they[/color][/color]
                  >do.[color=green][color=darkred]
                  >> >However, it seems to me that when you are displaying information you[/color][/color]
                  >don't[color=green][color=darkred]
                  >> >need to print out that a printer-friendly report is not the best way to[/color][/color]
                  >go.[color=green][color=darkred]
                  >> >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[/color][/color]
                  >I[color=green][color=darkred]
                  >> >went to define my sorting and grouping there was none available, making[/color][/color]
                  >it[color=green][color=darkred]
                  >> >pretty much impossible to convert my report to a form without adding[/color][/color]
                  >coding.[color=green][color=darkred]
                  >> >Looks like I'm going to stick with the orginal report and forget about[/color][/color]
                  >the[color=green][color=darkred]
                  >> >form. Has anyone felt the same way or know of another way of displaying
                  >> >complex reports in a true display manner in Access?[/color]
                  >>
                  >> 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.
                  >>[/color]
                  >
                  >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.[/color]

                  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.

                    Comment

                    • Robert
                      #6
                      Re: Displaying information in Access - general question


                      "Bernard Peek" <bap@shrdlu.com > wrote in message
                      news:HCXIdzYHvA MAFw6l@shrdlu.c om...[color=blue]
                      > In message <102q8bss74nt77 b@corp.supernew s.com>, Robert
                      > <projecttoday@y ahoo.com> writes[color=green]
                      > >
                      > >"Bernard Peek" <bap@shrdlu.com > wrote in message
                      > >news:m9P+wPFRr QLAFwF3@shrdlu. com...[color=darkred]
                      > >> In message <102pvnff214c41 b@corp.supernew s.com>, Robert
                      > >> <projecttoday@y ahoo.com> writes
                      > >> >Hello Accessors
                      > >> >
                      > >> >I have some reports created in Access that are very good for what they[/color]
                      > >do.[color=darkred]
                      > >> >However, it seems to me that when you are displaying information you[/color]
                      > >don't[color=darkred]
                      > >> >need to print out that a printer-friendly report is not the best way[/color][/color][/color]
                      to[color=blue][color=green]
                      > >go.[color=darkred]
                      > >> >So, I tried converting one of my Access reports to an Access form. I
                      > >> >selected the continuous view to allow displaying multple records but[/color][/color][/color]
                      when[color=blue][color=green]
                      > >I[color=darkred]
                      > >> >went to define my sorting and grouping there was none available,[/color][/color][/color]
                      making[color=blue][color=green]
                      > >it[color=darkred]
                      > >> >pretty much impossible to convert my report to a form without adding[/color]
                      > >coding.[color=darkred]
                      > >> >Looks like I'm going to stick with the orginal report and forget about[/color]
                      > >the[color=darkred]
                      > >> >form. Has anyone felt the same way or know of another way of[/color][/color][/color]
                      displaying[color=blue][color=green][color=darkred]
                      > >> >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.
                      > >>[/color]
                      > >
                      > >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.[/color]
                      >
                      > 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.
                      >[/color]
                      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.


                        Comment

                        Previous template Next
                        Working...