Search results for query: *

I am so frustrated , woke up at 4.00am and in the last 4hrs been battling with a validation & calender pop up for my SIMPLE input box. behind already with this office project I thougt my initial code worked but , adding on the pop up window I got online from a google search the 2 codes did not...

thanks Ifigured out my error used this <OPTION Value="<%=RS("Access_UserName")%>"></option instead of <OPTION Value="<%=response.write rs("Access_UserName")%>"></option thanks!!

I would like to populate my drop down menu on an asp page with values from a database-ACCESS. below is what i have so far , it gives me no errors but the drop down is not being populated.pls what am i not doing right???. New too this functionality <select size="2" name="AUserName"> <OPTION...

The query is working now. thanks. will now clean it up so it accepts spaces and whatever character user puts in so i get no error message.

Am sorry , can u show me where exactly in my code i should avoid spaces in the table /field name and remove a comma from the where statement. the where has no comma??

Hi Guys, This is my code , below .i am tryinG to update a table in access. SQlstmt = "Update BILLTABLE Set " SQLStmt = SQlstmt & "BILLTITLE = '" & Strbilltitle & "'," SQLStmt = SQlstmt & "WEBADD = '" & Strwebadd & "'," SQLStmt = SQlstmt & "KEYWORDS = '" & Strkeywords & "'," SQLStmt =...

...the user picks an option from the drop down and submits , the billstatus field in the table is updated with the option picked. this is my problem *The billstatus field in the table shows a comma before the option picked eg ,active or ,nonactive . how do I eliminate this annoying comma...

below is my script in asp which works well and updates my access dtabase table, BUT [ SQLStmt = SQlstmt & "CCDATE=#" & Now & "# "] This piece does not update with the date. Am I missing a quote or..... Thanks as always, Ify SQlstmt = "Update BILLTABLE Set " SQLStmt = SQlstmt & "COMMENTS...

yes it did

Thanks guys !!!

Still wondering if anyone has an idea of how I can remove borders or teh depresion of a text box field so the text in the input box hust appears as a writing???

Thanks I thought so.yes it is just for design purposes.HOw do I use CSS to remove the borders and depression of textboxes

...be submitted without a form? below is a brief code for the , 2nd & 3rd page .How can I revise these pages to achieve my goal. Thanks as always ****2nd page <% billNO = request.querystring("billNo") Set Conn = Server.CreateObject("ADODB.Connection") Set Rs =...

Thank you so much your code did work. Most appreciated

...<% Set Conn = Server.CreateObject("ADODB.Connection") Set RS=Server.CreateObject("ADODB.RecordSet") Conn.Open "eiwp" SQLquery = "Select * from tblopgaCom2 where area LIKE 'AUDIT' order by billNo asc" RS.Open SQLquery, Conn If RS.EOF then Response.write "<center>There are no...

THANK YOU i MISSED THAT .IT WORKED

...Set Conn = Server.CreateObject("ADODB.Connection") Set Rs = Server.CreateObject("adodb.Recordset") Conn.Open "eiwp" SQLQuery = "SELECT * FROM tblopgaCOm2 WHERE billNo = "& billNo RS.Open SQLQuery ,Conn,1,1 strBillNo=RS("billNo") SQLQuery1= "Select area FROM tblopgaCOm2 WHERE...

thanks guys

hey guys I am getting an error at the 'AUDIT' what am I doing wrong. billno is alpanumeric SQLQuery = "SELECT * FROM tblopgaCOm2 WHERE billNo = '"&billNo&"'" and area like 'AUDIT'

Thank you guys it worked. annoyed I did not get it the first time cause I had tried that. but had put the session in bracket. thanks again it is a relief