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 derfloh 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: *

  1. chdavisjr

    How does one test if a table exists on web?

    ...this if the table is not there: "Microsoft OLE DB Provider for ODBC Drivers error '80040e37' cannot find the input table TBL2" mysql = "SELECT * FROM TBL2" recordset1.Open mysql, dbConn1, adOpenKeyset, adLockOptimistic if not recordset1.EOF then code to append records to TBL2 else...
  2. chdavisjr

    Copy data from previous record.

    Thanks, FancyPrairie, that works.[2thumbsup] I did find one thing, though. If the next record has identical values (no field changes: 2 male fish weighing 3 lbs on Pond1, Sample1) a new record will not be created. At least one field must be changed, to create the new record. I explained this to...
  3. chdavisjr

    Copy previous record's data to new record on form

    Thank you, PHV. Especially for your fast response! I didn't get much sleep last night, and cannot remember how to do what you suggested. Can you assume that I am a newbie (well, I am allmost one!) And outline the steps a little more detailed? I am sure that other members that view this would...
  4. chdavisjr

    Copy previous record's data to new record on form

    Okay, I know this has been answered, but the Search feature is disabled while the web is updated! A co-worker has a table with fields: Date, Pond, SampleName, Sex, Weight At our Fish Research Center He will be entering multiple data (weight & sex) for each pond and samplename. He wants all...
  5. chdavisjr

    Copy data from previous record.

    Has anyone found out how to make FancyPrairie's suggestion work on non-numeric data? Thanks in advance, Chalmers
  6. chdavisjr

    How can one create Unique Pairing of participants

    Thanks, Chris, and TwoOdd. TwoOdd: I'll assume that after all match pairings have been used, they will start over. The class(es) will have 15-20+ attendees, most likely, so this will (most likely) not be an issue. The main thing is to assure that there are unique pairings for each day...
  7. chdavisjr

    How can one create Unique Pairing of participants

    Thank you, TwoOdd, but I incorrectly stated my problem. Let me restate it here. Assume 6 attendees named A, B, C, D, E, and F. I need to match all the attendees together each day into different pairings, as shown below: Day 1: A-B, C-D, E-F Day 2: A-C, B-E, D-F Day 3: A-D, C-E, B-F Day 4: A-E...
  8. chdavisjr

    How can one create Unique Pairing of participants

    ...and the formula: nCr = n! [&divide;] ( (n-r)!r! ) I have a function: function factorial(n) if n <= 1 then factorial = 1 else factorial=n * factorial( n - 1 ) end if end function and the formula for combinations: As an example I am hardcoding n=4 and r=2 here for simplicity's...
  9. chdavisjr

    How do I access an array of arrays?

    Thank you! I believe you have given me enought to get started. I've been looking for an excuse to use Dictionary objects! [tongue]
  10. chdavisjr

    How do I access an array of arrays?

    Thanks, TomThumbKP. Would you show an example on how to use dictionaries to build the complex array in the examples above and how to access the different elements? For example: Dim x, y, z y = array(1, 2, 3) x = Array(y, array(3, 4, 5), array(6, 7, 8)) z = array(x, array(7,8,9)...
  11. chdavisjr

    How do I access an array of arrays?

    Thanks, TomThumbKP! This is still confusing, on exactly how to access elements of this type of an array. I mean, how could one go about accessing all the elements without knowing how the array was created or how many arrays are within arrays?? Anyway ... JohnYingling, here is what I get...
  12. chdavisjr

    How do I access an array of arrays?

    Hello, Narizz28: I found some more info in this thread that explains a little. "2 Dimensional Array" thread329-756337 In response to your question, Dim x, y, z y=Array(1,2,3) x=Array(y,Array(3,4,5), Array(6,7,8)) z=Array(x, Array(7,8,9), Array(10,11,12)) I can access these elements...
  13. chdavisjr

    How do I access an array of arrays?

    Thank you so much! That worked. Chalmers
  14. chdavisjr

    How do I access an array of arrays?

    I received this in an e-mail newsletter: Dim x, y y = array(1, 2, 3) x = Array(y, array(3, 4, 5), array(6, 7, 8)) that mentions using an array of an arrays. However, they do not indicate how to access the elements. My question is: How do I access each element of the array x? Nothing I have...
  15. chdavisjr

    How do i populate a textbox from a radio button?

    Thank you much, Martin, for your fast replies. I can always depend on the members of Tek-Tips to provide help when it is needed! Good point about "reusablility"! Chalmers
  16. chdavisjr

    How do i populate a textbox from a radio button?

    Thank you, tigerjade! I just "found" the solution! Here is what I did: <form name=form1> <input type=radio name=radio1 value="red" onClick="form1.color.value='red'"> Option 1 <BR> <input type=radio name=radio1 value="blue" onClick="form1.color.value='blue'"> Option 2 <BR> You select the color...
  17. chdavisjr

    How do i populate a textbox from a radio button?

    I've had a complete brain shut-down today. Any and all help would be appreciated on this "sorta" urgent problem! I have 2 radio buttons and a text box. Here is a very simplized version of my problem. If I click Option 1 I want the value "Red" in the text box. If I click Option 2 I want the...
  18. chdavisjr

    How do I Create Logical AND/OR DB search thru script

    Sorry for my posts AFTER your responses! I was forgetting to close the thread, so wasn't getting your response. Thanks, fixing to try your change now! I like your way much better than mine, since it is easier to read! Chalmers
  19. chdavisjr

    How do I Create Logical AND/OR DB search thru script

    Thanks, PHV I tried yours, but had a question about the sql=Mid(sql,4) I took all but the last, so I could end the SQL properly. I used the k counter for that purpose. I am still working on your solution, as it is much shorter and seems simplier! Just haven't gotten the bugs out ... my be my...
  20. chdavisjr

    How do I Create Logical AND/OR DB search thru script

    Hello, again, PHV. I have a question about your last suggestion for building the SQL for the "OR" or case 1: Select Case Option Case "1" 'For any of the words: For Each s in arrSearch sql=sql & "OR Term LIKE" & s & "OR Defn LIKE" & s Next 's sql=Mid(sql,4) I don't understand what...

Part and Inventory Search

Back
Top