-
Created Fast Efficient Way to Hide and Show Textboxes and Labels
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 … -
Began Watching Fast Efficient Way to Hide and Show Textboxes and Labels
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 … -
Marked Solved Status for Programatically creating multiple variables through a loop
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 … -
Replied To a Post in Programatically creating multiple variables through a loop
Group, Rev. Jim made a very good statement that I think I'm going to take: "You want to declare a variable number of variables dynamically which, in most cases, is … -
Replied To a Post in Programatically creating multiple variables through a loop
Rev. Jim, I may be misstating what I need to do. I know my phraseology may not be correct. In my earlier version of my application I defined (Dim) a … -
Replied To a Post in Programatically creating multiple variables through a loop
Minimalist, I believe I'm understand what you're doing here. It looks like Dim idList As New List(Of String) idList.Add("Props" & i.ToString) is creating the variable on the fly. Now I … -
Created Programatically creating multiple variables through a loop
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 … -
Began Watching Programatically creating multiple variables through a loop
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 … -
Created Reading an Excel Spreadsheet via VB.net
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: … -
Began Watching Reading an Excel Spreadsheet via VB.net
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: … -
Marked Solved Status for Using System.Diagnostics.Process to Open Files
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 … -
Replied To a Post in Using System.Diagnostics.Process to Open Files
Awesome! Thank you, Teme64! -
Created Using System.Diagnostics.Process to Open Files
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 … -
Began Watching Using System.Diagnostics.Process to Open Files
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 … -
Marked Solved Status for Creating and Writing to an Excel Spreadsheet
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 … -
Replied To a Post in Creating and Writing to an Excel Spreadsheet
Awesome.... Absolutely awesome. Thank you, Professor Jim..... err... I mean Rev. Jim... I'll use the array as well. I need to learn to do that anyway. thanks for the help! … -
Replied To a Post in Creating and Writing to an Excel Spreadsheet
If you really want to try it, here is the info you don't see in the text file: "propertyNo" is used to find the file and save the file. "392" … -
Replied To a Post in Creating and Writing to an Excel Spreadsheet
I've attached the test data file I'm using. The text file I'm using is created in the background. However I'd like to create the Excel document, add the parsed date … -
Replied To a Post in Creating and Writing to an Excel Spreadsheet
As it turns out, the code Dim restranFile As String = hotelFolder & "\Restran\" & propertyNo & "Restran.txt" Dim restranText As String = File.ReadAllText(restranFile) wasn't needed. I had copied it … -
Created Creating and Writing to an Excel Spreadsheet
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 … -
Began Watching Creating and Writing to an Excel Spreadsheet
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 … -
Marked Solved Status for Creating and Writing to an Excel File
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. … -
Replied To a Post in Creating and Writing to an Excel File
FYI.... I found the cause of this specific error. It was looking for a "sheet number" (integer). I entered "1" and this fixed it. The adjusted code looks like this … -
Marked Solved Status for Making a list of Folder Names from a Network Drive
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 … -
Marked Solved Status for Linux vs. UNIX output file /Converting to a Text File
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 … -
Marked Solved Status for Converting a Text File to a PDF file
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 … -
Marked Solved Status for Changing Font size Programmatically using ItextSharp
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 … -
Marked Solved Status for Summing values from two tables and summing them separately
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 … -
Created Creating and Writing to an Excel File
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. … -
Began Watching Creating and Writing to an Excel File
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. … -
Marked Solved Status for VBA Equivalent of getFolderNameGD
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 … -
Marked Solved Status for Select Case inside an If/Then statement
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 … -
Replied To a Post in Select Case inside an If/Then statement
Ahhhhh.... (and now the lightbulb comes on)! Excellent! Thanks for the advice and instruction. This is valuable! Thank you both! -
Created Select Case inside an If/Then statement
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 … -
Began Watching Select Case inside an If/Then statement
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 … -
Marked Solved Status for Understanding Regex
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: … -
Replied To a Post in Understanding Regex
Minimalist, You're probably on the right track for me. However I'm not sure I understand "Select Case" even after reading as I'm not sure how to incorporate this in my … -
Marked Solved Status for Error Message when Application Opens
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 … -
Revoked Solved Status for Error Message when Application Opens
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 … -
Marked Solved Status for How to use DECLARE
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 … -
Marked Solved Status for Macro's saving Worksheet as Strange Name
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 … -
Marked Solved Status for Cells changing Fonts and Formats automatically
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, … -
Marked Solved Status for VBA Equivalent to CStr(getFolderNameGD()) (VB.net)
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 … -
Created Understanding Regex
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: … -
Began Watching Understanding Regex
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: … -
Replied To a Post in VBA Equivalent of getFolderNameGD
tinstaafl, I'll do some reading and give that a try. I hope that works. Thanks for the help. -
Marked Solved Status for single-row subquery returns more than one row
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 … -
Replied To a Post in single-row subquery returns more than one row
As it turns out, I had a table listed twice which may have been causing the issue. I took it out, change to a different table and it worked correctly. … -
Created single-row subquery returns more than one row
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 … -
Began Watching single-row subquery returns more than one row
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 …
The End.