Search results for query: *

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

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

This is my current connection set up with a DSN: Dim conn, strSQL set conn = server.createobject("ADODB.Connection") conn.open "sand1" I had just been reading about how Jet is better using a DSN-less connection. anyway-back to my problem (thank you by the way-it worked...

when it gets into the else, it's trying to update the personid field and i don't want it to even look at personid in either scenario. is there an "else if" that can be used here to prohibit personid from being looked at in the else? thanks so much:) also, could it be my connection...

thanks, i'll try it:) i'll let you know how it works:)

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

thanks so much, i'll try it:)

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

thank you sooo much, you have pointed me in the right direction and i'm going to try it. wish me luck and please keep an eye out for my posts as they will undoubtedly related to this. i've almost got it now and i couldn't do it without the help and patience of people like you:) thank you sooo...

yes:) and thank you for reading my post:)

thank you so much-it seems like you understand what i am trying to do. now with what you said about checkboxes... i like that idea, but can i get the same result with a listbox. in reality, the user will have 50+ choices and aside from space being used, it will take time for the user to check...

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

Thank you so much- I can't tell you how that's helped. Now can you tell me what the INSERT syntax would be and how i can test each item selected against an existing database field header (column name). Do I have to use case statements or if-else statements and test each item against every...

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