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!

Register Log in
  • Congratulations Rhinorhino 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: nonprogrammer
  • Order by date
  1. nonprogrammer

    sum field value

    Hello I am writing a script where I have <%= rsGuestbook ("B1R1G2")%><%if rsGuestbook ("B1R1G2")=rsGuestbook ("B1R1G2w")then value="3" else response.Write(" Lost")end if%><% if value="3" then response.Write(" Win 3 Points")else response.write(" 0 points") end if%> I know you can do something...
  2. nonprogrammer

    If statement and input

    sweet got it thank you so very much !!!!
  3. nonprogrammer

    If statement and input

    rsone("a1") is a field in table umber 1 rstwo("aw1) is a field that gets populated from antother form in table number 2 I am trying to write an asp page that will compare both fields and if both fields are equal then input a specific number into table 2 field as1
  4. nonprogrammer

    If statement and input

    I was wondering if you can do in if statement then input would it be something like <% if rsone("a1") = rstwo ("aw1")then input 3 into "as1" end if%>
  5. nonprogrammer

    data from two tables

    Sorry for the delay reply I have been very sick. I just got back to work. I tried it and at first it did not work but after changing a couple of things it worked. I really appreciate it. Thank you
  6. nonprogrammer

    data from two tables

    ...'Set an active connection to the Connection object using a DSN-less connection adoConpoints.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("ncaa.mdb") 'Set an active connection to the Connection object using DSN connection 'adoCon.Open "DSN=guestbook" 'Create an ADO...
  7. nonprogrammer

    check duplicate entries in a form

    got it. Now the part that I am a bit confused the getElementById is the same as myform like in document.myform.MyField?
  8. nonprogrammer

    check duplicate entries in a form

    Ohh sorry one more question, what if "Myfield" is "Myfield1","Myfield2","Myfield3
  9. nonprogrammer

    check duplicate entries in a form

    thank you so very much that has help tremendously!!! theniteowl you are the best!!
  10. nonprogrammer

    check duplicate entries in a form

    theniteowl, thanks so very much for the response, that helps. But I the form is dynamic and to be honest I am not sure how to write the whole javascript could you help me get started? in advance thanks
  11. nonprogrammer

    check duplicate entries in a form

    Hello all, I have an asp form that has a field where you can input numbers. I was wondering if there is a way to add a javascript that will check for duplicate numbers. For example if the user enters: [code] UserName PartNumber StockNumber Sam 123ABC 1 Sam 123ABC...
  12. nonprogrammer

    &lt;windows. root.\system32\hal.dll is missing

    Has anybody encountered this <windows. root.\system32\hal.dll is missing I have tried pretty much all the options that I have found on the web but still cannot boot. I took the hard drive out and made it a slave the other desktop sees the drive but cannot access it. It says that it need to...
  13. nonprogrammer

    Can a Activex Control be record specific?

    Hello, I have an access Form and would like to append excel like documents I saw that under Insert there is an ActiveX Control and if you scroll down you find Microsoft Office Spreadsheet 9.0 in my case. I was wondering if there is a way to make this record specific because as of right now what...
  14. nonprogrammer

    dreamweaver 8 form

    so all it was, it was permissions. Arggg and I thought I had all my permissions checked. 1. Start Registry Editor (Regedt32.exe). 2. Select the following key in the registry: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC 3. On the Security menu, click Permissions. 4. Type the required permissions for...
  15. nonprogrammer

    dreamweaver 8 form

    Hello, I am fairly new to the world of web forms. I created an asp form with dreamweaver 8. My first step to create the form was to create an odbc to an access table. In the access table I have about 70 fields or so. Then open dreamweaver 8 clicked on new asp vbscript, then clicked on...
  16. nonprogrammer

    Help with nested if statements

    Thank you so very much for all the help I also tried O1=IF(MIN(G1:N1)>=E1,IF(MAX(G1:N1)<=F1,"Yes","No"),"No") This also seems to work especially thank you anotherhiggins
  17. nonprogrammer

    Help with nested if statements

    I am a bit confused now. Sorry about that ok so what I want to acomplish is that if any of the values in G1 through N1 are less than E1 and Greater than F1 O1 should say "No" and if the values in G1 through N1 are equal or between the values in E1 and F1 it should say "Yes" for P1 I woluld...
  18. nonprogrammer

    Help with nested if statements

    some of the values could be zeros or they could be empty
  19. nonprogrammer

    Help with nested if statements

    Ok it still kind of works I Added a "No" and Changed the Yes for No O1=if(or(max(G1:N1)<E1,min(G1:N1)>F1)),"No","Yes") and P1=if(or(max(G1:N1)<F1,min(G1:N1)>E1)),"Yes","No") here is what my values look like A B C D E F G H I J K L M N O P 1 1 .25 .75...
  20. nonprogrammer

    Help with nested if statements

    DirkStruan, I got another error, The formula you typed contains an error. * For information about fixing common formula problems, click Help * To get assistance in entering a function, click OK, then click Function on the insert menu. * If you are not trying to enter a formula, avoid using...

Part and Inventory Search

Back
Top