Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

Thank you so much! That worked. Chalmers

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

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

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

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

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

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

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