Javascript & M$Access

clark · 05-09-2005, 09:02 PM

HI,

I've been trying to figure out how to do something all night. Can someone please help?

Created a dynamic HTML page of a table (called 'systems') from an Access db. Two of the fields in this table are called 'system' and 'price'. In the page there is a combobox which was created in Access. The combos ListBoundField is 'price', but I have set its ListDisplayField to 'systems'. Therefore, in the webpage itself, the user will click the combobox to choose a system and its price will be used to add information to the shopping cart.

I'm trying to keep this question short so basically what I wish to do is display in another textbox the text which is displayed in the combobox. Unfortunately its value is 'price' and so that's what I keep getting displayed. Im using javascript and I want to keep with that. Did any of that make sense to anyone?

jackson17 · 05-12-2005, 06:04 AM

No didnt really make that much sense, but if the value is "price" then obviously thats what is going to be displayed as thats the set value

clark · 05-13-2005, 05:57 PM

In M$Access the user can set a fields value to one field in a table but set it to display a different field in the same table. Therefore, when displaying the data in a web page or on a form, a field can hold the value from the "price" field but display another field from the same table, for example "system".

example:

textbox2.value = textbox1.value

textbox1 may display "notebook 2.6ghz" whilst textbox2 will display £650.

Does anybody know how to display not the value of textbox1 but the text which is displayed in it?

thanks

05-09-2005, 09:02 PM	#1 (permalink)
clark Registered User Join Date: Nov 2003 Location: gt. yarmouth, east anglia, UK Posts: 10 OS: XP pro	Javascript & M$Access HI, I've been trying to figure out how to do something all night. Can someone please help? Created a dynamic HTML page of a table (called 'systems') from an Access db. Two of the fields in this table are called 'system' and 'price'. In the page there is a combobox which was created in Access. The combos ListBoundField is 'price', but I have set its ListDisplayField to 'systems'. Therefore, in the webpage itself, the user will click the combobox to choose a system and its price will be used to add information to the shopping cart. I'm trying to keep this question short so basically what I wish to do is display in another textbox the text which is displayed in the combobox. Unfortunately its value is 'price' and so that's what I keep getting displayed. Im using javascript and I want to keep with that. Did any of that make sense to anyone? Last edited by clark : 05-09-2005 at 09:20 PM. Reason: make more sense

05-13-2005, 05:57 PM	#3 (permalink)
clark Registered User Join Date: Nov 2003 Location: gt. yarmouth, east anglia, UK Posts: 10 OS: XP pro	In M$Access the user can set a fields value to one field in a table but set it to display a different field in the same table. Therefore, when displaying the data in a web page or on a form, a field can hold the value from the "price" field but display another field from the same table, for example "system". example: textbox2.value = textbox1.value textbox1 may display "notebook 2.6ghz" whilst textbox2 will display £650. Does anybody know how to display not the value of textbox1 but the text which is displayed in it? thanks Last edited by clark : 05-13-2005 at 06:27 PM.

05-12-2005, 06:04 AM	#2 (permalink)
jackson17 Registered User Join Date: May 2005 Posts: 9 OS: XP	No didnt really make that much sense, but if the value is "price" then obviously thats what is going to be displayed as thats the set value