Search:

Type: Posts; User: Spooman

Page 1 of 13 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    32
    Views
    3,340

    Re: Delete duplicate in access table

    Luca

    The best I can do is for DAO, and one field only


    strSQL = "SELECT DISTINCT [field_cf] FROM table1

    HTH
    Spoo
  2. Re: New Firefox: BMC MULTI-CLOUD PopUp Driving Me Nuts!

    Agreed
    I'm on the East Coast, and it seems to go away after 1:00 PM +/-
  3. Re: Trying to enable control tab and control shift tab results in unexpected navigati

    Ilia

    FWIW, I was sort of able to recreate your InkEdit issue ...

    Objects

    PictureBox .. blue
    TextBox .. white
    InkEdit .. yellow
  4. Re: New Firefox: BMC MULTI-CLOUD PopUp Driving Me Nuts!

    Plan B:
    Drag your browser widow down about 1-1/2 inches, but don't tell any one else.
  5. Replies
    25
    Views
    16,925

    Re: Ad at bottom of pages

    Amen
    At least you've help confirm I'm not the only one still getting them
  6. Re: Trying to enable control tab and control shift tab results in unexpected navigati

    Ilia

    re:



    .. I take it that in lieu of Crtl-Tab, an alternative would be to use the mouse to click on the next tab.


    Does that work, or does it produce same "loss of text"?
  7. Re: New Firefox: BMC MULTI-CLOUD PopUp Driving Me Nuts!

    Amen
    That why I've resorted to plan B
  8. Thread: VB6 Work

    by Spooman
    Replies
    6
    Views
    7,304

    Re: VB6 Work

    OB1

    Re PM's ..

    click Settings on menu-bar at upper right of the screen
    At top left, under My Messages, click Sent



    BTW, a belated welcome to the Forums .. :wave:
  9. Re: New Firefox: BMC MULTI-CLOUD PopUp Driving Me Nuts!

    Chris

    FWIW, here is a Forum Feedback thread on the same matter

    http://www.vbforums.com/showthread.php?854481-Ad-at-bottom-of-pages

    I'm using Chrome, and still have problems with it, at least...
  10. Re: [RESOLVED] how do i remove duplicate data while looping through a listview

    Niya

    I echo Sammi's thought

    Sadly, I have no experience with Collection class.
    Now I have a reason to gain some .. :)

    Thanks

    Spoo
  11. Re: [RESOLVED] how do i remove duplicate data while looping through a listview

    Niya

    In your post #19, you referenced this function


    If Not uniqueColors.ContainsKey(_pixels(i)) Then
    uniqueColors.Add(_pixels(i), _pixels(i))
    End If

    While this may be a .Net...
  12. Replies
    12
    Views
    8,031

    Re: How to draw a waveform graph from mp3 or wav?

    DM

    Maybe for starters (ie, to get the basics down pat), you might consider using a smaller file.

    Spoo
  13. Thread: Format a date

    by Spooman
    Replies
    11
    Views
    3,107

    Re: Format a date

    Back at ya, Sammi. I was making a loose reference to the Y2K issue .. read as time-warp.
  14. Thread: Format a date

    by Spooman
    Replies
    11
    Views
    3,107

    Re: Format a date

    Maybe 19 days after the OP and just before you know what
  15. Replies
    12
    Views
    8,031

    Re: How to draw a waveform graph from mp3 or wav?

    Guys

    Thanks for the links

    Spoo
  16. Thread: Who is morose?

    by Spooman
    Replies
    36
    Views
    6,451

    Re: Who is morose?

    And then there's the one that goes "Less is more"

    Seems like that NYC condo/hotel is taking this to heart and is removing whats-it's name.
  17. Re: [RESOLVED] how do i remove duplicate data while looping through a listview

    Good one Niya .. :)
  18. Replies
    6
    Views
    3,020

    Re: XOR Checksum for High And Low Byte

    OB1



    Emphasis added

    Spoo
  19. Thread: Who is morose?

    by Spooman
    Replies
    36
    Views
    6,451

    Re: Who is morose?

    Agreed

    Apparently, though, the gist of my post was unclear ...

    I was thinking more along the lines that by making his multiple denials, he is merely setting himself up.
    Not real clever on...
  20. Replies
    6
    Views
    3,020

    Re: XOR Checksum for High And Low Byte

    Neat link
  21. Replies
    12
    Views
    8,031

    Re: How to draw a waveform graph from mp3 or wav?

    DM

    Where did you find Olaf's and theTrick's code?
  22. Thread: Who is morose?

    by Spooman
    Replies
    36
    Views
    6,451

    Re: Who is morose?

    Actually. speaking of the Devil, one would think Moore would be familiar with forensics.

    Regarding his total denial regarding the yearbook thingy ..

    Test the ink .. can be dated
    Check for...
  23. Thread: Who is morose?

    by Spooman
    Replies
    36
    Views
    6,451

    Re: Who is morose?

    Oink
  24. Replies
    2
    Views
    4,173

    Re: Enhance links .. add underline

    Bold isn't a bad idea, but Bold Green is hard to read, too.

    Bold Blue, on the other hand, with [U], really "pops", IMHO.
  25. Replies
    2
    Views
    4,173

    Enhance links .. add underline

    Just setting the font to blue is sometimes hard to interpret as a link ..

    153923

    Here is where it came from.

    As you can see, I manually added the Underline tags.
    It "pops".

    Could you...
  26. Re: how do i remove duplicate data while looping through a listview

    Salsa

    FWIW, I finally tested my post #2



    Sub Command2_Click()
    '
    With ListView1
    cc = .ListItems.Count
  27. Re: how do i remove duplicate data while looping through a listview

    Salsa

    Re Sammi's post,



    With LsVw
    For i = 1 To .ListItems.Count
    For j = .ListItems.Count To (i + 1) Step -1
    If...
  28. Re: how do i remove duplicate data while looping through a listview

    My quick read of your code was that A was a loop counter going from 1 to ListItems.Count
    So, A would increment

    1
    2
    3
    etc
  29. Re: how do i remove duplicate data while looping through a listview

    Salsa

    How about something like this ...

    It creates a long string of each unique Item, tests by using Instr()



    Dim A As Integer
    Dim AStr as String
  30. Re: [RESOLVED] How do I move existing controls into a frame?

    Interesting
  31. Re: [RESOLVED] How do I move existing controls into a frame?

    Alex

    Glad it worked.

    Out of curiosity, how did you select all 10 at once?

    Spoo
  32. Re: [RESOLVED] How do I move existing controls into a frame?

    Alex

    I just tried this ...

    Put 2 OptionButtons on a Form
    Put 1 Frame on the Form

    153899

    Then ...
  33. Re: question regarding screen size and controls

    Salsa

    ,, and/or a screenshot

    Spoo
  34. Thread: Who is morose?

    by Spooman
    Replies
    36
    Views
    6,451

    Who is morose?

    Roy Moore?
    Charlie Rose?

    I guess I go with Charlie.
    Too bad .. he usually had good guests on his show
  35. Thread: Post Race!

    by Spooman
    Replies
    68,852
    Views
    17,966,650

    Re: Post Race!

    A true bell-ringer, no less.
  36. Replies
    32
    Views
    4,243

    Re: Obtaining informations about trapped error

    DEX

    Who knew?
    Thanks

    Spoo
  37. Thread: Post Race!

    by Spooman
    Replies
    68,852
    Views
    17,966,650

    Re: Post Race!

    What is a CRM website?
  38. Replies
    32
    Views
    4,243

    Re: Obtaining informations about trapped error

    How does one do that?
  39. Replies
    32
    Views
    4,243

    Re: Obtaining informations about trapped error

    Herve

    Which case applies?

    If you're working with compiled app, I'm not sure.
    If you're running in the IDE, it should tell you.



    If the former, a brute force approach might be to...
  40. Replies
    41
    Views
    12,251

    Re: Obtain Form Size in Millimeters

    So, are you saying that if the resolution is the same on each, and a form is 12 inches wide on the 24 inch screen, it will be 21 inches wide on the 42 inch screen?

    I'd have thought it would be...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width