Search:

Type: Posts; User: dccjr3927

Search: Search took 0.03 seconds.

  1. Replies
    12
    Views
    1,252

    Re: Interate through Lists for Querys

    Thank you. I am guilty of letting frustration get the better of me. I understand the criticism, and know that the mistakes are mine. Sometimes I do not know what I am looking for (or should be...
  2. Replies
    12
    Views
    1,252

    Re: Interate through Lists for Querys

    I am confused regarding how it is referencing the value of each key in the loop. Specifically, the line that assigns the value to cmd.CommandText. To my mind it is assigning the key of the dictionary...
  3. Replies
    2
    Views
    445

    A New Post or Existing?

    Hi everyone. This is a general question concerning forum posts from a newbie. When should I continue a previous thread dealing with an on-going problem and when should I start a new one?
  4. Replies
    12
    Views
    1,252

    Re: Interate through Lists for Querys

    (NOTE: I am not sure whether I should start an new post or continue this one. If this should be a new one, please let me know.)
    ChrisE - This is a 'dashboard' view of all of the work centers. I am...
  5. Replies
    6
    Views
    1,132

    Re: Date Format in SQL string

    There are more than 2 queries (there's actually 9 in this section). I just included these two for illustration purposes. The result from each query show the quantity of active orders for each work...
  6. Replies
    6
    Views
    1,132

    Re: Date Format in SQL string

    Thanks. I am going to use parameterized queries. I am not sure how to do this in a string. My queries are in a dictionary like this


    Dim WCtbx As New Dictionary(Of TextBox, String) From {
    ...
  7. Replies
    6
    Views
    1,132

    [RESOLVED] Date Format in SQL string

    Could someone provide some insight into how to format dates in an SQL string in my code? If I copy the statement into MySQL query editor (and hard code the date instead of a variable), it works fine....
  8. Replies
    12
    Views
    1,252

    Interate through Lists for Querys

    I have two lists (SQL statements and textbox names). My goal is to run each SQL statement (getting a sum) and place the value in the respective textbox. Below is what I have so far. Note: I have...
  9. Re: Generating Secure Salt and Pepper

    Thank you both for the examples. djancuk - thank you for the NET7 info. I am using NET6, so not an issue right now. dday9 - thanks for turning me on to Fiddle. I have been testing code by running my...
  10. Re: Populating DataGridView with Query

    Thanks for the responses. I was able to solve the issue through a combination of your suggestions. It works perfectly for the app.config field now. Thanks!
  11. Re: Generating Secure Salt and Pepper

    I did read the documentation, which is how I knew that the previous method had been deprecated. I have likewise read the documentation on the RandomNumberGenerator, and as a new user found it...
  12. Re: Generating Secure Salt and Pepper

    Thank you. I cannot find any code examples that generate a string. The ones that I have generate a single number, but I want 128 bit alphanumeric before hashing.
  13. [RESOLVED] Generating Secure Salt and Pepper

    I have searched and search by cannot find a way to generate random strings for salt and peppering passwords. All of the examples that I can find rely on the RNGCryptoServiceProvider (which has been...
  14. Re: Populating DataGridView with Query

    Thanks for all of the valuable information. I have updated the code as suggested.


    Public Class FrmInventory
    Private Sub FrmInventory_Load(sender As Object, e As EventArgs) Handles...
  15. [RESOLVED] Populating DataGridView with Query

    I got the code for Here is my sub for populating the DataGridView.


    Public Class FrmInventory
    Private Sub FrmInventory_Load(sender As Object, e As EventArgs) Handles MyBase.Load
    ...
  16. Re: Storing Caluculated Values and Normalization

    Thanks Zvoni. I do log transactions, both from the warehouse receiving/shipping, and logging order completion. Rarely do I need to pull inventory numbers from a date/time other than current stock...
  17. Re: Storing Caluculated Values and Normalization

    Thanks. I guess I misunderstood what storing calculated fields was. I will go look at normalization rules and try to get a better grasp on the topic.
  18. [RESOLVED] Storing Caluculated Values and Normalization

    First, I understand that this is a very general question. Second, while I have worked with Access quite a bit, the projects have been small and normalization was never a consideration (I didn't...
  19. Re: Opening and Closing MySQL Connection

    Thank you. I think this will work well for my use.
  20. Re: Opening and Closing MySQL Connection

    Thanks. I am developing on the local host, but will be deploying on a network with the database either on a server or on a cloud server (boss has not decided yet). Is there an easy way of having to...
  21. [RESOLVED] Opening and Closing MySQL Connection

    Not sure if this is the correct place for this question. I created a module for handling connect and disconnect actions to my database. The reason was to prevent from having to put the same 20+ lines...
  22. Replies
    7
    Views
    1,674

    Re: User Permissions and Form Control

    tg - Thanks for this additional information. The 'assigned number' method seems very promising. It gives me another avenue to consider .
  23. Replies
    7
    Views
    1,674

    Re: User Permissions and Form Control

    Thank you very much for the input. I am always hesitant to ask "non-specific" questions like these. I learn a lot from them, not just corrections to my mistakes in code. I guess I will start blocking...
  24. Replies
    7
    Views
    1,674

    Re: User Permissions and Form Control

    Thank you for the response. Should I put the code allowing or denying features/options in the form module (say the OnLoad event) or in a separate module?

    As for changing my mind, this was the...
  25. Replies
    7
    Views
    1,674

    User Permissions and Form Control

    I am transitioning from Access/VBA to VB.net, and this is my first real project (it is a Windows Forms Application project). I am using VS 2019 and MySQL. It is basically a custom small ERP system...
  26. Replies
    4
    Views
    805

    Reusing Code (in Module)

    I have a couple of related best practices questions. I know that these are pretty open ended questions, but a few common suggestion or example would be appreciated.


    When should I put code in a...
  27. Re: Project Folder Structure/Restructure

    Thanks for the explanation.

    I was able to complete the restructuring without issue. Created the folders, then cut and pasted the forms and modules in their respective folders in the src folder.
    ...
  28. [RESOLVED] Project Folder Structure/Restructure

    I have a VB.NET (Windows Forms app) project. It currently consists of 20 forms and a module in their default location. While reading on setting up a a repository (GitHub) I noticed that there is a...
  29. Replies
    14
    Views
    1,512

    VS 2019 Re: Sharing Sub across forms

    I apologize for sounding as though I was ungrateful or complaining. That was not my intent. I do appreciate the time that you and others spend helping people like me. Thank you.
  30. Replies
    14
    Views
    1,512

    VS 2019 Re: Sharing Sub across forms

    Again, thanks for all of the replies. To address a few of items.

    It didn't work. I am checking the background color of the textbox or combo box, not the form or group box. So I do need to check...
  31. Replies
    14
    Views
    1,512

    VS 2019 Re: Sharing Sub across forms

    Thanks for all of the responses. I had made some changes that seem to accomplish what I wanted before see this last response. I am not familiar with the DirectCast operator. Below is the solution...
  32. Replies
    14
    Views
    1,512

    VS 2019 Re: Sharing Sub across forms

    Thanks for all of the continued help, but I am a little confused now. I would like to clarify because I think I may have been too vague with the purpose of this sub. My forms have 2 or more group...
  33. Replies
    14
    Views
    1,512

    VS 2019 Re: Sharing Sub across forms

    Thanks for the replies!! I had overlooked the specific control. I will remove it and use when necessary within the form.

    When you say not to declare a variable before I need it, you mean declare...
  34. Replies
    14
    Views
    1,512

    VS 2019 [RESOLVED] Sharing Sub across forms

    Hello all. I am new to vb.NET. I have a few subs that I would like to be able to use in several different forms without copying and pasting the code into each one. Below is an example.


    Sub...
Results 1 to 34 of 34



Click Here to Expand Forum to Full Width