Posts
 
Reputation
Joined
Last Seen
Ranked #802
Strength to Increase Rep
+4
Strength to Decrease Rep
-1
100% Quality Score
Upvotes Received
14
Posts with Upvotes
12
Upvoting Members
8
Downvotes Received
0
Posts with Downvotes
0
Downvoting Members
0
3 Commented Posts
3 Endorsements
Ranked #486
~199.66K People Reached
About Me

I'm truly a newbie to VB.net programming. I fell into script writing and report writing (from a database) in the middle 1990s that used the "old" BASIC language I learned back in the early 1980s (but really never used). I took a couple of courses…

Favorite Tags
Member Avatar for HitNSplit

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 names, addresses, etc. Just change the data field you're searching. Dim con As New SqlConnection Dim cmd As New SqlCommand …

Member Avatar for Dani
0
221
Member Avatar for Papa_Don

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 variable. As an example, the string is "Dickerson Tile Company". I have defined 7 variables to accept up to 7 …

Member Avatar for Reverend Jim
1
98
Member Avatar for Papa_Don

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 variable. As an example, the string is "Dickerson Tile Company". I have defined 7 variables to accept up to 7 …

Member Avatar for Reverend Jim
0
87
Member Avatar for Papa_Don

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 code that would write to a SQL database. It seems like the connection string is correct. However I'm getting a …

Member Avatar for JamesCherrill
0
45
Member Avatar for Papa_Don

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 in 2015 and 2016). Because of the economic downturn in 2008 and the sale of Starwood Hotels to Marriott, I …

Member Avatar for Reverend Jim
0
4K
Member Avatar for Papa_Don

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 keyword 'FROM'." It's not clear to me what the error is. The code I've written is as follows: Dim strQ …

Member Avatar for RuhiAngel
0
3K
Member Avatar for Papa_Don

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 FAILED. Please contact your systems administrator." From the code below, do you see where my error may be? What corrections …

Member Avatar for Santanu.Das
0
3K
Member Avatar for Papa_Don

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 is to query the database to see if that number exists. If it does, the message box displays the message …

Member Avatar for xrjf
0
3K
Member Avatar for Papa_Don

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 Name and Name). Those columns are being populated appropriately as expected. However data column names are being shown in column …

Member Avatar for xrjf
0
3K
Member Avatar for Papa_Don

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. I now want to begin writing to the tables I've created. But I'm stumped on how to do this. Hopefully …

Member Avatar for Papa_Don
0
3K
Member Avatar for Papa_Don

Group, you were very helpful to me in adding multiple textboxes, labels, etc., in my original post. If you would like to read through that, see http://www.daniweb.com/software-development/vbnet/threads/447985/creating-multiple-labels-textboxes-etc.-dynamically#post1934799. In a similar vein, I now want to dynamically add these multiple panels within a "main" panel, one at a time, with the …

Member Avatar for Enrique_2
0
3K
Member Avatar for major_lost

I'm attempting to do similar things here, only with multiple labels, buttons and textboxes. I've attempted to insert the needed code to display these controls on the form. Unfortunately with I debug it, the form is still blank. Here is what I've written: Public Sub frmOrderEntry2_Load(ByVal sender As System.Object, ByVal …

Member Avatar for Reverend Jim
0
4K
Member Avatar for Papa_Don

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 installed. So the application works fine with no issues. However we've begun to upgrade computers and software in the office …

Member Avatar for rproffitt
0
332
Member Avatar for Papa_Don

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 why and how to fix this. Here is the code for the portion of the app that creates the workbook, …

Member Avatar for Papa_Don
0
5K
Member Avatar for Papa_Don

Hi group, I'm making a handful of changes to an existing program I wrote a year or so ago. For some reason I can't get it to build as I'm getting an error that says: 1> Copying file from "obj\x86\Debug\Restran Solutions.exe" to "bin\Debug\app.publish\Restran Solutions.exe". 1>C:\Program Files (x86)\MSBuild\14.0\bin\Microsoft.Common.CurrentVersion.targets(3506,5): error MSB3113: Could …

Member Avatar for Papa_Don
0
653
Member Avatar for Papa_Don

Group, I've written what I believe is fairly simple code to populate a combobox via data from an Oracle Database. Unfortunately it isn't working and the error in the output box says: "Exception thrown: 'System.BadImageFormatException' in OracleConnections.exe" (the name I've assigned to the program is "OracleConnections"). This is not an …

Member Avatar for rproffitt
0
395
Member Avatar for Papa_Don

Hi Group, I'm attempting to pull info from our database to populate a combo-box in VB.net (Visual Studio Express 2015). Here's my first attempt at the connection: Dim conn As New Oracle.DataAccess.Client.OracleConnection() conn.ConnectionString = oraDB From here I'm not sure how to pull the data into the combobox. I do …

Member Avatar for Papa_Don
0
1K
Member Avatar for Papa_Don

Hi group, I've looked all over the internet to find my solution without luck. Hopefully you can help. I need to add an Oracle server to my data sources in Visual Studio (if it matters, I'm using VB.net). Per the best instructions I've found so far, I've selected "Data Sources" …

Member Avatar for Papa_Don
0
465
Member Avatar for Papa_Don

Hi Group, I've imported an existing form into a new project that I'm creating (using Visual Studio 2015 Express/VB.net). When displaying the "Design" version (the user interface), it looks like a plain form and doesn't resemble the actual form in the original program. As per the directions, I added the …

Member Avatar for Minimalist
0
5K
Member Avatar for Papa_Don

Good Morning group! I've made some minor changes to my coding (to open a log file, write to it and then close it) and now I'm getting an error that I've not seen before. The error code is CA2213. I've read what it says and I've tried to look it …

Member Avatar for Papa_Don
0
2K
Member Avatar for Papa_Don

Group, I can't seem to append multiple files into one text file. Unfortunately it's creating the first file but is not creating or appending the additional files into the first file. My code looks like this: getRestranName = System.IO.Directory.GetFiles(folderName) Dim counter As Integer = My.Computer.FileSystem.GetFiles(folderName).Count fileCount = Convert.ToInt32(counter) fileCount = …

Member Avatar for Papa_Don
0
1K
Member Avatar for Papa_Don

Group, I'm trying to import an EXCEL table into an SQL Server Table. Although new to SQL, I've done it several times. However for the first time I'm having to import a column that is a date. I'm not sure how the EXCEL column should be formatted so that it …

Member Avatar for David_Fisher
0
384
Member Avatar for Papa_Don

Group, I'm using VB.net 2010 and would like to convert a text file into a PDF file. In reading through the internet, it appears that I need to download a 3rd party .dll file. But is that needed? I see multiple PDF library references by right clicking the project name, …

Member Avatar for Sblogger
0
2K
Member Avatar for Papa_Don

Group, I've created and published a VB.net program. I've also installed this onto my computer. I want to set it up now to run via the Window Task Scheduler. However I need to locate the executable file to start the run. However I'm unable to find it using the name …

Member Avatar for Minimalist
0
5K
Member Avatar for Papa_Don

Hi group, I'm trying to insert both a copied range (from and Excel file) AND a message (text) into the body of an Outlook email. I've perfected the code to insert the range, but I've not figured out how to get the message to go along with it. I hope …

Member Avatar for Papa_Don
0
5K
Member Avatar for Papa_Don

Group, I've expanded a small app that started with 50 textboxes and labels to 200 of each. To hide and make these visable I use the codes lblProperty01.Visible = False tbxProperty01.Visible = True lblProperty02.Visible = False tbxProperty02.Visible = True This means there are 400 lines of code to hide and …

Member Avatar for Reverend Jim
0
527
Member Avatar for Papa_Don

Group, 10 months ago I posed the same question as to how to programatically create the variable names via the loop. However I'm now in real need of doing this and I don't fully understand what each step of the syntax actually means and what it does. Therefore I need …

Member Avatar for Papa_Don
0
1K
Member Avatar for Papa_Don

Hi group, I'm modifying a VB.net app where I need to loop through an Excel spreadsheet for data out of two column. In essence the code will need to read: For i = 2 to end of file propNo = Cells(i, 2).Value crms = Cells(i, 8).Value If crms = "Y" …

Member Avatar for Teme64
0
16K
Member Avatar for Papa_Don

Hi group, I'm starting a test to see if I can automate some tasks. In this first test, I'm using System.Diagnostics to open a specific version (I actually have two versions on my computer - both are needed). After that's open, I want to open a specific file within that …

Member Avatar for Papa_Don
0
231
Member Avatar for Papa_Don

Hi group, I'm attempting to create and write to an Excel spreadsheet with data from a text file. The code is meant to parse each line of the text and place the data into individual variables. I then need to place these variables into the appropriate cells on this newly …

Member Avatar for Papa_Don
0
436