Yes, I took part. I prefer outer join -- because of portability and such.

You could try Exchange Web Services[^]

A seven field composite primary key X| - sounds like a disaster has found somewhere to happen. This is a BAD idea, I have no knowledge of the performance issues with such a mess but the sheer cumberomeness of forever doing a 7 key join would drive me to drink. I recommend that you insert a primary key into the central table and populate it, then turn autonumber on. Now add the foreign key field to the other table(s) and use the 7 key horror to populate the field. Make your relationship using these fields. You must make sure you support the change within your CRUD code. Never underestimate the power of human stupidity RAH

Three points. 1. You fill the array with dates starting at index = 1, but with numbers starting at index = 0. Is this correct? 2. You could try something like intRow = 0 For j = 1 to 13 for i = 1 to 28 intRow = intRow + 1 arrArray(intRow,1 ) = j next i next j 3. Wrong forum - there is a VB one (though people tend to be VB6 hostile, and this looks like VB6 or VBA to me.) :) Regards David R --------------------------------------------------------------- "Every program eventually becomes rococo, and then rubble." - Alan Perlis

Read this article: http://office.microsoft.com/en-us/excel/HA011117011033.aspx?pid=CL100570551033[^] OK. I have an array created inside the function, and then I search through the array for a match of a value and return the second value as the result. The problem is that it does not make sense to create the array each time the function is run. Can it be stored some place else so that the function has access to it?

Assuming you have filled the array with something like: arrArray(1, 0) = "#1/1/2006#" arrArray(1, 1) = 1 arrArray(2, 0) = "#1/2/2006#" arrArray(2, 1) = 4 Then something like this should do it Dim retVal Dim match Dim i match = "#1/2/2006#" For i = 1 To 10 If arrArray(i, 0) = match Then retVal = arrArray(i, 1) End If Next i Regards David R --------------------------------------------------------------- "Every program eventually becomes rococo, and then rubble." - Alan Perlis

Although replacing single apostrophe with double apostrophes will correct your problem, I think you should use parameters instead. Concatenating literal strings leaves you open to sql injections. Also using parameters gives a performance advantage. The need to optimize rises from a bad design.My articles[^]

OK, one last time. A CSV file is NOT an Excel file, it does NOT contain formatting information and there is no way under the sun you are gong to make Excel put the fields in any format except its default one. The ONLY reason a csv file open in Excel is because of the file associations on your computer. If you want, you could make Word the default association for a csv file - would you expect it to input and format the text then? It does not matter what you do with decimal places in the csv file, Excel will format the column with its default settings. Bob Ashfield Consultants Ltd

If you want a free program for creating chm files you can use Microsoft's HTML Workshop. Keep in mind that it is free for a reason :) . Regards, Thomas Stockwell Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. Visit my homepage Oracle Studios Discounted or Free Software for Students: DreamSpark - downloads.channel8.msdn.com MSDN Academic Alliance - www.msdnaa.com

What you need is Microsoft's HTML Workshop. Regards, Thomas Stockwell Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. Visit my homepage Oracle Studios[^]

Error 3218 "Could not update; currently locked." This error occurs when a user tries to save a record that is locked by another user. To handle this error, program your solution to wait for a short period of time, and then try to save the record again. Or, you can display a message that explains the problem and give users the opportunity to try the operation again.

Google ought to be able to point you in the direction of some help file compilers out there... "I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon

new_phoenix wrote: Does anybody know where there is an article about how to write a .HLP help file? It is my understanding that it can be done in Windows and can also be done in a web type application. This is a SQL question...how? Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush