Search:

Type: Posts; User: techgnome

Page 1 of 13 1 2 3 4

Search: Search took 37.63 seconds; generated 35 minute(s) ago.

  1. Re: Issues with connecting to SQL Server from VB.Net using SQLOLEDB connection string

    Is there a reason for using SQLOLEDB and ADO and not ADO.Net with a proper provider?

    -tg
  2. Replies
    1,501
    Views
    66,271

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

    I should know better than to enter this thread with a hot open mic conference call ... I almost did a spittake when I saw the iodine comment/.

    -tg
  3. Replies
    8
    Views
    279

    Re: convert vb6 program to vb.net

    With out seeing the code, that's not possible. As previously stated: it depends. Is the data scraped? Or is it obtained through an API?
    You're asking us to scope a project that isn't even ours,...
  4. Thread: calender

    by techgnome
    Replies
    4
    Views
    122

    VS 2017 Re: calender

    I can see this going a number of ways... in an effort to head that off, I'm going to ask a number of questions:
    1) What did the documentation tell you?
    2) You do realize the control (if it's the...
  5. Replies
    4
    Views
    211

    VS Code Re: Crystal Report sql conn in VB.net

    The real answer is that you should be setting the authentication, including the user and password on the report and all subreports ...

    -tg
  6. Thread: calender

    by techgnome
    Replies
    4
    Views
    122

    VS 2017 Re: calender

    I tried that once with Google Calendar... now I have scratches on my phone...

    -tg
  7. Replies
    8
    Views
    279

    Re: convert vb6 program to vb.net

    Are you asking someone to do it for you? Or what it would take for you to do it yourself?
    Either way, it depends a lot on the complexity of the code, components used, experience of the developer......
  8. Replies
    3
    Views
    155

    Re: Can I view contents of a recordset?

    The only way I know of is programatically... there's no viewer or anything built-in in the IDE itself to vview a recorset to see the schema.
    There might be an add-in or something.
    Can't you...
  9. Re: Why do web pages render differently on different computers?

    The short answer: you can't.
    The longer answer: you develop against a known set of circumstances and settings.

    I work on a system that's utilized by the VA. The standards by which I have to...
  10. Re: Check if Date is greater than todays date

    what happens when you change it to this:


    If rs.Fields("ShipDate") > Now() Then


    -tg
  11. Re: Return the Index value of a datatable, by searching the Datatable

    No, that's not what you want to do. What you want to do is simply update your DGV because it should already be bound to the datatable. Since it's already bound, updating one should update the other....
  12. Replies
    149
    Views
    3,793

    Re: Presidential Debates

    Step 1: get rid of all the %&$%$ standardized testing.
    Seriously. Teachers aren't teaching material any more. They are teaching to the tests... the kids then spend the last 4-6 weeks of each school...
  13. Replies
    149
    Views
    3,793

    Re: Presidential Debates

    Meh... they're more the Republican Party Press Corp... it's just that Trump is "head" at the moment, so they're his shill... Once he's out, they'll drop him... may not turn against him, but they'll...
  14. Replies
    21
    Views
    490

    Re: Read background color of a bitmap

    Further more, bitmaps don't support the background concept the way a GIF or PNG does where there is an alpha channel - which when set is what is used to provide a transparent background.
    There is...
  15. Re: [RESOLVED] Sqlite how to check if a field is empty?

    Just out of curiosity, how do y'all handle cases where there's a difference between a null number and a 0?
    Example: Grade books, a null means no grade has been recorded - it's an unknown. A 0 on...
  16. VS 2019 Re: VS2019 Json undefined when using Webbrowser

    You're correct, although it's IE7... but you're on the right track there...



    The version is irrelevant... the compatibility setting is what matters. There's a registry setting you can change...
  17. Re: How to remove a section in the middle of a video?

    Use something else more suited to editing video. Since I'm on Linux I use OpenShot for editing. It has a zoom feature that allows me to step through the video at different rates so that I can get...
  18. Re: Delete a file on android device with web page

    Uh, yeaaaaah... I don't think that's possible... if it were, people could write web pages that could easily brick people's phones by deleting various files.

    It just seems like a bad thing right...
  19. Re: Is it possible to pass a javascript variable to a global vb.net variable

    That all makes even less sense ... Unless this is a web app and not a windows app... in which case... that's a completely different animal, and a completely different part of the forum.

    -tg
  20. Re: Is it possible to pass a javascript variable to a global vb.net variable

    That's almost like saying, I have a toaster, can I use it to start my car?

    The short answer is: no.

    The slightly longer answer is: What does one have to do with the other? Unlikely. Depends on...
  21. Re: Can you refer to a recordset by a variable rather than explicitly?

    Do you use all of them all the time... or is only one in use at any given time?
    Would something like this work:


    Dim currentRS as RecordSet

    Select Case Mid$(SearchStr$, 2, 1)
    case "A"
    ...
  22. Re: Setting header text in different column for .xls file

    1) changing the extension doesn't actually convert the file... you still have a CSV but now it's got a xls extension...
    2) You were losing them visually... because that's what excel does. it deals...
  23. Re: Code to Display Data Matrix Barcode Reading With Separators

    Not real versed in bar codes other than scanning them at the grocer's... but... a few things come to mind:

    Are you *sure* the group separator is a space?

    What created the bar codes in the first...
  24. Replies
    22
    Views
    790

    Re: DataGridView won't refresh

    adaptor.InsertStatement =
    adaptor.UpdateStatement =
    adaptor.DeleteStatement =

    That's all there is... I don't remember if they are strings or not (probably not)... but shouldn't be too hard to...
  25. Replies
    149
    Views
    3,793

    Re: Presidential Debates

    https://www.youtube.com/watch?v=Wsije1KetVw
    This was the best coverage of the debate...

    -tg
  26. Replies
    22
    Views
    790

    Re: DataGridView won't refresh

    That's because you're never adding it to the datatable... you're just adding it straight to the database.... so, yes, of course you'd need to reload it. Sorry, I didn't realize that sooner.
    Usually...
  27. Replies
    22
    Views
    790

    Re: DataGridView won't refresh

    Call Form12_ProdMeet.UpdateStartDate(WONO, StartDate, User, dbWONO)

    End Sub

    This... this right there... that's exactly what I'm trying to say you should NOT be doing.

    in fact, now that...
  28. Replies
    22
    Views
    790

    Re: DataGridView won't refresh

    Ungh.... the second form shouldn't do ANYTHING. Period. Full stop.
    All the second form should do is collect the data. The first form should show the second, then get the data from the second form...
  29. Replies
    2
    Views
    183

    VS 2019 Re: Merge Two DataTables in a DataSet

    Why? you should have ONE dataset... with TWO datatables in it...
    The dataset.Merge is for when you have a table in two datasets with the same structure and you want to merge one into the other......
  30. Replies
    5
    Views
    215

    VS 2017 Re: Read XML Attribute

    SelectSingleNode does just what it states... selects a single node... you don't want a single node... you want multiple nodes... use SelectNodes...

    -tg
  31. Replies
    5
    Views
    215

    VS 2017 Re: Read XML Attribute

    Well, if SelectSingleNode returns a single node, and you want more than one node... what do you think you should do?
    Select multiple nodes... loop through them, and then get the attribute from each...
  32. Replies
    149
    Views
    3,793

    Re: Presidential Debates

    Yes... it was the result of the Jenner Accords signed sometime back...


    -tg
  33. Replies
    22
    Views
    790

    Re: DataGridView won't refresh

    That right there is probably the issue. your secodn form should know noting about your first form. Form 1 should show form 2... form 2 should then close... form 1 should then get what it needs from...
  34. Re: Help. Scrollbars not appearing when populating ListView control. Full?

    Then that should tell you you're not loadding them correctly...



    Annnd that's not the way to do it....

    Maybe if you had also shown the original code, someone would have been able to help. ...
  35. VS 2015 Re: How to Use rest Api to post this Json data to SQLserver database

    Try removing the eels from your hovercraft... there's a link in my sig that will help with this.

    -tg
  36. Replies
    5
    Views
    300

    Re: decimal point

    Are you sure it's Access? My guess is that it's your Windows Regional Settings... Format (or rather Format$ which is what you should be using) respects the local regional settings on the computer. So...
  37. Replies
    42
    Views
    1,047

    VS 2019 Re: MySQL Populate 2nd Dropdown

    Use of the backticks on fields is appropriate (yet optional) since this is MySQL.... it's the object identifier, same as square brackets in Access or SQL Server. BUT, using them in the WHERE clause...
  38. Replies
    4
    Views
    204

    Re: [RESOLVED] Command Button Issue

    Where does it go then? You've decided that's the key, but then decided to keep that info to yourself.

    -tg
  39. Replies
    1,501
    Views
    66,271

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

    Unfortunately it isn't going to keep him off Twitter.... probably will be on it more...
    Oddly, just last night as we were watching the news and they were talking about how one of his aides had...
  40. Replies
    6
    Views
    325

    Re: VB6 - String Formatting

    https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/format-function-visual-basic-for-applications


    That should be right. UCase definately will upper case the...
Results 1 to 40 of 493
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width