I have this frm_customers and this button called View/Edit.
What I want is that when i click this button it should ask me a customer Id and then go to that customer id in frm_customer
i'm not expert in writting vb codes. but there's this IT project im doing in access
View 3 RepliesI have form A that has a datagrid on it, I want to be able to double click a row in form A and open form B to that record.
I know how to do that in VBA in Access 2007, but I am having trouble comprehending the procedure for VB 2010.
I have a Query to Display values in grid view, now i wanted impose certain condition in query to filter the values.I have FABDue(date column) and FABComp(date column)columns in a table.I need to check following two conditions in query
1.Records which does not contain FABdue date in FABDue column, then those records should not be listed in Grid view.
2.Rcords which are having FabComp(column) date then those records should not be listed in grid view
[Code]...
I have a gridview displaying all employees. Upon selecting an employee, I'd like to open a new page or window that would display all of the information for that employee with the option to edit/delete/update. Once this transaction is complete, return to previous page with gridview of all employees. ((language I'm usings is VB))
[code]...
I am facing a problem displaying the result of my "select *" query on the form . Here is my code:
[code]...
But when I write this code and run my form I am not able to see any records present in my database tables being displayed on my form. I have inserted a DataGridView on my form . What changes should I do to my code ?
I Have A form With With Data source DS1 Is There A Way To Filter The DS1 To Show A Specific Record Parameter Input Textbox
View 2 RepliesI am working on a project using Visual Studio .NET 2003.I am trying to open a second form based on user response to Yes/No Message Box. I have tried two different code variations. The first variation is:
Dim MsgAnswer As Boolean
MsgAnswer = True
Dim MsgRes As DialogResult
Dim CustomerInfo1 As New Form
[code]....
With this code I get an exception error: An unhandled exception of type 'System.NullReferenceException' occurred in OrpheyOnOpen.exe Additional information: Object reference not set to an instance of an object.
I have a form which has has a bound data source (generated automatically by VB - table adapter, binding source etc).How do I use the Form.Show method to open the form ready to enter a new record. Is there a simple way of doing this?
View 4 RepliesI just want to open a form based on a users input into the textbox
Public Class MainForm
Private Sub PictureBox1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TagBox1.Click
Form2.Show()
[CODE]....
I already have it opening the form2 based on a click from the picture, but decided aginst that design. Also any design on form2? (below) I am storing values for tags inside the forms....
Public Class Form2
Private Sub saveButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles saveButton.Click
My.Settings.SaveTitle = TextBox1.Text
[CODE]...
i m using vb. net when i run my form
View 1 RepliesI am developing an application with a number of windows forms. The first form I designed is the one that opens when I run the program. This was fine all during the development and testing.
Now I want to add a Login form but can't figure out how to get it to be the opening form when a user starts the program.
Is there a way that I can use like F1, F2, F3, etc to open a specific form? I would like to have an options form but not have it to where anyone can access it unless they know the Function key to use.
View 1 Replieshow to take a query that returns a single row of data and load that data into textbox controls.I know about ExecuteScalar but it is only good for a single column of data from the query.
View 2 RepliesI am developing a software using microsoft visual studio basic 2010. I used a datagridview control to display a list of data from product table. What I want to do (actually I am not sure how to do it, or is there a way to do it), when I choose one of the value in one of the column inside the table, I want it to open a form that contain data(details) based on that value.
How to do it? How to call the value that I pressed, so it can be used to open a new form containing the details of that value
Example of the data: (the "system" column) SYSTEM
topaz
nex1300
Nec
If I pressed "topaz" system, it will prompt me to a new form containing the details of that "topaz" system.
work using Access 2010, however am having to use VBA as the Macros are not compatible.I have a form which for this I will call Form1, on this form I have a Combo Box called Combo202, this combo box lists a selection of Building Names, and a button called Command201.The process goes;User selects a Building Name from the drop down list in Combo202, and then clicks Command201. This then opens a form, Form2, which displays a record based on the field [Building Name] in Form2 matching that value in Combo202. I have been using this code;
View 1 RepliesI have a small "options" form that when shown, the user submits some changes, clicks a button, and then it fades out. I want the form to open at the mouse location. How would I do that?
View 1 RepliesI have a dataset called KeyData made up of two tables Customers and Orders.
I have two forms, one named MainForm that shows records from Customers in details view and the related Orders shown in GridView called OrdersDataGridView. The other form is called OrdersForm and is populated with the Orders table from the keydata dataset and shows records in details view.
When I navigate the MainForm customer records the correct orders are shown in the OrdersDataGridView. So far so good.
Here's the code that was generated when I dropped the tables within KeyData dataset onto the MainForm:
Private Sub MainForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'KeyData.Orders' table. You can move, or remove it, as needed.
[Code]....
How would i make it so when the user clicks a button. it will open a form with a some tabs but go to a specific tab like lets say i have 4 lets say i click the button and it goes to 2.
View 10 RepliesI want to know how you can open a form with specific information as if you are just calling a sub, kinda like how a message box is. Example:
MyForm.Show("The form title")I also want to know how I could apply this to forms that are being created from pre existing forms. Exaple:
vb Dim NewMyForm as New MyForm("Title Text")'Now I want to know for each of these next 2 lines of code, think of them as being different codes all together.NewMyForm.Show() ' orNewMyForm.MdiParent = Form1NewMyForm.Show
I've got 2 levels of users, and I'd like to find a way to open a certain form for each user. I have tried something that I thought would work, but it just opens the same form for all users:
If "MenuType" = "Landscaper" Then
Dim MainPanel As frmOwnerPanel
MainPanel = New frmOwnerPanel
[code]......
I've created a very simple form with one button on. I need it so when the form runs, it opens in the bottom right hand corner of the screen regardless of the resolution. It also needs to be always on top of all other applications.
When the buttons pressed, i need it to close all iexplore instances and reopen a fresh instance.
I've tried to search for the answer but to no avail.
I have a access database with these columns. USER_ID,COUNT,TIMES
Let say the current record is this:
USER_ID,COUNT,TIMES
STEVE20,24,1.5
Now I want to updated the current count record and times, but before updating I want the old record to be added to the new record. What should be my query?
I have a data table that looks like this:
USERNAME ICOUNT IAVERAGE DATE_LOGGED
LAGX01 1245 1245 05-07-2012
LAGX02 2211 1422 05-07-2012
LAGX03 1698 1112 05-07-2012
LAGX04 4598 1555 05-07-2012
LAGX05 2589 3245 05-07-2012
LAGX06 3321 1155 05-07-2012
LAGX07 3698 3458 05-07-2012
LAGX08 2589 4587 05-07-2012
LAGX09 1598 1142 05-07-2012
LAGX10 3156 1987 05-07-2012
LAGX11 5547 2011 05-07-2012
LAGX12 9456 3459 05-07-2012
Now, I want to execute a sql query that will display the top 5 based on average, so i did this:
SELECT DISTINCT USERNAME,IAVERAGE FROM myTable WHERE IAVERAGE > 0 AND DATE_LOGGED='05-07-2012' ORDER BY IAVERAGE LIMIT 0,5 and the result is:
USERNAME ICOUNT IAVERAGE DATE_LOGGED
LAGX03 1698 1112 05-07-2012
LAGX09 1598 1142 05-07-2012
LAGX06 3321 1155 05-07-2012
LAGX01 1245 1245 05-07-2012
LAGX02 2211 1422 05-07-2012
Now, I want to numberize my query result, so it will look like this:
RANK USERNAME ICOUNT IAVERAGE DATE_LOGGED
1 LAGX03 1698 1112 05-07-2012
2 LAGX09 1598 1142 05-07-2012
3 LAGX06 3321 1155 05-07-2012
4 LAGX01 1245 1245 05-07-2012
5 LAGX02 2211 1422 05-07-2012
I want to let the user select a value from a combo box, and then exclude a row from the result set of a stored procedure based on that selection. Something like this:
Select RegNo from Vehicle Except select VehicleID from Trip
I have this code:
Private Sub EditPage_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load'TODO: This line of code loads data into the 'InventorySysDataSet.tb_master_products' table. You can move, or remove it, as needed.
Me.Tb_master_productsTableAdapter.Fill(Me.InventorySysDataSet.tb_master_products)
sqlCnn = New SqlConnection("Data Source=ZEREYSQLEXPRESS2008;Initial Catalog=InventorySys;Integrated Security=SSPI")
[Code]...
what i want to do is to automatically change the selected option of the cboProductCode on page load depending on the result of a query executed onload also.
I want to be able to get the one record I return from a table and put the results into text box's directly rather than put the result into a combo box and then transfer the text across.
Private Sub GetStationStats()
conn.ConnectionString = myConnString
Dim myCommandStationStats As New MySqlCommand
Dim myAdapterStationStats As New MySqlDataAdapter
Dim myDataStationStats As New DataTable
Dim SQLStationStats As String
[Code] .....
The fields Signon and SignOff, plus many others which I didn't include in this sub. Above code does work, its how to get it into a text box.....
I have a page with a form on it and needs a range of dates. Thus I've placed a number of textboxes on the page into which users can type dates. When the user clicks the save button I want to trigger a LINQ update to the SQL Server...all the rows already exist, so I'm just updating existing data.
For example, lets say my table looks like this:
Column Names: Description dateValue
Column Values:
Birthdate 1/1/1990
Anniversary 1/10/1992
Death 1/1/1993
I want to do something like this:
hupdate.Description("Birthdate").dateValue = TextBox1.Text
hupdate.Description("Anniversary").dateValue = TextBox2.Text
hupdate.Description("Death").dateValue = TextBox3.Text
hconfig.SubmitChanges()
Is there a way to do this with LINQ?
I have the following code in my project:
rivate Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim connectionString As String
[code].....
I want to bind the following query result to datatable:
Dim query = From c in db.Customers _
Where c.Status = "Active" _
Select c.CId, c.FirstName, c.LastName, c.Email