I have a form where the first field is a dynamic drop-down that pulls
from a db (Access). The fields associated with the query are task_id,
task_name and task_rate. The field has the value of "task_id" and the
label of "task_name" .
In the second form field, I would like the default value to be
determined by the selection made in the first field. Based on the
selection of the first form field, I would like the default value of
the this field (task_rate) to be populated with the associated
task_rate value of the selection chosen above.
Any suggestions?
Thanks
Brett 9 3862
Brett_A wrote on 18 apr 2008 in microsoft.publi c.inetserver.as p.general:
I have a form where the first field is a dynamic drop-down that pulls
from a db (Access). The fields associated with the query are task_id,
task_name and task_rate. The field has the value of "task_id" and the
label of "task_name" .
In the second form field, I would like the default value to be
determined by the selection made in the first field. Based on the
selection of the first form field, I would like the default value of
the this field (task_rate) to be populated with the associated
task_rate value of the selection chosen above.
Any suggestions?
If this is a serverside code problem, show your code,
if it is clientside code or a html Q, ask elsewhere.
--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)
On Apr 18, 12:59 pm, "Evertjan." <exjxw.hannivo. ..@interxnl.net >
wrote:
Brett_A wrote on 18 apr 2008 in microsoft.publi c.inetserver.as p.general:
I have a form where the first field is a dynamic drop-down that pulls
from a db (Access). The fields associated with the query are task_id,
task_name and task_rate. The field has the value of "task_id" and the
label of "task_name" .
In the second form field, I would like the default value to be
determined by the selection made in the first field. Based on the
selection of the first form field, I would like the default value of
the this field (task_rate) to be populated with the associated
task_rate value of the selection chosen above.
Any suggestions?
If this is a serverside code problem, show your code,
if it is clientside code or a html Q, ask elsewhere.
--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)
Are for frik'n real Evertjan?
This is an ASP forum, I'm asking an ASP question.
I don't have the code because I need some direction on how to write
the code. Did you read my question? Do you understand my question?
Did I say I already have code that isn't working?
I explain what I want and ask for suggestions. If my question isn't
clear, than I need to fix it.
Thanks
Brett
Brett_A wrote:
I have a form where the first field is a dynamic drop-down that pulls
from a db (Access). The fields associated with the query are task_id,
task_name and task_rate. The field has the value of "task_id" and the
label of "task_name" .
In the second form field, I would like the default value to be
determined by the selection made in the first field. Based on the
selection of the first form field, I would like the default value of
the this field (task_rate) to be populated with the associated
task_rate value of the selection chosen above.
This is typically done in client-side code so it is more appropriately
asked in a client-side scripting group such as
microsoft.publi c.scripting.jsc ript
However, you can look here to get a head start and narrow your question
down to more specific issues: http://classicasp.aspfaq.com/forms/h...n-another.html
While the client-side scripting is the major part of the solution, there
may be server-side asp issues as well that we will be happy to address
here.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Brett_A wrote on 18 apr 2008 in microsoft.publi c.inetserver.as p.general:
On Apr 18, 12:59 pm, "Evertjan." <exjxw.hannivo. ..@interxnl.net >
wrote:
>Brett_A wrote on 18 apr 2008 in microsoft.publ ic.inetserver.a sp.general:
I have a form where the first field is a dynamic drop-down that
pulls from a db (Access). The fields associated with the query are
task_id, task_name and task_rate. The field has the value of
"task_id" and the label of "task_name" .
In the second form field, I would like the default value to be
determined by the selection made in the first field. Based on the
selection of the first form field, I would like the default value
of the this field (task_rate) to be populated with the associated
task_rate value of the selection chosen above.
Any suggestions?
If this is a serverside code problem, show your code, if it is clientside code or a html Q, ask elsewhere.
[please do not quote signatures on usenet]
Are for frik'n real Evertjan?
Getting angry usually shows getting angry at yourself.
Don't, it does not help you.
This is an ASP forum, I'm asking an ASP question.
How can we be sure, Bret?
Many a time Qs are asked in the wrong NG.
Your Q does not specify it as such.
I don't have the code because I need some direction on how to write
the code.
So?
Did you read my question?
Yes
Do you understand my question?
Not completely, it seems not directed at a serverside problem.
Could you specify the serverside Q?
It seeme you want dynamically changing formfields content.
Did I say I already have code that isn't working?
Should you?
Yes you should.
This NG usually helps people that get stuck,
but usually does not write code for others out of the blue.
I explain what I want and ask for suggestions. If my question isn't
clear, than I need to fix it.
Help yourself.
you wrote:
In the second form field, I would like the default value to be
determined by the selection made in the first field. Based on the
selection of the first form field, I would like the default value
of the this field (task_rate) to be populated with the associated
task_rate value of the selection chosen above.
Seems very clientside to me!
Classic ASP does not know of forms
nor of dynamically changing formfields.
--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)
this may be of some help -- demo is for dependent dropdownlists.. . http://www.aspkey.net/aspkey/_articl...cle.asp?id=100
"Brett_A" <br********@gma il.comwrote in message news:94******** *************** ***********@l28 g2000prd.google groups.com...
>I have a form where the first field is a dynamic drop-down that pulls
from a db (Access). The fields associated with the query are task_id,
task_name and task_rate. The field has the value of "task_id" and the
label of "task_name" .
In the second form field, I would like the default value to be
determined by the selection made in the first field. Based on the
selection of the first form field, I would like the default value of
the this field (task_rate) to be populated with the associated
task_rate value of the selection chosen above.
Any suggestions?
Thanks
Brett
On Apr 18, 4:28 pm, "Evertjan." <exjxw.hannivo. ..@interxnl.net wrote:
Brett_A wrote on 18 apr 2008 in microsoft.publi c.inetserver.as p.general:
On Apr 18, 12:59 pm, "Evertjan." <exjxw.hannivo. ..@interxnl.net >
wrote:
Brett_A wrote on 18 apr 2008 in
microsoft.publi c.inetserver.as p.general:
I have a form where the first field is a dynamic drop-down that
pulls from a db (Access). The fields associated with the query are
task_id, task_name and task_rate. The field has the value of
"task_id" and the label of "task_name" .
In the second form field, I would like the default value to be
determined by the selection made in the first field. Based on the
selection of the first form field, I would like the default value
of the this field (task_rate) to be populated with the associated
task_rate value of the selection chosen above.
Any suggestions?
If this is a serverside code problem, show your code,
if it is clientside code or a html Q, ask elsewhere.
[please do not quote signatures on usenet]
Are for frik'n real Evertjan?
Getting angry usually shows getting angry at yourself.
Don't, it does not help you.
This is an ASP forum, I'm asking an ASP question.
How can we be sure, Bret?
Many a time Qs are asked in the wrong NG.
Your Q does not specify it as such.
I don't have the code because I need some direction on how to write
the code.
So?
Did you read my question?
Yes
Do you understand my question?
Not completely, it seems not directed at a serverside problem.
Could you specify the serverside Q?
It seeme you want dynamically changing formfields content.
Did I say I already have code that isn't working?
Should you?
Yes you should.
This NG usually helps people that get stuck,
but usually does not write code for others out of the blue.
I explain what I want and ask for suggestions. If my question isn't
clear, than I need to fix it.
Help yourself.
you wrote:
In the second form field, I would like the default value to be
determined by the selection made in the first field. Based on the
selection of the first form field, I would like the default value
of the this field (task_rate) to be populated with the associated
task_rate value of the selection chosen above.
Seems very clientside to me!
Classic ASP does not know of forms
nor of dynamically changing formfields.
--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)
This is what you answered:
If this is a serverside code problem, show your code,
if it is clientside code or a html Q, ask elsewhere.
If you read my question, why would you ask if I had a code problem? I
hadn't gotten that fair in the development. After reading the other
answers and doing more research, it is partially client-side issue - I
think I need some AJAX to create the desired functionality. I was
asking the initial question to see where I should start - the last
sentence was "Any suggestions"? If you thought it was a client side
issue, why not answer like Bob did? It was informative without being
condescending.
Brett
On Apr 18, 3:26 pm, "Bob Barrows [MVP]" <reb01...@NOyah oo.SPAMcom>
wrote:
Brett_A wrote:
I have a form where the first field is a dynamic drop-down that pulls
from a db (Access). The fields associated with the query are task_id,
task_name and task_rate. The field has the value of "task_id" and the
label of "task_name" .
In the second form field, I would like the default value to be
determined by the selection made in the first field. Based on the
selection of the first form field, I would like the default value of
the this field (task_rate) to be populated with the associated
task_rate value of the selection chosen above.
This is typically done in client-side code so it is more appropriately
asked in a client-side scripting group such as
microsoft.publi c.scripting.jsc ript
However, you can look here to get a head start and narrow your question
down to more specific issues:http://classicasp.aspfaq.com/forms/h...opdown-depend-...
While the client-side scripting is the major part of the solution, there
may be server-side asp issues as well that we will be happy to address
here.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
The first form field is a dynamically populated list. The second form
field is a text box, not another list. The value to populate the
second text box is a value that needs to be pulled from the database
determined by the value of the selected value from the first form
field. I don't want a page refresh which is what seems to happen if I
set it up as outlined in the samples suggested.Somet hing has to happen
on the server side to retrieve that value before any onchange event
can update the second field with the proper value doesn't it? Is this
a place where I need to implement some AJAX?
Thanks
Brett
Brett_A wrote on 19 apr 2008 in microsoft.publi c.inetserver.as p.general:
>Seems very clientside to me! Classic ASP does not know of forms nor of dynamically changing formfields.
Again: [please do not quote signatures on usenet]
This is what you answered:
If this is a serverside code problem, show your code,
if it is clientside code or a html Q, ask elsewhere.
[wrong quoting level]
If you read my question, why would you ask if I had a code problem?
Because that is the main subject of this NG,
and you did not include such problem.
I hadn't gotten that fair in the development.
Ah, so you were just fishing? "that fair"? I think not sofar.
After reading the other
answers and doing more research, it is partially client-side issue - I
think I need some AJAX to create the desired functionality.
Indeed. Ajax is in fact clientside coding technology,
as the requested html streamlayout from the server could be,
but not necessarily has to be,
prepared by serverside coding,
which coding even then is not part of AJAX technology as such.
I was
asking the initial question to see where I should start - the last
sentence was "Any suggestions"? If you thought it was a client side
issue, why not answer like Bob did? It was informative without being
condescending.
So that is the bottom line:
You are asking and at the same time think
you have a right to determine how the response should be?
While it was not my intention to be condescending,
[you could be from the west side of the great pond,
where such sensitivities excessively abound,
as seen from the rest of cyberworld,]
it won't do to expect the absence of condescence on usenet.
"Any suggestions"?
So again, show us the serverside problem, and do some initial work
yourself, and you have a good chance of getting help where you get stuck.
--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)
Brett_A wrote:
On Apr 18, 3:26 pm, "Bob Barrows [MVP]" <reb01...@NOyah oo.SPAMcom>
The first form field is a dynamically populated list. The second form
field is a text box, not another list. The value to populate the
second text box is a value that needs to be pulled from the database
determined by the value of the selected value from the first form
field. I don't want a page refresh which is what seems to happen if I
set it up as outlined in the samples suggested.Somet hing has to happen
on the server side to retrieve that value before any onchange event
can update the second field with the proper value doesn't it?
Right. it sounds as if you know how to accomplish the server-side aspect of
this problem.
Is this
a place where I need to implement some AJAX?
If you don't want to submit the form to get the new value, then yes, AJAX,
or something like that will be required. The client-side scripting group is
the place to get help with that.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM" This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: JJ |
last post by:
Hi All,
When someone selects a value in a select on a form I want to show the
same form with another select with certain values depending on first select.
How can I do this? Should I keep acouple of arrays loaded with the second
selects values not to be shown till selected in first or what other means?
Also how do you reload the current form to show maybe a nex field or select
box?
|
by: Steve Speirs |
last post by:
Hi
I'm trying to show/hide a simple piece of text and a text field on a
form based on what choice is made from a drop down box.
<select name="dropdown" size="1">
<option selected value="">Please make a selection</option>
<option value="1">Choice 1</option>
<option value="2">Choice 2</option>
<option value="3">Choice 3</option>
|
by: Vincent Yang |
last post by:
I'm using Access 2002. My database is in Access 2000 format.
I'm designing a form to collect responses to a 40-item questionnaire.
I can fit four list boxes on a screen, so I plan to have 11 tab pages
(one page at the end for collecting identifying information) on my
form. To ease the task for the user, I'd like to have an automatic
movement to the next page. For instance, when the user clicks on the
choice for Question 4 (the last of...
|
by: William Wisnieski |
last post by:
Hello Everyone,
Access 2000
I have a main form with a continuous subform. On the main form I have a
text field called . It gets populated based on what the user
selects in a field on the sub form (code in the AfterUpdate
Event). Here's the issue. If the user deletes a subform record. The
field on the main form shows null even if there is a value in the
preceding subform record. What I'd like it to do is immediately refresh to
|
by: Lyn |
last post by:
Hi,
I am working on a genealogy form. The only table (so far) lists everybody
in the family, one record per person. Each record has an autonum ID.
The parent form (frmMainForm) displays the data in each record, which
includes the ID of the father and the mother (who also have records in the
table). One record per form.
I have a Tab Control in the form, and in one of the tabs I have a subform
(sfmSiblings) in which I wish to list...
| |
by: Abhi |
last post by:
FYI:
This message is for the benefit of MS Access Community. I found that
this prblem has been encounterd by many but there is hardly any place
where a complete solution is posted. So I thought I should give back
to the community by posting our findings.
Thanks you all for all your help till now by posting problems and
their solutions.
~Abhijit
|
by: MissiMaths |
last post by:
I am creating a reference table of all the information used to draw a
sample. I start by first clearing the table in form1 using a delete
query.
Then after the user selects certain options, i create a string
"optionString" and put it into my table refTab in the appropriate
field.
DoCmd.OpenQuery "ClearRefTable"
Dim MyDB As Database
|
by: User |
last post by:
Form A (Main)
Text Box 1
Text Box 2
Text Box 3
Form B (Pop-up)
Choose a selection for Form A/Text Box 3
Scenario:
|
by: AndiSmith |
last post by:
Hi guys,
I wondered if anyone could help me with this problem, or even shed some light on the direction I need to take to resolve it? I'm using .NET 2.0 (C# flavor) to build a large user-based website.
I've created an AJAX based user control, which is dynamically placed on a page (once, or multiple times) if the user has the correct permissions to receive it.
It contains two drop down lists - employee value and partner value; and a...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |