bklynman01

I have an application that opens up Excel, reads some information, then closes Excel. I developed this application using Microsoft Office XP 2007. A few weeks ago, my company upgraded to Microsoft Office 2010. The applications still works fine, but I can not compile in VS 2008 anymore. I get …

I have a windows form that has 4 comboboxes inside. These 4 boxes are linked, in that when the first box receives user selected data, the second box populates. When the second box receives user selected data, the third box populates. At least that is how I want this to …

I have a program I wrote a few years ago that interfaces largely with MS Excel. At the time my company used Office 2007. We have since upgraded to 2010 with no problems. However, I had to make some adjustments, and now I can not compile. The error is Error …

My wife has been complaining about a virus on her computer for a few days now. I finally witnessed a "Just-In-Time Debugging" window pop up. It fails to open the thread, but its trying to open ping.exe. I can see it in the task manager, and even kill it, but …

This one has me stumped. I feel like it is something really simple, but I can't figure it out. I have a combobox that is triggering the population of some checkboxes depending on the user mode. For some reason, when I put a MsgBox() at the beginning of the function, …

I think it might be because you're not giving it a file to open. I built an application that uses excel, and this is how I opened the file... [CODE] Dim xlFile As New Excel.Application Dim xlSheet As New Excel.Worksheet xlFile.Workbooks.Open(Me.strFilename) xlSheet = xlFile.Workbooks(1).Sheets("Sheet1") [/CODE] The big difference is where …

I have began building a piece of software that needs to collect a series of information from the user. This information will all be based on what has already been entered. I would like to create a window that has a "NEXT" button in it. As they enter information, they …

I believe in your case, it is as simple as just adding another set of lines that define the parameter (lines 26~29 in your code). The ParameterFieldName would be set to a different name each time. Not sure if it is any help to you, but I have some code …

I have an application that allows the user to upload information from and Excel sheet. Since the user is more familiar with Excel, they prefer to do it this way. My software will close the workbook with [ICODE]Me.exApp.Workbooks.Close()[/ICODE], but if you have the task manager running, you can see the …

I'm trying to find a way to check for changes in a DataGridView. The gridview does not have a binding source because I am populating it based on some other information. Right now I get a NullReferenceException. It happens as the gridview is populated. I have marked the line where …

I have a piece of code that takes two strings, puts them together, then attempts to save that result into a table in a database. For some reason, the database is only showing the second half of the string ([ICODE]Me.txtRev.text[/ICODE] in this case). When in debug, I can see that …

Are you trying to create a new sheet in excel, or edit one that is current? If all pages are going to have Title, Name|Address, etc... then it may be easier to create a template and just fill it in. I have some code that opens existing sheets and edits …

My company assigned me the task of building software capable of training hundreds of individuals on hundreds of different items, building reports to show progress, and having sections for both users and administrators. The tools available to me were Visual Studio 2008 and SQL Server 2008. Previous programming experience was …

I'm having trouble populating a combobox from a table. I do it probably 100 other times in this same program and there are no problems. When the box populates, it just displays [ICODE]System.Data.DataRowView[/ICODE], even thought the display member is set properly. Any ideas? [CODE] Dim tbldoc As DataSet1.docHeaderDataTable tbldoc = …

Try: [CODE] Dim i As Integer TextBox6.Text &= "Insert Into " & ComboBox2.Text & " (" For i = 0 To ListBox1.Items.Count - 1 TextBox6.Text &= ListBox1.Items.Item(i).ToString() & "," Next TextBox6.Text.Remove(TextBox6.Text.Length - 1, 1) TextBox6.Text &= ")" [/CODE] That one line should remove the very last character, in your case …

I have a training program that is used by MANY different people. I have encountered many formatting issues already (like not allowing initials) but now I have a new one that I'm not sure about. When the code tests the name in the TextBox.Leave function, I can find if there …

I'm not sure if this is true, but maybe since the variable Period is a double, it is rounding up to the next whole number then testing. So in the For loop, try: [ICODE]For i = 1 to Period - 1[/ICODE] or even [ICODE]For i = 1 to Period.ToInt32[/ICODE] Again, …

I recently began working on an application that was built by someone that is no longer available. This application is filling an excel file, but I can not find ANY code that uses excel. There aren't even any references to excel interops. My thought is that this a multi-threaded application …

It looks like you are reading this from a dataset, not a database? If so, go into the dataset designer and click to highlight one of the table adapters. Then in the Properties pane, click the little plus symbol (+) to expand the field "Connection" and the connection string will …

Hello, I'm trying to sort a training table in order of the sequence of tasks. These tasks are numbered 1.1.1 1.1.2 1.1.3 ...... 1.1.10 1.1.11 When the query sorts this and displays it, it comes up: 1.1.1 1.1.10 1.1.11 1.1.2 .... Is there a way to get them to come …

It depends on a few things... The way the table is set up in the database. It is much easier to manage your information by using views, and not tables in Crystal Reports (especially in VS) And the group function... I had a hard time figuring this one out. It …

Hello, Does anyone know if there is a way to keep a desktop icon after a new version of software is installed? I'm using VS .net 2008 and after publishing a new version of software, the program updates the first time it is opened. However, after the install of the …

Hello, I have two DataGridViews in one window. The first one displays 2 columns, itemNo and task. When I click on a row in this grid, I want to populate the second grid with corresponding material. It is organized so that the itemNo in grid1 is 1, 2, 3, and …

Hello - I am using Visual Studio .net 2008. I have a form that has a tabpage control in it with 5 pages. I need to add another page, but in position 2, not at the end. Is this possible? I do not see any settings for the position of …

You can check your references. In the toolbar, click Project -> [projectname] Properties -> References Tab. In here, check the boxes in the bottom window to include any namespaces that you need to be included in the final project. I had this same problem, and just checked every box that …

I'm using Visual Studio .net 2008 to build my Crystal Reports. I have a simple table that shows training records of people. Training takes 5 days to complete, and each day has a record in a SQL database. I can display all the data, but want only to show the …

I have a section of code that builds a table as the user enters information. I'm having trouble figuring out how to navigate through this table. There is a NEXT button and a BACK button. When they hit NEXT, either the next row loads, or the textboxes are emptied out. …

I am using Visual Studio .net 2008, which has a Crystal Reports builder. I have gotten to the point of building the report from a view I have setup on my SQL server. Instead of using a table on the server, can I use a table from my DataSet? I …

I've never heard of the exceLINX software, but when you enter the VB Editor in Excel, double-click on WORKSHEET in the explorer bar. Then, at the top of the viewer are two dropdowns. These dropdowns contain functions that already exist. Some of them you can set be activated during certain …

I have a form that uses 28 checkboxes(checkBox1 ~ checkBox28), 28 labels(label1 ~ label28), and 28 textboxes (textBox1 ~ textBox28). These items need to be visible/invisible depending on the mode of the program (there are 5 modes). I could specify each item individually with visibility, but that requires a whole …

I have a set of code that builds a table as the user enters information. This information may be changed more than once before it is considered complete. After the user is done, I want them to click a button, and have that information entered into the SQL database where …

Maybe not the best way to do it, but... You can set a variable equal to the selected value (would have to be global inside the class). Then in your [ICODE].SelectedIndexChanged[/ICODE] function, you can put your code inside an [ICODE]If[/ICODE] statement that tests to see if the newly selected value …

I agree with not wasting your previous work. Maybe you can adjust it to be for High School, instead of College. Maybe a High School education program that is web based? You can use all the tracking capabilities of the previous program, and and in a web interface. That should …

I'm having trouble filling a ComboBox from a dataset. When the program runs, the combobox has the correct number of lines, but they all appear as System.Data.DataRowView Any ideas? [CODE] Dim tblModels As New DataSet1.modelDataTable tblModels = Me.ModelTableAdapter.GetModel Me.cmbModel.DataSource = tblModels [/CODE]

Can you just use a message box if there is no result? [CODE]MsgBox("YOUR MESSAGE GOES HERE")[/CODE] or [CODE]MsgBox(stringOfCode)[/CODE] Use a simple [ICODE]If[/ICODE] statement around it. Hope this helps.

Since your combobox is only populated with the customer_name and customer_id, these are the only items that you can load directly into the textbox. The syntax is [ICODE]comboBox1.SelectedItem.ToString[/ICODE] and [ICODE]comboBox1.SelectedValue.ToString[/ICODE]. If you are trying to fill the textbox with the address of this customer, you must first find the address …

I have a function that imports an Excel sheet into a SQL database. This function works except ONE line. [CODE] If sheetContent.Range("A" & exRow).Value2.ToString.Length < 1 Then Exit For End If[/CODE] The rest of this function works great, and it uses lines of code that are VERY similar to that …

I'm relatively new with VB.net, so please bear with me... I have a tabpage with 28 textboxes in it. These textboxes will be loaded with data and maybe changed. There is a Save button on the form that will take the data from these textboxes and save them in a …

[CODE] For Each cb As Control In Me.Controls If cb.GetType.ToString = "System.Windows.Forms.CheckBox" Then boxNo = cb.Name() boxNo = boxNo.Substring(4) Dim tempCB As CheckBox = DirectCast(cb, CheckBox) If tempCB.Checked = True Then MsgBox("Checked" & boxNo) Else MsgBox("Unchecked" & boxNo) End If End If Next [/CODE] The SubString() line will remove the …

I'm having trouble getting some data from a combobox. I have a series of comboboxes that populate as you make selections from the boxes. Each combobox is using data that is pulled from a SQL database into a dataset. This all works. When I get to the last box, I …

If you are using Visual Studio... In the toolbox is WebBrowser. You can open the file into the browser, but it will not look like M$ Excel. It will open the sheet only. You can build your own toolbar in the form. I do have some code for this if …

What is [ICODE]wl[/ICODE]? It is looking for an object to be there, but is not finding one.

I am working on exporting some data to a DataGrid (with no luck). So far I have: [CODE] Private Sub SaveDoc() Dim MyConn As System.Data.OleDb.OleDbConnection Dim DtSet As System.Data.DataSet Dim MyCommand As System.Data.OleDb.OleDbDataAdapter Try MyConn = New System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0; Data Source='c:\book2.xls'; Extended Properties=Excel 8.0;") MyCommand = New System.Data.OleDb.OleDbDataAdapter("select * from [Sheet]", …

I was able to find a few different threads that talk about using Excel in VB.net, but none seem to help me. Here is what I'm trying to do... I do not want the standard excel toolbar to be usable. I have a form that opens an excel file with …

I'm using VB.net 2008... Within the program, there is a button that opens a file inside of a second form ([ICODE]DocViewFrm[/ICODE]) and it works fine the first time around. Within this new window, there is a button that uses [ICODE]Me.Close()[/ICODE] to close the window and return to the main window. …

Recently, I have been assigned the task of tracking training records used by multiple departments within my company. Before, they would fill out ISO Standard Forms that are built in MS Excel and save them in one folder. This folder held ALL of the documents used by multiple departments, training …

What data type is the element in your database? Maybe you're trying to post a string to an integer? I've had that problem before, and had to pull the data from the combobox, manipulate it, then use it in a db command. Its a stretch, but only takes a second …

Hello, I'm writing code that will populate a listbox with the contents of a folder (a list of excel and word files). Naturally, the listbox has all file names with the ".xls" or ".doc" extension included. How can I get rid of this? I have tried [CODE]fileName.Remove()[/CODE] and [CODE]fileName.Replace()[/CODE] functions …

I do not see declaration of buttons that do not use images. Lines 42 and 49 show buttons that are being sized first, then being setup with the image. Perhaps this could be a problem? Otherwise... If you're using Visual Studio, there is a toolbar named Layout. View->Toolbars->Layout This will …