130 Discussion / Question Topics
Remove Filter  | 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 …  |
| | 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 … |
| | 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 …  |
| | 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 … |
| | 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 …  |
| | 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 …  |
| | 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 …  |
| | 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 … |
| | 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 … |
| | 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 …  |
| | 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 …  |
| | 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, … |
| | 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 … |
| | 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 … |
| | 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 … |
| | 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" … |
| | 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 …  |
| | 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 … |
| | 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 = … |
| | 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 … |
| | 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, … |
| | 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 … |
| | 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 … |
| | 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 … |
| | 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 … |
| | 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" … |
| | 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 … |
| | 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 … |
| | Hello Group, I'm attempting to create and write to an Excel file. I'm sure I've hit the first of many snags. Hopefully you can point me in the right direction. In this first attempt, I'm getting an error code: "Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))". The error is attached … |
| | Group, I've got a complex If/Then statement that may require the use of "Select Case". However I'm not familiar with how "Select Case" actually works. Needless to say, I'm not sure if you can use it within an "If/Then" statement. Here's what I need to do: If row > 7 … |
| | Group, I need to insert an "If/Then" statement that will require the command to check the string for multiple variables. In other words it needs to say something like this: If Microsoft.VisualBasic.Mid(txtLine, 18, 1) = "C" or "T" or "G" or "W" Then Go do something End If After doing … |
| | Group, In VB.net, I use the following to return the actual name of a folder where data is kept. Is there an equivalent in VBA? I sure hope so. It would solve some problems for me. foldernameGD = CStr(getFolderNameGD("O:\Revenue Management\Centralized Revenue Management Service\CRMS Hotels", propertyNo2 & "*")) In advance, thanks … |
| | Hi group, I'm getting an "single-row subquery returns more than one row" error when running my routine. Looking through the table I'm querying, it is listing a date twice for some reason. Since I'm not able to remove this one row, is there a way to return the first instance … |
| | Group, In VB.net, I use the following to return the actual name of a folder where data is kept. Is there an equivalent in VBA? I sure hope so. It would solve some problems for me. foldernameGD = CStr(getFolderNameGD("O:\Revenue Management\Centralized Revenue Management Service\CRMS Hotels", propertyNo2 & "*")) In advance, thanks … |
| | Group, I've created some spreadsheets that others use. The headings of the spreadsheets are divided up with colors. However after I've created these and saved them formatted as I like, some of these cells are changing automatically after the other users open them up. I've read online there may have …  |
| | Hi Group, I've recreated a spreadsheet that has multiple macro's behind it. One of these macro's opens and existing file, copies the data in it and then pastes it into the original workbook (where the macro's originate) and then closes the existing file. After the copy and paste is done, … |
| | Hello group, I've decided I want to take some classes in SQL, to better understand how to write queries. In looking online for where to turn to for this kind of training, I also see classes to prep for certification. I'm curious of what the value to my employer would …  |
| | Hi Group, I'm getting the following error message as soon as the application opens: ************** Exception Text ************** System.NullReferenceException: Object reference not set to an instance of an object. at IPSDataUpdate.Main.RunComplexProperties() at IPSDataUpdate.Main.Main_Load(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Windows.Forms.Form.OnLoad(EventArgs e) at System.Windows.Forms.Form.OnCreateControl() at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) at … |
| | Group, I'm extracting some month and year values from dates. I need to ensure they are NUMBERS as I'm going to multiply, add and subtract. I'm assuming I need to DECLARE these as NUMBERs. However I'm not sure how to do this correctly as I'm getting errors preventing me to … |
| | Group, I'm using TOAD to query the Oracle database. My better expertise is in VB.net. I have very little SQL experience. My question: Can I create a variable in TOAD/SQL to prompt for a date(s)? Here is what I want to do: Question 1: Enter Beginning Date (user to enter … |
| | Hi group! I'll be up front and say I'm very new to SQL. I'm just now getting my feet under me in my new job. So I have lots of questions. I'll start simple (I hope). I've created my own tables (2) that have multiple columns of data that looks … |
| | Group, I'm converting a text file into a .pdf file using ItextSharp. The code below works perfectly to do this. Unfortunately the default font size is to large. I need to make it smaller. Here's my code: Private Sub ConvertToPDF() ' Converting the Restran text file to a PDF file …  |
| | Group, I'm using `System.IO.File.Move` to move an existing file into another folder. However it the program is stopping at this point with the error message "The process cannot access this file because is being used by another process". Unfortunately I can't find "the other process". For the record, I've also … |
| | Group, I'm using the following code to read down to the third line of a text file. If it meets the criteria, I need to stop the read and then delete the file. However I'm finding it difficult to do this as everything I've tried has failed. Have you some … |
| | Hi group, I'm using VB.net to convert an output file (text) from a Linux based program into a file that will easily read in Notepad. I found some code in VB.net to do this conversion for UNIX that works "OK" (meaning fair but not perfect). It looks like this: txtLine …  |
| | Hi group, I'm attempting to use a variable (i) to read the multiple files within a folder. However this doesn't seem to be working. Can you tell me what I'm doing wrong? For i = 0 To counter Dim objReader As New System.IO.StreamReader(getRestranName(i)) If System.IO.File.Exists(folderName) Then Do While objReader.Peek() <> … |
| | Hi Group, I attempting to save a file to a specific folder that is begins with the hotels property number. Currently I've manually listed the properties complete folder name in a text file. This is proving to be a management problem that needs to be fixed. The code I'm using … |
| | Hello Group! I've written an app that saves the updated info into a network file folder based on the property number (I'm in the hotel industry). Currently I have a text file with the individual folder names that I've hand written so the app knows where to store the data. … |
| | Group, You've helped me write a routine that merges and formats a text file when multiple files exist. The code is as follows: If fileCount = 3 Then RestranName = getRestranName(0) RestranName2 = getRestranName(1) RestranName3 = getRestranName(2) Dim readtxt() As String = File.ReadAllLines(RestranName) 'Deleted the actual file. File.Delete(RestranName) 'Now time … |
| | Group, Some weeks back you helped me solve a formating issue with a text file that originates from a UNIX based program (see [https://www.daniweb.com/software-development/vbnet/threads/489626/remove-end-of-report-line-and-format-unix-text]). While reviewing this newly formated data I saw that a character was place at the beginning of each page. Thus, I assume it does set the … |
The End.