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

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

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

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

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

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