Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ifeyinwa
  • Order by date
  1. ifeyinwa

    input box ,date validation & pop up calender

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

    populating drop down menu with values from access DB

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

    populating drop down menu with values from access DB

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

    syntax error

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

    syntax error

    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??
  6. ifeyinwa

    syntax error

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

    updating an mdb field via drop down box in asp

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

    Date issues

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

    submitting an updated page w/out using a form

    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???
  10. ifeyinwa

    submitting an updated page w/out using a form

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

    submitting an updated page w/out using a form

    ‘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...
  12. ifeyinwa

    error message

    Thank you so much your code did work. Most appreciated
  13. ifeyinwa

    error message

    Another quick question In my page dept.asp where infor on a bill is displayed in 3 columnar headings How do I make each of those column heading to be a hyperlink and when clicked on resort the table/column in ascending order. This is the script for the page so far.How do I add this...
  14. ifeyinwa

    error message

    THANK YOU i MISSED THAT .IT WORKED
  15. ifeyinwa

    error message

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

    Synax error

    thanks guys
  17. ifeyinwa

    Synax error

    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'
  18. ifeyinwa

    Showing a user's name on a page

    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

Part and Inventory Search

Back
Top