Search Results - VBForums

Search:

Type: Posts; User: ColinE66

Page 1 of 13 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    16
    Views
    350

    Re: Program Testers

    Hi reexre - interesting project :)

    I noticed that you ship a lot of bmps for the 'app loading' image. I have a nice pre-loader written using RC5 that i will put into the codebank if you are...
  2. Replies
    3
    Views
    145

    Re: MorphListBox Change detection

    Yes, that's another way of doing it :) I was going to make that suggestion in addition to the one in Post #2 but, well, the purist in me made me make the more 'correct' one ;)

    Don't forget that,...
  3. Re: Count and Sum using SQL (MS Access and ADO)

    I think this is what you are looking for, if I understand the problem correctly:

    SELECT sold, count(1) FROM
    (SELECT DISTINCT lot, sold FROM table)
    GROUP BY sold
  4. Replies
    3
    Views
    145

    Re: MorphListBox Change detection

    Well, all the source code is there and the ListIndex property is stored as the variable m_ListIndex inside the UserControl's code. What I would do, in your shoes, is add a new event to that code...
  5. Replies
    22
    Views
    671

    Re: [Help] Skew image in vb6 like 3D

    I've asked the moderators to move this thread to another part of the forum. No, wait! Another forum altogether; www.mustang-appreciation.com ;)
  6. Re: [RESOLVED] never done this before How to insert 4 tables to 1 table called custom

    Which would require a NOT EXISTS or NOT IN and that is (arguably) more difficult than the UNION?
  7. Re: [RESOLVED] never done this before How to insert 4 tables to 1 table called custom

    Or subsequent posts in the case of salsa ;)
  8. Re: [RESOLVED] never done this before How to insert 4 tables to 1 table called custom

    Perhaps there were duplicates across the 4 tables. Running 4 separate queries might have seen one or more of them fail a constraint check whereas a UNION automatically resolves all the duplicates....
  9. Re: [RESOLVED] never done this before How to insert 4 tables to 1 table called custom

    OK but you really do need to check things before posting here, salsa!
  10. Re: [RESOLVED] never done this before How to insert 4 tables to 1 table called custom

    Hmm. I don't use Access but the SQL looks fine to me. Don't know why the error message suggests otherwise!

    Are you sure that's the exact SQL you are trying to execute?
  11. Re: [RESOLVED] never done this before How to insert 4 tables to 1 table called custom

    Yes. We've established that. What error? :rolleyes:
  12. Re: [RESOLVED] never done this before How to insert 4 tables to 1 table called custom

    Correct! :)

    EDIT: Just noticed your last line. What error are you getting. Always helpful to say...
  13. Re: never done this before How to insert 4 tables to 1 table called customers

    De nada
  14. Re: never done this before How to insert 4 tables to 1 table called customers

    Hardly surprising as field a is not in Y4 and field c is not in Y1!
  15. Re: never done this before How to insert 4 tables to 1 table called customers

    Why not use something like

    INSERT INTO Customers ( FullName)
    SELECT a as FullNameFrom Y1
    UNION
    SELECT b as FullName From Y2
    UNION
    SELECT c as FullName From Y3
    UNION
    SELECT d as FullName...
  16. Replies
    4
    Views
    229

    Re: Presence of Train on Rail WeighBridge

    Yes. Check the value of your pre-declared bIsTrainOnWeighBridge variable. If 'True', the train is on the weigh-bridge. Ask a vague question...
  17. VS 2013 Re: linQ - Need to optimize slow subquery code (.contains)

    My instinct tells me that, if NID and PID are both indexed, the example without the UNION would be quicker. Not tested, though...and off to bed. Have no idea how Sqlite might have optimized it in...
  18. VS 2013 Re: linQ - Need to optimize slow subquery code (.contains)

    For a two-tier hierarchy, surely you don't need the UNION at all?

    i.e.

    "SELECT * FROM Nodes Where NID=@ID Union All Select * From Nodes Where PID=@ID"

    is the same as

    "SELECT * FROM Nodes...
  19. Thread: True = False?

    by ColinE66
    Replies
    17
    Views
    410

    Re: True = False?

    It was just meant as an example of when 'Visible' isn't 'Visible'. To more precisely illustrate an example of your problem we only need one more line of code:



    Option Explicit

    Private Sub...
  20. Thread: True = False?

    by ColinE66
    Replies
    17
    Views
    410

    Re: True = False?

    Start a new project and, then, to the form, add a textbox, leaving it's visible property set to true

    Paste this into the form's code and run the project:



    Option Explicit

    Private Sub...
  21. Thread: Numeric

    by ColinE66
    Replies
    8
    Views
    353

    Re: Numeric

    Happens to the best of us, sometimes, jp :)
  22. Thread: Numeric

    by ColinE66
    Replies
    8
    Views
    353

    Re: Numeric

    Don't really need the loop when you have the Index of the textbox that was changed - it's one of the benefits of having a control array in the first place :p

    If Not IsNumeric(Text18(Index).Text)...
  23. Replies
    3
    Views
    258

    Re: Need a simple demo for vbRichClient.cFSO

    Haven't tried it but a quick look at the Object Browser reveals a MoveFile function:

    Function MoveFile(SrcFileName As String, DstFileName As String, [ReplaceExisting_Dst As Boolean = False]) As...
  24. Re: How to tell the pixels of a JPEG image file using VB6

    In this particular instance, that may well be the case, since this sounds like a one-off exercise on the part of the OP. But, let's be fair, the thread started to side-track toward the most peformant...
  25. Re: How to tell the pixels of a JPEG image file using VB6

    I don't understand you sometimes, dil and I pay attention to what you post because I hold you in high esteem, knowledge-wise. You seem to have this purist view that everything should be coded around...
  26. Re: VB6 Handling of Alpha-Layered Windows with vbRichClient5

    The Cairo surface object has a number of methods to write out it's content to an image file (Surface.WriteContentToJpgFile "C:\picture.jpg" is one) and also the ability to Draw it's content to a...
  27. Replies
    1
    Views
    422

    Re: Image Carousel Class [vbRichClient]

    Update: Enhanced the demo a little to illustrate how to use the parameters in the events that the carousel class raises (in this case a transition effect for the captions)
  28. Replies
    1
    Views
    422

    Image Carousel Class [vbRichClient]

    Here's a class that you can use to create Image Carousel controls as either standard VB6 User Controls or vbRichClient widgets. This demo shows how to do the former; the UC is just a small wrapper...
  29. Thread: vb6 question

    by ColinE66
    Replies
    8
    Views
    440

    Re: vb6 question

    Nah. She's definitely a codder...
  30. Thread: vb6 question

    by ColinE66
    Replies
    8
    Views
    440

    Re: vb6 question

    Happy codding!
  31. Re: [RESOLVED] How to show picturebox outside UserControl

    The tip stays visible on the screen, of course. All lonesome and orphaned :(

    Worse still, if the user Alt-Tabs to another application, the tooltip will appear over the top of the newly focused...
  32. Replies
    6
    Views
    402

    Re: [RESOLVED] DrawText issue

    You can probably use some of the code from the project I recently posted here if you insist on creating your own from scratch:
    ...
  33. Re: Tooltips, Balloon Tips, Tray Notofications [vbRichClient]

    Tidied the code a little and simplified the sub-classing aspects. Also fixed a couple of small drawing errors; one with the tips shadow and the other with the close button.

    Oh, and enhanced the...
  34. Re: Tooltips, Balloon Tips, Tray Notofications [vbRichClient]

    Updated zip file to incorporate the suggestions from #2, including the slide-in effect.
  35. Re: Tooltips, Balloon Tips, Tray Notofications [vbRichClient]

    No problem, Olaf. Though you might want to see if you can improve upon the sizing/positioning aspects of the balloon and its stem. If you can do that the code-size might reduce drastically! My brain...
  36. Re: Tooltips, Balloon Tips, Tray Notofications [vbRichClient]

    Thanks jp. :) I'll look into those suggestions and upload a revised version a little later...
  37. Tooltips, Balloon Tips, Tray Notofications [vbRichClient]

    Here's a dll I've created that provides visually nicer and enhanced (functionality-wise) tooltips. It is dependent on Olaf's vbRichClient (the nice drawing comes via Cairo functionality) but is...
  38. Re: [RESOLVED] Stumped on issue with mshflexgrid and overlaid textbox.

    You're welcome DM :) ...
  39. Re: Stumped on issue with mshflexgrid and overlaid textbox.

    I think some of the problems relate to the order in which events fire.
    Anyway, this approach should cover most of what you are trying to achieve, or at least help to see the solution from a...
  40. Thread: vb6.0

    by ColinE66
    Replies
    5
    Views
    339

    Re: vb6.0

    The thread title was so intriguing I just had to look inside!!
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.