Search results for query: *

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

All the necessary information for uninstalling should be there in the St6unst.log. However, this forces the user to use the Add/Remove Programs in the control panel. You could always use some other types of install scripting programs like Wise if you just really really want that uninstall exe...

Anyone understand how (or if?) I can use IMAP to be able to: 1) list the number of pieces of mail in a specified mailbox on a specified server 2) retrieve the oldest piece of unread mail (and leave it unread) from a specified mailbox on a specified server If not in IMAP, does anyone have...

I need to watch for any new text being sent to a 3rd party richtextbox. Because of inefficiencies (and other issues) in simply watching the richtextbox itself and performing updates when it changes, I'd rather just watch for the WM_SENDMESSAGE (or whatever it's using to update the window), make...

There are two ways you can do this - depending upon your vb version. With versions 5 and below (I believe...someone correct me if I'm wrong here) - you have to create at least 1 instance of the control during design. Make sure you set the Index to 0 - then you can use: Load Text1(1)...