Is there anyway of access the value of a chekbox in a excel worksheet using vb? I need to import the answers of a survey that is in multiple excel files.
I´ve tried
wsheetB.OLEObjects("CheckBox1").Object.Value
but I get a com exception
Exception from HRESULT: 0x800A03EC
I wanted to know if anyone could tell me how to access the Click_event.I have a boarderles form with a panel control which has the Dock property set to fill and on the panel I have placed a Label also with the Dock property set to fill. I also have a timer running.How can I get code to execute in the Label1 click event.I've tried doing it by using the generic Click_event and also with two variations of the Click_event Handles parameters
'Alternativ 1:
Private Sub Form1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Label1.Click
[code].....
If I have the following ListView, how can I attach a SelectedIndexChanged event listener to the DropDownList so I can perform a command on the respective object? Imagine I have a list of new users and I want to add them to a usergroup by selecting the group from the DropDownList.
<asp:ListView ID="NewUsers" runat="server" DataSourceID="NewUsersSDS" DataKeyNames="ID">
<LayoutTemplate>
[Code].....
I have a module level sub that I use to clear text fields etc on my forms:
CODE:
The problem I have is in the last few lines of code as I'm not really sure how to access the text boxes contained within the tab controls (of which there are many tabs and many text boxes).
This is the closest I've got but I am getting an "option strict on disallows late binding" error on the tabCtl in the following line.
I have a thread running on a child form, I want to activate a control on the parent form but cannot. It works fine if It's done from the child forms UI thread:
(FormMain.SetControlPropertyValue(FormMain.RBSQL2005, "Checked", True))
but not from a thread running on the child form:
Public Class FormRestoreDB
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim t = New Thread(AddressOf UpdateListView1)
[code]....
how can i access the controls that i made from another form? i'm also going to also use function (on the same form as the controls) that access that controls?
View 3 RepliesI have a nokia phone, which is connected to my PC through Nokia PC Suite. Whenever I get a call on my phone, a small window appears above System Trey. I want to read out the number of caller that appears on that window through my program, so that I can use it further.
View 1 RepliesI have placed a button on data repeater (called datarepeater1) so that it is repeated with other controls. When I click this button, How do I access/reference the text value of a textbox control called TxtAnimalID on the same row? (This would be something like the current row I am on).
View 2 RepliesI have an ASP.NET Web Site I am creating in Visual Web Developer 2008 Express using Visual Basic as the language. It is actually a rewrite-with-mods of an existing ASP script and I'm trying to chew what I've bitten off. I created my page with a text box (txtOutput) on it and since the end product is very complex, and it's generally good practice to separate like functions, I have created 4 separate classes in the App_Code section. My main page is Sync.aspx and has a code file Sync.aspx.vb with it. One of my code files is SyncDatabases.vb and in it I have created
Public Class SyncDB
In that class I have created some routines such as
Public Function ReadMSDB(ByVal SQLString as string) as Boolean
In this routine I want to put information in my text box txtOutput on the main form (the default - Form1).
My problem is that if I try:
Form1.txtOutput.Text = "Hello world"
or just
txtOutput.Text = "Hello world"
it says Name 'Form1' (or 'txtOutput') is not declared. I am sure I am missing something simple but have no clue what it is. I assume it's the fact that the write command is in a file (class?) outside the file (class?) containing the page itself but I don't know how to address it properly.
I am trying to create an app that adds tabpages into a tabcontrol which has a several controls on each tabpages. However how do I access those controls?lets say the controls I add are named label1 and label2. the tabpage is named infoTab1.
If I do inftoTab.infoTab1.label1.Text = "some text" I get an error saying infoTab is not a member of 'system.windows.forms.tabcontrols' cause in design time it isn't added yet.So how is this actually done? am I on the right track?Any tutorials are more then welcome, tried google but only get basic concept stuff comes out it or trying the wrong keywords.
I want to be able to use a loop and reference controls using a string. The following code works for textboxes.
dim myControl as Control
dim ControlName as string
dim LoopCount as Integer
For LoopCount = 1 to 3
[code].....
I'm having trouble trying to access a list of comboboxes created dynamically in one procedure from another. I believe I have to add in an event handler but I not sure how this is going to work. Or should I change the array scope?
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'variables declared here.
[code].....
I have an application that has a grid of rich text boxes on a panel. I would like to access and modify the text in the various rich text boxes during run time. I know this has been brought up a bazillon times over the years, but I would have done this as a series of control arrays in VB 6. Below is a simplified representation of how the textboxes would appear in a panel if control arrays were availble:
rtbA(1) rtbB(1) rtbC(1)
rtbA(2) rtbB(2) rtbC(2)
rtbA(3) rtbB(3) rtbC(3)
I find that I can access the properties of the rich text boxes via panel1.controls.item(x).text, for example, where x is the control index assigned by the panel when I dropped the controls on it.
Since I created the rich text boxes at design time and dropped them on the panel, it has arbitrarily assigned the index values, and they are not in the index order that I would desire.
How does one re-assign a control's index at design time for a controls collection on a panel? And if one has 24 text boxes on one panel, is there a way to break them into subgroups, such as rtbA(), rtbB(), rtbC() with their own index values?
I'm trying to iterate through a group of ComboBoxes and set a property using a concatenated string & variable to represent the name of the control. However, I can't get the instance of the form to recognize the (String & Integer_Variable) as one of its controls -- and so it doesn't recognize any of the appropriate properties or subroutines as members of the System.Windows.Forms.Control.Is there a cleaner way to do this?
For myTempCount = 1 To 6
If tempValue < Me.("ComboBox" & myTempCount).Items.Count Then
ComboBox.SelectedIndex = tempValue 'appears to work -- how?[code].....
This code was originally VBA / VB6, which I put through ArtinSoft's Visual Basic Upgrade Companion (VBUC). FWIW, I'm using Microsoft Visual Basic 2010 Express.
how to access the main ui's labels from a delegate method?
View 7 RepliesI am trying to access controls that were added to the form and created code all before I added them to a panel. Upon form loading I create the form handle into a dictionary. then I call that dictionary ID and add data to the controls. I can't seem to add data to the controls inside the panel.. I think it is something simple. I may just be over looking the method I need to call.
View 11 RepliesWhen I try to access the controls of a form which is not yet created (i.e. to modify the contents of a text box , to press a button etc) , I fail , usually without even an error message . I found out that the only way to make my program go right is to take care that the form is first created before I try to access anything on that form . However this means I must use the Show method to create it and then to Hide it , which leads to an instant awful optical effect . I remember back in VB6 there wasn't such a problem ; it seems that in VB6 each time I accessed a control on a not-created form led to the form being created silently . Is there any way I could do that in .NET too in order to access my precious controls ?
View 15 RepliesI don't know the best way to use multiple forms in VB, but I have created a problem and I'm not sure where it came from or how to fix it.
Background: I start the program at Sub Main. This is the main function:
Code:
Module modFunctions
Dim frmD As frmDAQ
Dim frmT As frmTrendView
[Code].....
it works, but I don't want to have to change the entire project.
I have to make some automatization on a web server, I use Visual Studio 2005 Visual Basic Windows Console Application. I want to make a load/performance test of the web server, so I open several Internet Explorer instances, and I login the application, that is not a problem. But after that I have a mess on the page and I cannot make any more automatization...The composition of the page after the login is like this: I have the default form, another form and a multiple data window(mdw) controller, which dinamically can switches the forms on this part.
The problem is that I don't know how to access the controls of this mdw forms. I couldn't find much about this mdw controller and I am not an expert.
My code is here:
Imports System
Imports System.Diagnostics
Imports System.Web.Ui.Webcontrols
[Code].....
What i would like to do is change the color of a column in excel. I cannot seem to get the right command string to accomplish it.
View 2 RepliesI was thinking about writing some VB 2005 code that would be able to open an excel file and keep it open while I do things in separate functions/subs basically just check boxes, so each check box is its own sub but HOW do I do that with out opening and closing the excel file for every check box sub, since every time I make a check box the sub comes up as private?
View 9 RepliesI need to migrate from Excel 2003 VBA to Excel 2007 VBA. When Microsoft introduced Excel 2007 it removed many objects from the previous versions and added some new objects. Also it hid some properties of particular objects. These hidden properties can be viewed by going to the object browser, right clicking any object and selecting "Show Hidden Members". My problem is I need to access these hidden properties. Is there any way I can access these properties. I can successfully migrate from Excel 2003 VBa to Excel 2007 VBA with the same functionality?
View 5 RepliesHow do I access the new attributes of Excel 2007 chart objects from VBA code such as setting the line gradient on a data series?
View 1 RepliesOn my Staff Scheduling application I have everything working except for some conditional programming. What I was wondering was if it possible to export to a preformatted worksheet in excel. I found code on the web that allows me to export from the DGV, but it has no formatting.Examples:I set the DGV Column Headers to visible = false and use labels above the columns to show the weekday and date. So I need to use S,M,T,W,T,F,S as the column headers (4 sets) and the days date just below each week day. So I don't want the auto generated column headers names in the Excel fields.
View 23 RepliesI 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.
1- Read an Excel Worksheet into DataTable (dt);2- Check 'dt' to know if some columns titles exists;3- Query 'dt' and discard rows where some itens are null or empty;4- After query 'dt', fill some ComboBox.I wrote the code below. It works nice, but I don't know if I'm using best practices when I use Linq to query the data table like I did.
View 1 RepliesBasically in visual basic 6 I could access word tables in existing templates with the code owordactivedoc.tables(1).select() where owordactivedoc refers to the active word document and tables(1) refers to the first table in the template.Trying the same code in VB 2003 just leads to errors. Secondly how do I access bookmarks or alternatively word variables.Furthermore how do one deploy web.services. For example the current program I am building is for another computer. Simply copying the web service to Inetpubwwwroot dont work because it is not picked up by the Internet Information Services program. I have to create the web service in vb2003 on the other computer change msconfig manually. Copy and paste the existing service vb file in the created folder replacing the empty vb file.
View 3 RepliesI need to access the current instance of MS Excel. To do that, I wrote the following code:
Imports Excel = Microsoft.Office.Interop.Excel
Imports System.Diagnostics
Private _ExcelApp As Excel.Application
[Code].....
The code runs nice, but it has a problem: After the user close the Excel application (click button X - note: no other instance of Excel exists), if you open the Windows's task manager, its possible to see the process Excel.exe.
If I open and close the Excel application, there is no process Excel.exe, but if I run my code with the Excel application openned, after the user close the Excel application, the process Excel.exe isn't finished.
There is newer code in a follow up post. I suggest using the code in the later post rather than the code in this one. You can still read this post though. When designing a user interface, one should be conscious of how many individual controls are required to implement the functionality. In some cases an initial design may begin with many buttons or textboxes (for example) but then further review of
the actual required functionality allows for a reduction in the number of unique controls.
But other times, there isn't a better way (which will still make sense to the user of the application) then to have a series of many repeated controls. So in the cases where one can be certain that the best UI implementation for an application will require the use of multiple copies of a given control, then it often becomes necessary to maintain some method of managing all of those controls at various points
throughout the application. Doing so typically requires that one build up some collection of controls which can then be accessed by index in order to work with any given control; but this can lead to a lot of clutter in the code file which handles these control's events. For instance there will be some kind of collection declaration, some recursive routine to find all of the controls of interest, and then any number of event handler methods with long lists of Handles clauses, or additional code loops to wire up the event handling for each control.
Purpose Since most of this functionality could be considered a requirement regardless of the type of control being managed, or its required functionality, it may make sense to wrap all of the control management functionality into a single class. And since our first requirement is a collection of controls, then a base collection class could be the perfect starting point for our control manager. There are a number of existing thread around this topic, with some recent (at the time of this writing) ones being:[URL]..In this, and related, threads I have posted examples of a simple TextBoxManager and ButtonManager control. But again, with so much similar functionality required regardless of the control being managed, it would be technically possible to create a generic ControlManager(Of T As Control) class which can manage any type of control.
[Code]...
So in summary, one can facilitate managing a large number of user interface controls by building a "control manager" class which both encapsulates the list of control instances, and deals with adding and removing defined event handlers for every control it manages. The generic control manager class itself can be inherited and extended into a more specific class on a per-application basis in order to provide more application-specific functionality. Reed Kimble - "When you do things right, people won't be sure you've done anything at all"
I have a maximized form that has controls at the top of it and a large DataGridView that is docked below all the controls. Its kind of like the Ribbon in MS Office. The controls cover about 1/4 of the screen at the top. I would like a way for the user to click a button to hide all the controls then automatically expand into the place the controls were so the user can view more data in the DataGridView and visa versa. For example, in MS Office Excel you can hide the ribbon by clicking a tiny button that has "^" on it.
I'm not very familiar with all the controls in Visual Studio so I would like to hear some recommendations. Is this situation ideal for a SplitContainer or ToolStripContainer or am I way off base here?