I'm trying to add the spreadsheet control to a form in VB but I can't remember what reference or file I need to load to get the object in the toolbox.It has been a while since I used it last and that was in VB 2008.I looked and loaded several microsoft interop files from the .net reference menu but none of the seemed to work.
View 3 RepliesI have a spreadsheet control on a windows form that I would like to populate with data from an existing worksheet (myworkbook.xls, sheet1). The best solution for me would to be to actually open the workbook on my form (not sure that is possible?), the next best solution would be to fill the spreadsheet control.
View 1 RepliesError: ClassFactory cannot supply requested class.I installed 2003 Add-in: Office Web Components, you can download and install OWC11.exe from the following link:aunched a VB formadded the Spreadsheet 11.0 control and got the above error.
View 1 Repliesrecommend a spreadsheet control other than the OWC webcomponents with very simple functionality? I just need a 2x100 matrix and the ability for user input. I need this for VB.NET and I need it to be compatible with both 32bit and 64bit systems.
View 1 RepliesI have a spreadsheet in excel with three headers:
Project Name The name of a project i'm working on.
Requested Role The job title/profession of the project employee. (example: mechanic, manager, engineer)
The name of the employee.When i click on the Person's name i want another page or tab (specific to this person) to appear showing details about them such as their name, job title, how long they worked, what project they are doing... etc. (similar to a Facebook profile)
When i click on the project name i want another page or tab (specific to this project) to appear showing details about it such as the requirements, the deadline, who is currently working on it... etc.
Furthermore, i would like to set up two levels of access:For the specific pages i was thinking of using the tab control but i want it so that i can search through the list of projects or names, select one, and then it brings up the page about it.The levels of access is the least of my worries.
I have a VB.Net program that reads in a flat file, and then parses line by line, formatting the data into different spreadsheets in an excel workbook (each line can be any 10+ different record types so I parse and put in appropriate excel sheet).
For smaller sized flat files (under 10mb), the parser works great. However, I am trying this on a file that is over 120mb (400k+ lines). While running, I will get an OleDBException saying that the spreadsheet is full. Now I am pretty confident that Excel can handle a much larger data set than a flat file. So I assume this exception is not giving me the true story as to what is really occuring.
I open a connection, and then parse each line in the file, inserting each row into the excel file. I assumed it would be bad performance wise to open/close the connection between each insert. Could this be causing the issue? Any ideas what I need to do to handle such a large file? There are cases where the flat file can be over 500mb.
To actually do the insert into excel, I am just doing the following (I construct an sql query based on the type of row and values parsed):
Dim conn As New OleDbConnection()
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + ExportLocation.Text + "" + importFileName + "-PVF.xls;Extended Properties=""Excel 8.0;HDR=YES"""
[Code]....
I have a spreadsheet control on a windows form that I would like to populate with data from an existing worksheet (myworkbook.xls, sheet1).
View 4 Replieshow can I add a spreadsheet into my form
View 3 Repliesembed an excel spreadsheet in my form and maintain its functionality - so i can edit it, formula still works etc etc...
and also if changes are made, save the spreadsheet and so on.
I have an issue that I am trying to work around. I have an aspx page that needs to load up a formated XLS spreadsheet into a DIV tag and then allow the user to input data that will be retrieved later on postback and values store in a MS SQL database.
I created an excel spreadsheet and formatted it with the formulas and colors. I also added a combobox from the control toolbox. I also added a checkbox from the control toolbox to another cell. I then saved the page using File-->Save AS WebPage. I checked the 'Add Interactively' checkbox on the save dialog. I then opened the file in an editor and copied the object tag into my aspx page. Everything was fine except my combobox and checkbox did not appear in the HTML spreadsheet.
I am assuming that I have to EITHER programmatically add the controls prior to render or add the combobox as a XML element to the proper node of the XMLData value parameter attribute.the current XML Block for this node is :
<Row ss:AutoFitHeight="0" ss:Height="18.75">
<Cell ss:StyleID="s23"><Data ss:Type="String">Fund</Data></Cell>
<Cell ss:StyleID="s23"/>
[code]....
The second cell, between FUND and ENG is where I need to add the combobox. also how about binding data to this dropdown control control. This data is coming from SQL DB, and not from a range in the activesheet. Someone told me that I should use Access instead of Excel but I dont think that is right as I need spreadsheet capabilities on the page?
I am converting an Excel spreadsheet with VBA macros to VB. I have been able to export all of the VBA macros (.frm, .cls, .bas), but cannot figure out how to export the controls embedded on an Excel spreadsheet to a VB form (e.g. =EMBED("Forms.CommandButton.1",""). I have buttons, check boxes, list boxes, etc. embedded in an Excel spreadsheet. In the macro editor, I can see the controls in the object browser window. For example:
cmdPrvFirst As CommandButton
Member of VBAProject.Sheet1
Copy/paste does not work. How can I do this? I hate to have to create the VB forms from scratch.
I'm relatively new to VB programming & My question was, how do you see the control source or rowsource of a text box so that you can make I display data. I have a case where I am trying to display sub-totals from an exce spreadsheet into a text-box on a User-form. And is it possible to make a selection in one listbox and have corresponding selection highlighted in another listbox?
View 1 RepliesIm Using VB 2008. I have MsgBox() statements in all Mouse & Form Click events to TEST & NOTHING FIRES during Form Load when I click on Form or Button Controls !!! The Form Load event contains code for Displaying the Label.Text control many times with changes in the Text to simmulate annimation.
[Code]...
I have created simple windows form control with some events.
This form has button which opens Form with some settings.
Now, I need to raise the events inside the control when I click some buttons within the settings form ..
The following code works perfectly to allow moving a control on a form at run-time. However, when AutoScroll is set to True on Form1, and you drag Button1 past the right and/or bottom bounds of the form, it goes haywire. I really need someway to smoothing control the autoscroll so that as you scroll the control off the form, the scrollbars smoothly appear.
[Code]...
I am still messing around with Cntrl/Copy and Paste from a menustrip. Paste is working fine. The copy is working to a certain extent. It will copy the complete text field from one control to another. how do I determine what is the selected text only. My code below:
Private Sub CopyToolStripMenuItem_Click(ByVal sender As Object, ByVal e As EventArgs) Handles CopyToolStripMenuItem.Click
Dim activeChild As Form = Me.ActiveMdiChild ' Determine the active child form.
Dim activeControl As Control = activeChild.ActiveControl
[code]....
The code is listed below which hopefully illustrates what I'm trying to do:[code]....
View 12 RepliesI've got a Panel on a main Form containing a PictureBox control on Top of a TableLayout control. Both the child controls have their docking properties set to Top. The Picture control has sizemode set to Zoom.
What I'm finding is that the picture doesn't size properly when I start the app. There is a border at the top and bottom in the PictureBox control. It's only when I resize the overall form that it's correct.
So at the moment I've got this ugly bit of startup code, just to fix the problem Me.WindowState = FormWindowState.Normal Me.WindowState = FormWindowState.Maximized
What am I missing?
i want to set the CommandTarget property of menu item to the TextControl which is written in win form or just tell me any way which can execute the command lets say cut copy paste on the control which is written in win form user control and added to xaml through WindowsFormsHost
View 1 RepliesI have a form set up with a few text boxes for first name last name and job title and i got the class for EditDialog. vb. The question is I have to drop some controls onto the form to make a generic add and edit employee dialog. Now would I use the listbox or drag and drop control?
View 2 RepliesI have a user control which contains some textboxes,buttons ,labels and comboboxes . I used that control in a form and inside a split contaier.Splitter can be moved by the user. User control is docked as fill.
Now when user move the splitter the user control size is changes as it is dock fill but the inner controls used in that user control looks like fixed in a single place .It are not moving nor resizing .How to do this .Is there any property to perform thisI already know about anchor property but sometimes it causes overlapping of controls so I can not use it.
Here is the pertinent part of my code:
Public Class Form1
Inherits System.Windows.Forms.Form
Private Sub MenuItem3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
[code].....
I have a basic Windows form with one Crystal Reports form veiwer control on it. When ran on the development machine it displays the report fine.After build and publish the application is now installed on a user PC. I am getting an error that the Crystal Decisions. Windows. Form version 12.0.2000.0 can not be found. All the Crystal dll's are in the install directory but none of them are being installed in the install machines GAC.Am I setting my publish output up wrong, may references wrong, or is the local GAC files the problem. The message is so criptic, it doesnt really point me in the right direction.
View 1 RepliesI need to create text box at a run time.
I found the following VB NET code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim textbox1 As New TextBox
[Code].....
When this row GroupBox1.Controls.Add(textbox1) and GroupBox control are being deleted from Form, the TextBox isn't created on the Form after the event is fired.
I've created the beginnings of my new web application, but I am often coming up against the issue that ASP.NET renames elements IDs or in the case of form fields, their names.I have a form which is basically a sales system. It is essentially made up of two User Controls, one is a form for Customer Details (name, address etc) and the second is a form for the customer's purchases, it consists of a number lines dynamically created by Javascript created as you list the items the customer is purchasing. Both these sections are User Controls because they are to be used for other areas of the system where this data will need to be recalled/re-entered.When the USer Control is loaded, the field which contains the Customers' Name is renamed "m$mainContent$customerForm$name" I understand where this comes from, "m" is the ID of my Master Page, "mainContent" is the main Content Placeholder and "customerForm" is the name of the User Control.
In fact, in my case, this will always remain the same on all forms, so it is relative easy to overcome... but... suppose it wasn'tI can see there are ways I could deal with this with Javascript, but the form doesn't need an AJAX submit, a normal Post will do fine for this, so when I open up the recieving page I want to call Request.Form("name")% to save the customer's name into the database, but of course I really need Request.Form("m$mainContent$customerForm $name")%How would I dynamically extract those prefixes from the posting form to ensure that if I rename anything or use it in a different scenario, the problem will not break it?I am using .NET 2.0, so can't use Static Client.
I've created the beginnings of my new web application, but I am often coming up against the issue that ASP.NET renames elements IDs or in the case of form fields, their names.I have a form which is basically a sales system. It is essentially made up of two User Controls, one is a form for Customer Details (name, address etc) and the second is a form for the customer's purchases, it consists of a number lines dynamically created by Javascript created as you list the items the customer is purchasing. Both these sections are User Controls because they are to be used for other areas of the system where this data will need to be recalled/re-entered.
When the USer Control is loaded, the field which contains the Customers' Name is renamed "m$mainContent$customerForm$name" I understand where this comes from, "m" is the ID of my Master Page, "mainContent" is the main Content Placeholder and "customerForm" is the name of the User Control.In fact, in my case, this will always remain the same on all forms, so it is relative easy to overcome... but... suppose it wasn't I can see there are ways I could deal with this with Javascript, but the form doesn't need an AJAX submit, a normal Post will do fine for this, so when I open up the recieving page I want to call Request.Form("name")% to save the customer's name into the database, but of course I really need Request.Form("m$mainContent$customerForm$name")% How would I dynamically extract those prefixes from the posting form to ensure that if I rename anything or use it in a different scenario, the problem will not break it?
I have another question (and anticipate that I will have about two more before I'm done with my class project). Here is my issue (and I'll copy and paste my code for clarification). I need to link up the control from the form on either side of the current form that I'm working on so that if I click on the buttons that I'm titling previous and next that I can click on the proper button and either go directly to the previous form or the next form. I was successful in doing this for two earlier forms on this project (with some direction from a couple of helpful people on this forum before), but for some reason, no matter what I details I use the controls do not connect to the previous and next forms.
Option Explicit On
Option Strict On
Option Infer Off
[code]....
I have an application that when ran I can not seem to be able to move the form. When I try to select the cancel (x) button on the form nothing happens. I am lost as to why I am unable to select the form and move it or close the form.
View 1 RepliesWhat is the best way to access a value of a control within a form outside of the form class. I have a lot of functions defined in a module, one of these functions requires a series of values from controls in my main form such as the FolderBrowserDialog.SelectedPath element. I understand that these cannot be accessed in the format form.FolderBrowserDialog1.SelectedPath and that they need to be accessed using a delegate. This is the part I am stuck with.
[Code]...
I have multiple form application in vb.netNow i rose to a condition where i want to display one Form in the Groupbox/Panel control of other form.
View 2 Replies