I need a drop-down list that has hyperlinks as values and passes the values onto another Data Access Page as a filter. I am submitting this for the third time. I wish I can give more than 500 points but I can't.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
now, in regards to your question, can you give a bit more details about what you have:
I assume ms access as database (and a table with the values for the drop-down?)
how do you call the other page from the drop down? what do you want to be passed?
do you know how to pass data from one page to another?
ok, thanks, I have an MS Access Database which has a table for the values from the drop down. I am trying to click on the drop down select a value and that will open up another page and filter records based on the value I selected on the previous page.
I want to call the other page from the drop down through a hyperlink, that is on the afteraction of the drop down, a hyperlink connects to page #2. I want to pass the value from page#1 from the drop down to page #2 as the filter criteria for the records. No I do not know how to pass data from one page to another.
I don't know where you got the idea of using "hyperlink" here, in access, you just create a short vba macro on the dropdown's selection changed/itemclick events, and open the other form, and set the form's filter criteria...
Private Sub Combo0_Change()
Dim f As Form_Page2Form
set f = new Form_Page2Form <<< create a (new) instance of page2
f.FilterOn = False <<< disable any existing filter
f.Filter = " somefield = somevalue " <<< this will be based on the criteria in Page1
f.FilterOn = True <<< apply the filter
f.Visible = True <<<< show the form
End Sub
by the way, thanks for responding I do realize this is an all volunteer system, I have unlimited points and I willing to share as many as I can today since I am under a little pressure here to get this data access page working.
I have several more questions and wouldn't mind giving you all of the 500 points for each question.
"...I will be using data access pages via Internet Explorer,..."
Is this a web-based application? Or is it an internal network?
If it's the former, you're going to find that Access macros and the web don't mix very well. ASP can't tell an Access database to run a macro or a procedure in a module the same way it can tell a SQL database to run a stored procedure (or rather, it couldn't as of Access2000 -- that could have changed).
Jim is largely correct in saying that generally, most ASP people will use some other database for a web application, but using Access isn't impossible or even unsatisfactory if you're not expecting a ton of traffic. In your case, I would highly recommend you consider using ASP. Doing what you want to do isn't really difficult, but using Data Access Pages is going to make it so. If you want, we can get the Moderators or the Zone Advisor to cross-post this for you.
JMHO,
ep
ericpete, you are exactly right, this application will be on an internal network for only a few users. Please see if the moderators or the Zone Advisor can cross post this so I can get some feedback on how to do it using Data Access Page, I gues the reason why I want to use Data Access Pages is because it seems so much simpler, Is there another way to do it?
VBDATAMAN,
You could remove it from SQL Query Syntax or Architecture/Design; the issue has little or nothing to do with it. But I don't think that's really your best solution. It DOES have to do with Forms, but your best bet is to post it in the top level Access zone. Perhaps angelIII would be so good as to take care of that.
"...I gues the reason why I want to use Data Access Pages is because it seems so much simpler.."
I suppose that's reasonable. The problem is that you can't get there from here. For what you want to do, forms are the way to go.
Somewhere around here, I have an app that has a form that essentially does what you want yours to do: You want to have information displayed based on the selection of an item from a list, as I understand it.
So... it's not really that complicated. You build your list box. You do a series commands based on the selection (it's been a while since I actually had to do this, so I'm just going to post the framework, but I can dig up specific code, or one of the real Experts can help you as well).
Then you create a module for that list box that says
Case (SelectionMadeFromList)
Case1: DoThisStuff
Case2: DoSomethingElse
Case3: DoSomethingEntirelyDiffere
End Case
You can also do it with a series of If/Then/Else statements. But you can use each Case to build a series of functions, including opening a different form or, if you're really tricky and the source information is the same, use the same form with hidden fields that become visible only when you need them.
ep
"so the only thing you can do is to post a pointer question in any other zone(s) and point it to this question"
I am sorry but I am a newbie and I do not know how to do this. As for the forms, I know how to do it in the forms with no problem, I used if statements. What I can't figure out is how to do it on Data Access Pages. I am going to try and do it with ASP and see how far I get.
Code and ample comments are on this live example page.
http://www.rodsdot.com/ee/
Regards,
Rod
Ans a version that does not require JavaScript, but will require a submit button.
http://www.rodsdot.com/ee/
A few questions please:
1) Do the hyperlinks come from a table or do you use a static list?
2) If you use a table, does that table have an auto-increment field?
3) Using filters may not be the best approach with a web application. Using the passed parameter in a WHERE clause on the receiving page may be a better option.
I am asking for the following reasons:
If you are using a static list, then you will just do something like this:
<select name="strURL">
<option value="http://www.cnn.com"
<option value="http://www.mnsbc.co
<option value="http://www.pbs.org"
</select>
If you are taking the value from the database, you have two options:
a) if you have no auto increment field, then you would have to do something like this:
<select name="strURL">
<%
do while not objRS.eof
response.write("<option value=""" & objRS("strURL") & """>" & objRS("strURLFriendlyName"
objRS.MoveNext
Loop
%>
b) if you have an auto increment field, I would use that instead of the actual URL. You could then pass the integer ID to the receiving page as a parameter instead.
In any event, if you would be willing to post the table name and the name and types of your fields, someone here will point you in the right direction.
FtB
Business Accounts
Answer for Membership
by: VBDATAMANPosted on 2007-07-31 at 13:57:56ID: 19604184
ok I can try and attemt to answer myself but I will wait a couple of minutes