Search:
Type: Posts; User: dccjr3927
Search:
Search took 0.03 seconds.
-
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...
-
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...
-
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?
-
(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...
-
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...
-
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 {
...
-
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....
-
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...
-
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...
-
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!
-
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...
-
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.
-
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...
-
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...
-
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
...
-
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...
-
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.
-
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...
-
Thank you. I think this will work well for my use.
-
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...
-
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...
-
tg - Thanks for this additional information. The 'assigned number' method seems very promising. It gives me another avenue to consider .
-
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...
-
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...
-
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...
-
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...
-
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.
...
-
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...
-
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.
-
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...
-
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...
-
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...
-
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...
-
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...
|
Click Here to Expand Forum to Full Width
|