114 Solved Topics
Remove Filter  | Hello group! I need to scrape data from the screen of an open application. It will be used as text, so it will need to be converted into a string that I can parse. I've looked around and found scrapers that use the "picture" as a bitmap or jpeg. The …  |
| | Group, I'm trying to improve a macro in an EXCEL spreadsheet. The spreadsheet has multiple tabs (sheets), some of which have grouped rows in them. My "cleanup" routine needs to check to see if these grouped rows exist. Is there some code that does this (hopefully boolean)? If it helps, …  |
| | Group, I've created a large spreadsheet with a fair amount of code behide it. Historically it has run well and with no issues. However it has started giving me a "Run-time error '9': Subscript out of range" error. I have no idea what is causing it. It is stoping at … |
| | Group, I'm trying to write some code that will read the clocktime. When it hits a predetermined time, I want it to run a routine. I know how to do this in VB.net. It would be done like this: Private Sub Timer1_Tick(sender As System.Object, e As System.EventArgs) Handles Timer1.Tick If …  |
| | Hello group! I've created a short program to open an application at a specific time. It's working but is attempting to open the application multiple times. What should I be doing to control the number of times it is opening? It only needs to open one time. Here's my code: … |
| | Hello Group, I'm writing a macro to match dates from one spreadsheet to another. Specificially, SpreadsheetA has the date listed as text. I want to match that date to a range of dates in a column to find the row the matching date is on. I have some things that … |
| | I need to dynamically group rows together in an EXCEL worksheet. The obvious choice to do this will be VBA. I hope you can help. My spreadsheet has 18 columns and (up to) 5,000 rows of data. I've written the following code which works "OK" however it fails to group … |
| | Hi Group! I'm curious to know, is it is possible to build a custom control in Visual Basic? Specifically, I want to build a control that would be similar that would be similar to a ListView (in the Detail "view"). However the difference would be in how it actually displays. … |
| | Group, I've got a protected spreadsheet at work that prevents me from creating links or writing macro's to do some repetitive copying and pasting from one spreadsheet to another. I hope someone can help. I'd like to use VB (if possible) to copy from a specific range in Spreadsheet1.Sheet1 (let's … |
| | Hi group, I'm looking through the book "Mastering Microsoft Visual Basic 2010" by Evangelos Petroutsos. I'm trying to work through a chapter on designing windows controls. In the first step the directions read: "Start a new project, and in the New Project dialog box, select the template Windows Forms Control … |
| | Group, I've got 1000 questions regarding this "Rocket" (Unidata) database, but I digress. To give you some background, I do have some experience with SQL, but nothing with Unidata. But given what I've read, I can't believe it is that much different from SQL, aside from the command syntax (I …  |
| | Hi group! I hope all is well! As part of my connection string and database insert/update, I have an exception command in it to display an error message. Can this also be read or made into a true/false answer? I would like to have my program run very short command …  |
| | Hi group! I have what I hope is a unique question: In need to populate a combo Box with the information stored in 6 different columns on one row of a data table. I know how to do this if it just one column and one row. To be specific, … |
| | In trying to teach myself about the properties of the textbox, I'm wondering what the propert "Lines" is all about. The value in the property says "String[]Array". When I click this, a box comes up that asks "Enter the strings in the collections (one per line)". Can someone explain to … |
| | Group, I may have made a huge mistake repairing SQL Server Management 2008 Express. Here are the details: I'm running Windows 7 on a Toshiba Laptop. SQL Manager 2008 had been installed and was working fine. I had some registry errors popping up, so I ran ARO 2013 to do … |
| | Group, I've found code that will format a number found in a TextBox to display it with two decimal places. It looks like this: Private Sub txbStateTaxPcnt_Leave(sender As System.Object, e As System.EventArgs) Handles txbStateTaxPcnt.Leave stateSlsTax = Convert.ToInt32(txbStateTaxPcnt.Text) txbStateTaxPcnt.Text = stateSlsTax.ToString("n2") End Sub This works great when a whole number is … |
| | Group, Historically I've used 'Convert.ToInt32(TextBox1.Text)' when moving the numbers stored in a TextBox to an integer variable. But it's made me wonder what the difference is between Int16, Int32 and Int64. In simple terms, can someone explain this to me (remember, I'm simple minded!)? As a follow-up question, I'm finding … |
| | Group, I'm not sure if this is a SQL Server issue or a Visual Basic issue. However during the runtime, I'm getting the following error message: String or binary data would be truncated. The statement has been terminated. I'm not sure why or where this is being caught. Searching this … |
| | Hello Group! I've looked around to see if there is specific code in VB.net to do this, but I haven't seen any. I'm using ListView/Detail and want to ensure that it is sorted ascending by one specific column. That column is called "hdrLineNo". I know that I can choose "Sorting …  |
| | Group, I've written a short stored procedure in SQL Server 2008 to create a new Order Number. The code looks like this: INSERT INTO ORDRNUMBERREC(OrderNo,UserId,CreateDate) SELECT MAX(OrderNo)+1,'system',GETDATE() FROM ORDRNUMBERREC WITH (TABLOCKX) In VB2010, I've written the following code to execute the stored procedure: con = New SqlConnection(sConnection) cmd = New … |
| | Hi Group! I've created a stored SQL procedure that will need to be modified to lock the table, run the commands and then unlock the table. I need to do this because I want any other users/programs that will need access to "wait in line" until the procedure is finished. … |
| | Hi group, If you've seen my posts before on SQL Server stuff you know I'm a "raw rookie" with this. Again, I need some help. I'm going to need SQL to create an order number for me. I've created a datatable with two fields: OrderNoID (key) and OrderNumber. I've already … |
| | Hi Group! I suppose this should be titled, "Everything You Wanted to Know about ListViews, but were Afraid to Ask". Here are my questions(s): I've used ListView with "Details". This has been great when getting smaller bits of information to easily display and edit. However I'd like to use it … |
| | Group, I've learned to find the index number of a specific character within a string by writing dIndex = myText.IndexOf("|") Obviously, this start counting left to right. But I'd like to do the same but start counting from the right side of the string to the left to find the … |
| | Group, I'm trying to write the commands to update a row within a SQL table. I've written the following: USE DATADESIGNSOLUTIONS SET IDENTITY_INSERT LocationID ON INSERT INTO LOCATIONS_SETUP(LocationID, LocationNumber, LocationName, LocationAddress1, LocationAddress2, LocationAddress3, LocationCity, LocationState, LocationZipCode, LocationZipCodeExt, PhoneNumber, FaxNumber, BillToAnswer, BillToLocation) VALUES(10, 1, 'Traditions in Tile / Buford RDC', '4325 … |
| | Group, I'm working to use a second for to do task that will be populate texts boxes in the first form. However I'm getting an error that says, "An error occurred creating the form. See Exception.InnerException for details. The error is: Object reference not set to an instance of an … |
| | Hello group! I've seen one short discussion of ensuring that the controls within a form will shrink, grown and stay in their proportional position as the user changes the form size. Unfortunately it covered parent/child forms, etc. It didn't make a lot of sense to me. Ultimately I do want … |
| | Hi group, I recognize the today, most people navigate from control to control within a form with their mouse. However some old school people may want to use a "enter" key or a up, down, left or right arrow. I'm curious to know if these kinds of events (if that's …  |
| | Group, I'm working with a ListView box for the first time. I've figured out how to populate it with data from a database. I now want to click one line of that ListView and have it return each of the five cells from that line into 5 textboxes. I've written … |
| | Hi group, I've been playing with a ListView and I'm struggling to get it to populated with info in a database. I'm hoping you may see something in my code that is creating the error. Dim con As New SqlConnection Dim cmd As New SqlCommand Dim rdr As SqlDataReader = …  |
| | Group, I'm declaring a variable in one form that I need to make available in a second form. My code in Form1 looks like this: Public Sub FuncKeysModule(ByVal value As Keys) Select Case value Case Keys.F5 Dim searchtype As Integer If txbPartNo.Focused = True Then Popup_PartNumbers.Label1.Text = "Enter the beginning … |
| | Hi group, I'm still learning Visual Basic and SQL. Please overlook my inabilities. I'm writing a module that is meant to write a small amount of data to a database. I've named these fields 'PrinterID', 'PrinterName', 'PrinterNumber', 'PrinterLocation' and 'PrinterAddress'. The user will eventually have 30 or 40 records to … |
| | Group, I've been working for several hours trying to correctly write to a database file. Here are the parameters: Database Name: DATADESIGNSOLUTIONS Table Name: PRINTERMAINT Column Names: PrinterID (primary Key), PrinterName, PrinterNumber, PrinterLocation, PrinterAddress I've been working at this two ways: through the Visual Basic code and through SQL Server … |
| | Hi group, Within one form, I need to run a routine twice. Obviously, I can write the code twice in the two places it needs to run. Isn't there a way to write the routine one time and the call it in two places within the form? Would this be …  |
| | Group, In reviewing the data in one of my SQL Server tables, I noticed that my nchar or nvarchar fields have additional spaces added to the end of the record. Is there a way to stop this? Should I be using a different data type? In advance, thanks for your …  |
| | Group, I need to use Function keys within a form I've created. The problem I'm having is determing the correct routine to fire it off. Here's what I'm attempting to do: In Form1 (actually called "OrderEntry2"), I want to give the user the option of keying in a part number … |
| | Group, I'm thinking I may want to use the Date data type in SQL Server. However I'm still very unclear how to read, write and compare using this kind of data type. I realize this has a time component which is of no importance right now (it will be later … |
| | Group, I'm having an issue with SQL Server that has me baffled. I need help. When I originally loaded SQL Server 2008 Express and created my database, I called it "DataDesignSolutions". The tables were created through VB Studio 2010 Express. It's path was "C:\User\Don\Documents\DataDesignSolutions.mdf". I'm not sure how, but somewhere … |
| | Group, After asking what seems to be a thousand questions, clearly there is so much more to learn about Visual Basic. So this prompts my "Today's Question": Are there some good online courses or classes at a local college that I can take? By the way..... I live in the … |
| | While creating a module within my program, I created a second Dataset (and it's called DesignDataSet2). I would like to delete it from the database altogether. I have already removed the one datatable that was within this dataset. I now want to eliminate this completely. How do I go about … |
| | Group, I've got several textboxes within a form that are set to link to a data column that are set to accept a "null" (blank) value. However, these columns are formated to receive numeric data. When the user bypasses entering anything within those textboxes (as they should do), what is … |
| | Group, I see there are multiple "validation" type events to choose from in the "Declarations" drop-down box. I want to understand these choices better to see if one would work for what I want to do. I've got several textboxes that need to have either a number entered into them … |
| | Group, I'm stuggling to get values from an sql database table into several textboxes. I'm not getting an error, but I'm also not getting anything to show up in these textboxes. Can you offer some thoughts as to what I need to do to fix this? Private Sub btnUpdateOrder_Click(ByVal sender … |
| | Group, I've got part of my code started to populate the DataGridView with the data I need to return. When testing it, I have this long pause and no returned data. I finally have to kill it via <Control><Alt><Delete>. I've tried reading through mulitple websites to find some information to … |
| | Group, I've read through the tutorial regarding Listviews and SQL's (http://www.daniweb.com/software-development/vbnet/code/445801/avoiding-sql-injection-attacks). Thanks for the article. It was very imformative. So I thought I might try this with the project I'm doing. I really like how these listview look and what they can do. But I realize I need to know … |
| | Group, I'm trying to change the "sa" password to my SQL Server Database via the 2008 SQL Server Manager Express. I have followed every instruction dillegently and can't seem to "complete" the change. Each time when trying to login with the SQL Server Authentication, I get the error message that … |
| | Hello Group, I'm beginning to understand the connections required to return information from your database. I'm now trying to return multiple lines from the database that have the same "prefix" within the part number. As my example, I have two records within my database that both start with "AO0025". I … |
| | I'm trying to read and return info from an SQL database. To ensure you have the details, here's the basic info: The database is called "DataDesignSolution" The table is called "INVENTORY" I'm trying to read the columns "INV-PART-NUMBER" and "INV-DESCRIPTION". I've written the following code hoping to SEARCH through the … |
| | Group, I'm discovering that the SQL Server tables don't like identical (in this case) Part Numbers, even though one of the columns will have different information in it (in this instance, it is the "Location"). FYI.... I'm using SQL Server 2008 Express for my testing. With this said, I'm trying … |
| | As state previously, I'm a newbie at coding in VB and have much to learn. I'll appreciate your input and knowledge! I'm creating a Order Entry form. I have the database in place with some "test" items in the in the table. I now want to begin creating a new … |
The End.