Search results for query: *

thought i had this sorted but was not doing what i thought.. have twobuttons <form action = "dealaddmain.asp" method = "post"> <input name="action" type="image" src="images/calcbut1_01.gif" width="108" height="50" border="0" value = "X"><input name="action" type="image"...

Hi, I want to be able to select an item from a list and then have the cost of the item to be displayed in a response.write - so far i have a combo -the value i choose from the list is warranty -the value i want displayed is warrcost <% x_warridList = "<select name='x_warrid'><option...

can someone explain how i can make this work on a form there are two buttons one does a calculation and displays a result the other goes to another page - <form> <input name="action" type="image" src="images/calcbut1_01.gif" width="108" height="50" border="0" value = "X"> <input name="action"...

Hi, i need a good 24port managed switch with gigabit and stacking capability. have heard cisco 2924? is a good model am in UK and have 500 UK quids to spend. any recomendations

a dropdown is populated from a table but one of the fields is an id field for a lookup table. i want a field from the lookup table to be displayed in the dropdown instead of the id. ne advice welcome my attempt <% 'codefor dropdown x_partneridList = "<select name='x_partnerid'><option...

have the following sql statement strsqlacc = "SELECT tbl_acc.accid,tbl_acc.acccost,tbl_acc.accdesc, tbl_deal.dealid FROM (tbl_acc INNER JOIN tbl_acclink ON tbl_acc.accid = tbl_acclink.accid) INNER JOIN tbl_deal ON tbl_acclink.dealid = tbl_deal.dealid WHERE (((tbl_deal.dealid)= 1));" instead of...

which part of the code below chooses the filter field to pass to a second combo box please? <% x_stypeidList = "<select name='x_stypeid' onChange='EW_updatecombo(this.form.x_partnerid, ar_x_partnerid, this.options[this.selectedIndex].value);'><option value=''>Please Select</OPTION>" sqlwrk =...

when this add to combo code is fired i get a variable undefined error on the first line. surely this is defining the variables itself? Private Sub taskcombo_NotInList(NewData As String, Response As Integer) Dim Db As DAO.Database Dim Rs As DAO.Recordset DoCmd.SetWarnings (warningsoff) If...

hi, i get a variable undefined error highlighting the top row of my code - can ne1 see why? Private Sub taskcombo_NotInList(NewData As String, Response As Integer) Dim Db As DAO.Database Dim Rs As DAO.Recordset DoCmd.SetWarnings (warningsoff) If MsgBox("OK to add new Task type.?. Or Press...

hi, i want to update the field 'dateassess' in table 'tbl_risk' with the value 01/10/2004 where 'tbl_risk'.'siteid' = 2 UPDATE tbl_risk.dateassess = '01/10/2004' WHERE (tbl_risk.siteid) = 2; can you tell me where i am goin wrong?

i have a question about writing a many to many table ne examples would be welcome a user can choose a car and then choose accessories they would like for that car. at the moment my page loops through the accessories table and lists all products. at the end of each row is a yes/no dropdown to...

hi, how do i make a query that inserts a value into a field as long as the field is empty

Hi, am trying to let users select multiple choices. the source of the choices is a table. so far i have the code below that users can select multiple items from a combo box. this is ok apart from two things: 1) the combo is 4 rows long and you have to scroll down to see other choices. how can...

Hi, after wipeing some XP pro pcs after reinstall the users find that when it comes to opening office docs they get the following message a document with the name "filename" is already open. you cannot open two documents with the same name, even if they are in different folders ne ideas welcome

have a form that i want to be able to edit a record with linked list combos - works fine until i put the title of the page which comes from a linked table. the title is put in a text box and gets data from the forms query. when this is added to form the title is displayed but combo boxes can not...

ok...i look at processes regularly because i think this is the way to spot bad things so today i find notpad.exe its 65k and lives in system32 right next to notepad.exe im running xp and have virus/adware/spybot checked ne1 else seen this

i open a form with the code DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 DoCmd.OpenForm "riskdetail", acNormal, , "tbl_risk.riskID = " & Me!rid this takes the field id from a main form and opens the record in a form with more detail the table relationship is a star...

help me understand have this code <code> If Not IsNull (x_pxid) Then sqlwrk = "SELECT * FROM tbl_stock" sqlwrk = sqlwrk & " WHERE stockid = " & x_pxid Set rspx = conn.Execute(sqlwrk) endif </code> ...but this query is still being run even though value of x_pxid is nothing

to get my site running on my local testing server i have to click put...right? so why sometimes when i make changes to the code and click put does it not save and put files? ne more info needed..let me know

Hi, when inputting dates ive chosen to have 3 dropdowns day,month,year is it best to have three fields for each dropdown or combine them all in one field?