Search:

Type: Posts; User: si_the_geek

Page 1 of 13 1 2 3 4

Search: Search took 0.19 seconds.

  1. Replies
    3
    Views
    85

    Re: VB.Net & Sqlite help for query

    The article Why should I use Parameters in my program instead of putting values directly into my SQL string? gives the explanation of why, and also contains links to examples (at the bottom of the...
  2. Replies
    6
    Views
    137

    Re: Query of a Query

    That's annoying :(
  3. Replies
    6
    Views
    137

    Re: Query of a Query

    Cool, by the way I missed something earlier... you'll need to add GROUP BY DateField to each of the sub-queries.
  4. Replies
    3
    Views
    85

    Re: VB.Net & Sqlite help for query

    You need to ensure that you are formatting and delimiting the values the same way.

    Your initial query contains this:

    ...but the second version will create this:



    You need to include the...
  5. Replies
    6
    Views
    137

    Re: Query of a Query

    Here's a quick thought:

    SELECT A.DateField, ACount - BCount
    FROM ( SELECT DateField, Count(*) as ACount
    FROM TableA
    GROUP BY DateField
    ) as A
    LEFT JOIN
    ( ...
  6. Re: Excel Interop Change NumerFormat on Range

    If values are stored as their original types (Integer, Single, Date, etc), then they are passed directly into the target application that way, and the target application just needs to format them for...
  7. Re: Operation Must Use an updateable Query

    The link I gave in post #19 has some guidance, under the heading "Which folder(s) should be used?"

    Part of that is:
    As you say single-user, you probably don't want to use CommonAppData, as that...
  8. Re: Operation Must Use an updateable Query

    It applies to all writeable files (whether that is database files, text files, etc).

    Executable files (such as .exe and .dll etc) should be in ProgramFiles or similar.

    The location of the files...
  9. Re: Operation Must Use an updateable Query

    Using folders like ProgramFiles for writeable files has been off-limits for over 20 years.

    These days it is more complex to get that working (partly due to virtualisation etc), and it isn't a...
  10. Re: How to generate a report based on customer number (retrieving data from 3 tables)

    I have moved this thread from the VB.Net forum to the Database Development forum
  11. Replies
    16
    Views
    458

    Re: We Didn't Start the Fire

    The good news is that at that point they get taken to an air-conditioned hospital, and then a cup of tea does fix that issue.
  12. Replies
    8
    Views
    4,884

    Re: Twain Scanning in VB .Net

    That was me, my apologies for the confusion caused!

    There was spam amongst the nonsense post, so I toasted it :)
  13. Replies
    3
    Views
    365

    Re: My font got really small

    It is almost certainly due to a browser setting - you can (even accidentally) set the zoom level per-site.

    One way to change the zoom level is hold the Ctrl key while moving the mouse-wheel, and...
  14. Re: Why does my TextBox not expand with it's form ?

    Have you manged to unwittingly put it inside another control? (a TLP or something else)

    If so the settings for that control need to be set appropriately too (or just move the textbox out of that...
  15. Re: Canīt use two CreateParams functions ... Error BC30269

    I did actually make a minor change to the Shadow code, so reverting that might fix it... just move the CheckAeroEnabled line to above the Dim line.


    If that doesn't solve it, also try putting...
  16. Re: Canīt use two CreateParams functions ... Error BC30269

    Welcome to VBForums! :wave:

    You need to merge the two routines together, in this case I think it could be like this:

    Protected Overrides ReadOnly Property CreateParams() As CreateParams
    ...
  17. VS 2022 Re: Get the BackColor from the selected DataGridView row when clicked.

    One possible issue is that DataGridView1.CurrentRow.Index might not return the correct value (as clicking a cell might not set CurrentRow before the event is fired), so you should be making use of...
  18. Replies
    9
    Views
    403

    VS 2010 Re: How to make new font() black

    There are some fonts (such as Arial) which have a 'black' (ultra-bold) variation.

    You can only use the 'black' variation if the font already contains it - you can't create it with .Net (except...
  19. Replies
    24
    Views
    1,088

    VS 2015 Re: WebBrowser not loading phpmyadmin

    There is actually an issue with attachments on the forum at the moment.

    If you use the features in the "Quick Reply" area they don't attach properly, but you can add attachments via "Go Advanced"...
  20. VS 2019 Re: Adding Tables to a Dataset with Primary Key Relationships

    For Access-based databases you need to write the joins in a slightly different way to most database systems, and put brackets around each join, like this:

    .. FROM (TableMain Main INNER JOIN...
  21. Replies
    4
    Views
    410

    Re: Unverified Publisher

    I have moved this thread to our 'Application Deployment' forum
  22. Replies
    7
    Views
    599

    Re: UnhandledException Doesn't Work

    You generally should not write to the app directory, and generally wont be able to - as Windows will block writing to protected folders (such as ProgramFiles etc), because that is what malware will...
  23. Replies
    11
    Views
    669

    Re: newer VS versions and subscriptions

    From what I understand, the Community edition is almost identical to the Professional edition, just with different license terms (free for personal use and small business).

    They have a decent...
  24. Replies
    11
    Views
    669

    Re: newer VS versions and subscriptions

    Modern versions of VS (since 2017 or possibly earlier) do have the option to log in, but I think you don't actually need to log in. I did log in (so settings get shared wherever I use VS), but the...
  25. Replies
    241
    Views
    8,071

    Re: Musk buys Twitter

    As a general rule "far left" messages tend to be along the lines of "treat people from group-x as people", whereas a "far right" message tends to be along the lines of "treat people from group-x...
  26. Replies
    3
    Views
    383

    Re: German Question

    Welcome to VBForums :wave:

    I have moved this thread from our VB.Net forum to our C# forum.
  27. Re: How do I make a color written to file as "RRRGGGBBBAAA", each pixel showing 000-2

    But you didn't delete Dim here if you mean this (In thick letters)?
    [/QUOTE]That line of my post was referring to your save routine... meaning that you should use just the Dim I showed (which...
  28. Re: How do I make a color written to file as "RRRGGGBBBAAA", each pixel showing 000-2

    Your code in post #8 would be changed to this:

    Dim hexString4 As String = Nothing

    Private Sub InvisibleButton_Click(sender As Object, e As EventArgs) Handles InvisibleButton.Click
    ...
  29. Re: How do I make a color written to file as "RRRGGGBBBAAA", each pixel showing 000-2

    The problem there is that you have declared hexString4 inside each of the routines - and variables declared inside a routine only exist inside that routine (the ones inside other routines are...
  30. Re: From Date is okay but values are not showing for To Date

    A date value without a time is counted as being midnight, so your from/to dates are treated as:

    From Date: 5/5/2022 0:00
    To Date: 5/7/2022 0:00

    This means that you will get all rows where...
  31. VS 2019 Re: Combo Box doesn't fetch data from MS Access Database when I apply If Conditions.

    There is a good debugging tutorial (with mini-videos where apt) here:
    https://docs.microsoft.com/en-gb/visualstudio/debugger/navigating-through-code-with-the-debugger

    You probably want to start...
  32. Replies
    18
    Views
    790

    Re: What is our generation's "log table"?

    We wont really need to learn new languages... there is already technology to translate spoken conversation in almost real time (and it will get faster and more accurate), so far fewer people will...
  33. Replies
    18
    Views
    919

    Re: how to get 2st level on vbforums

    You can only do that when you are a PowerPoster (after 2000 posts I think).
  34. Re: Constructors Swallowing Exceptions...sort of.

    Presumably the GUID is being interpreted as an index to the Dictionary (or perhaps as a parameter to the default method of a dictionary).

    If that is the case, I would expect the item returned by...
  35. Replies
    487
    Views
    84,436

    Re: Hamilton 5x World Champion ?

    How a stopped car is dealt with depends on various factors, primarily can the marshalls remove the car without risking themselves.

    In this case it seems that they had all the...
  36. Replies
    6
    Views
    696

    Re: ARG! The "e" in a function statement

    I have moved this thread from the VB.Net CodeBank forum (which is for working code samples, not questions) to the VB.Net forum
  37. Re: Can't disable verbose setting VS 2022.

    I have moved this thread from the VB.Net CodeBank forum (which is for working code samples, not questions) to the VB.Net forum
  38. Thread: Testing

    by si_the_geek
    Replies
    2
    Views
    283

    Re: Testing

    Are you the Angle of Cod? ;)


    edit: it seems you are: https://www.vbforums.com/showthread.php?895688-problem-with-Microsoft-ACE-OLEDB&p=5561199#post5561199
  39. Re: Cannot pass parameters to report

    I don't know about that, but I have spotted an issue in the error message that is easy to overlook:

    Microsoft.Reporting.WebForms.ReportParameter
    Microsoft.Reporting.WinForms.ReportParameter

    ...
  40. Re: Inserting data into database with autonumber

    You should also specify the names of the fields, eg:

    Insert into Table1 (field1, field2, field3, ...) Values(value1, value2, value3, ...)
    Doing that avoids a wide variety of issues, including...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width