Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Re: Data access pages

Discussion in 'Information Technology' started by Vista, Jul 28, 2006.

Tags:
  1. Vista

    Vista
    Expand Collapse
    Guest

    Another question about Data Access Pages that are based on Queries:

    For some reason, everytime I create one from a Query that contains this
    following Criteria: 'Like "*"' the DAP won't load any records at all.
    Suggestions?

    Thank you,
    Vista

    "Ken Snell [MVP]" wrote:

    > Good luck.
    >
    > --
    >
    > Ken Snell
    > <MS ACCESS MVP>
    >
    > "Amateur" <Amateur@discussions.microsoft.com> wrote in message
    > news:4D8E6BE0-647A-430F-A839-35987320344D@microsoft.com...
    > > Thanks Ken everything you wrote today helped me very much.
    > > Have a nice day
    > > Klaus
    > >
    > > "Ken Snell [MVP]" wrote:
    > >
    > >> With no knowledge about your table, the data and fields in it, and which
    > >> record is supposed to be the one selected, it's fairly difficult.
    > >>
    > >> Go to the database window, click on Queries, create a new query in design
    > >> view, select the appropriate table, drag fields that you want to see onto
    > >> the grid, put a "Criteria:" expression under the field that is how you
    > >> decide which record is to be selected, and then save the query with some
    > >> name.
    > >>
    > >> In your data access page, use that query as the Recordset data.
    > >> --
    > >>
    > >> Ken Snell
    > >> <MS ACCESS MVP>
    > >>
    > >>
    > >> "Amateur" <Amateur@discussions.microsoft.com> wrote in message
    > >> news:1DD67B5F-843A-47F2-84BD-8BFD70234F6F@microsoft.com...
    > >> > Again sorry, could you be as kind as to tell me how I can create a
    > >> > query
    > >> > based on that table to return just one record? - How does the query has
    > >> > to
    > >> > look like?
    > >> > Thanks Ken - after this I'll not bothering you anymore. (for the
    > >> > moment)
    > >> > Klaus
    > >> >
    > >> > "Ken Snell [MVP]" wrote:
    > >> >
    > >> >> Create a query that will return just that one record. Then use that
    > >> >> query
    > >> >> as
    > >> >> the page's Recordset data source.
    > >> >>
    > >> >> --
    > >> >>
    > >> >> Ken Snell
    > >> >> <MS ACCESS MVP>
    > >> >>
    > >> >> "Amateur" <Amateur@discussions.microsoft.com> wrote in message
    > >> >> news:6150E0FD-201A-4FD5-A421-D22A05E24B5B@microsoft.com...
    > >> >> > Sorry Ken, I used the word filter. Totally wrong !!!!
    > >> >> > Actually, I would like to see on the data access page 1 specific
    > >> >> > record
    > >> >> > from
    > >> >> > the table. It will be always the same record, just updated on a
    > >> >> > daily
    > >> >> > basis.
    > >> >> > Does this help to answer my problem? -
    > >> >> > I try to explain again from the beginning:
    > >> >> > -I have a table with +/- 50 customer records in.
    > >> >> > -All records will be up-dated on a daily basis , BUT
    > >> >> > -only one customer record should be shown on the dataaccess page
    > >> >> > which
    > >> >> > will
    > >> >> > be integrated in a web page on the internet.
    > >> >> > -all other records are not and never shown on the internet.
    > >> >> > Thanks for helping me
    > >> >> > Klaus
    > >> >> > "Ken Snell [MVP]" wrote:
    > >> >> >
    > >> >> >> Filter out which records? How is the data access page supposed to
    > >> >> >> know
    > >> >> >> which
    > >> >> >> record is to be displayed? is it the same record all the time? or
    > >> >> >> is
    > >> >> >> it
    > >> >> >> dependent upon some choice by the user?
    > >> >> >>
    > >> >> >>
    > >> >> >> --
    > >> >> >>
    > >> >> >> Ken Snell
    > >> >> >> <MS ACCESS MVP>
    > >> >> >>
    > >> >> >> "Amateur" <Amateur@discussions.microsoft.com> wrote in message
    > >> >> >> news:40362C22-76C8-4F93-8EBA-DCA94F5BC34F@microsoft.com...
    > >> >> >> >I have a table with different customer records specified by
    > >> >> >> >Customer
    > >> >> >> >ID.
    > >> >> >> > I builded a Data access page with the page wizzard using all
    > >> >> >> > fields
    > >> >> >> > from
    > >> >> >> > that above mentioned table.
    > >> >> >> > The point is: The Data access page should only show one fixed
    > >> >> >> > record
    > >> >> >> > of
    > >> >> >> > that
    > >> >> >> > table (always the same). It should be, if it excist, a "fixed
    > >> >> >> > record
    > >> >> >> > data
    > >> >> >> > access page".
    > >> >> >> > How can I filter all other records out - so that there are not
    > >> >> >> > shown
    > >> >> >> > in
    > >> >> >> > the
    > >> >> >> > page?
    > >> >> >> > Thanks for help
    > >> >> >> >
    > >> >> >> >
    > >> >> >> > "Ken Snell [MVP]" wrote:
    > >> >> >> >
    > >> >> >> >> Yes. How to do it depends upon how you open that data access
    > >> >> >> >> page.
    > >> >> >> >>
    > >> >> >> >> Tell us more details.
    > >> >> >> >>
    > >> >> >> >> --
    > >> >> >> >>
    > >> >> >> >> Ken Snell
    > >> >> >> >> <MS ACCESS MVP>
    > >> >> >> >>
    > >> >> >> >> "Amateur" <Amateur@discussions.microsoft.com> wrote in message
    > >> >> >> >> news:EF0CD256-A48C-4BAE-8CD1-710B5528B974@microsoft.com...
    > >> >> >> >> > Is there any possibility to show in a data access page ONLY
    > >> >> >> >> > one
    > >> >> >> >> > record
    > >> >> >> >> > from a
    > >> >> >> >> > table with multiple records?
    > >> >> >> >> > If yes, maybe someone can tell me how.
    > >> >> >> >> > Thanks Klaus
    > >> >> >> >>
    > >> >> >> >>
    > >> >> >> >>
    > >> >> >>
    > >> >> >>
    > >> >> >>
    > >> >>
    > >> >>
    > >> >>
    > >>
    > >>
    > >>

    >
    >
    >
     
  2. Loading...


  3. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Don't Really know much about DAP but the 'correct' SQL syntax would be Like
    '%''

    Pieter

    "Vista" <Vista@discussions.microsoft.com> wrote in message
    news:737EE8C1-9329-4BD6-9997-56BF86859F39@microsoft.com...
    > Another question about Data Access Pages that are based on Queries:
    >
    > For some reason, everytime I create one from a Query that contains this
    > following Criteria: 'Like "*"' the DAP won't load any records at all.
    > Suggestions?
    >
    > Thank you,
    > Vista
    >
    > "Ken Snell [MVP]" wrote:
    >
    >> Good luck.
    >>
    >> --
    >>
    >> Ken Snell
    >> <MS ACCESS MVP>
    >>
    >> "Amateur" <Amateur@discussions.microsoft.com> wrote in message
    >> news:4D8E6BE0-647A-430F-A839-35987320344D@microsoft.com...
    >> > Thanks Ken everything you wrote today helped me very much.
    >> > Have a nice day
    >> > Klaus
    >> >
    >> > "Ken Snell [MVP]" wrote:
    >> >
    >> >> With no knowledge about your table, the data and fields in it, and
    >> >> which
    >> >> record is supposed to be the one selected, it's fairly difficult.
    >> >>
    >> >> Go to the database window, click on Queries, create a new query in
    >> >> design
    >> >> view, select the appropriate table, drag fields that you want to see
    >> >> onto
    >> >> the grid, put a "Criteria:" expression under the field that is how you
    >> >> decide which record is to be selected, and then save the query with
    >> >> some
    >> >> name.
    >> >>
    >> >> In your data access page, use that query as the Recordset data.
    >> >> --
    >> >>
    >> >> Ken Snell
    >> >> <MS ACCESS MVP>
    >> >>
    >> >>
    >> >> "Amateur" <Amateur@discussions.microsoft.com> wrote in message
    >> >> news:1DD67B5F-843A-47F2-84BD-8BFD70234F6F@microsoft.com...
    >> >> > Again sorry, could you be as kind as to tell me how I can create a
    >> >> > query
    >> >> > based on that table to return just one record? - How does the query
    >> >> > has
    >> >> > to
    >> >> > look like?
    >> >> > Thanks Ken - after this I'll not bothering you anymore. (for the
    >> >> > moment)
    >> >> > Klaus
    >> >> >
    >> >> > "Ken Snell [MVP]" wrote:
    >> >> >
    >> >> >> Create a query that will return just that one record. Then use that
    >> >> >> query
    >> >> >> as
    >> >> >> the page's Recordset data source.
    >> >> >>
    >> >> >> --
    >> >> >>
    >> >> >> Ken Snell
    >> >> >> <MS ACCESS MVP>
    >> >> >>
    >> >> >> "Amateur" <Amateur@discussions.microsoft.com> wrote in message
    >> >> >> news:6150E0FD-201A-4FD5-A421-D22A05E24B5B@microsoft.com...
    >> >> >> > Sorry Ken, I used the word filter. Totally wrong !!!!
    >> >> >> > Actually, I would like to see on the data access page 1 specific
    >> >> >> > record
    >> >> >> > from
    >> >> >> > the table. It will be always the same record, just updated on a
    >> >> >> > daily
    >> >> >> > basis.
    >> >> >> > Does this help to answer my problem? -
    >> >> >> > I try to explain again from the beginning:
    >> >> >> > -I have a table with +/- 50 customer records in.
    >> >> >> > -All records will be up-dated on a daily basis , BUT
    >> >> >> > -only one customer record should be shown on the dataaccess page
    >> >> >> > which
    >> >> >> > will
    >> >> >> > be integrated in a web page on the internet.
    >> >> >> > -all other records are not and never shown on the internet.
    >> >> >> > Thanks for helping me
    >> >> >> > Klaus
    >> >> >> > "Ken Snell [MVP]" wrote:
    >> >> >> >
    >> >> >> >> Filter out which records? How is the data access page supposed
    >> >> >> >> to
    >> >> >> >> know
    >> >> >> >> which
    >> >> >> >> record is to be displayed? is it the same record all the time?
    >> >> >> >> or
    >> >> >> >> is
    >> >> >> >> it
    >> >> >> >> dependent upon some choice by the user?
    >> >> >> >>
    >> >> >> >>
    >> >> >> >> --
    >> >> >> >>
    >> >> >> >> Ken Snell
    >> >> >> >> <MS ACCESS MVP>
    >> >> >> >>
    >> >> >> >> "Amateur" <Amateur@discussions.microsoft.com> wrote in message
    >> >> >> >> news:40362C22-76C8-4F93-8EBA-DCA94F5BC34F@microsoft.com...
    >> >> >> >> >I have a table with different customer records specified by
    >> >> >> >> >Customer
    >> >> >> >> >ID.
    >> >> >> >> > I builded a Data access page with the page wizzard using all
    >> >> >> >> > fields
    >> >> >> >> > from
    >> >> >> >> > that above mentioned table.
    >> >> >> >> > The point is: The Data access page should only show one fixed
    >> >> >> >> > record
    >> >> >> >> > of
    >> >> >> >> > that
    >> >> >> >> > table (always the same). It should be, if it excist, a "fixed
    >> >> >> >> > record
    >> >> >> >> > data
    >> >> >> >> > access page".
    >> >> >> >> > How can I filter all other records out - so that there are not
    >> >> >> >> > shown
    >> >> >> >> > in
    >> >> >> >> > the
    >> >> >> >> > page?
    >> >> >> >> > Thanks for help
    >> >> >> >> >
    >> >> >> >> >
    >> >> >> >> > "Ken Snell [MVP]" wrote:
    >> >> >> >> >
    >> >> >> >> >> Yes. How to do it depends upon how you open that data access
    >> >> >> >> >> page.
    >> >> >> >> >>
    >> >> >> >> >> Tell us more details.
    >> >> >> >> >>
    >> >> >> >> >> --
    >> >> >> >> >>
    >> >> >> >> >> Ken Snell
    >> >> >> >> >> <MS ACCESS MVP>
    >> >> >> >> >>
    >> >> >> >> >> "Amateur" <Amateur@discussions.microsoft.com> wrote in
    >> >> >> >> >> message
    >> >> >> >> >> news:EF0CD256-A48C-4BAE-8CD1-710B5528B974@microsoft.com...
    >> >> >> >> >> > Is there any possibility to show in a data access page ONLY
    >> >> >> >> >> > one
    >> >> >> >> >> > record
    >> >> >> >> >> > from a
    >> >> >> >> >> > table with multiple records?
    >> >> >> >> >> > If yes, maybe someone can tell me how.
    >> >> >> >> >> > Thanks Klaus
    >> >> >> >> >>
    >> >> >> >> >>
    >> >> >> >> >>
    >> >> >> >>
    >> >> >> >>
    >> >> >> >>
    >> >> >>
    >> >> >>
    >> >> >>
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>
     
  4. Vista

    Vista
    Expand Collapse
    Guest

    Thank you Pieter, but my Queries are running fine with the field Criteria
    'Like "*"' which filters out those records that have no data in that field.
    My problem is that, for some unknown reason, the Data Access Pages that I
    create from these Queries are not displaying any records at all. For
    example: I want to limit a DAP to show only the records that have data in the
    "ID Number" field; I create a Query with the Criteria 'Like "*"' in that
    field, and the Query does exactly what I want it to (shows only records that
    have an ID Number); I save that Query as a Data Access Page, but the DAP
    shows no records at all. I'm still hoping for suggestions...

    Vista


    "Pieter Wijnen" wrote:

    > Don't Really know much about DAP but the 'correct' SQL syntax would be Like
    > '%''
    >
    > Pieter
    >
    > "Vista" <Vista@discussions.microsoft.com> wrote in message
    > news:737EE8C1-9329-4BD6-9997-56BF86859F39@microsoft.com...
    > > Another question about Data Access Pages that are based on Queries:
    > >
    > > For some reason, everytime I create one from a Query that contains this
    > > following Criteria: 'Like "*"' the DAP won't load any records at all.
    > > Suggestions?
    > >
    > > Thank you,
    > > Vista
    > >
    > > "Ken Snell [MVP]" wrote:
    > >
    > >> Good luck.
    > >>
    > >> --
    > >>
    > >> Ken Snell
    > >> <MS ACCESS MVP>
    > >>
    > >> "Amateur" <Amateur@discussions.microsoft.com> wrote in message
    > >> news:4D8E6BE0-647A-430F-A839-35987320344D@microsoft.com...
    > >> > Thanks Ken everything you wrote today helped me very much.
    > >> > Have a nice day
    > >> > Klaus
    > >> >
    > >> > "Ken Snell [MVP]" wrote:
    > >> >
    > >> >> With no knowledge about your table, the data and fields in it, and
    > >> >> which
    > >> >> record is supposed to be the one selected, it's fairly difficult.
    > >> >>
    > >> >> Go to the database window, click on Queries, create a new query in
    > >> >> design
    > >> >> view, select the appropriate table, drag fields that you want to see
    > >> >> onto
    > >> >> the grid, put a "Criteria:" expression under the field that is how you
    > >> >> decide which record is to be selected, and then save the query with
    > >> >> some
    > >> >> name.
    > >> >>
    > >> >> In your data access page, use that query as the Recordset data.
    > >> >> --
    > >> >>
    > >> >> Ken Snell
    > >> >> <MS ACCESS MVP>
    > >> >>
    > >> >>
    > >> >> "Amateur" <Amateur@discussions.microsoft.com> wrote in message
    > >> >> news:1DD67B5F-843A-47F2-84BD-8BFD70234F6F@microsoft.com...
    > >> >> > Again sorry, could you be as kind as to tell me how I can create a
    > >> >> > query
    > >> >> > based on that table to return just one record? - How does the query
    > >> >> > has
    > >> >> > to
    > >> >> > look like?
    > >> >> > Thanks Ken - after this I'll not bothering you anymore. (for the
    > >> >> > moment)
    > >> >> > Klaus
    > >> >> >
    > >> >> > "Ken Snell [MVP]" wrote:
    > >> >> >
    > >> >> >> Create a query that will return just that one record. Then use that
    > >> >> >> query
    > >> >> >> as
    > >> >> >> the page's Recordset data source.
    > >> >> >>
    > >> >> >> --
    > >> >> >>
    > >> >> >> Ken Snell
    > >> >> >> <MS ACCESS MVP>
    > >> >> >>
    > >> >> >> "Amateur" <Amateur@discussions.microsoft.com> wrote in message
    > >> >> >> news:6150E0FD-201A-4FD5-A421-D22A05E24B5B@microsoft.com...
    > >> >> >> > Sorry Ken, I used the word filter. Totally wrong !!!!
    > >> >> >> > Actually, I would like to see on the data access page 1 specific
    > >> >> >> > record
    > >> >> >> > from
    > >> >> >> > the table. It will be always the same record, just updated on a
    > >> >> >> > daily
    > >> >> >> > basis.
    > >> >> >> > Does this help to answer my problem? -
    > >> >> >> > I try to explain again from the beginning:
    > >> >> >> > -I have a table with +/- 50 customer records in.
    > >> >> >> > -All records will be up-dated on a daily basis , BUT
    > >> >> >> > -only one customer record should be shown on the dataaccess page
    > >> >> >> > which
    > >> >> >> > will
    > >> >> >> > be integrated in a web page on the internet.
    > >> >> >> > -all other records are not and never shown on the internet.
    > >> >> >> > Thanks for helping me
    > >> >> >> > Klaus
    > >> >> >> > "Ken Snell [MVP]" wrote:
    > >> >> >> >
    > >> >> >> >> Filter out which records? How is the data access page supposed
    > >> >> >> >> to
    > >> >> >> >> know
    > >> >> >> >> which
    > >> >> >> >> record is to be displayed? is it the same record all the time?
    > >> >> >> >> or
    > >> >> >> >> is
    > >> >> >> >> it
    > >> >> >> >> dependent upon some choice by the user?
    > >> >> >> >>
    > >> >> >> >>
    > >> >> >> >> --
    > >> >> >> >>
    > >> >> >> >> Ken Snell
    > >> >> >> >> <MS ACCESS MVP>
    > >> >> >> >>
    > >> >> >> >> "Amateur" <Amateur@discussions.microsoft.com> wrote in message
    > >> >> >> >> news:40362C22-76C8-4F93-8EBA-DCA94F5BC34F@microsoft.com...
    > >> >> >> >> >I have a table with different customer records specified by
    > >> >> >> >> >Customer
    > >> >> >> >> >ID.
    > >> >> >> >> > I builded a Data access page with the page wizzard using all
    > >> >> >> >> > fields
    > >> >> >> >> > from
    > >> >> >> >> > that above mentioned table.
    > >> >> >> >> > The point is: The Data access page should only show one fixed
    > >> >> >> >> > record
    > >> >> >> >> > of
    > >> >> >> >> > that
    > >> >> >> >> > table (always the same). It should be, if it excist, a "fixed
    > >> >> >> >> > record
    > >> >> >> >> > data
    > >> >> >> >> > access page".
    > >> >> >> >> > How can I filter all other records out - so that there are not
    > >> >> >> >> > shown
    > >> >> >> >> > in
    > >> >> >> >> > the
    > >> >> >> >> > page?
    > >> >> >> >> > Thanks for help
    > >> >> >> >> >
    > >> >> >> >> >
    > >> >> >> >> > "Ken Snell [MVP]" wrote:
    > >> >> >> >> >
    > >> >> >> >> >> Yes. How to do it depends upon how you open that data access
    > >> >> >> >> >> page.
    > >> >> >> >> >>
    > >> >> >> >> >> Tell us more details.
    > >> >> >> >> >>
    > >> >> >> >> >> --
    > >> >> >> >> >>
    > >> >> >> >> >> Ken Snell
    > >> >> >> >> >> <MS ACCESS MVP>
    > >> >> >> >> >>
    > >> >> >> >> >> "Amateur" <Amateur@discussions.microsoft.com> wrote in
    > >> >> >> >> >> message
    > >> >> >> >> >> news:EF0CD256-A48C-4BAE-8CD1-710B5528B974@microsoft.com...
    > >> >> >> >> >> > Is there any possibility to show in a data access page ONLY
    > >> >> >> >> >> > one
    > >> >> >> >> >> > record
    > >> >> >> >> >> > from a
    > >> >> >> >> >> > table with multiple records?
    > >> >> >> >> >> > If yes, maybe someone can tell me how.
    > >> >> >> >> >> > Thanks Klaus
    > >> >> >> >> >>
    > >> >> >> >> >>
    > >> >> >> >> >>
    > >> >> >> >>
    > >> >> >> >>
    > >> >> >> >>
    > >> >> >>
    > >> >> >>
    > >> >> >>
    > >> >>
    > >> >>
    > >> >>
    > >>
    > >>
    > >>

    >
    >
    >
     
  5. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Have you tried % instead of *?

    Pieter

    "Vista" <Vista@discussions.microsoft.com> wrote in message
    news:45A104CB-0C8A-441A-9D36-E6535A712DC2@microsoft.com...
    > Thank you Pieter, but my Queries are running fine with the field Criteria
    > 'Like "*"' which filters out those records that have no data in that
    > field.
    > My problem is that, for some unknown reason, the Data Access Pages that I
    > create from these Queries are not displaying any records at all. For
    > example: I want to limit a DAP to show only the records that have data in
    > the
    > "ID Number" field; I create a Query with the Criteria 'Like "*"' in that
    > field, and the Query does exactly what I want it to (shows only records
    > that
    > have an ID Number); I save that Query as a Data Access Page, but the DAP
    > shows no records at all. I'm still hoping for suggestions...
    >
    > Vista
    >
    >
    > "Pieter Wijnen" wrote:
    >
    >> Don't Really know much about DAP but the 'correct' SQL syntax would be
    >> Like
    >> '%''
    >>
    >> Pieter
    >>
    >> "Vista" <Vista@discussions.microsoft.com> wrote in message
    >> news:737EE8C1-9329-4BD6-9997-56BF86859F39@microsoft.com...
    >> > Another question about Data Access Pages that are based on Queries:
    >> >
    >> > For some reason, everytime I create one from a Query that contains this
    >> > following Criteria: 'Like "*"' the DAP won't load any records at all.
    >> > Suggestions?
    >> >
    >> > Thank you,
    >> > Vista
    >> >
    >> > "Ken Snell [MVP]" wrote:
    >> >
    >> >> Good luck.
    >> >>
    >> >> --
    >> >>
    >> >> Ken Snell
    >> >> <MS ACCESS MVP>
    >> >>
    >> >> "Amateur" <Amateur@discussions.microsoft.com> wrote in message
    >> >> news:4D8E6BE0-647A-430F-A839-35987320344D@microsoft.com...
    >> >> > Thanks Ken everything you wrote today helped me very much.
    >> >> > Have a nice day
    >> >> > Klaus
    >> >> >
    >> >> > "Ken Snell [MVP]" wrote:
    >> >> >
    >> >> >> With no knowledge about your table, the data and fields in it, and
    >> >> >> which
    >> >> >> record is supposed to be the one selected, it's fairly difficult.
    >> >> >>
    >> >> >> Go to the database window, click on Queries, create a new query in
    >> >> >> design
    >> >> >> view, select the appropriate table, drag fields that you want to
    >> >> >> see
    >> >> >> onto
    >> >> >> the grid, put a "Criteria:" expression under the field that is how
    >> >> >> you
    >> >> >> decide which record is to be selected, and then save the query with
    >> >> >> some
    >> >> >> name.
    >> >> >>
    >> >> >> In your data access page, use that query as the Recordset data.
    >> >> >> --
    >> >> >>
    >> >> >> Ken Snell
    >> >> >> <MS ACCESS MVP>
    >> >> >>
    >> >> >>
    >> >> >> "Amateur" <Amateur@discussions.microsoft.com> wrote in message
    >> >> >> news:1DD67B5F-843A-47F2-84BD-8BFD70234F6F@microsoft.com...
    >> >> >> > Again sorry, could you be as kind as to tell me how I can create
    >> >> >> > a
    >> >> >> > query
    >> >> >> > based on that table to return just one record? - How does the
    >> >> >> > query
    >> >> >> > has
    >> >> >> > to
    >> >> >> > look like?
    >> >> >> > Thanks Ken - after this I'll not bothering you anymore. (for the
    >> >> >> > moment)
    >> >> >> > Klaus
    >> >> >> >
    >> >> >> > "Ken Snell [MVP]" wrote:
    >> >> >> >
    >> >> >> >> Create a query that will return just that one record. Then use
    >> >> >> >> that
    >> >> >> >> query
    >> >> >> >> as
    >> >> >> >> the page's Recordset data source.
    >> >> >> >>
    >> >> >> >> --
    >> >> >> >>
    >> >> >> >> Ken Snell
    >> >> >> >> <MS ACCESS MVP>
    >> >> >> >>
    >> >> >> >> "Amateur" <Amateur@discussions.microsoft.com> wrote in message
    >> >> >> >> news:6150E0FD-201A-4FD5-A421-D22A05E24B5B@microsoft.com...
    >> >> >> >> > Sorry Ken, I used the word filter. Totally wrong !!!!
    >> >> >> >> > Actually, I would like to see on the data access page 1
    >> >> >> >> > specific
    >> >> >> >> > record
    >> >> >> >> > from
    >> >> >> >> > the table. It will be always the same record, just updated on
    >> >> >> >> > a
    >> >> >> >> > daily
    >> >> >> >> > basis.
    >> >> >> >> > Does this help to answer my problem? -
    >> >> >> >> > I try to explain again from the beginning:
    >> >> >> >> > -I have a table with +/- 50 customer records in.
    >> >> >> >> > -All records will be up-dated on a daily basis , BUT
    >> >> >> >> > -only one customer record should be shown on the dataaccess
    >> >> >> >> > page
    >> >> >> >> > which
    >> >> >> >> > will
    >> >> >> >> > be integrated in a web page on the internet.
    >> >> >> >> > -all other records are not and never shown on the internet.
    >> >> >> >> > Thanks for helping me
    >> >> >> >> > Klaus
    >> >> >> >> > "Ken Snell [MVP]" wrote:
    >> >> >> >> >
    >> >> >> >> >> Filter out which records? How is the data access page
    >> >> >> >> >> supposed
    >> >> >> >> >> to
    >> >> >> >> >> know
    >> >> >> >> >> which
    >> >> >> >> >> record is to be displayed? is it the same record all the
    >> >> >> >> >> time?
    >> >> >> >> >> or
    >> >> >> >> >> is
    >> >> >> >> >> it
    >> >> >> >> >> dependent upon some choice by the user?
    >> >> >> >> >>
    >> >> >> >> >>
    >> >> >> >> >> --
    >> >> >> >> >>
    >> >> >> >> >> Ken Snell
    >> >> >> >> >> <MS ACCESS MVP>
    >> >> >> >> >>
    >> >> >> >> >> "Amateur" <Amateur@discussions.microsoft.com> wrote in
    >> >> >> >> >> message
    >> >> >> >> >> news:40362C22-76C8-4F93-8EBA-DCA94F5BC34F@microsoft.com...
    >> >> >> >> >> >I have a table with different customer records specified by
    >> >> >> >> >> >Customer
    >> >> >> >> >> >ID.
    >> >> >> >> >> > I builded a Data access page with the page wizzard using
    >> >> >> >> >> > all
    >> >> >> >> >> > fields
    >> >> >> >> >> > from
    >> >> >> >> >> > that above mentioned table.
    >> >> >> >> >> > The point is: The Data access page should only show one
    >> >> >> >> >> > fixed
    >> >> >> >> >> > record
    >> >> >> >> >> > of
    >> >> >> >> >> > that
    >> >> >> >> >> > table (always the same). It should be, if it excist, a
    >> >> >> >> >> > "fixed
    >> >> >> >> >> > record
    >> >> >> >> >> > data
    >> >> >> >> >> > access page".
    >> >> >> >> >> > How can I filter all other records out - so that there are
    >> >> >> >> >> > not
    >> >> >> >> >> > shown
    >> >> >> >> >> > in
    >> >> >> >> >> > the
    >> >> >> >> >> > page?
    >> >> >> >> >> > Thanks for help
    >> >> >> >> >> >
    >> >> >> >> >> >
    >> >> >> >> >> > "Ken Snell [MVP]" wrote:
    >> >> >> >> >> >
    >> >> >> >> >> >> Yes. How to do it depends upon how you open that data
    >> >> >> >> >> >> access
    >> >> >> >> >> >> page.
    >> >> >> >> >> >>
    >> >> >> >> >> >> Tell us more details.
    >> >> >> >> >> >>
    >> >> >> >> >> >> --
    >> >> >> >> >> >>
    >> >> >> >> >> >> Ken Snell
    >> >> >> >> >> >> <MS ACCESS MVP>
    >> >> >> >> >> >>
    >> >> >> >> >> >> "Amateur" <Amateur@discussions.microsoft.com> wrote in
    >> >> >> >> >> >> message
    >> >> >> >> >> >> news:EF0CD256-A48C-4BAE-8CD1-710B5528B974@microsoft.com...
    >> >> >> >> >> >> > Is there any possibility to show in a data access page
    >> >> >> >> >> >> > ONLY
    >> >> >> >> >> >> > one
    >> >> >> >> >> >> > record
    >> >> >> >> >> >> > from a
    >> >> >> >> >> >> > table with multiple records?
    >> >> >> >> >> >> > If yes, maybe someone can tell me how.
    >> >> >> >> >> >> > Thanks Klaus
    >> >> >> >> >> >>
    >> >> >> >> >> >>
    >> >> >> >> >> >>
    >> >> >> >> >>
    >> >> >> >> >>
    >> >> >> >> >>
    >> >> >> >>
    >> >> >> >>
    >> >> >> >>
    >> >> >>
    >> >> >>
    >> >> >>
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>
     
  6. Vista

    Vista
    Expand Collapse
    Guest

    Yes, I tried "%" instead, which made my previously-working Queries stop
    showing any records as well. "*" seems to work in Queries, but not Pages.

    Vista

    "Pieter Wijnen" wrote:

    > Have you tried % instead of *?
    >
    > Pieter
    >
    > "Vista" <Vista@discussions.microsoft.com> wrote in message
    > news:45A104CB-0C8A-441A-9D36-E6535A712DC2@microsoft.com...
    > > Thank you Pieter, but my Queries are running fine with the field Criteria
    > > 'Like "*"' which filters out those records that have no data in that
    > > field.
    > > My problem is that, for some unknown reason, the Data Access Pages that I
    > > create from these Queries are not displaying any records at all. For
    > > example: I want to limit a DAP to show only the records that have data in
    > > the
    > > "ID Number" field; I create a Query with the Criteria 'Like "*"' in that
    > > field, and the Query does exactly what I want it to (shows only records
    > > that
    > > have an ID Number); I save that Query as a Data Access Page, but the DAP
    > > shows no records at all. I'm still hoping for suggestions...
    > >
    > > Vista
    > >
    > >
    > > "Pieter Wijnen" wrote:
    > >
    > >> Don't Really know much about DAP but the 'correct' SQL syntax would be
    > >> Like
    > >> '%''
    > >>
    > >> Pieter
    > >>
    > >> "Vista" <Vista@discussions.microsoft.com> wrote in message
    > >> news:737EE8C1-9329-4BD6-9997-56BF86859F39@microsoft.com...
    > >> > Another question about Data Access Pages that are based on Queries:
    > >> >
    > >> > For some reason, everytime I create one from a Query that contains this
    > >> > following Criteria: 'Like "*"' the DAP won't load any records at all.
    > >> > Suggestions?
    > >> >
    > >> > Thank you,
    > >> > Vista
    > >> >
    > >> > "Ken Snell [MVP]" wrote:
    > >> >
    > >> >> Good luck.
    > >> >>
    > >> >> --
    > >> >>
    > >> >> Ken Snell
    > >> >> <MS ACCESS MVP>
    > >> >>
    > >> >> "Amateur" <Amateur@discussions.microsoft.com> wrote in message
    > >> >> news:4D8E6BE0-647A-430F-A839-35987320344D@microsoft.com...
    > >> >> > Thanks Ken everything you wrote today helped me very much.
    > >> >> > Have a nice day
    > >> >> > Klaus
    > >> >> >
    > >> >> > "Ken Snell [MVP]" wrote:
    > >> >> >
    > >> >> >> With no knowledge about your table, the data and fields in it, and
    > >> >> >> which
    > >> >> >> record is supposed to be the one selected, it's fairly difficult.
    > >> >> >>
    > >> >> >> Go to the database window, click on Queries, create a new query in
    > >> >> >> design
    > >> >> >> view, select the appropriate table, drag fields that you want to
    > >> >> >> see
    > >> >> >> onto
    > >> >> >> the grid, put a "Criteria:" expression under the field that is how
    > >> >> >> you
    > >> >> >> decide which record is to be selected, and then save the query with
    > >> >> >> some
    > >> >> >> name.
    > >> >> >>
    > >> >> >> In your data access page, use that query as the Recordset data.
    > >> >> >> --
    > >> >> >>
    > >> >> >> Ken Snell
    > >> >> >> <MS ACCESS MVP>
    > >> >> >>
    > >> >> >>
    > >> >> >> "Amateur" <Amateur@discussions.microsoft.com> wrote in message
    > >> >> >> news:1DD67B5F-843A-47F2-84BD-8BFD70234F6F@microsoft.com...
    > >> >> >> > Again sorry, could you be as kind as to tell me how I can create
    > >> >> >> > a
    > >> >> >> > query
    > >> >> >> > based on that table to return just one record? - How does the
    > >> >> >> > query
    > >> >> >> > has
    > >> >> >> > to
    > >> >> >> > look like?
    > >> >> >> > Thanks Ken - after this I'll not bothering you anymore. (for the
    > >> >> >> > moment)
    > >> >> >> > Klaus
    > >> >> >> >
    > >> >> >> > "Ken Snell [MVP]" wrote:
    > >> >> >> >
    > >> >> >> >> Create a query that will return just that one record. Then use
    > >> >> >> >> that
    > >> >> >> >> query
    > >> >> >> >> as
    > >> >> >> >> the page's Recordset data source.
    > >> >> >> >>
    > >> >> >> >> --
    > >> >> >> >>
    > >> >> >> >> Ken Snell
    > >> >> >> >> <MS ACCESS MVP>
    > >> >> >> >>
    > >> >> >> >> "Amateur" <Amateur@discussions.microsoft.com> wrote in message
    > >> >> >> >> news:6150E0FD-201A-4FD5-A421-D22A05E24B5B@microsoft.com...
    > >> >> >> >> > Sorry Ken, I used the word filter. Totally wrong !!!!
    > >> >> >> >> > Actually, I would like to see on the data access page 1
    > >> >> >> >> > specific
    > >> >> >> >> > record
    > >> >> >> >> > from
    > >> >> >> >> > the table. It will be always the same record, just updated on
    > >> >> >> >> > a
    > >> >> >> >> > daily
    > >> >> >> >> > basis.
    > >> >> >> >> > Does this help to answer my problem? -
    > >> >> >> >> > I try to explain again from the beginning:
    > >> >> >> >> > -I have a table with +/- 50 customer records in.
    > >> >> >> >> > -All records will be up-dated on a daily basis , BUT
    > >> >> >> >> > -only one customer record should be shown on the dataaccess
    > >> >> >> >> > page
    > >> >> >> >> > which
    > >> >> >> >> > will
    > >> >> >> >> > be integrated in a web page on the internet.
    > >> >> >> >> > -all other records are not and never shown on the internet.
    > >> >> >> >> > Thanks for helping me
    > >> >> >> >> > Klaus
    > >> >> >> >> > "Ken Snell [MVP]" wrote:
    > >> >> >> >> >
    > >> >> >> >> >> Filter out which records? How is the data access page
    > >> >> >> >> >> supposed
    > >> >> >> >> >> to
    > >> >> >> >> >> know
    > >> >> >> >> >> which
    > >> >> >> >> >> record is to be displayed? is it the same record all the
    > >> >> >> >> >> time?
    > >> >> >> >> >> or
    > >> >> >> >> >> is
    > >> >> >> >> >> it
    > >> >> >> >> >> dependent upon some choice by the user?
    > >> >> >> >> >>
    > >> >> >> >> >>
    > >> >> >> >> >> --
    > >> >> >> >> >>
    > >> >> >> >> >> Ken Snell
    > >> >> >> >> >> <MS ACCESS MVP>
    > >> >> >> >> >>
    > >> >> >> >> >> "Amateur" <Amateur@discussions.microsoft.com> wrote in
    > >> >> >> >> >> message
    > >> >> >> >> >> news:40362C22-76C8-4F93-8EBA-DCA94F5BC34F@microsoft.com...
    > >> >> >> >> >> >I have a table with different customer records specified by
    > >> >> >> >> >> >Customer
    > >> >> >> >> >> >ID.
    > >> >> >> >> >> > I builded a Data access page with the page wizzard using
    > >> >> >> >> >> > all
    > >> >> >> >> >> > fields
    > >> >> >> >> >> > from
    > >> >> >> >> >> > that above mentioned table.
    > >> >> >> >> >> > The point is: The Data access page should only show one
    > >> >> >> >> >> > fixed
    > >> >> >> >> >> > record
    > >> >> >> >> >> > of
    > >> >> >> >> >> > that
    > >> >> >> >> >> > table (always the same). It should be, if it excist, a
    > >> >> >> >> >> > "fixed
    > >> >> >> >> >> > record
    > >> >> >> >> >> > data
    > >> >> >> >> >> > access page".
    > >> >> >> >> >> > How can I filter all other records out - so that there are
    > >> >> >> >> >> > not
    > >> >> >> >> >> > shown
    > >> >> >> >> >> > in
    > >> >> >> >> >> > the
    > >> >> >> >> >> > page?
    > >> >> >> >> >> > Thanks for help
    > >> >> >> >> >> >
    > >> >> >> >> >> >
    > >> >> >> >> >> > "Ken Snell [MVP]" wrote:
    > >> >> >> >> >> >
    > >> >> >> >> >> >> Yes. How to do it depends upon how you open that data
    > >> >> >> >> >> >> access
    > >> >> >> >> >> >> page.
    > >> >> >> >> >> >>
    > >> >> >> >> >> >> Tell us more details.
    > >> >> >> >> >> >>
    > >> >> >> >> >> >> --
    > >> >> >> >> >> >>
    > >> >> >> >> >> >> Ken Snell
    > >> >> >> >> >> >> <MS ACCESS MVP>
    > >> >> >> >> >> >>
    > >> >> >> >> >> >> "Amateur" <Amateur@discussions.microsoft.com> wrote in
    > >> >> >> >> >> >> message
    > >> >> >> >> >> >> news:EF0CD256-A48C-4BAE-8CD1-710B5528B974@microsoft.com...
    > >> >> >> >> >> >> > Is there any possibility to show in a data access page
    > >> >> >> >> >> >> > ONLY
    > >> >> >> >> >> >> > one
    > >> >> >> >> >> >> > record
    > >> >> >> >> >> >> > from a
    > >> >> >> >> >> >> > table with multiple records?
    > >> >> >> >> >> >> > If yes, maybe someone can tell me how.
    > >> >> >> >> >> >> > Thanks Klaus
    > >> >> >> >> >> >>
    > >> >> >> >> >> >>
    > >> >> >> >> >> >>
    > >> >> >> >> >>
    > >> >> >> >> >>
    > >> >> >> >> >>
    > >> >> >> >>
    > >> >> >> >>
    > >> >> >> >>
    > >> >> >>
    > >> >> >>
    > >> >> >>
    > >> >>
    > >> >>
    > >> >>
    > >>
    > >>
    > >>

    >
    >
    >
     
  7. Vista

    Vista
    Expand Collapse
    Guest

    I'm still trying to resolve my problem. The Data Access Pages that I've
    created from Queries (with Criteria of 'Like "*"') are not retrieving any
    records, even though the founding Queries are working just fine. Any ideas
    on the reason for this?

    Also, it seems that some of the computers on my network can make changes to
    records by using Data Access Pages, but some cannot. How can I make sure
    that changes CAN be made to the Database of records through the use of Data
    Access Pages? (I don't want the rest of my network to have access to the
    Access program itself.)

    Vista


    "Vista" wrote:

    > Yes, I tried "%" instead, which made my previously-working Queries stop
    > showing any records as well. "*" seems to work in Queries, but not Pages.
    >
    > Vista
    >
    > "Pieter Wijnen" wrote:
    >
    > > Have you tried % instead of *?
    > >
    > > Pieter
    > >
    > > "Vista" <Vista@discussions.microsoft.com> wrote in message
    > > news:45A104CB-0C8A-441A-9D36-E6535A712DC2@microsoft.com...
    > > > Thank you Pieter, but my Queries are running fine with the field Criteria
    > > > 'Like "*"' which filters out those records that have no data in that
    > > > field.
    > > > My problem is that, for some unknown reason, the Data Access Pages that I
    > > > create from these Queries are not displaying any records at all. For
    > > > example: I want to limit a DAP to show only the records that have data in
    > > > the
    > > > "ID Number" field; I create a Query with the Criteria 'Like "*"' in that
    > > > field, and the Query does exactly what I want it to (shows only records
    > > > that
    > > > have an ID Number); I save that Query as a Data Access Page, but the DAP
    > > > shows no records at all. I'm still hoping for suggestions...
    > > >
    > > > Vista
    > > >
    > > >
    > > > "Pieter Wijnen" wrote:
    > > >
    > > >> Don't Really know much about DAP but the 'correct' SQL syntax would be
    > > >> Like
    > > >> '%''
    > > >>
    > > >> Pieter
    > > >>
    > > >> "Vista" <Vista@discussions.microsoft.com> wrote in message
    > > >> news:737EE8C1-9329-4BD6-9997-56BF86859F39@microsoft.com...
    > > >> > Another question about Data Access Pages that are based on Queries:
    > > >> >
    > > >> > For some reason, everytime I create one from a Query that contains this
    > > >> > following Criteria: 'Like "*"' the DAP won't load any records at all.
    > > >> > Suggestions?
    > > >> >
    > > >> > Thank you,
    > > >> > Vista
    > > >> >
    > > >> > "Ken Snell [MVP]" wrote:
    > > >> >
    > > >> >> Good luck.
    > > >> >>
    > > >> >> --
    > > >> >>
    > > >> >> Ken Snell
    > > >> >> <MS ACCESS MVP>
    > > >> >>
    > > >> >> "Amateur" <Amateur@discussions.microsoft.com> wrote in message
    > > >> >> news:4D8E6BE0-647A-430F-A839-35987320344D@microsoft.com...
    > > >> >> > Thanks Ken everything you wrote today helped me very much.
    > > >> >> > Have a nice day
    > > >> >> > Klaus
    > > >> >> >
    > > >> >> > "Ken Snell [MVP]" wrote:
    > > >> >> >
    > > >> >> >> With no knowledge about your table, the data and fields in it, and
    > > >> >> >> which
    > > >> >> >> record is supposed to be the one selected, it's fairly difficult.
    > > >> >> >>
    > > >> >> >> Go to the database window, click on Queries, create a new query in
    > > >> >> >> design
    > > >> >> >> view, select the appropriate table, drag fields that you want to
    > > >> >> >> see
    > > >> >> >> onto
    > > >> >> >> the grid, put a "Criteria:" expression under the field that is how
    > > >> >> >> you
    > > >> >> >> decide which record is to be selected, and then save the query with
    > > >> >> >> some
    > > >> >> >> name.
    > > >> >> >>
    > > >> >> >> In your data access page, use that query as the Recordset data.
    > > >> >> >> --
    > > >> >> >>
    > > >> >> >> Ken Snell
    > > >> >> >> <MS ACCESS MVP>
    > > >> >> >>
    > > >> >> >>
    > > >> >> >> "Amateur" <Amateur@discussions.microsoft.com> wrote in message
    > > >> >> >> news:1DD67B5F-843A-47F2-84BD-8BFD70234F6F@microsoft.com...
    > > >> >> >> > Again sorry, could you be as kind as to tell me how I can create
    > > >> >> >> > a
    > > >> >> >> > query
    > > >> >> >> > based on that table to return just one record? - How does the
    > > >> >> >> > query
    > > >> >> >> > has
    > > >> >> >> > to
    > > >> >> >> > look like?
    > > >> >> >> > Thanks Ken - after this I'll not bothering you anymore. (for the
    > > >> >> >> > moment)
    > > >> >> >> > Klaus
    > > >> >> >> >
    > > >> >> >> > "Ken Snell [MVP]" wrote:
    > > >> >> >> >
    > > >> >> >> >> Create a query that will return just that one record. Then use
    > > >> >> >> >> that
    > > >> >> >> >> query
    > > >> >> >> >> as
    > > >> >> >> >> the page's Recordset data source.
    > > >> >> >> >>
    > > >> >> >> >> --
    > > >> >> >> >>
    > > >> >> >> >> Ken Snell
    > > >> >> >> >> <MS ACCESS MVP>
    > > >> >> >> >>
    > > >> >> >> >> "Amateur" <Amateur@discussions.microsoft.com> wrote in message
    > > >> >> >> >> news:6150E0FD-201A-4FD5-A421-D22A05E24B5B@microsoft.com...
    > > >> >> >> >> > Sorry Ken, I used the word filter. Totally wrong !!!!
    > > >> >> >> >> > Actually, I would like to see on the data access page 1
    > > >> >> >> >> > specific
    > > >> >> >> >> > record
    > > >> >> >> >> > from
    > > >> >> >> >> > the table. It will be always the same record, just updated on
    > > >> >> >> >> > a
    > > >> >> >> >> > daily
    > > >> >> >> >> > basis.
    > > >> >> >> >> > Does this help to answer my problem? -
    > > >> >> >> >> > I try to explain again from the beginning:
    > > >> >> >> >> > -I have a table with +/- 50 customer records in.
    > > >> >> >> >> > -All records will be up-dated on a daily basis , BUT
    > > >> >> >> >> > -only one customer record should be shown on the dataaccess
    > > >> >> >> >> > page
    > > >> >> >> >> > which
    > > >> >> >> >> > will
    > > >> >> >> >> > be integrated in a web page on the internet.
    > > >> >> >> >> > -all other records are not and never shown on the internet.
    > > >> >> >> >> > Thanks for helping me
    > > >> >> >> >> > Klaus
    > > >> >> >> >> > "Ken Snell [MVP]" wrote:
    > > >> >> >> >> >
    > > >> >> >> >> >> Filter out which records? How is the data access page
    > > >> >> >> >> >> supposed
    > > >> >> >> >> >> to
    > > >> >> >> >> >> know
    > > >> >> >> >> >> which
    > > >> >> >> >> >> record is to be displayed? is it the same record all the
    > > >> >> >> >> >> time?
    > > >> >> >> >> >> or
    > > >> >> >> >> >> is
    > > >> >> >> >> >> it
    > > >> >> >> >> >> dependent upon some choice by the user?
    > > >> >> >> >> >>
    > > >> >> >> >> >>
    > > >> >> >> >> >> --
    > > >> >> >> >> >>
    > > >> >> >> >> >> Ken Snell
    > > >> >> >> >> >> <MS ACCESS MVP>
    > > >> >> >> >> >>
    > > >> >> >> >> >> "Amateur" <Amateur@discussions.microsoft.com> wrote in
    > > >> >> >> >> >> message
    > > >> >> >> >> >> news:40362C22-76C8-4F93-8EBA-DCA94F5BC34F@microsoft.com...
    > > >> >> >> >> >> >I have a table with different customer records specified by
    > > >> >> >> >> >> >Customer
    > > >> >> >> >> >> >ID.
    > > >> >> >> >> >> > I builded a Data access page with the page wizzard using
    > > >> >> >> >> >> > all
    > > >> >> >> >> >> > fields
    > > >> >> >> >> >> > from
    > > >> >> >> >> >> > that above mentioned table.
    > > >> >> >> >> >> > The point is: The Data access page should only show one
    > > >> >> >> >> >> > fixed
    > > >> >> >> >> >> > record
    > > >> >> >> >> >> > of
    > > >> >> >> >> >> > that
    > > >> >> >> >> >> > table (always the same). It should be, if it excist, a
    > > >> >> >> >> >> > "fixed
    > > >> >> >> >> >> > record
    > > >> >> >> >> >> > data
    > > >> >> >> >> >> > access page".
    > > >> >> >> >> >> > How can I filter all other records out - so that there are
    > > >> >> >> >> >> > not
    > > >> >> >> >> >> > shown
    > > >> >> >> >> >> > in
    > > >> >> >> >> >> > the
    > > >> >> >> >> >> > page?
    > > >> >> >> >> >> > Thanks for help
    > > >> >> >> >> >> >
    > > >> >> >> >> >> >
    > > >> >> >> >> >> > "Ken Snell [MVP]" wrote:
    > > >> >> >> >> >> >
    > > >> >> >> >> >> >> Yes. How to do it depends upon how you open that data
    > > >> >> >> >> >> >> access
    > > >> >> >> >> >> >> page.
    > > >> >> >> >> >> >>
    > > >> >> >> >> >> >> Tell us more details.
    > > >> >> >> >> >> >>
    > > >> >> >> >> >> >> --
    > > >> >> >> >> >> >>
    > > >> >> >> >> >> >> Ken Snell
    > > >> >> >> >> >> >> <MS ACCESS MVP>
    > > >> >> >> >> >> >>
    > > >> >> >> >> >> >> "Amateur" <Amateur@discussions.microsoft.com> wrote in
    > > >> >> >> >> >> >> message
    > > >> >> >> >> >> >> news:EF0CD256-A48C-4BAE-8CD1-710B5528B974@microsoft.com...
    > > >> >> >> >> >> >> > Is there any possibility to show in a data access page
    > > >> >> >> >> >> >> > ONLY
    > > >> >> >> >> >> >> > one
    > > >> >> >> >> >> >> > record
    > > >> >> >> >> >> >> > from a
    > > >> >> >> >> >> >> > table with multiple records?
    > > >> >> >> >> >> >> > If yes, maybe someone can tell me how.
    > > >> >> >> >> >> >> > Thanks Klaus
    > > >> >> >> >> >> >>
    > > >> >> >> >> >> >>
    > > >> >> >> >> >> >>
    > > >> >> >> >> >>
    > > >> >> >> >> >>
    > > >> >> >> >> >>
    > > >> >> >> >>
    > > >> >> >> >>
    > > >> >> >> >>
    > > >> >> >>
    > > >> >> >>
    > > >> >> >>
    > > >> >>
    > > >> >>
    > > >> >>
    > > >>
    > > >>
    > > >>

    > >
    > >
    > >
     

Share This Page