E
Elizabeth S
I have a database that I have recently built. I have a query, accessible by
a data access page, that presents only certain records (all books beginning
with F, for example).
This database needs to be run client-side only.
What I now want to do is, in each record on the data access page that shows
the results of my query, have a link to a second data access page *for that
record only*. If I have 10 books starting with F, I want the second data
access page to show only the full record for the book I am interested in.
I tried setting a "server filter" as shown in the Help documentation, and
while it produced all the information I wanted it to, it produced the
information on *all* the books, not just on the one I was interested in.
My workaround would be to hard-code an HTML page with the full information
on it, and have it linked, but I can't use links like that on a data access
page, so that's no help.
My users will have read-only access, and are not computer experts, so
working with queries through data access pages seemed like the best solution.
But not being able to put in a usable link to an HTML page anywhere other
than in the form completely removes the usefulness of Access for this project.
I appreciate any ideas anyone could suggest!
Best regards,
Elizabeth
a data access page, that presents only certain records (all books beginning
with F, for example).
This database needs to be run client-side only.
What I now want to do is, in each record on the data access page that shows
the results of my query, have a link to a second data access page *for that
record only*. If I have 10 books starting with F, I want the second data
access page to show only the full record for the book I am interested in.
I tried setting a "server filter" as shown in the Help documentation, and
while it produced all the information I wanted it to, it produced the
information on *all* the books, not just on the one I was interested in.
My workaround would be to hard-code an HTML page with the full information
on it, and have it linked, but I can't use links like that on a data access
page, so that's no help.
My users will have read-only access, and are not computer experts, so
working with queries through data access pages seemed like the best solution.
But not being able to put in a usable link to an HTML page anywhere other
than in the form completely removes the usefulness of Access for this project.
I appreciate any ideas anyone could suggest!
Best regards,
Elizabeth