If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Generating a one-record ouptut from a query-based data access page
Hi all,
I have Access 2002, running on Windows XP Professional. The example I've been using to describe my database is a library, where each book has a specific reference number. I have a table with some information about each book (title, author, year, number of pages). I have a query that will show all books where, for example, the title begins with a specific letter. I've produced a data access page, based on this query, that shows all the books that correspond to the query. So far, it's all going great and everything is working. The first restriction is, I need to have this database run off of a CD, as this is highly confidential information and it can't be on any servers. The second restriction is that I have absolutely no experience with VB, Java, or other such languages, or with XML. I've hard-coded HTML and have no problems with that, but scripting is beyond what I know now. What I want to be able to do is, within the data access page that results from my query for all books starting with, say, F, for each of those listings have a link to a data page that presents other, additional information about that book only. So, the results of a query on my data access page look like: (title followed by ID number) Farther from home, 123.4 Fathers and sons, 234.5 Flying away, 345.6 and so on. I then want to be able to click on something (a field in the listing for each book? A link? whatever it is, doesn't matter) in a specific listing, that will link to a page/query/report that gives me more info on *only* that book. So if I want more info on "Flying away," clicking on the link/button/field in the listing for "Flying away" gives me a new data access page that has binding type, edition, cover condition, review, similar to other books (which would then be linked), and so on. But only for Flying away, not for Farther from home or for Fathers and sons. I followed the instructions in the help file for creating a hyperlink to another data access page in which records are filtered after the query is run (create a filter for the target access page, by clicking on "server filter".) It did work, to an extent, in that doing this created a link to a target access page. No problems. But, when I ran the query it asked me for the query parameter twice (probably because the query parameter and the server filter parameter were the same thing), and when I clicked on the link in the "Flying away" record, the target data access page had information for *all* the books on the initial query data access page. Is there a painless, no-server-involved way to limit this to producing the extra info for only the specific record I want? And, without putting it on a server? Many, many thanks for any help! Elizabeth |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Moving from xBase/Clipper | [email protected] | New Users | 1 | February 3rd, 2005 07:25 PM |
Big number gives error! | Sara Mellen | Running & Setting Up Queries | 8 | October 11th, 2004 02:48 AM |
Taher | Setting Up & Running Reports | 1 | August 31st, 2004 09:07 PM | |
Report Based Upon Parameter Query with Form References | Vincent DeLuca | Setting Up & Running Reports | 4 | July 19th, 2004 01:55 AM |
Newbie? Do I use Report or Query | John Egan | New Users | 11 | June 28th, 2004 08:31 PM |