Database - Reference A Control From A Module?
Jan 30, 2010
I have a MS Access database set up, with a Period field that has either values 1, 2, 3, 4 or 5. I retrieve these values using a database connection and I would like to reference a particular control based on what period was grabbed from the database.
Here's example code, pseudo of course.
TextBox(dr(3)).Text = dr(0)
dr(3) contains the period, and dr(0) contains the content I would like to put into the text box. I have these text boxes on my form: TextBox1, TextBox2, TextBox3, TextBox4 and TextBox5.So if dr(3) contained 2 then I would want to reference TextBox2.
View 2 Replies
ADVERTISEMENT
Aug 27, 2010
How can I reference the errorprovider on another form from a module.
Sample Code:
Sub
leaveOptionalTBTextValidation(ByRef TBControl
As custTextBoxControl,
ByRef intMaxChars
[Code].....
View 5 Replies
Jun 20, 2012
I recently have convert my project from VB6 to VB.NET2008,after the convert here is a sub that control form from a module that i create,the error was something like
"cmdAdd is not a member of System.Windows.Forms.Form"
Public Sub ButtonSet(ByRef frmObj As System.Windows.Forms.Form)
frmObj.cmdAdd.Visible = True
frmObj.cmdCopy.Visible = True
frmObj.cmdEdit.Visible = True
[Code]...
View 1 Replies
Mar 20, 2012
I'm trying to use it in writing VB.NET Windows Form code.So I'm thinking, instead of using a VB.NET module, or having code embedded in the forms, I should create my own "Control" Class, to handle all operations and "application" level variables.Is this the right approach?Ex:
Private Sub frmLogin_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
goControl = New MyControlClass()
goControl.sUserID = txtUser.text[code]....
View 1 Replies
Dec 1, 2009
i am currently building a MDI application. Both my Add and Edit screen use a form called frmStaffDetails.
On load, this form is redefined as 'AddStaffChild' and 'EditStaffChild' dependant on which menu item is selected. I've defined the CurrentForm as Form.ActiveForm.ActiveMdiChild.
Within a module I am checking the text within certain textboxes. So for example here I am checking a name has been inputted. If it has, then I will allow the record to be saved.
[Code]...
The problem I am having is that this code works perfectly if the textbox control is not within a Tab Control. As soon as I put it in a tab page I get the error.
"Referenced object item has a value of Nothing" Also if I reference it directly for example
If Not AddStaffChildForm.txtFirstName.Text this works fine too, but i want it to be more genric so I can use it for my edit screen as well. How can I define a control within a Tab Control from a module (or any other way to declare a public sub).
View 3 Replies
Apr 12, 2012
I'm building a apps that which allow to check the room availability for a hostel.I am looking some controls which is similiar to the following which allowed me to change the color of the box during runtime.
View 10 Replies
Mar 17, 2010
I have a dynamically created CheckBoxList in a DotNetNuke module I'm building. When DNN creates the page, it prepends the control name with the moduleID and moduleName.
So, when I have "AddLicenseCheckBoxList" on the page, it becomes:
"dnn_ctr949_addRateGroup_AddLicenseCheckBoxList" depending on what the ModuleID and page name is (in this instance it's 949 and addRateGroup respectively). Now, I don't know what the name of the page or moduleID will be when this module is finished, so I need to make sure I am accessing the control my whateer name DNN gives it, and getElementById or getElementByName do not work even when using '<%= %>'.
So what I need to do is use Javascript or some VB to retrieve the checked values of the dynamically created CheckBoxList so that I can run an update on the database with those selected values. [code]...
View 2 Replies
May 7, 2012
I simply cannot refer to a control on a form from module code as in all other versions of VB. Here is the code that I mean:[code]The fact that this cannot seemingly be done without getting into looping through an array of controls, assigning the control to a general control variable etc. and much more guff is puzzling and is in my opinion an added complexity to Visual Basic. There must be a simple way to do this - I just want to refer to the value in a control, on a form, from a module.
View 13 Replies
Oct 29, 2009
I can't find a media player control or module. I'm using the Express Edition does it even have one?
View 8 Replies
Jan 3, 2012
I am trying to access a browser control in one of my forms from a module but keep getting an error. I attached a screen capture showing the code and the error balloon. The subroutine is public, and I am addressing the browser correctly. If I copy that same code into the "Main" form, and it works perfectly.
View 3 Replies
Jul 2, 2011
My application has a total of 1 form. I have several modules, one of which is a module that handles a background worker dynamically. But what I need to be able to do is update a textbox from the background worker thread. Again, this code is contained within a module, not directly on the main form, so I am totally clueless as to how to make a reference to it. It's easy in WinForms, but I can't for the life of me figure out how to do it in WPF...
View 4 Replies
Mar 7, 2012
I have a single form application with two modules. The first module holds all the Sub procedures that provide the filtering functionality for 3 DataGridViews on the form. The second module holds the Predicate of T functions that actually filter the List(Of T) objects that are bound to the DataGridView controls.
I split them into modules since I was starting to have difficulty organising and finding the procedures and functions if I held them all in the form code.In some cases I can happily both Get and Set form control properties from within the modules. In one case I simply can't, I suspect I may yet find some more instances as I test further. The offending line is in one of the Predicate of T functions:
If tWord.Length <= Investigator.NumericUpDown.Value Then Investigator is the Class name of the form.
I suspect my problem might be that the Predicate of T functions (which are collated in a module) are called from the DoWork procedure of a BackgroundWorker that is a component of the form - hence the DoWork procedure is in the form code, but I'm not certain. The same code worked fine when everything was all in the form code. The error reported when adding a watch to the Value property in the module function is "
'Value' is not declared. It may be inaccessible due to its protection level ". I have tried the following to no avail:
1) Setting the NumerciUpDown modifier to Public
2) Adding a Public ReadOnly Property to the form class that simply returns the Value propety of the NumericUpDown
3) Adding Imports Root Namespace.Investigator to the module
I am considering adding a Public Shared variable to hold the curent value of the NumericUpDown and referencing that from the Predicate of T function.I realise, and have read many times, that accessing form control properties from module functions is generally not seen as a smart thing to be doing, but since I am not trying to chnage anything, I simply want to know what the current value is I decided that I wasn't too worried.
View 11 Replies
Apr 20, 2012
I have a UserControl named DataGridViewFilterAndSorter that I built using a SplitContainer. In each Panel of the SplitContainer contains a FlowLayoutPanel and in each FlowLayoutPanel contains a LinkLabel.
I have a procedure that accepts a reference to one of the FlowLayoutPanels in the UserControl. I want to get a reference to the UserControl (DataGridViewFilterAndSorter) using the FlowLayoutPanel reference. Currently, I have to use this[code]...
View 1 Replies
Nov 16, 2010
I have created a user control and am able to add it to a page with out any problems, but how to I reference a control that is inside of the user control For example if I have a text box inside the user control and want to set the text property through code or get the text property, How can I reference the control inside the user control. I have tried a few different things but nothing seems to work when I type the usercontrolname.control.property I just get an error.
View 3 Replies
Jun 6, 2011
What I am used to declaring database connection is that in every form I type the codes for it which is a tiring way. Now, I want to use module instead but I really don't know how. And also, how will I call the connection to every forms I created?
View 4 Replies
Feb 1, 2012
how to create modules and consequently how to use them.I need to do a database in mySql from vb.net. I have tried the usual way, that is my connecting to the database at the beginning of each of my class. I want to know if that can be done through modules, as far as i have read about that or some other way like procedures and functions. In that way, it could ease my coding in not having to write the db connection each time.
View 4 Replies
May 18, 2012
Do you know which module in VB.net will allow me to connect to a file (mdf/mdb) and SQL Server (not at the same time but to change in runtime).Or do you know of two modules which have the same API?
I'm building software which I will wont work both locally and on a server. But I don't want to have to go changing all of my code just because I'm using a different modules. I know VB.net, but I've never used databases.There's so many different database connectors its confusing!
View 1 Replies
May 1, 2009
I'm working with a form that has five combo boxs, when the form loads it goes to the modQuotations where there is a public sub that loads the comboboxs with data from a database but it after its done loading the form there is nothing in the combo boxs. [code]..
View 8 Replies
Jun 22, 2010
How to make module to vb.net 2008 and using mysql database
View 1 Replies
Jan 28, 2010
I have a form set up where I want to run the function PopulateGrid on it's Form_Load event. I have initialized the DB connection as follows:
Private Sub Main_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
LoadConfigFile()
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & config("DatabasePath") & ";")
cn.Open()
End Sub
Now, I want to run the PopulateGrid function directly after I connect to the database as shown above. I'm confused as to how I'd use a database query in a module when the database is initialized in my main form. Would simple setting the variable cn to public work?
View 1 Replies
Apr 19, 2011
I have finally got my code all working, but there is just a quick query really. At the moment I have all the database stuff in each form seperatly. When I place it in a global module, it looks like the dataset is being duplicated I was wondering why this happens when I place it in a global module?
This the code I use and the code I would put in a global module
Dim con As New OleDb.OleDbConnection
Dim dbProvider As String
Dim dbSource As String
[CODE]...
View 1 Replies
Aug 16, 2010
how we can declare a connectionstring in a module and call that module
View 1 Replies
Nov 19, 2009
Not sure why this is being so difficult..I want to reference a property of a control through code by its name. I should be able to use "Me.Controls("ControlName")", but this gives me an ArgumentNullReference exception, no matter how I try to do it.Here is what I'm doing:
I have several buttons on the form with standardized names (minExpandOSD, minExpandSettings, etc). All the buttons names start with "minExpand" and the last portion of the button name is always the same as its parent (a group box). Each of the group boxes also have a standard name (GroupOSD, GroupSettings, etc).Each groupbox has a minimize/maximize button. I have many group boxes. Rather than copy the same code block for each groupbox, I am trying to write a sub that can be called for each of the group boxes.
[Code]...
View 3 Replies
May 5, 2010
I wont to add swf file to my Vb.net project. I'm using Visual Studio 2010. How can i insert swf file to vb.net project ?
View 7 Replies
Sep 7, 2008
I'm new to VB (and .net), just started taking an introductory class. One of the things we've done is set up a little form that does basic math. It looks something like this:
Code:
[txt1] = [txt1mod1] + [txt1mod2] [btn1]
[txt2] = [txt2mod1] - [txt2mod2] [btn2]
[txt3] = [txt3mod1] * [txt3mod2] [btn3]
[txt4] = [txt4mod1] / [txt4mod2] [btn4]
When you click btn1, it adds the values txt1mod1 and txt1mod2 and displays the answer in txt1. The same happens for buttons 2, 3, 4 on their respective lines. So the way we handle this is to have four subprocedures that handle the button clicks, one for each button. I was thinking it would make more sense to have one function handle all of the button clicks, since it's basically the same thing. Through my own research I've learned you can have multiple events call one procedure like so:
Private Sub btn1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn1.Click, btn2.Click, btn3.Click, btn4.Click
'stuff
End Sub
But how do I determine which of the four buttons was clicked, and which text box values the user cares about? Then after doing so, how do I reference the relevant controls (txt[x]mod1, txt[x]mod2, txt[x])?
Code:
Dim b As Button = CType(sender, Button)
Dim t As String = b.Tag.ToString
But it gets a little fuzzy after that because I can't figure out how to reference the controls using the tags. I don't even know if I'm going down the right path. I can, for example, set some string to
Code:
strBox1 = String.Concat("txt",t,"mod1") 'string is "txt1mod1" for example
but trying to reference the control
Code:
...strBox1.Text...
gives me errors that, "Text is not a member of String."
Well, I don't know if this is correct or not, but it seems to work if I use "Controls()":
Code:
'if t = 1
Dim a As String = Controls(String.Concat("txt",t,"mod1")).Text 'value of txt1mod1
Dim b As String = Controls(String.Concat("txt",t,"mod1")).Text 'value of txt1mod2
Dim s As Integer = CInt(a) + CInt(b) 'im actually determing the operand elsewhere
Controls(String.Concat("txt",t)).Text = s.ToString
View 2 Replies
Jun 6, 2012
When I am working in a project I can reference the current form using "ME"...
Is there a way to reference the current control?
For example I am working in the button1_click subroutine. I can type button1.text but is there a MYCURRENTCONTROL.text that I can use?
View 1 Replies
Nov 21, 2009
Do i need to add a reference to a third party control(DLL) before i can use it.When i go to project->add refernece ,i select the control but it didn't becomeavailable in toolbox to use it.Do i need to install that control?I just placed it inwindows/system32 dir.
View 6 Replies
Jan 11, 2011
If i have a check box in a groupbox on my form, and i wanted to get the "control" using its name, how would i do that?
The function below returns the control, but only if the control is on the form directly. It doesn't function if the control (in my case, the checkbox) is in a groupbox, or on a tab control, or both!
Private Function getControlFromName(ByVal controlName As String) As System.Windows.Forms.Control
Return Me.Controls(controlName)
End Function
View 3 Replies
Feb 4, 2012
I have some different controls (PictureBox, Label,Button...) that are created by code. The set number of these controls isnot fixed. So let me set this number ton. And I have the following lines of code to create some of these controls.
For i5 As Integer = 0 To n
dBoxArray(i5) = New PictureBox 'PictureBox
Panel1.Controls.Add(dBoxArray(i5))
[code].....
View 7 Replies
May 7, 2012
I have many textboxes that I need to reference dymanically. The controls themselves aren't dynamic, just the way I need to reference them.I've got several text boxes say:
txtMe1
txtMe2
txtMe3
...
txtMe100
I will need to randomly change one of the properties of the edit boxes. So lets say it picks a random number between 1-100 which is 56. So, I would want to change the background of my 56th edit box to:
txtMe56.Backcolour = Color.Gray
The only way I could think of doing this would be to have one giant select case statement to evaluate the random number. But, that is really dirty and not the best peformance wise (this could potentially get called hundreds of times) so was wondering what my options are?I tried to concatenate the random number to my generic control name 'txtMe' but it throws a wobbler. I essentially would want the following to worK:
dim iNum as integer = 56
txtMe & iNum & .Backcolour = Color.Gray
View 2 Replies
