Search:

Type: Posts; User: vbdotnut

Page 1 of 6 1 2 3 4

Search: Search took 0.06 seconds.

  1. Re: Need query to get only last record of a customer from his/her total records ...

    There is no better way to do it than this.
  2. Replies
    14
    Views
    1,387

    Re: looking for a good online code porter

    Funny thing, I cant tell if you are bragging or complaining.

    It is unwise to roll up on a vb.net forum with that attitude really. You seem eager to dazzle us with your robust references and you...
  3. Re: Opacity increase slowly works but form is empty before it reaches max

    Even more efficient would be to not do it at all. Its just not necessary.
  4. Re: [RESOLVED] Opacity increase slowly works but form is empty before it reaches max

    When it come to presentation effects with WinForms... what I have learned.... Just dont do it!
  5. Replies
    23
    Views
    1,843

    VS 2022 Re: Adding Time mm:ss

    No worries,
    I dont know why, but I do prefer the way I put it. Seems to be closer to satisfying the requirement and less overkill.
  6. Replies
    23
    Views
    1,843

    VS 2022 Re: Adding Time mm:ss

    ... this is BS!
  7. Replies
    23
    Views
    1,843

    VS 2022 Re: Adding Time mm:ss

    How I would achieve this is breaking it down into total seconds then format the string from total seconds

    Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
    Dim...
  8. Re: Referring to a control which created programmatically

    If you know the name, type, and parent of control you dont need to find it

    Controls.Add(New Label With {.Name = "Label1"})
    DirectCast(Controls("Label1"), Label).Visible = True

    You lost me...
  9. Re: Connecting to MySQL database without IP restricitions

    3rd the API.
    At this point MS is no longer providing/supporting updates to the web API/VB.Net and is steadfast with ASP.NET/Core/C# Web API. You can however still create a 'legacy' VB.Net Web...
  10. Replies
    6
    Views
    1,084

    Re: Interacting with custom made controls

    Would be nice to downvote this gpt response
  11. Replies
    6
    Views
    1,084

    Re: Interacting with custom made controls

    You can also create Public methods or functions and pass arguments in. Here are some examples, obviously the controls in this example are just created for example and dont belong to any container so...
  12. Replies
    6
    Views
    952

    Re: Backgroundworker and Clipboard.Gettext()

    Assuming youre not setting the text somewhere in your "lots of procedures" and you are setting the text by means of Ctrl+C or right-click Copy, then you should be sending the text in as a parameter...
  13. Replies
    9
    Views
    1,111

    Re: Simple Questions?

    My opinion is if you are going to use vbCrLf (etc) instead of Environment.NewLine maybe you should also be using VB6 instead of VB.Net. Which maybe thats not fair to say but that is where I will...
  14. Replies
    9
    Views
    1,111

    Re: Simple Questions?

    I always use Environment.NewLine because I feel like its an explicit part of the framework and the other choices are as old as dirt, but thats no reason not to use them. At the end of the day its...
  15. Re: VB2022 - how can a form get focus?

    You could try ActiveControl=Nothing
  16. Replies
    27
    Views
    2,713

    Re: Division Code Error

    Sorry, I will spell it out for you then

    Dim FirstNumDec As Decimal = Nothing
    Dim SecondNumDec As Decimal = Nothing
    Decimal.TryParse(TextBox1.Text, FirstNumDec)
    Decimal.TryParse(TextBox2.Text,...
  17. Re: For Loop - Need individual Values

    looking at this i am wondering if you created a Dict to hold the zonename and bool which you would populdate in your iteration, then after iterate the Dict and set the values accordingly. Just a...
  18. Replies
    27
    Views
    2,713

    Re: Division Code Error

    When dealing with this type of conversion where a user can enter string I like to play it safe and parse the values as such:

    Dim FirstNumStr As String = "5.5"
    Dim SecondNumStr As String = "100.5"...
  19. VS 2022 Re: Panel scrollbars don't move when I scroll window via code.

    in a very generic example:

    Public Class FormIcons
    Private Sub FormIcons_Load(sender As Object, e As EventArgs) Handles MyBase.Load
    Dim UC_Icons As New UserControl With {.Dock =...
  20. VS 2022 Re: Panel scrollbars don't move when I scroll window via code.

    Instead of using a form to add into pnlContent try using a UserControl instead

    Also make sure AutoScroll on pnlContent is set to true
  21. VS 2022 Re: Panel scrollbars don't move when I scroll window via code.

    One thing I dont do i DL ppls projects.

    Paste the entire class instead
  22. VS 2022 Re: Panel scrollbars don't move when I scroll window via code.

    ive not tried moving the position around on a scroll before, but from here it looks like you should be declaring intFormPos as a class member. Also, after the first mouse leave...
  23. Re: Pros, Cons and opinions of Background processing.

    it still stands that you dont need to update a cost on assembly/BOM items. if you must, I would still use the CTE type query and join it to the item table where the cost doesnt match the CTE result...
  24. VS 2022 Re: Panel scrollbars don't move when I scroll window via code.

    from which methods/order does this run?
  25. Re: Pros, Cons and opinions of Background processing.

    Maybe its just me, but something is just weird about the db/m interface(s) within your solution. In my environment it would be a disaster if concurrent users were updating component costs which would...
  26. Replies
    7
    Views
    1,016

    VS 2019 Re: Updating a datatable

    I think just keep it simple and iterate the dt rows

    For Each DRow As DataRow In SampleDT.Rows
    If DRow.Item("Col1").Equals("Foo") Then DRow.Item("Col2") = "Bar"
    Next

    Linq is going to...
  27. Re: Pros, Cons and opinions of Background processing.

    Shaggy brought that up in post #6
  28. Re: Pros, Cons and opinions of Background processing.

    this is a comprehensive example of a CTE function that returns a cost rollup which uses component yields, duty%, and shipping rates it also converts some consumption units into grams because we have...
  29. Re: Pros, Cons and opinions of Background processing.

    where it gets real tricky is calculating yield, which is what youre touching on here.
    you really need a table that has itemid,parentid,componentyield,qty, and assemblyqty. so the qty/assemblyqty...
  30. Re: Pros, Cons and opinions of Background processing.

    THE CTE Query in question was run on SQL Server Std 15.0.2000.5 and the CTE query was introduced in 1999 with SQL3. (Making me feel old here Shaggy)

    and no, a google search reveals access does not...
  31. Re: Pros, Cons and opinions of Background processing.

    To get a cost rollup on your assemblies should not take an epic amount of time to return a result. This is an area where a CTE will shine. If you have a table that holds the item and its parent then...
  32. Replies
    4
    Views
    862

    Re: [RESOLVED] Query failure

    +1 on using parameters instead. if youre not going to use parameters you should use explicit date format of yyyy-mm-dd to avoid the chance of misinterpretation
  33. Replies
    8
    Views
    1,064

    Re: UC in disabled UC

    on that note maybe like this:

    Ctl.Enabled = If(TypeOf Ctl Is UserControl, True, Not Ctl.Enabled)

    so that it will either enable or disable the controls when you run it.

    Additionally this...
  34. Replies
    29
    Views
    144,352

    Re: Correct way to use the BackgroundWorker

    You should have posted this question in the .net forum with a link to this thread in addition to pasting the code youre using.
    Have you sorted it. If not please post a new thread in the forum and...
  35. VS 2019 Re: how to get on the value of specific cells after select datagridview row?

    updated the code on this recommendation
  36. VS 2019 Re: how to get on the value of specific cells after select datagridview row?

    I reckon both issues could be solved like this

    TBox.Text = If(DGVCell.Value Is Nothing, "NO CODE", DGVCell.Value.ToString)
  37. Replies
    8
    Views
    1,064

    Re: UC in disabled UC

    Perhaps disable all other controls on the parent with the exception of any other user control

    For Each Ctl As Control In Controls
    If Not TypeOf Ctl Is UserControl Then
    Ctl.Enabled =...
  38. VS 2019 Re: how to get on the value of specific cells after select datagridview row?

    I had in mind something like this, give or take:

    Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
    Dim CurrRow As DataGridViewRow = DataGridView1.CurrentRow
    ...
  39. VS 2019 Re: Reading CSV file into datatable, skipping first line

    i was thinking a good ol fashioned text parser as well.
  40. VS 2019 Re: Reading CSV file into datatable, skipping first line

    maybe try jet or ace instead of txt driver. it has been my experience that extended properties are hit or miss across the board on all drivers.... mostly miss.
Results 1 to 40 of 213
Page 1 of 6 1 2 3 4



Click Here to Expand Forum to Full Width