A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Generating a one-record ouptut from a query-based data access page



 
 
Thread Tools Display Modes
  #1  
Old February 15th, 2005, 05:15 PM
Elizabeth S
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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
Print 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


All times are GMT +1. The time now is 12:13 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.