How can i declare a simple variable in a form that is the count of the amount of times a field appears in a database.Basically i want to count the amount of times the word "Saloon" appears in a column in my database (access 2007) and then assign that value to a variable.
View 22 Repliesvb.net
Public Class UniQueGlobalConnector Public GlobalConnection As New OleDb.OleDbConnection Private Sub OpenConnection() Dim UniqueConnectionName As String = "GlobalConnection" & (Rnd(10)).ToString.Replace(".", "_") Dim InternalConnection As New OleDb.OleDbConnection GlobalConnection = InternalConnection
[Code]...
I have an issue with variables that are used to name For-Next loops. I have had this problem in a couple programs but not consistently, i.e. some variables work, some throw a warning (not an error).
The situation is this. I declare the variable along with all my declarations in a module-
Module MainModule
Public Counter1 As Integer
end Module 'MainModule
[Code]....
The type for variable 'Counter1' will not be inferred because it is bound to a field in an enclosing scope. Either change the name of 'Counter1', or use the fully qualified name (for example, 'Me.Counter1' or 'MyBase.Counter1'). In the past I've always broken down and changed the names to get rid of all those ugly warnings. Sometimes I have eliminated them from being declared in the module and declared them at call time. This is not how I program and I like to keep consistency throughout.
how I can get rid of this spotty, on-and-off nonsense? There is obviously a lot I don't understand about VS and I would have never taken it up but would have stopped 3 languages ago if I weren't forced into bulkier and bulkier languages (sorry about the rant. I feel OK now).
I simply wont to read one field in a databasetable into a variable.[code]....
View 6 RepliesIs it possible to declare a variable using the text of, lets say a string, as the name?If u dont get it im looking for something like;Dim Var + string1 As PictureBox..In the code "Var" is the start of the name and "string1" is the end of it so if string1 was "Hello", the picturebox would have been named VarHello.
View 2 RepliesI just started using VS2010. I am very familiar with Visual Basic 6 and was very comfortable with it.I was able to take a variable and assign a database field to iwithout using data binding. I can't seem to figure out how to do thatin VS2010 What I am trying to do is have the use enter a password to gain access to the program. The password is stored in a database so that the user/owner can change this password to suit their preference.
View 1 RepliesI created a local Database in VB2008 with 4 tables, the problem is that I have a textbox in one table and a combobox in other table and I want that the information that I put in textbox appear after in combobox from the other table... that's possible?
Table: Filmes ... Field: NomeTextBox
Table: Tempo de Aluguer ... Field: Nome_FilmeComboBox
I am looking for a way to count words in VB My full code is as follows Public Class lblTranslator
[Code]...
What's the C# equivalent of
<% dim name %>
so you can use it for web forms in PayPal API integration?
why don't we declare a variable for instance variable with dim not private?
View 3 RepliesHow can I declare a blob field in an access database with SQL?
View 1 RepliesI tried using the parameter you sugessted in inserting records. Am getting this error must declare the scalar variable "@Account_no", below is my code
View 9 RepliesAs 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]....
Public Class Form1
Dim x, c, number(0 To 19) As Integer
Dim s As Integer
[CODE]...
The variables in the brackets [example] do not actually have brackets in them in the original code. These are where the issues are. For both variables, it says, "The type for variable [variable] will not be inferred because it is bound to a field in an enclosing scope. Either change the name of [variable], or use the fully qualified name (for example, 'Me.[variable]' or 'MyBase.[variable]')." Now, I'm not entirely sure if this is a stupid question or not, as I'm used to VB '98 because that's what we use in my programming class at High School. let me know why this won't work.
-Note: The intention of this program is to continually loop the generation of numbers for this list until I tell it to stop. Button1 ends the program, Button2 generates the list one time only, Button3 is supposed to loop the generation of the list, and Button4 is supposed to end the loop, but not the program.
I want to know if it is possible to declare a variable thrice.
[code]...
I have a form with 2 controls, a textbox and a button. The user will type text into the textbox and then when they click the button the text that they entered will be added to a List Collection. You can see the code below. There is just 1 problem. Where would I put my declaration of my List Collection so that it holds the values and does not start at the first element everytime the button is clicked?[code]
View 5 RepliesI want to count the amount of records in my table where the distance column is greater or equal to the passed integer.I have:
Dim TenMilesCount = GetDistanceCount("10")
Public Function GetDistanceCount(ByVal Miles As Integer) As Integer
statcon = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:My
[code]....
Yet running the code gives me "An error occurred creating the form. See Exception.InnerException for details. The error is: No value given for one or more required parameters."
I am using a mysql database and I am trying to get the number of results. I should only have 1 result because this is for a username/password login. I tried this
If loginReader.HasRows Then
'do whatever here
Else
'do something else here
End If
The loginReader gets the results and does the ExecuteReader. The problem with this is that if I use a good username and password it works but if I put in a bad username and password it doesnt do either one of them. Any ideas on how to just count the number of results?
I have been debugging my code for a while and looking at posts in other forums, but it seems to be that everyone has a different problem than mine and what works for them will not work for me.My dropdown list is supposed to filter a gridview by choosing all the Companies that are associated to a certain product. The solution I have found online is that most people did not have DataKeyNames set in their gridview. I do have this set, but not to CompanyID. It wouldn't make any sense. So I have no idea what I am supposed to do since this is the only answer I have found.
<asp:DropDownList ID="ddlCompany" runat="server" DataSourceID="dsCompanyFilter"
DataTextField="CompanyName" DataValueField="CompanyID" AppendDataBoundItems="true"
AutoPostBack="true">
[code]....
How do you declare a variable as a Date and initialize it with a date before year 1. I would like to caluate historical BC dates using a fuction that returns the ellaspt time.
I've used this line of code however I can't to work setting the date value to a negative.
Dim
myDate As Date = CDate("2/6/1400")
why we can't declare a variable on some class such as math
for example?
dim s as new math
?
but we should imports them..
I have searched online for a few hours to try to figure out how to do this, but nothing I found really makes sense, so could someone please tell me, in a simple way, how to do this?
Let's say I have a text box that the user fills out, named textbox1. And I have a combo box, named combobox1, which contains the choices A, B, C. And then I have a button named submit_button.
Each time that the user clicks submit_button, I would like to dynamically create a new variable. This variable should be named the same as textbox1.text, and should contain the value of combobox1.
For example, if the user types "blue" into textbox1, and chooses value "C" from combobox1, and then clicks submit_button... then the following variable should be dynamically created, like..Dim blue as String = "C"
And then, after that, if the user types "red" into textbox1, and chooses value "B" from combobox1, and then clicks submit_button... then another variable should be dynamically created, like...
Dim red as String = "B"
And each time the user submits new information into the textbox and combobox, a new variable should be created.Is it possible to have the program automatically create variables like this? If so, how?
My actual project is much more complicated than this, of course, so the above is just an example. But if I could figure out how to solve the problem in this example, I could figure out how to solve the entire project.
I can declare a variable in VB.NET that stays even after closing and re-opening the program?
View 2 RepliesWhat i am trying to do is this:
Dim Name as string
Name = "Bob"
Dim Name.tostring as Integer
Which will create as variable called Bob of type integer.
But obviously this code doesn't work. So what is the real way to do this if it can be done?
how to declare out global variable? i tried out but get error.. below is my orginal code
[Code]....
I'm trying to make a message box appear, I don't want to have to declare the message box as a variable, And I don't want it to be in it's own Sub!I just want it to print (variable) S, It's in a sub. Just not sure of the structure of that code. Just a really quick example
View 1 RepliesWhat's the main problem if I don't declare the type of a variable? Like, Dim var1 versus Dim var1 as Integer.
View 6 Replies I am working on an alarm system software, which is SMS-based. I am using a GSM modem to receive the SMS when a client's premise security devices are triggered. The types of SMS text received will be like for e.g. "fire alert"(when devices triggers), "fire clear"(when devices are 'reset').
My program can detect real and false alarm, it works this way, i will input a premise site-map on a picture box at the main GUI, i can then create buttons at run-time and drag them to the respective position on the map. The buttons created have their text set as the client's block number referred to the database. So basically, a button represent a client. When a device in the client's premise is triggered, a SMS will be sent and my GSM modem will receive it, process the SMS and the button representing the client will start 'flashing' showing that the client's premise is under danger. Then when the button is clicked, which acts as an acknowledgement, will display the client's information on labels and turning that specific button to red color. Finally, when the device is 'resetted' in the client's premise, it will send another SMS to my GSM modem, after processing, the button will be back to normal.
But my program has detect false alarms also, the first part is similar to mentioned above, client's premise security device triggers, SMS sent, SMS received by GSM modem, process SMS, button 'flashing'. Secondly, if the alarm is false, it will be automatically 'resetted' or the client may 'reset' it, then a SMS will be sent to my modem, turning the button to 'flashing' green in color. when 'acknowledged' will display the client's info and the button will become normal.
The problem here i am facing is during the processing of the SMS, because the real and false alarms both will receive the 'clear' SMS when during some stages, but the functions are different and of course the 'checking' for both functions will be different too. The problem occurs at the checking process whereby the 'btn' variable is not detected.
'Try
'AT commands to receive SMS
serialPort.Write("AT+CMGL=""REC UNREAD""" & vbCrLf) 'set command message format to text mode(1)
[Code]....
Later on i have a form where a cost for a class is calculated by timing the duration of a class by the costperhour textbox which is in a different form.
View 3 Repliesthe error is pointing at : objAdapter.Fill(objDataSet, "placename")
the following is the code that is throwing an error.
Dim selectedname
As
String = "boston"
[Code]...