Data Access Pages Hyperlink Wizard

[Valori]

I have created two Data Access Pages each based on queries that I put together in a database that I didn't put together. I still don't understand the entire database because there is unused tables, duplicated entries, etc. (A generally poor design). My queries give me the information I want and when I create a subdata sheet from the general to the specific - it works great. Each data sheet works great, but...
The hyperlink help files say that if I put the link in with the display of the record in the first (general) page and write a WHERE clause in the window, it will open up the specific page at the specific record.

my where clause is simply

[CompanyName] = CompanyName

This seems to be the method recommended by the help file.
But when the second sheet opens there is nothing displayed in the fields. I can see the address in the top of explorer

C:\Documents and Settings\vz50240\My Documents\VZPart Rejection Detail.htm?ServerFilter="266010-1003 = CompanyName"

So it looks like its trying. I played around for months and can't find the trick. Any suggestions, I'm not a programmer so I don't even know where to enter any VB code.

Thanks for any help
Valori

 

[krappleby025]

can you provide a better statement, i do not understand, is this supposed to be all on a website, or is it on a private hard drive, etc,etc, and can you provide an example of the script you have at the moment, this may help in solving the problem
thankx

 

[Valori]

Thanks krappleby025,
I'll see if I can clarify at all. These pages are for an Intranet site. Currently I'm working on them locally. I have used the hyperlink tool in the design view of Data Access Pages in Microsoft Access. The help file states --

Create a hyperlink from one data access page to another in the current database
Open a data access page in Design view.
On the Insert menu, click Hyperlink.
In the Insert Hyperlink dialog box, click Page in this database under Link to.
From the list, select the data access page you want to link to.
To create a filter for the data access page, type an expression in the form of a WHERE clause in the Filter criteria for the data access page box. For example, if you have a data access page that displays order information, including the ID of the salesperson, and you want to link to a second data access page with the employee record about that salesperson, type EmployeeID=[EmployeeID].
Click OK.
Microsoft Access adds the hyperlink to the data access page. To test the link, switch to Page view and click the hyperlink. Microsoft Access opens the target page in your Web browser.


I get to the data access page but the field "Company Name" is blank and no records will disply. I've tried turning the query to a parameter query an I get to the data access page and get a dialog box to enter the value. But, it seems that this hyperlink function is supposed to enter the value for the user. I just don't get why it wouldn't work.

 

[krappleby025]

ok i dont actually know if i can help.... This appears to be an access database, yes, or is it an asp page, which connects to an access database.
if it is the later i may be able to help, but as for the first this being in an access database, i am sorry but i cannot help with that........

if you are using an asp page, are you trying to hyperlink from a link that is generated in a list of results from the database. for example

record link

1 link
2 link
3 link
4 link

then when someone clicks on the link the record vaiable say the number is passed to the next page......

is this what you are trying to do

 

[Valori]

Yes it is an Access database, and yes, that is what I'm trying to do. I haven't worked with asp pages. Can you recommend a good place to start?

 

[krappleby025]

i do not know if it will help but you could try

http://search.office.microsoft.com/assistance/product.aspx?p=Access