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...

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...

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 =...

I have a table with a billno and billstatus field in access. I have an asp page that display's the bill no, then a drop down box with 2 options to pick from eg active & nonactive. when the user picks an option from the drop down and submits , the billstatus field in the table is updated with...

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...

‘Hey Guys have a question . Have 3 asp pages. The first page displays information with a select statement on all bill from a dept. Each of these bills it displays is a hyperlink which when clicked opens up a second page with just a more detailed information about that bill picked. This 2nd page...

I have a database in Access. Scripting in asp. BACKGROUND Each user can only view infor for a billNo from their designated “area”. Eg Joe from the audit dept can view billNO HB0030 from the audit dept. However the same billNo HB0030 also appears in another dept say Fin. So users in the fin dept...

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'

Hey guys I have a password page.Each user can only view information for their own dept.an Access table called tbl_Leg is set up where each user is assigned to a dept. when a user therfore logs on via the password page it authenticated the user and sends the user to the user dept page which is a...

hey guys, Have a quick question. The Sql statement below works. SQlstmt = "Update tblopgaCom2 Set " SQLStmt = SQlstmt & "comments ='" & "" & "'," SQLStmt = SQlstmt & "priorcomments ='" & Strpriorcomments & "."&" "& ";" & vbcrlf & Strcomments & "'," SQLStmt = SQlstmt & "updDate=#" &...

How do I get the contents in a table downloaded to an external file. I need a button on my form that when the administrator clicks it will download the contents of the table to an external file. this external file will then be used by the administrator to update another Database. My backend I...

How do I get the contents in a table downloaded to an external file. I need a button on my form that when the administrator clicks it will download the contents of the table to an external file. this external file will then be used by the administrator to update another Database. My backend I...

I had posted a question on Retriving data Using 2 sql statements... thread333-853837 and thread333-848660 which no solution was found. have it figured out now and would like to share the solution with the forum especially amorus ,Drexor,alfredomulet& cassidyhunt who had helped out in search...

I am getting just one value returned from the field in the DB called 'area into the textarea in my form called 'otherdescription based on my 2nd sql statement in the code below . it just returns one value when it should return 2values - Because each billNo from the DB appears twice...

your input will be highly appreciated.worked on this all thru yesterday without sucess I am displaying data from my access DB into a form that shows one record with the select statement below SELECT * FROM tblopgaCOm2 WHERE billNo = '" & Request.Form("BILLNO") & "' AND area LIKE 'AUDIT'"...

I have a form that displays information selected from an Access Data base. A select statement is used to do this on my asp page SQLQuery = "SELECT * FROM tblopgaCOm2 WHERE billNo = '" & Request.Form("BILLNO") & "' AND area LIKE 'AUDIT'" billNo and area are the 2 fields used together to...

have a quick question. *My asp has an access backend.On my asp page can I have a button that can actually print a report from the Acesss Database.Or can I create a popup box to pull the information and print it from the database if this can be done will appreciate the appropriate codes for...

Have 2 intresting Q * Is there a way I can put a print button on my asp that will actually print the current Screen opened. *My asp has an access backend.On my asp page can I have a button that can actually print a report from the Acesss Database.ie a button that will go the report section...

hey guys have an intresting questions * A user selectes from a list of options from an asp page. when he clicks on this option which rep a record in an access DB it pulls out all the information/fields related to that record selected..On the page where the Information is displayed I have a...

Thanks guys for yesterday of course the struggle continues. *have my asp page1.asp here I have 2 forms on this page. In The first form on this page there is no actual texboxes etc just used the submit button put a link on it which takes you to another page.(just serving the purposed of a...