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 Shaun E 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: sbishops
  • Content: Threads
  • Order by date
  1. sbishops

    Excel VBA-Date format "mmm" not working as expected

    i have some code that seems simple enough but is giving the wrong result and i'm going batty: If Month(Date) = 1 Then myMonth = Format(Month(Date) + 11, "mmm") Else myMonth = Format(Month(Date) - 1, "mmm") End If For January, myMonth should be "Dec", but it keeps showing up as...
  2. sbishops

    can i use...

    i am developing a dynamic asp website for business purposes and am wondering if i can use msaccess 2000 db, or is there some legal issue regarding this? i can't seem to find a clear answer on the net. if i have to convert to another db, i'd rather do it now than later. sorry if i'm posting to...
  3. sbishops

    if else loop problems

    I have a web page utilizing asp, vbscript, msaccess 2000. Here is my code: First version (this works fine): <% for each Field in rs.fields for k = 0 to UBound(arrSand) if Field.name = arrSand(k) then SQL = &quot;UPDATE sand SET &quot; & Field.name & &quot; = 'True' WHERE(sand.personid =...
  4. sbishops

    Is there a way...

    Is there a way to dynamically get a column name from an access 2000 db in asp, using vbscript? Like a COL_NAME function or something????? THANKS IN ADVANCE
  5. sbishops

    i am using access 2000 db, asp form

    i am using access 2000 db, asp forms and vbscript. here is my question: i want to get some bits of information (name, email) from a user via a form. I want to then insert this info into an access 2000 database via an asp processing page. this part i have accomplished using one table, one...
  6. sbishops

    How do I insert muliple selected values in a listbox into a database?

    I am hand-coding (no FrontPage or Dreamweaver) an ASP, VBScript, JavaScript, MS Access 2000 dynamic web site. Here are some code excerpts: form1.asp <label>Please enter name: <input name = &quot;deliName&quot; type = &quot;text&quot;> </label> Please select all sandwiches that you make...

Part and Inventory Search

Back
Top