Upon entry into my database, frmLot opens. The form opens in datasheet view. It displays several fields to include one named WorkOrder. The user clicks in the cell named WorkOrder. In the On Click property, I store that variable and name it stWorkOrder. What I need to happen then is to pass this variable to the criteria field of a query named qryWorkOrder and have it run and display results.
View 1 RepliesI have 2 public variables that I declared in form1 of an application. I am trying to call that variable in form2 and then pass that variable in a sql query. [code]...
View 2 RepliesI have a public variable that I declared in form1 of an application. I am trying to call that variable in form2 and then pass that variable in a sql query.
If I declare
Public Class Form1
Public payPeriodStartDate, payPeriodEndDate As Date
How then to I declare that variable in form2 and how to I pass it to my sql query
SELECT [Exceptions].Employeenumber,[Exceptions].exceptiondate, [Exceptions].starttime, [exceptions].endtime, [Exceptions].code, datediff(minute, starttime, endtime) as duration INTO ScratchPad2[code].....
I need to pass a string variable into a wql query:
Dim booking As String = System.Configuration.ConfigurationManager.AppSettings("PlayersFile")
Dim query1 As New WqlEventQuery( _
[Code]......
However, I'm uncertain how to make the variable booking parsable by the query.
I have 2 public variables that I declared in form1 of an application. I am trying to call that variable in form2 and then pass that variable in a sql query. [code]...
View 14 RepliesMy goal is to make the content of TextBox1 to depend on the value chosen in ComboBox1. My code is as follows:
Imports System.Collections
Imports System.Data
Imports System.Data.OleDb
[Code].....
Right now I am using this code on client side.
[Code]...
The values for the hidden fields are already set. I want these value to open a window, in which the fields will be already filled using the values passed by this page. This code is working fine on Internet Explorer, but not on other browsers. Moreover, when I don't pass any value and just open the required window, it works on all browsers.
I've been trying to add a database to my interface, and i can't seem to filter the data, i want to search based on last name and only display people with the that last name (the last name will be entered in a search form).I've tried writing SQL Queries but I can't seem to pass the variable that that holds the last name into the SQL Query, to filter the data.
View 3 RepliesPrivate Sub cmdLogin_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles cmdLogin.Click
Dim conn As MySqlConnection
conn = New MySqlConnection()
[code]....
in this example i want to query "insert into .." to two variable for each field?
set the selection criteria using combobox, but there is a possibility to select "All Items" option. There are more than 2 combobox selection.
Code:
strSQL = "SELECT nama from GridView"
Dim da As New SqlDataAdapter(strSQL, oconnection)
Dim ds As New DataSet
[code].....
My project consists of a user interface designed in Visual Studio 2010 Express. I have it linked to an Access database. At this time, I have two text boxes that the user will enter a number. I want to be able to write a query that will take the first and second number and pull the information from the database that is equal to or greater than the user entered number
View 6 RepliesI have a problem with unicode character, as i create a database in SQL Server 2005. I want to query from a table that criteria fields are contain unicode character i.e NVARCHAR.
e.g: SELECT * FROM tblMyTable WHERE MyField='ភាសាខ្មែរ'. But when i did like this all rows that contain Unicode Character always display. it doesn't fit to my criteria
I have database with table called "Konzultacije" with field "Vrijeme" (Date/Time). I have datagridview (DGKonzultacije) with columns. Column (1) data format is set to date/time. I want to delete record from "Konzultacije" table depending on selected cell in datagridview but only I can get is error.
This is my code:
Dim iSql As String = "DELETE FROM Konzultacije WHERE Vrijeme = " & DGKonzultacije.CurrentRow.Cells(1).Value
conn.Open()
[CODE]...
If i add apostrophe like this:
Dim iSql As String = "DELETE FROM Konzultacije WHERE Vrijeme = '" & DGKonzultacije.CurrentRow.Cells(1).Value & "'"
error is raised: Data type mismatch in criteria expression.
I want to retrieve query from MS.Access database criteria is between some date range,but I get the following error when execute my reader:Syntax error in date in query expression 'D_ate BETWEEN # @DateFrom # AND # @DateTo #'.
Dim StrSQL As String
StrSQL = "Select * from Pla_Comp Where D_ate BETWEEN # @DateFrom # AND # @DateTo #"
myCommand = New OleDbCommand(strSQL, conn)
[code]....
Using Visual Basic 2008 Express. I need to pass a variable to another form. Or else make the variable visible to both forms.
View 4 RepliesI am trying to find a way to use a month calendar control as an object data source, such that when end user selects a given date, or a date range (1 week max), it will supply the date range criteria for an access query, and the results will wind up displaying in a data grid view below the month calendar. I am having a really hard time..
how to write the date criteria into the access query for something like this
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 am getting the error:"Range variable 'sender' hides a variable in an enclosing block or a range variable previously defined in the query expression."for this
Imports System.Data.SqlClient
Imports System.Linq
Public Class Form1
[code]....
I can select any other item from the table without the error. "sender" has the same properties as "receiver" in the SQL table.
I am trying to run a query an Access db from VB. The general query which I want to run is
SELECT * FROM Patient WHERE Patient.PatientID = ?
or SELECT * FROM Patient WHERE Patient.PatientLname = ?
I tried using an input box which captured the user input and pass that variable to the query, but that failed. Then I read about writing a function and using that, however, I keep getting an error which says Function not defined, but when stepping through the code, it seems to work. Here is my function: [Code]
I have the following function:[code]I need to know if it's possible for a function to take a parameter as a type of field?
View 3 RepliesI'm using VB2005 and I got a message error in a runtime: Abstract does not belong to table tblBooks. I don't think that the problem is its datatype. I'm currently using MEMO datatype because I need to load it more than the capacity of string. Is it possible to use this code in order to accomplish it? txtAbstractInfo.Text = MyTable.Tables(0).Rows(Counter)("Abstract").ToString
txtAbstractInfo is the name of my textbox and my field's name is Abstract.
I m trying to filter a sql db with many filter criteria which inert the user in textboxes .. i ve tryed this query
[Code]...
How to take a value from a combo box and have it update a field in sql table?
View 1 RepliesI want to passing field in database to list view with stored procedure.[code]...
View 3 RepliesI have a sales report (crystal reports), and it's launched from the APP, but I need to pass the value of 2 textbox and 2 labels to a sales report fields.
View 1 RepliesI am relatively new to VB but have written a few VBA applications.I want to write a context menu item for Firefox that allows the user to right mouse on a field that is being displayed and take some action.Is it possible to identify the field the cursor is on and pass the entire value to the vb program? If so which namespace should I be searching for methods? Can this be done without selecting the field's contents or does the user have to select the field?
View 3 RepliesI have the following Data Transfer Objects defined:
Public Class MemberWithAddressesDTO
Public Property Member_PK As Integer
Public Property Firstname As String
Public Property DefaultAddress As AddressDTO
Public Property Addresses As IQueryable(Of AddressDTO)
End Class
[Code]...
I have a stored procedure which updates a database using the parameters I supply but I'm having trouble passing a NULL to the stored procedure
The field I need to make NULL is a DateTime field
DB.Parameters.AddWithValue("@date", NULL)
This gives me the error 'NULL' is not declared. 'Null' constant is no longer supported; use 'System.DBNull' instead
[Code]...
i have stored the sort field parameter value in the variable szYes_No.I have to pass this value to crystal report, i used the code given below but not work--
Dim FieldDef As FieldDefinition
FieldDef = frmReportDisplay.cryRpt.Database.Tables.Item(0).Fields.Item(szYes_No & "{REP_i_fORMAT.Mem_Name}")
[Code]....
how can i pass sort field parametr to crystal report.
I'm trying to create a Pass-Through Query in an MS Access database using VB 2008.In VB the statement below creates an error that says the property is Ready Only.In MS Access the code works fine.(My complete MS Access VBA subroutine is below.)Is there any other way to create a Pass-Through Query in an MS Access database or am I just doing something wrong?[code]
View 5 Replies