Search:

Type: Posts; User: techgnome

Page 1 of 13 1 2 3 4

Search: Search took 0.15 seconds.

  1. 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
  2. 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
  3. 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
  4. 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'
  5. 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....
  6. 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...
  7. Replies
    2
    Views
    133

    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...
  8. 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...
  9. Replies
    48
    Views
    773

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

    Here Comes the Ping Again (eurythmics)

    -tg
  10. Replies
    48
    Views
    773

    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
  11. Replies
    4
    Views
    400

    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...
  12. 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...
  13. Replies
    91
    Views
    1,350

    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...
  14. 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...
  15. 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
  16. 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...
  17. Replies
    978
    Views
    24,612

    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 -...
  18. Replies
    6
    Views
    443

    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...
  19. Replies
    978
    Views
    24,612

    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...
  20. Replies
    9
    Views
    330

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

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

    -tg
  21. Thread: SQL Value +1

    by techgnome
    Replies
    5
    Views
    702

    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...
  22. Thread: SQL Value +1

    by techgnome
    Replies
    5
    Views
    702

    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,...
  23. Replies
    18
    Views
    530

    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
  24. Replies
    3
    Views
    238

    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...
  25. Replies
    6
    Views
    430

    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...
  26. Replies
    6
    Views
    430

    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...
  27. Replies
    11
    Views
    547

    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...
  28. Replies
    69
    Views
    1,603

    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 ......
  29. Replies
    978
    Views
    24,612

    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
  30. 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...
    ...
  31. Replies
    4
    Views
    313

    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.

    ...
  32. 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...
  33. Replies
    4
    Views
    313

    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...
  34. Replies
    978
    Views
    24,612

    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...
  35. Replies
    3,320
    Views
    410,351

    Re: What song are you listening to right now?

    https://www.youtube.com/watch?v=8SbUC-UaAxE
    After a trip trhough Coolio, 2Pac, Outkast, and Warren G.... I found myself here...

    -tg
  36. Replies
    3,320
    Views
    410,351

    Re: What song are you listening to right now?

    https://www.youtube.com/watch?v=sOnqjkJTMaA
    A classic...

    -tg
  37. Re: No need to declare variables in form events?

    Me is always implied. it represents the current instance of what ever class/object you are in at that moment.

    Or you could just do


    Dim dgv as DataGridView = ViewTracksDataGridView

    You...
  38. VS 2022 Re: Sending email from a specified account (Outlook)

    That works because it's manipulating Outlook. The alt account still has to be setup up in the Outlook client in order for that to work.

    -tg
  39. VS 2022 Re: Sending email from a specified account (Outlook)

    The short answer is you can't ... You're opening Outlook and it's going to open using what ever profile it's designated for it.
    If you want to send from an alt account, you're going to need to...
  40. Replies
    1,185
    Views
    56,768

    Re: Current Russia Ukraine tensions

    Wasn't it because of that incident that the "red phone" was installed at both ends?


    -tg
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width