i just got 1 question how do u create a (in excel ) variable table (database) inside a function which could be called for filling and reading through "for to next" loop module
View 2 RepliesI have the following statement and the function 'InitialiseOsTransform' is in a Module which is in the project.
If InitialiseOsTransform() = False Then But instead of the code going into this function it goes into the Paint function.
I have used the similar code in another project and it works correctly.
Im having a problem with a loop inside a C++ dll being called from VB. I want this loop to update a global variable, but when I call the function the variable does not update the first time round, but does so every subsequent time.
This is how I am trying to update the variable.
else
{
::nScore = nHighest;
[Code].....
As a workaroud I am forcing the variable to be what I want in the VB code
How can I call a function from inside another function and suspend the calling function until the called function is finished? I hope I can get some replies because I don't know how to ask the question and make sense:).
Anyway what I am trying to do in steps:
1. The user clicks button1 which triggers the click event.
2. From the click event I call a function
3. I then pop-up a form, that has instructions for the user to read.
4. After the user has read the form he will click the "Done" button and return to the calling function.
The problem is the the calling function continues to execute. I want to stop execution of the calling function until the users clicks the "Done" button on the instruction pop=up. I know I can use a msgbox but the instructions can be lengthly and does not look good in a msgbox.
I have tried the Call method with return in the "Done" button click but I can make that work. I also tried a goto statement but I can get that to work either. In the call statement I said call frmInstruction.show() and it got there but as I said the calling function continued to execute.
I have three table and I want to put the three table's data in one variable and from that variable i will produce the datatable and then want to write the data in CSV file.I am Following this step..
Void
GetDetails()
DataClasses1DataContext
[code].....
i am trying to create a table in a access 2007 database with the name stored in a variable wich the user inputs. For example, if the username entered by someone is "John", i want to create a table in the database also named "John". I have tryed this:
Dim mypath = Application.StartupPath & "\mydb.mdb"
Dim mypassword = ""
Di Cmd As OleDbCommand
[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 wand to Expose a function inside a module in my Class Liberary( DLL)
module Module1
Public Function Add(val1 , val2) as double
return val1 + val2
End Function
End Module
I have a module1.vb that contains a public sub, for example
Public Sub LogEvent(ByVal strIn As String)
Dim objLogFile As Object
objLogFile = frmEventLog.txtLog
[code].....
I've got a basic logon form where if you enter the right password/username, it redirects you to the "MainMenu" Form How can I make a function called "checkLogon" that checks the username/password text to a variable in that function?
View 3 RepliesUsing VB.NET .NetFramwork 3.5. This fails and strikes me as odd. Is this correct behavior:
Public Sub TestForEach()
For index As Integer = 1 To 10
Dim z As Integer
Assert.AreEqual(0, z)
z = index
Next
End Sub
I would expect z to always equal 0 as I thought the dim-ing of an integer would set the value to 0. If you run this. It fails at the second loop. For some reason z retains it's value of 1. I know I can manually initialize z to = 0, but I wanted to know if this is a bug or expected behavior.
For i As Integer = 1 To 10
Dim j As Integer = 10
Next
now my question is, Is memory allocated to j every time its executed inside for loop? or only value of 10 is assigned on subsequent iterations?
As you can see below in the code the " & tblName & " will work fine but instead of using the BankName (which the user cannot change because it is in the code) I would like to do the same as I did with the Table name and use a variable that gets its name from an excel spreadsheet rather that an actual name hard coded in a VBA module. I would like the variable field name entered in the Excel Spreadsheet by the user just like the table name is filled in by the user. The problem is getting the ADO SQL string ( cmd.CommandText = "ALTER TABLE " & tblName & " Add Column BankName Char(25)" ) to recognize that the value in the Variable " & fldName & " is the field name to be used.
Sub AddFieldToAccess()
Dim cnn As ADODB.Connection
Dim cmd As ADODB.Command
[code]....
'If I do this I end up with a field named BankName what I need is the name in the variable " & fldName & "
cmd.CommandText = "ALTER TABLE " & tblName & " Add Column BankName Char(25)"
cmd.Execute , , adCmdText
Set cmd = Nothing
[code]....
For a class, I have to create a delegate and use the function in my program called DoStuff(). There is an error tht says "Method 'Public Sub DoStuff(stringVal As String)' does not have a signature compatible with delegate 'Delegate Sub MyDel()'.
[Code]...
Today I investigated a logical bug in our software and figured out that this is related to the way VB.NET thread variables inside a loop.Let's say I have the following code:
Dim numbers As New List(Of Integer) From {1, 2, 3, 4, 5}
For Each number As Integer In numbers
Dim isEven As Boolean
[code]....
The problem is that isEven is declared but not assigned.In this specific case, it would be correct to write dim isEven as Boolean = false but I haven't done this.In VB.NET, a variable that is declared inside a for loop keeps its value for the next itaration. This is by design: [URL]but this is also dangerous pitfall for programmers.
However, until now, I haven't been aware of this problem/behaviour. Until now.Most of our code base is C# anyway, which doesn't allow the use of an uninitialized variable, so there is no problem. But we have some legacy code that is written in VB.NET that we have to support. So the best thing would be to generate a warning or even an error in this specific case.But even with Option Explicit / Option Strict this does not generate a warning / an error.Is there a way make this a compile time error or maybe a way to check this with FxCop?
I got a problem I need to search by First Name OR Surname. So the user can enter one or the other or BOTH.
So here's what I got I set two primary keys to try and find the row but I'm gettin all sorts of problems, for example when I set FirstName & Surname as primary key which you need to do to use the find method i get an error as it expects two values..
Dim da As New SqlDataAdapter
Dim con As New SqlConnection("Data Source=UserSQLEXPRESS;Initial Catalog=StudentTeacherDB;Integrated Security=True")
[Code]....
I have this code the exports datagridview from vb.net to ms excel, There should be a total at the end of the table in the ms excel after exporting it but my problem is I can't merge the cells for "Total".
View 2 RepliesI have a button inside a one of my forms which contain a lot of coding and normally a lot of variables declaration.
Is there is a option/add-on that I can use/set that enable me to display all the variable used inside the sub or function I am currently working in?
All I can find is add-on to display the Properties/Methods and only Public variables inside the form or inside the class. but I need to list the local variables also.
This is code I use to display Date from Access Database Table called RecordList
Sub RC1Fill()
ADBConnString2()
conn = New OleDbConnection(NewAdbconnstr)
cmd = New OleDbCommand()
daRC1 = New OleDbDataAdapter
[Code]...
I have an sql table called Stock with two fields called StockID and StockCode. I want the user to select the stockcode from a combo which in turn populates the stockid for that item into a lable on my form. I have already populated the stockcode into the combo but dont know how to compelte the rest.
Imports System.Data.SqlClient
Public Class cbo2
Private Sub cbo2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[CODE]...
Like in topic.I want adddashes to variable.So textbox1.text = "Nice "weather" is..."BUT it's not working :/ when I'm using dashes VB 2010 thinks that I want close
View 6 RepliesI 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?
I would like to create a MDI form, then open and place an Excel 2003 workbook (a full version, not an OWC11) inside the form. I am using VB2008?
View 3 RepliesI have a class that add extra information about a column for linq2sql (see code below) right now, I have to explicitly tell what column I want that info on, how would you put that code with a loop on every column in every table from a dbml file? I was doing my test on a very very small DB, now I have to implement it on a much more bigger database and I really don't want to do it manually for every tables/columns it will take hours.
how it's being used:
Partial Class Contact ''contact is a table inside a dbml file.
Private _ContactIDColumn As ExtraColumnInfo
Private _ContactNameColumn As ExtraColumnInfo
Private _ContactEmailColumn As ExtraColumnInfo
[Code]....
I am having a bit of a problem working with textboxes, subroutines, and modules.I have a form (frmMain) with 30+ textboxes. These textboxes collect data input by the user either manually or the user can choose to have the program randomize all the numbers in the textboxes by clicking a button. To randomize these numbers, I have a subroutine in the module called randomizeData(). The problem I am having is that the textboxes on frmMain are never actually updating themselves with the random numbers generated in the module. No errors or anything, but no results either. Here is a simple summary of what I have going on.
Public Class frmMain
Private Sub cbRandom_click()
randomizeData()
End Sub
[code]....
My code Adds a New Row from a Source Table called "objTablaOrigen" To a final table called "objTablaDestino". This tables are passed ByRef because they come from a DataSet respectively. objRowNuevo is The Row that will be added to "objTablaDestino" The data from "objRow" is well copied to the "objRowNuevo" (that is the new Row with type of objTablaDestino).
'The problem occurs when the instruction Add is executed. ¿What happens? The new row is added as well, but this generates an Exception with the next message:
[Code]...
How do I create a function to copy and image from a picturebox to another inside the form. Or from a picturebox to a coordinate place inside the form.
View 12 RepliesOK, after trying to get this working for a couple of days now I decided that I would turn to the experts here. I am trying to create a nested loop with a variable amount of nests. Let me elaborate. I have a program that first asks for the minimum and maximum amount of loops, I currently have a SELECT CASE statement that addresses each level of nesting individually.
Dim cMin As Integer = InputBox("Min")
Dim cMax As Integer = InputBox("Max")
Dim c1, c2, c3 As Integer
[Code].....
I want to create thread for reading data from Excel. I found this link.url...I download the sample project and tried to run the project.First I build the project using visual studio 2005 and add reference the NetFX20Wrapper.dll..When I run the project, I got error "ActiveX Component cannot create obect" in the Line "Set background = New NetFX20Wrapper.BackgroundWorkerWrapper"
View 2 RepliesI have to create a multiplication table and it has to contain a postest loop. For example:
[Code]...