I 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'm not expert in writting vb codes. but there's this IT project im doing in access
View 3 RepliesI 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 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 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 have this addform to add, edit and delete records in marriage tab, baptism tab and so on and before we can see this form theres another form the emform my question is how am i supposed to code the "view this event" button, that when i click on the selected row my addform will show up with the row i click on the view button is selected/highlighted on this addform (btw i bind all the textbox in my add form on the columns of my marrige table)
View 10 RepliesThis VB.NET rookie is asking for the support of those with expertise. BACKGROUND: Form1 has a Datagrid, Dataset1 create by drag DB into datagrid. Form2 presents the record selected from the datagrid. Within the LOAD_FORM I search the DB with the Key and place data in Dataset2 (DS created manually)
CHALELNGE Record updated in Form2 is saved in DB fine and when Form2 is closed, record updated does not appear in Form1. I�ve tried the following but no sucess In form1 event Ive got the code to load data into the DS Me.TUSERSTableAdapter.Fill(Me.PTDataSet.TUSERS) FINALLY: What should I do to see the datagrid updated?
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 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 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]......
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've created a datagrid and made it read only, I want to double click it and it will open a new form with all the data so I can edit it and press save.
I have a form called New client where you add the name address etc and press save.
I want the fields already on the add client form to fill in the data from the row you double click on the grid.
I am using vb.net. i am having datagrid on my form. Now i want that when i enter datagrid and i press insert key from keyboard, new form should get open.
View 1 RepliesI'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.
get a button on form A to open form B and then close (not hide) form A when clicked?Background: I am coding a VSTO application for Excel in VB2008.
Private Sub FormAButton_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles FormAButton.Click
Dim FormB As New FormB
[code]....
What I want to do is setup a form to act like a control panel. When it loads I do not want it to be more than 94px in height but when the maximize button is pressed I would like it to expand the width of the screen. I was thinking I could do this with an "onload" event in the main form but not sure how to do it.
View 4 RepliesI am new to VB.net and have created a simple master detail windows form. I created a two table data set and then dropped the master table on the form as a continues form or a detail form with several text boxes to hold the data. The child form is a data grid.
test data that I have added directly to the database shows up with the proper parent child relationships on the form. I can also enter new records into the database using the parent only portion of my form.
When I attempt to enter a complete record with data in both the parent form and the child data grid I get this error. The INSERT statement conflicted with the FOREIGN KEY constraint
[Code]...
I have searched for a possible reason for this error but can not find any explanation. I have noted in earlier versions of VB.net you had to enter code to save the child record, but the VB 2010 code does not seem to use the same syntax so I assumed the UpdateAll eliminated the need for the extra code
This is well documented and easy to accomplish in Access, but how does one accomplish this in Visual Basic 2010 on a form designed in Visual Studio that is bound to a SQL Server database?
The idea is to create a combobox that holds 2 columns - a primary key value and a unique value such as a [Company Name] or a [Student Name]. The user would then find the appropriate record within the combobox and the code behind the combobox control would then perform a .findfirst method that would NOT filter out all other records, but would rather use selectedvalue primary key column value to move to the selected record.
I am currently getting into VS 2010 & revisiting VB having been programing in ACCESS & VBA for years. In the Access/VBA environment it is very common to have to find a given record on a given form using this method, but it would appear to be poorly documented if in fact not commonly used in the VB.NET/VS community.
This is well documented and easy to accomplish in Access, but how does one accomplish this in Visual Basic 2010 on a form designed in Visual Studio that is bound to a SQL Server database?
The idea is to create a combobox that holds 2 columns - a primary key value and a unique value such as a [Company Name] or a [Student Name]. The user would then find the appropriate record within the combobox and the code behind the combobox control would then perform a .findfirst method that would NOT filter out all other records, but would rather use selectedvalue primary key column value to move to the selected record.
How I Can open the same form in my application one time only can not open the form tow time in same time
View 5 Repliesso I am a little confused. I am trying to refresh my datagrid when I have either add, deleted or edit a row via another form. I have it so my main form shows the datagridview, I have bound my controls to the database and I see all rows, no problem. I also have it setup to double click a row and it brings it up in another form to edit that record. This works. but it doesn't refresh the datagrid when saved. I am trying to follow this thread, specifically this post Refresh Datagridview - Post 2 Here is how I am loading the datagridview in main form
[Code]...
Im using a dataset to display data in a datagrid from a sql server DB. One of the colums I have in my datagrid is "Status" the table adapter sql statment selects certain items based on whether there open or closed e.g "where = Open ". I want to remove this row entirely and instead of displaying open or closed for status column, display the open/ closed results in colour on the datagrid. Im really not sure how to go about this whether i need to do it in the table adapter or some sort of property. I presume i need to write a sql statement and selct the identity of the row where x= open etc , is there a way of assigning a colour in sql statement so it displays on my vb form ?
View 2 RepliesI want to have a DataGrid in a form Docked as Fill, and have it located below the ToolStrip.What I mean by Docked as Fill is I want to be able to resize the DataGrid along with the Window Form.When I select Dock as Bottom, the space between the DataGrid and ToolStrip changes as well.
View 1 RepliesI'm running VS2010, and I'm trying to open (or show) a form from a different project.My solution contains 3 projects: #1-The main program, #2-a custom control DLL, #3-a report generator project.I want to use a menu item click in project #1, to open (Load & show) a form in project #3. I can't figure out how to programmatically get access to the a form in a project #3.
View 3 Replies