Search:

Type: Posts; User: techgnome

Page 1 of 13 1 2 3 4

Search: Search took 5.26 seconds.

  1. Replies
    4
    Views
    55

    Re: SQL Query to eliminate duplicates

    No it doesn't. Firstly you might want to rethink using the term client when dealing with hotel info... unless you're in the red light district, you don't want clients at your hotel. IF you have to...
  2. Replies
    4
    Views
    89

    VS 2013 Re: Clear last Document in Printdocument

    hmm... apparently I'm not sure then...




    aaaaah.... I found it...
    bloody global variables...

    try clearing them out when you're done... or before you start using them.
  3. Replies
    4
    Views
    89

    VS 2013 Re: Clear last Document in Printdocument

    Its hard to read, but it looks like you're missing an .EndDocument...that's what tells the PrintDocument object that you're done with the document and to release it to the printer.

    -tg
  4. Replies
    7
    Views
    254

    Re: vb6 add table rows webbrowser

    I'm in the office at work, where are you?
    I don't jsut download the code of random people. Heck I don't even download the code of most people I do know on here.
    Downloading code and fixing it on...
  5. Replies
    6
    Views
    153

    Re: Add a title to a site in a web browser

    ok... hang on... WordPress is a template-based website. So if there is no title for your website, then it's because you didn't enter one on the configuration of your WordPress admin area. It's that...
  6. Replies
    7
    Views
    254

    Re: vb6 add table rows webbrowser

    If it works, why does it need to be modified?

    -tg
  7. Re: Structuring a Select Case Block (With a Single Data Type testexpression)

    Wouldn't this have worked?



    Select Case mySingle
    Case Is < 12
    '
    Case 12
    '
    Case Is < 24
  8. Replies
    16
    Views
    351

    Re: Automation???

    In otherwords... it looks like you're only using the .Text property anyways... which is probably a String... so declare the parameter as a String, and rather than pass in the object, passing the...
  9. Thread: Lupin ?

    by techgnome
    Replies
    14
    Views
    273

    Re: Lupin ?

    I'll have to check those out. Ragnarok was really good.
    For the most part sub-titles don't bother me, except that I may miss something on screen while trying to read the captions...


    -tg
  10. Thread: Lupin ?

    by techgnome
    Replies
    14
    Views
    273

    Re: Lupin ?

    Yes! I was annoyed to get to the end of that episode and find out there weren't more waiting. I find myself watching more and more of these imports on Netflix. IT started with Money Heist (original...
  11. Re: Stored Procedure Stepping on Itself

    I think that right there is the issue... I could be wrong about this, it's been some time since dealing with transactions like this, but the transactions are tied to the connection... and if you have...
  12. Re: Receive Data from Serial Port and show them in Datagridview

    Looks like the problem is lack of a EOL terminator... there's no way to know when you've reached the end of the data. That's a problem. That's why Mc_Vb suggested changing the output to include a...
  13. Replies
    11
    Views
    291

    Re: SQLite save images in database

    But it isn't just diskspace... though is it? It's pagespace... it's the allocation of rowspace by the DBMS too. Because there's always more than just the image. There's the metadata that goes with...
  14. Replies
    3
    Views
    164

    Re: Compile error

    That was my thought... it referrs to the currently running application,Word, Excel, Powerpoint... I don't think you can overwrite it like that.

    Just what are you trying to do?

    -tg
  15. Replies
    11
    Views
    291

    Re: SQLite save images in database

    Agreed it was a general blanket statement, I just want to make sure that the OP does it with their eyes wide open. I've been in too many situations where blinders were on and this was "the solution"...
  16. Replies
    11
    Views
    291

    Re: SQLite save images in database

    Yes. Yes. Yes. A million times yes.

    -tg
  17. VS 2019 Re: Edit TextBox of an UserControl from another CLass

    I wasn't trying to be mean... I'm confused. But then again, that's not unusual for this forum... we tried to help and give you the best possible solution and you went off on a tangent with something...
  18. Replies
    11
    Views
    291

    Re: SQLite save images in database

    If you can help it... don't. Do what you can to avoid it. If you can't make sure you're using the smallest images with high compression and making it as small as possible before storing it.
    Trust...
  19. VS 2019 Re: Edit TextBox of an UserControl from another CLass

    So to recap:
    "I need would like to do X, but can't figure it out."
    "To do X, the best way, would be to do A and B, along with C."
    "But it's not that simple because of L M N O P."
    "Would have been...
  20. Replies
    31
    Views
    761

    Re: Getting a new machine

    I'm the reverse... I'd prefer to invest in the slim form that I can move about. Take the two worlds I live in: work & home. For work, they gave me an Apple MacBook Pro. My setup includes two...
  21. VS 2019 Re: Edit TextBox of an UserControl from another CLass

    In short: no. That's like asking if you're bank would know if your private wallet in your pocket would know if you had $20 or $10... the list is private, meaning it is only visible to the scope in...
  22. Replies
    3
    Views
    321

    Re: VB6 Make Activex OCX For vb.net

    .NET doesn't use OCX files. In fact it doesn't rely on COM in the first place, which is what OCX files are based upon. It's what makes them easily usable in VB6. So in order to use them in VB.NET,...
  23. Replies
    46
    Views
    1,002

    Re: join three tables to get Sum

    Hmmm... I see the problem -- it became apparent when I tried to re-write it...


    " GROUP BY PersonID) AS T2 ON T2.PersonID = T1.PersonID where T1.PersonID= 2"

    Dont join your second table to...
  24. Replies
    46
    Views
    1,002

    Re: join three tables to get Sum

    LEft join is what you want... but you need to handle NULL values.... when you add NULL vlaues, the whole expression becomes null...
    So when you get to this point: SELECT TarifTotal + RecetteTotal AS...
  25. Replies
    9
    Views
    399

    VS 2019 Re: NullReferenceException when adding list

    Well it means that something on the line on which occurred us null or nothing. Your best bet is to examine each object from left to right when it happens. From experience, I can tell right off the...
  26. Re: Javascript code for a binary translator?

    Tack on "0000000" to the front, then take the right 8 ...

    -tg
  27. Replies
    6
    Views
    249

    Re: Typed Dataset cannot read database...

    Who says it references anything? It should be the PKey for the table. At least that's what I'd expect it to be given the info.

    -tg
  28. Replies
    9
    Views
    275

    Re: Assistance Visualizing Schema

    Yeah, that's the kind of things the groups tble handled in the schema I used to work in... and it also tracked it over time, with begin and end dates... It just depends on how important it is. From...
  29. Replies
    9
    Views
    275

    Re: Assistance Visualizing Schema

    In a previous life I used to work on a CMS that did fundraising... so households were something we had to deal with... along with deaths, divorces.... and other things... in fact, it was actually...
  30. Replies
    9
    Views
    275

    Re: Assistance Visualizing Schema

    I think the issue might be thqt your Household table is really an Address table... I'd rename it to Address, and then create a Household table where you can create a Household ("John and Jane Sith")...
  31. Replies
    20
    Views
    545

    Re: Need help with this query

    Then there must be something wrong with your data...

    Here is a script I just used to replicate your tables and data:



    create table Item_Tbl (
    ID INTEGER,
    Item CHAR(10 CHAR)
    );
  32. Replies
    14
    Views
    477

    Re: comma value in csv file

    That's all fine and dandy (and quite possibly dandy and fine) but it still doesn't address the problem at hand, which is how to deal with CSV data when the data also has a comma in it somewhere.
    ...
  33. Re: VB.NET DataGridView pick Max NEGATIVE Number under 0 or Above

    Wait... are you talking about that 0 in the last column there where there is no data above it?
    If there's no data, the default for numbers will be 0... that's probably what's happening here......
  34. Replies
    1,745
    Views
    105,519

    Re: Corona virus, China major city lockdowns, etc.

    Be sure to let us know when your third eye grows... an pictures too... we demand pictures...

    -tg
  35. Replies
    12
    Views
    442

    Re: Help with IO.DirectoryInfo

    Awesome... I didn't realize you were resource hopping at first, otherwise I would have pointed you in that direction at first. Man, that drags up some (not so) fond memories. :D

    -tg
  36. Re: VB.NET DataGridView pick Max NEGATIVE Number under 0 or Above

    But 0 is greater than -70 or -80... so if it's part of the dataset you're looking at, then that's the correct result. If it isn't, then there's something else that's wrong.
    Idealy you should be...
  37. Replies
    12
    Views
    442

    Re: Help with IO.DirectoryInfo

    Also, I don't think IIS_IUSRS is a global account, or a network account, it's a local machine account... it's used to access local resources when necessary. So the IIS_IUSRS account on machine A...
  38. Replies
    5
    Views
    352

    Re: Data base show patern

    In short, you'll need some additional info, and will need to know there's more than one file. Then you'll need to start a loop, and look for the additional files to play them automatically. For...
  39. Thread: FYI: Adios

    by techgnome
    Replies
    59
    Views
    2,319

    Re: FYI: Adios

    MY sister used to have a Ball Python... yes his name was Monty.

    -tg
  40. Replies
    5
    Views
    352

    Re: Data base show patern

    So what is your question exactly?

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



Click Here to Expand Forum to Full Width