Search Results - VBForums

Search:

Type: Posts; User: ColinE66

Page 1 of 13 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    3
    Views
    106

    Re: Removing Duplicate Rows (Please Help)

    I don't know what you are trying to accomplish but I don't see how you can expect to aggregate by Invoice Number by summing Debit Amounts from your CustDetails table as nothing in that table says...
  2. Replies
    8
    Views
    9,075

    Re: How to Remove Decimal Part

    So, 9 years on from the OP, the answer is to use a .NET method to solve a VB6 problem ;)
  3. Replies
    42
    Views
    1,815

    Re: Program Testers

    Thanks - I'll look into it....
  4. Replies
    42
    Views
    1,815

    Re: Program Testers

    Hi reexre, if you have found a bug with RichTip, can you please post details of how to reproduce in the RichTip thread. Thanks...
  5. Re: Hello need help creating a chart (with or without vbRichClient5)

    Oops. Just noticed you were looking for a line-graph. My links were probably not that helpful! Sorry...
  6. Re: Hello need help creating a chart (with or without vbRichClient5)

    Here ya go, max:

    http://www.vbforums.com/showthread.php?737511-cwPieChart-w-Doughnut-style&highlight=richclient+chart

    another one here
    ...
  7. Re: Hello need help creating a chart (with or without vbRichClient5)

    There are some nice examples of vbRC5 charts in the codebank if you care to search there...
  8. Re: Testing for Optional parameters

    You can also use a default value for optional params and test for that as well:

    Private MySub(Param1 as Long, optional Param2 as long = -1)

    Besides that, optional parameters have a default...
  9. Re: vbRichClient5 - DrawToDC , how to GetFromDC ?

    That would be a welcome addition...
  10. Re: vbRichClient5 - DrawToDC , how to GetFromDC ?

    Ooh, meant to ask...

    @Olaf: Can I do the above with RC5's cStream class? Wasn't obvious to me how...
  11. Re: vbRichClient5 - DrawToDC , how to GetFromDC ?

    wrt to the OP, I normally do this via the following function (needs a reference to olelib.tlb)



    Public Function StdPictureToByteArray(ByVal image As StdPicture) As Byte()
    Dim abData() As Byte...
  12. Re: Copy all properties from Form to other Form

    Fair point. :) There's way too much second-guessing that goes on here due to poorly-asked questions...
  13. Re: Copy all properties from Form to other Form

    I assumed that the OP was asking about copying a form with all of its controls but we'll see, I suppose!
  14. Replies
    42
    Views
    1,815

    Re: Program Testers

    Aah, OK. I thought it was supposed to be something for the user to look at while the program loaded....
  15. Re: Copy all properties from Form to other Form

    If that were true you couldn't have Command1 on more than one form...which you can!
  16. Replies
    42
    Views
    1,815

    Re: Program Testers

    I was referring to all the images named like 'A 0 M 0 of 40 size 11.bmp' that are in the Kernels folder. They appear to only be used for the 'visual effect' while the program is initialising.
  17. Replies
    42
    Views
    1,815

    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...
  18. Replies
    3
    Views
    170

    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,...
  19. 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
  20. Replies
    3
    Views
    170

    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...
  21. Replies
    22
    Views
    797

    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 ;)
  22. 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?
  23. Re: [RESOLVED] never done this before How to insert 4 tables to 1 table called custom

    Or subsequent posts in the case of salsa ;)
  24. 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....
  25. 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!
  26. 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?
  27. Re: [RESOLVED] never done this before How to insert 4 tables to 1 table called custom

    Yes. We've established that. What error? :rolleyes:
  28. 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...
  29. Re: never done this before How to insert 4 tables to 1 table called customers

    De nada
  30. 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!
  31. 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...
  32. Replies
    4
    Views
    238

    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...
  33. 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...
  34. 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...
  35. Thread: True = False?

    by ColinE66
    Replies
    17
    Views
    441

    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...
  36. Thread: True = False?

    by ColinE66
    Replies
    17
    Views
    441

    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...
  37. Thread: Numeric

    by ColinE66
    Replies
    8
    Views
    396

    Re: Numeric

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

    by ColinE66
    Replies
    8
    Views
    396

    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)...
  39. Replies
    3
    Views
    292

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