Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data Access Pages Hyperlink Wizard

Status
Not open for further replies.

Valori

Technical User
Joined
Sep 10, 2001
Messages
7
Location
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top