Search:

Type: Posts; User: techgnome

Page 1 of 13 1 2 3 4

Search: Search took 0.13 seconds.

  1. Replies
    24
    Views
    505

    Re: MsgBox Timer on some Forms

    Jeezes... Immma dork... I thought I was downloading the OP's project... I wan't paying close enough attention and didn't realize it was your project. Thank god it's friday and the weekend is here.......
  2. Replies
    24
    Views
    505

    Re: MsgBox Timer on some Forms

    Was it? I jsut opened the frm file ... don't have Vb6 installed...


    yeah, then I don't have an idea what's going on.


    -tg
  3. Replies
    24
    Views
    505

    Re: MsgBox Timer on some Forms

    there was ...


    Begin VB.Timer Timer
    Enabled = 0 'False
    Left = 480
    Top = 1800
    End
  4. VS 2022 Re: SMTP email generates error on 11th email send

    Can you sent 10 emails with no pause ... then wait 30 seconds, then try to send another 10?

    -tg
  5. Replies
    6
    Views
    176

    Re: Issue with SQLite DB

    SQLite doesn't have a DateTime type ... you'll need to convert the value to an integer value before passing it in. That means you also need to convert it FROM the integer TO a DateTime.

    How you go...
  6. Re: SQL Server Query - count if any rows have a certain value

    Starting with this:


    SELECT customer_part_number, P21.dbo.p21_view_oe_line.extended_price, P21.dbo.p21_view_oe_line.disposition, P21.dbo.p21_view_oe_line.parent_oe_line_uid
    FROM...
  7. Re: Extreme New Guy - Not Even Sure I'm in the Right Place

    These are so bad ... I need to get the schist outta here.

    -tg
  8. Re: SQL Server Query - count if any rows have a certain value

    There wasn't a _need_ to count the number of S rows ... just that at least ONE exists. If one does, then the price is 0... otherwise, get the price from the EQ_PORT row.

    -tg
  9. Re: SQL Server Query - count if any rows have a certain value

    Can I claim temporary insanity as I hadn't had my coffee yet? Still ... it should work with that tweak.

    -tg
  10. Re: SQL Server Query - count if any rows have a certain value

    Get all the EQ_PORTs ...


    select SONumber, EXTPRICE where disposition = 'EQ_PORT'


    Get the "S" rows:


    select SONumber, EXTPRice where disposition = 'S'
  11. Re: Extreme New Guy - Not Even Sure I'm in the Right Place

    It's not backwards ... It's different and not the way most of use would fill a combobox based on database information. Sometimes though, that's all you need ... just straight up text in a drop down....
  12. Re: Extreme New Guy - Not Even Sure I'm in the Right Place

    First... welcome!
    Secondly - when you create a connection object, it is expecting a STRING for it's parameter... so this:


    Dim CNN As New OleBdConnection(Provider = Microsoft.Jet.OLEDB.4.0;Data...
  13. Replies
    2
    Views
    166

    Re: Problem with integer

    I was thinking along the line of usibng the .Tag property ... set it to True or "Available" initially ... then in the if statement, also check the .Tag. If it's True or "Available" then you set it...
  14. Re: Service app not getting SystemEvents.SessionSwitch

    I could be wrong about this, but Services run under a special service account... not the user ... so there's no context switching happening. I could be wrong though... probably am... But if not, that...
  15. Replies
    48
    Views
    803

    Re: Let's form an IT-Band....

    Here Comes the Ping Again (eurythmics)

    -tg
  16. Replies
    48
    Views
    803

    Re: Let's form an IT-Band....

    WinRAR Love (Golden Earring)
    Pour Syntax Sugar on Me (Def Leppard)
    Don't Thread on Me (Metallica)
    Where the Streams Have No Name (U2)


    -tg
  17. Replies
    4
    Views
    439

    Re: Small Wireless Monitor

    Look at a Raspberry PI .... there's monitors that can be attached to them, I've seen as small at 3.5" and as large as 7" ... some even as touch screens .... and it's possible to run a form of Windows...
  18. Re: Check if same app runs on other PC in local network

    Guess that begs the question: is the intent to only have 3 computers with it installed period? With three being the number of the count, thou shant count two unless proceeding straight to three. Nor...
  19. Replies
    107
    Views
    1,649

    Re: Here we go again...

    Not sure what anyone was/is supposed to do about it... it was a house of cards...
    I remember the Enron debacle... no one batted an eye at that... why should this be any different?
    And when it...
  20. Re: Query Question how to get desired result.

    A subquery of:


    select recordid, count(id) PSCount from yourTable where status='PS' group by recordid


    Then you can left join on record ID ... then use a case or isNull on PSCount to either...
  21. Re: ARRAY of label and cursor mouse move

    Isn't there MouseEnter and MouseLeave events? OR am I smoking something and not remembering it right?


    -tg
  22. Re: How to change properties of added control in table layout panel

    TableLayoutPanel1.Controls.Add(New UserControl1 With {.Textbox1.Text = "SOMETHING"}, 0, 0)


    You should be exposing a .Text property in your UC that then sets (and gets) the .Text of the textbox...
  23. Replies
    1,037
    Views
    25,705

    Re: Musk buys Twitter

    pretty much.

    There's privately held companies - which means the ownership (may or may not be stock) is held by a selected group of one or more individuals. Then there's publicly traded companies -...
  24. Replies
    6
    Views
    457

    VS 2022 Re: Moving from SQL Server to MySQL

    It changes everything. The reason: Hosted databases on the web should *never* be publicly accessible. There should *always* be a middle man that talks to the database. Often called a web service. It...
  25. Replies
    1,037
    Views
    25,705

    Re: Musk buys Twitter

    Elon does... lock, stock, and both barrels... and now both checkmarks...


    The "public" and by that I mean the stockholders of the company.

    Before that (before their IPO) then it would have...
  26. Replies
    9
    Views
    335

    Re: I found a MIDI file in vb6.exe->

    And people wonder why Office products are so bloated...

    -tg
  27. Thread: SQL Value +1

    by techgnome
    Replies
    5
    Views
    773

    Re: SQL Value +1

    $lKey->Update('inuse', + 1);
    $lKey->Save();


    You're not updating the data there ... you're setting it to 1. You need to get the current value, +1 it, THEN use that result in the...
  28. Thread: SQL Value +1

    by techgnome
    Replies
    5
    Views
    773

    Re: SQL Value +1

    I "do" ... but it's PHP, not VB so it's another lost thread that's going to get all the wrong responses...

    stand by, asking the mods to move it...


    -tg

    EDIT - while it is a DB question,...
  29. Replies
    18
    Views
    532

    Re: Select Case Trouble

    That's because this


    Case Duration > 0.5 And Duration < 1

    (and the others like it) is wrong...



    Case Is > 0.5 And Is < 1
  30. Replies
    3
    Views
    244

    Re: Change of database SQLExpress to MySql

    Depends on which version of VB ... if VB6 then it might need some tweaking on the SQL iteself... if .NET then you'll need to swap out the SQLServer objects fro the MtSQLConnector ones... which should...
  31. Replies
    6
    Views
    445

    Re: Date Format in SQL string

    you have the parameter in the query ... that's what the @thisDate is ... that's the parameter ... and you set it just like you are.... using .AddWithValue ...


    BUT ... because you have it in a...
  32. Replies
    6
    Views
    445

    Re: Date Format in SQL string

    1) as noted, you should be using parameter, not concatenating string. Then the format wouyldn't matter.
    2) Dates are just a value, they don't have an inherent format... the format you see in the db...
  33. Replies
    11
    Views
    551

    Re: Simulate multiple classes in one module

    I'm not sure that you can put the classes all into one file ... but to be honest, I don't know that you can't. Memory wants to tell me that they need to be in individual .cls files ... but it's...
  34. Replies
    69
    Views
    1,642

    Re: Average age of people on this forum

    Nice ... somewhere in storage I have a Timex Sinclare 1000 ... with a whopping 1k memory!

    won't reveal exact age, but I'm in the range between fafone and zvoni ...

    Learned on the Apple][e ......
  35. Replies
    1,037
    Views
    25,705

    Re: Musk buys Twitter

    well, it's simple to think like a woman: men are pigs, all they want to do is drink beer and jump anything that moves.


    -tg
  36. Re: Bogus "Out of Memory" message when sitting on Ctrl+Y in the IDE

    I've always just used shift-arrow down.... scroll scroll scroll ... Delete... nothing in the clipboard.

    Also, depending on what I'm eliminating, I'll fold the code, select it then delete it...
    ...
  37. Replies
    4
    Views
    321

    Re: Bypass Startup Parameters

    What also wasn't clear is if this is an app the OP is working on? Also running from the command line? Through the IDE? Through a shortcut? So many questions, will have to wait for the answers.

    ...
  38. Re: Unhide selected datagridrows based upon condition

    This is why debugging is important ... stepping through the code line by line and checking values as you go may have pointed out what was going on.
    si pointed out the correction, but here's why the...
  39. Replies
    4
    Views
    321

    Re: Bypass Startup Parameters

    If you're passing parameters to hte app,. then it's not automatically choosing things. It's choosing things based on the parameters passed in. So you have the choice, pass in parameters and let it do...
  40. Replies
    1,037
    Views
    25,705

    Re: Musk buys Twitter

    That's the thing ... you don't learn to think like that ... you already do... that's what leads to genderdisphoria. The literal "feeling like a woman/man trapped in a man's/woman's body" .... The...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width