I created a module procedure in a access database, but I am having trouble trying to execute it in VB. I thought perhaps I should create a similar module in VB, but that didn't workThen I tried a few obj codes, but hitting a brick wall left and right. Should I create a new class? or is there some other way?
View 1 RepliesI can usually find the answers to most of my questions via the Google Gods, but not this time.I have a form that has a TabPageControl and on that page a collection of labels and text boxes via a usercontrol.
On the form I have a button that allows the user to create a new tabpage, when the code adds a new page, it automatically adds the UserControl collection. I can't get my head around how to access the objects on the newly created tabpage.
What I need to be able todo is take the index of the tabpage that has focus and translate that against the UerContol name, but I havn't a clue how to do it!
[Code]...
I have an application that dynamically creates winforms.
Dim NewS As New Form
Dim NewT as new Timer
NewT.Interval = 5000
[Code].....
I've inherited some code that has a Public Module for data access:
[Code]...
And all the pages call GetDataSet(sql). Am I correct is assuming that this is a bad idea? Worst case is that concurrent callers could get each others data?
How do I do something like this.[code]...
This is inside the Module separate from Form1 class as you can see right off the bat it's not a class and there is no reference to Form1.. how do I access Form1 without passing reference to make factory modules work like this.
I tried to access a variable using a module with this code:
Module DataModule
Public x As Integer = form1.trackbar.value
nd Module
I have a form called form1 which has a thread that runs a sub from a module.[code]...
Well from the module, there's a part where I have to update controls on the form1. Whenever I try doing it, it updates the value, but not the design. For example I write a delegate which makes label1.text = "111", while debugging, label1.text becomes 111, but it does not show it updated on the form design, it just stays at its default value.
with vb.net05 + access03 .mde file is it possible to create a module ( function ) in side a password protected access .mde file from ado.net?
View 2 RepliesI 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]...
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 RepliesI have an application that dynamically creates winforms.
Dim NewS As New Form
Dim NewT as new Timer
NewT.Interval = 5000
[code]......
I failed at the title: it should be "access a function of a class from a module"Edit by Moderator: I've amended the title for you.I got a huge VBA program which opns an excel workbook.I want that if i press crtl + s excel dont calls his save function but my own written save-function.
The code looks like this:
Code:
Namespace Test
[code]......
I've got a console app with a sub main then i have a seperate class inside the module..i can't seem to update the public global variable from inside the class as i can't declare the variable as shared...
View 6 RepliesI was a vb6 user, done a few projects only with forums Now i am moving to vb.net(vb2010) and i have some trouble.Lets say we have a form(form1), a module(mod1) and a textbox on the form1.
i want to start a Sub (DoWork) in the module but in a new thread.
Dim Thread1 As System.Threading.Thread
Thread1 = New Threading.Thread(AddressOf mod1.DoWork)
Thread1.Start()
The DoWork sub does some stuff and when it's finished i want to change the text of a textbox1 in the main form and start another sub (DoWork2) on the main form under the main thread not the one DoWork is running under.
Plese do not refer me to another post that mighe give me a part answer, try to explain to me what i have to do and why.
I've got this code
Public Class Form1
Dim m_listener As HttpListener = Nothing
Dim m_asyncCount As Integer = 0
[code].....
I receive the error "Too Few Arguments 1" when I excute the following code in Access 2010 on only one pc running VISTA 32 bit. The code works fine on 3 other machines running Access 2010 on XP 32 bit, Vista 64 bit and Windows 7 64 bit.
Dim UpdateCommand
UpdateCommand = "UPDATE Campaign SET DonationsReceived = " & _
SumDonations & " WHERE ID = " & SaveCampaign
CurrentDB.Execute UpdateCommand
I created an Access Object in vb.net:Dim acApp As Object = CreateObject("Access.Application.11")en I open Access I need to pass a parameter to it though "/cmd".I read that the only way to accomplish this is through a shell - that it is not possible directly using an Access object.
View 5 RepliesI'm trying to develop a program that turns matrices into their reduced Echlon forms. The user specifies the number of Columns & Rows for the matrix, which is generated by the following Sub Routine
Private Sub ButCreate_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles ButCreate.Click
'Columns and Rows are specified by the user
rows = TxtRows.Text
columns = TxtColumns.Text
'clears all of the controls(text boxes) from the TableLayoutContainer
[Code] .....
How to do is access/manipulate those newly created textBoxes. After the user enters values to those boxes, I want to assign each of their columns to an array.
I have created two dynamic objects in my project; one being a button and the other a listview. I have added addHandlers to the button so that I can print out information from the listview. The problem is I don't know how to access the listview through the button_click Sub.[code]...
View 3 RepliesI created a Query in a database in Access. I want to attach it to a DataGridView in VB2010. I then went to VB and connected to a Database. Then I dragged a DataGridView onto the form. Up came a pop-up menu. I Clicked on Choose Datasource, Add a DataSource,clicked on all the next buttons, selected Tables and Views checkboxes and clicked finish.In the next view up pops a menu that lists my Database and it's tables, but not the created Query. The Query does exist in the Database and I am accessing the correct version.
View 3 RepliesMy program creates columns at runtime with the following code:
Cmd = New OleDb.OleDbCommand("ALTER TABLE [Parent] ADD [" & ColumnDate & "] int", con)
objCmd = New OleDb.OleDbCommand("ALTER TABLE [Parent] ADD [" & ColumnDate & "] int", con)
objCmd.ExecuteNonQuery()
I add data into the newly inserted column with the following code:
da.SelectCommand = New OleDb.OleDbCommand(sql, con)
Dim cb As New OleDb.OleDbCommandBuilder(da)
cb.QuotePrefix = "["
cb.QuoteSuffix = "]"
ds.Tables("SchoolMaticsDatabase").Rows(inc).Item(ColumnDate) = Hours * Num
da.Update(ds, "SchoolMaticsDatabase")
All of the above works fine; the issue arises when I try to edit the information originally placed in the newly added column. These are the approaches that I have taken. (None of them give an error message; it simply won't update within the database.)
da.SelectCommand = New OleDb.OleDbCommand(sql, con)
Dim cb As New OleDb.OleDbCommandBuilder(da)
cb.QuotePrefix = "["
[code]....
I added a column to the table manually via opening the access database and all the above approaches work for editing data stored in that column. So I believe it is something to do with the fact that the columns are created at run time.
I add textboxes dynamically at runtime. How do I access them later in the program?
View 1 RepliesI am in the middle of the creation of an application using vb.net. I have a database created in MS.Access which includes 7 tables. I connected this one with my parent program code. Now the problem is that I want to display the data from each column. I have 12 columns and 14 rows in my first table. How can I display data from one column in a Combo box?
View 1 RepliesI have difficulty in removing the LDB generated by the "CREATE" method of ADOX in the following code segment.Aims: Create (on the fly) a new access database and then export data (says Arena modules) to that newly created database.
Expected: The newly created access database should be able to be used by some external operations, say Access.exe, after the end of the subroutine and without exiting the current VB program.
1) I tested that the "Arena code" do nothing about the create/release of the ldb file.
2) I tested the "Exclusive Mode" in connection string, but the access file is still locked by the vb program.
3) I tested under both inside the VB environment, and directly invoke the generated from Explorer, and same results.
4) Other database formats is not the options to me. (due to Arena export limit)
5) It is not a web app.
Code:
Sub Method1()
Dim logs As New System.Collections.Generic.List(Of String)
Dim arenaApp As Arena.Application = Nothing
Try
[code]....
Platform:
Windows 7 64bit, Office 2010 (32)
VB 2010 express
Lib: MS ADO Ext. 2.8 for DDL and Security
Access objects on a dynamically created UserControl an a dynamically created tab page. I can usually find the answers to most of my questions via the Google Gods, but not this time. I hope the collective that is StackOverFlow can help! I have a form that has a TabPageControl and on that page a collection of labels and text boxes via a usercontrol.
On the form I have a button that allows the user to create a new tabpage, when the code adds a new page, it automatically adds the UserControl collection, all good so far. I can't get my head around how to access the objects on the newly created tabpage. What I need to be able todo is take the index of the tabpage that has focus and translate that against the UerContol name, but I havn't a clue how to do it! [Code]
Why am I denied access to a folder which earlier code created? When I run this code an error is issues stating I am denied access to infopath is generated.
[Code]...
how to access to a folder created inside the project from the code
View 1 RepliesI have created an application in which I have to make a report with ReportViewver from Microsoft.Everything ok until now. I have created the report and for this report I have created a dataset. This dataset contains data for every month in every year from 2010 to 2015. With this dataset I am populating a graphic but my problem is that I want to select the year and create graphic for one year.I do not know how to insert a parameter in the dataset. In sql is very easy by in Access is different and if I try to put something like ...' where year_column=@year_parameter' I receive an error.
View 3 RepliesI'm developing a chat system. In this I'm creating dynamic tab panels in a tab container when I change the selected index of the list box of users. In these tab panels I'm creating 2 text boxes and 1 button dynamically and adding a handler for the button click event. I'm storing the tabid's in the session state and recreating all the tabs in the page_init event. I can fire the button click event in the tab panel, in which I'm unable to access these dynamically created text boxes but I can access a label which I created statically. I used the findcontrol() method but it is showing an error message: "Use new command to create the textbox instances". It is showing something like I haven't created the instances of textbox.
View 1 RepliesMy program creates columns at runtime with the following
Cmd = New OleDb.OleDbCommand("ALTER TABLE [Parent] ADD [" & ColumnDate & "] int", con)
objCmd = New OleDb.OleDbCommand("ALTER TABLE [Parent] ADD [" & ColumnDate & "] int", con)
objCmd.ExecuteNonQuery()
I add data into the newly inserted column with the following
da.SelectCommand = New OleDb.OleDbCommand(sql, con)
Dim cb As New OleDb.OleDbCommandBuilder(da)
cb.QuotePrefix = "["
[code]....
I added a column to the table manually via opening the access database and all the above approaches work for editing data stored in that column. So I believe it is something to do with the fact that the columns are created at run time.