Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. WaterTight

    XML for Excel - Date Function showing serial

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

    I still don't understand joining

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

    I still don't understand joining

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

    Joining Multiple (3 or more) Tables

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

    Joining Multiple (3 or more) Tables

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

    Joining Multiple (3 or more) Tables

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

    Joining Multiple (3 or more) Tables

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

    Am I just an idiot?

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

    Am I just an idiot?

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

    SendMessage Combination CTRL+Enter

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

    Forcing Flash Events

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

    Forcing Flash Events

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

    Subclassing 3rd Party RichTextBox

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

    Opening and Saving a Form

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

    trying to open a file for a rich textbox.

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

    why no uninstall in vb6?

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

    Using IMAP in for MailCount and OldestMailDateTime

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

    Subclassing 3rd Party RichTextBox

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

    Automatically Generate

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

Part and Inventory Search

Back
Top