• Member Avatar for Papa_Don
    Papa_Don

    Replied To a Post in Check if there is a duplicate username in MySQL database

    @Dani, I just tried to use the comment button inside your post. However I can't see this either. But I'm not deleting them I gather you saw my comment in …
  • Member Avatar for Papa_Don
    Papa_Don

    Gave Reputation to Dani in Check if there is a duplicate username in MySQL database

    This is very weird. Papa Don, I just got an email saying you commented on my post writing: > Dani, I see your point. You are correct that I am …
  • Member Avatar for Papa_Don
    Papa_Don

    Gave Reputation to Dani in Check if there is a duplicate username in MySQL database

    I would just like to add, I would not recommend doing it the way Papa_Don suggets. In his code, he is first doing a SELECT query to see if a …
  • Member Avatar for Papa_Don
    Papa_Don

    Replied To a Post in Check if there is a duplicate username in MySQL database

    Here's what I've done. Keep in mind that, in my search I was looking to see if an existing account number exists. But you can do the same thing with …
  • Member Avatar for Papa_Don
    Papa_Don

    Began Watching Check if there is a duplicate username in MySQL database

    Good day! I am new in vb.net and I want to detect if there is a duplicate of the record that a user will try to add. If the user …
  • Member Avatar for Papa_Don
    Papa_Don

    Replied To a Post in Splitting string into individual variables

    @rprofitt, I'm beginning to understand what you're pushing me to do. I've rewritten the code to read as: Dim words As String() = s.Split(New Char() {" "c}) Dim Search1 As …
  • Member Avatar for Papa_Don
    Papa_Don

    Replied To a Post in Split a string into individual words

    I just figured out how to post code. Here's what I've attempted, but it's failing: Dim i As Integer = 1 Dim searchName As String Dim searchNo As String Dim …
  • Member Avatar for Papa_Don
    Papa_Don

    Gave Reputation to rproffitt in Split a string into individual words

    What are "buckets"? Besides that, I see example 1 at https://www.dotnetperls.com/split-vbnet seems clear.
  • Member Avatar for Papa_Don
    Papa_Don

    Gave Reputation to rproffitt in Split a string into individual words

    To me an array is a variable. But if you look at example 1 at the link it puts them into an array. Let's say you don't want an array …
  • Member Avatar for Papa_Don
    Papa_Don

    Gave Reputation to rproffitt in Split a string into individual words

    What are "buckets"? Besides that, I see example 1 at https://www.dotnetperls.com/split-vbnet seems clear.
  • Member Avatar for Papa_Don
    Papa_Don

    Created Splitting string into individual variables

    Hi Group, I'm using the split function for the very first time. I understand what it's doing. However I don't know how to output each individual word into a specific …
  • Member Avatar for Papa_Don
    Papa_Don

    Began Watching Splitting string into individual variables

    Hi Group, I'm using the split function for the very first time. I understand what it's doing. However I don't know how to output each individual word into a specific …
  • Member Avatar for Papa_Don
    Papa_Don

    Created Split a string into individual words

    Hi Group, I'm using the split function for the very first time. I understand what it's doing. However I don't know how to output each individual word into a specific …
  • Member Avatar for Papa_Don
    Papa_Don

    Began Watching Split a string into individual words

    Hi Group, I'm using the split function for the very first time. I understand what it's doing. However I don't know how to output each individual word into a specific …
  • Member Avatar for Papa_Don
    Papa_Don

    Gave Reputation to JamesCherrill in Error when running program

    > 9999999999 That's 10 digits, not 7 and as such can hold values > 2^31 which cannot be stored in an int. (Although I have no idea if that is …
  • Member Avatar for Papa_Don
    Papa_Don

    Created Error when running program

    Hi group, It's been some time since I last posted. It's good to be involved in programming again. It's been much too long. It's been a while since I've written …
  • Member Avatar for Papa_Don
    Papa_Don

    Began Watching Error when running program

    Hi group, It's been some time since I last posted. It's good to be involved in programming again. It's been much too long. It's been a while since I've written …
  • Member Avatar for Papa_Don
    Papa_Don

    Replied To a Post in Write information to Database

    I'm not sure why but I'm not getting an error message. But I've looked and what I've attempted to write isn't there. I'll go back and step through it to …
  • Member Avatar for Papa_Don
    Papa_Don

    Replied To a Post in Is it realistic to pursue a career in programming?

    Interesting thought! I may have to consider something like that. That actually makes a lot of sense. Don
  • Member Avatar for Papa_Don
    Papa_Don

    Created Write information to Database

    Hi group, I'm trying to store the information from a various textboxes into my database. However it is not writing the data (I'm getting my planned error message, "New Record …
  • Member Avatar for Papa_Don
    Papa_Don

    Began Watching Write information to Database

    Hi group, I'm trying to store the information from a various textboxes into my database. However it is not writing the data (I'm getting my planned error message, "New Record …
  • Member Avatar for Papa_Don
    Papa_Don

    Marked Solved Status for Is it realistic to pursue a career in programming?

    Group, I've dabbled in coding (both front end and back end) since the mid 1990s. However I've never done it full time (except for a short stint writing database query's …
  • Member Avatar for Papa_Don
    Papa_Don

    Replied To a Post in Is it realistic to pursue a career in programming?

    @rproffitt, I think I've learned my answer. For me, at 60, it isn't realistic to consider a career in programming. I wish I had pursued it 10 or 20 years …
  • Member Avatar for Papa_Don
    Papa_Don

    Replied To a Post in Is it realistic to pursue a career in programming?

    You've answered my question with your comments. Ultimately I wanted to know if it was realistic for someone my age to attempt a new career in programming. If my age …
  • Member Avatar for Papa_Don
    Papa_Don

    Replied To a Post in Is it realistic to pursue a career in programming?

    Dani, I am not opposed in any way to remain as a data analyst. However it seems that in my area of the country (Atlanta, Georgia), my age is standing …
  • Member Avatar for Papa_Don
    Papa_Don

    Replied To a Post in Is it realistic to pursue a career in programming?

    Dani, The vast majority of my IT experience is with databases. Of the many hats that I wore in my career field (tile and stone distribution), one of those was …
  • Member Avatar for Papa_Don
    Papa_Don

    Created Is it realistic to pursue a career in programming?

    Group, I've dabbled in coding (both front end and back end) since the mid 1990s. However I've never done it full time (except for a short stint writing database query's …
  • Member Avatar for Papa_Don
    Papa_Don

    Began Watching Is it realistic to pursue a career in programming?

    Group, I've dabbled in coding (both front end and back end) since the mid 1990s. However I've never done it full time (except for a short stint writing database query's …
  • Member Avatar for Papa_Don
    Papa_Don

    Marked Solved Status for VB.net Check datatable for an existing account number

    Hi group, I'm attempting to write code to check to see if an existing account number exists. The user is to input a 10 digit account number. The code then …
  • Member Avatar for Papa_Don
    Papa_Don

    Replied To a Post in VB.net Check datatable for an existing account number

    I was able to figure this out. Here's what I did: Private Sub tbxAccountNo_LostFocus(sender As Object, e As EventArgs) Handles tbxAccountNo.LostFocus If GlobalVariables.custpnl1 = 2 And tbxAccountNo.Text.Length = 10 And …
  • Member Avatar for Papa_Don
    Papa_Don

    Created VB.net Check datatable for an existing account number

    Hi group, I'm attempting to write code to check to see if an existing account number exists. The user is to input a 10 digit account number. The code then …
  • Member Avatar for Papa_Don
    Papa_Don

    Began Watching VB.net Check datatable for an existing account number

    Hi group, I'm attempting to write code to check to see if an existing account number exists. The user is to input a 10 digit account number. The code then …
  • Member Avatar for Papa_Don
    Papa_Don

    Replied To a Post in Visual Studio 2019 with a database

    Close this post.
  • Member Avatar for Papa_Don
    Papa_Don

    Marked Solved Status for Visual Studio 2019 with a database

    Hi group, I've just installed Visual Studio 2019 and have started my first app using this. Within the program I created a database using the tools provided in Visual Studio. …
  • Member Avatar for Papa_Don
    Papa_Don

    Replied To a Post in Visual Studio 2019 with a database

    The problem turned out to be that the database wasn't setup correctly. I've since fixed that and have had no problem connecting.
  • Member Avatar for Papa_Don
    Papa_Don

    Replied To a Post in SQL error in VB.net

    @rproffitt, Yes, the same one. I'm no longer with them as the company was purchased by Marriott and the end of 2016. My position ended in April of 2017. I'm …
  • Member Avatar for Papa_Don
    Papa_Don

    Replied To a Post in Why is the ListView box showing same headings twice?

    FYI..... In attempting to fix this, I commented out a few lines to make it more visual. I failed to remove the comment marks before posting this. I hope this …
  • Member Avatar for Papa_Don
    Papa_Don

    Created Why is the ListView box showing same headings twice?

    Group, I've written some code to populate a listview using 3 fields from a database. When creating the listview, I named the individual columns for appearance purposes, (Account No, Company …
  • Member Avatar for Papa_Don
    Papa_Don

    Began Watching Why is the ListView box showing same headings twice?

    Group, I've written some code to populate a listview using 3 fields from a database. When creating the listview, I named the individual columns for appearance purposes, (Account No, Company …
  • Member Avatar for Papa_Don
    Papa_Don

    Marked Solved Status for SQL error in VB.net

    Hi group, I'm attempting to populate a listview with data from my test database created via Visual Studio 2019. I'm getting a syntax error that says, "Incorrect syntax near the …
  • Member Avatar for Papa_Don
    Papa_Don

    Replied To a Post in SQL error in VB.net

    @rproffitt, That was the fix. It worked as it should have. Again, thanks for the second pair of eyes. Don
  • Member Avatar for Papa_Don
    Papa_Don

    Replied To a Post in SQL error in VB.net

    @rproffitt, Duh..... I see the error - "SEARCH". It should have been "SELECT". I'm not sure why I wrote it that way. I'll change it and test it. I'll let …
  • Member Avatar for Papa_Don
    Papa_Don

    Created SQL error in VB.net

    Hi group, I'm attempting to populate a listview with data from my test database created via Visual Studio 2019. I'm getting a syntax error that says, "Incorrect syntax near the …
  • Member Avatar for Papa_Don
    Papa_Don

    Began Watching SQL error in VB.net

    Hi group, I'm attempting to populate a listview with data from my test database created via Visual Studio 2019. I'm getting a syntax error that says, "Incorrect syntax near the …
  • Member Avatar for Papa_Don
    Papa_Don

    Created Visual Studio 2019 with a database

    Hi group, I've just installed Visual Studio 2019 and have started my first app using this. Within the program I created a database using the tools provided in Visual Studio. …
  • Member Avatar for Papa_Don
    Papa_Don

    Began Watching Visual Studio 2019 with a database

    Hi group, I've just installed Visual Studio 2019 and have started my first app using this. Within the program I created a database using the tools provided in Visual Studio. …
  • Member Avatar for Papa_Don
    Papa_Don

    Created VB.net and the different versions of Excel

    Hello Group! I've developed an app that takes the data in a text file and moves it to specific columns in an Excel file. My computer has the Excel 2010 …
  • Member Avatar for Papa_Don
    Papa_Don

    Began Watching VB.net and the different versions of Excel

    Hello Group! I've developed an app that takes the data in a text file and moves it to specific columns in an Excel file. My computer has the Excel 2010 …
  • Member Avatar for Papa_Don
    Papa_Don

    Marked Solved Status for Excel Workbooks are not being completely Closed via VB.net

    Hi group, I'm discovering that my Excel spreadsheets that are being created by a VB.net app I've written isn't completely closing them as they should be. I'm struggling to understand …
  • Member Avatar for Papa_Don
    Papa_Don

    Replied To a Post in Excel Workbooks are not being completely Closed via VB.net

    @ Minimalist, I've run your test and found that it didn't find or kill anything on the network. It only killed those Excel applications running on my computer (which is …

The End.