Recent content by WaterTight

Using an XML for excel - have the following code: <?xml version="1.0" encoding="utf-8"?> <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"...

Ok - that did indeed work...but I want to know why Can anyone point me to an FAQ or something out there that explains this? thanks, Jeff

I need to left outer join both the Adjustments and the Payments tables to the Cases table where the CaseID's are equal. Sounds simple enough... SELECT Cases.Units From Cases Left Join Adjustments On Cases.CaseID = Adjustments.CaseID Left Join Payments On Cases.CaseID = Payments.CaseID...

doing a left outer join on both did the trick... just don't tell me that i'm going to have to pay you franchise fees whenever i'm an idiot... thanks again... J

I tried to do the left outer join (cases inner join procedures) - but it said 'Join expression not supported.' I'm guessing this is because I'm trying to inner join a member of an outer join - based primary on my attempts to do something similiar in sql server 2k query and getting an error...

Ok - the more I'm playing with it, the more familiar I'm becoming with it. I did leave out Cases on my first join - however, I didn't realize that I was then trying to inner join onto a member of a outter join. My query now works with the following: Select Distinct Patients.PatientID...

I'm trying to write the core select from clauses for this access query and am missing something. I have: Select Distinct Patients.PatientID, Patients.FName, Patients.LName From ((Patients Left Join ON Patients.PatientID = Cases.PatientID) INNER Join Procedures ON Procedures.CaseID =...

Doing a distinct would still yield the same results as all the orderdates are different...however, wrapping it in a MIN() function worked like a charm. thanks foxdev - apparently i was just being an idiot... thanks, J

I have two tables: Batch and Orders - both containing BatchID (which is either NULL or a valid id in the orders table). I want to try to avoid adding a StartDate to my Batch table because there is already an OrderDate in my Orders table that contains more accurate information for tracking...

Because the window that i want to send ctrl and enter to will not always be on-top, i'm hoping there's a way to use sendmessage or postmessage to do this...i'm able to: Public Const WM_CHAR = &H102 SendMessageByNum(tHwnd, WM_CHAR, 13, 0) and just hit enter...but i'm clueless about how to add...

Since there were no replies, I wanted to post the solution to this, in case anyone else was having this problem. To call frame 12 for the object called &quot;ul&quot; within &quot;style,&quot; ShockwaveFlash1.TGotoFrame &quot;_root.style.italic&quot;, 12 Setting a variable, such as changing...

I have integrated a flash interface for a vb6 program. I'm able to get all of the flash interactions by doing a select case on fscommands. However, there are occassions when I will need to force flash events due to the user selecting different settings. My main problem is that i'll need to...

The change occurs, on occassion, too quickly to ensure nothing is missed because of a relatively small buffer. Hence my attempts to approach it by subclassing. I'm not sure what events the 3rd party control has. I don't have access to it. I was hoping I could do some trial and error...

Is it just me, or are you not actually saving or loading anything from the file? After you've opened the file (&quot;Open CommonDialog1.FileName For Output As IFile&quot; or &quot;Open CommonDialog1.FileName For Random As IFile&quot;) the next thing you do is exit the sub. If you purposefully...

Ok...if your rich textbox is called RichTextBox1 then this will load the file &quot;c:\test.rtf&quot; into your rich textbox: RichTextBox1.LoadFile &quot;c:\test.rtf&quot; The ability to save into and load from files already exists in the richtextbox control. Now, if you want the user to be...