Open A Form At Specific Record?
Mar 29, 2010i'm not expert in writting vb codes. but there's this IT project im doing in access
View 3 Repliesi'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 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 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 Replieswork 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 created a project that has an add a new record, edit record and a search form, that has multiple text, combo boxes and is working great.Last nite I have added a checkbox under my add new record form and i am saving the checkbox value to my database, so far so good. I would like to be able to search any record that is mark with a checkbox to show up in my search screen when I do a search: [code] The problem that i am having is that now that I have added the code to my project to search for the checkbox field in the search screen and if I leave everything blank and click on the the search button I get no record found. I expected to see all that data, since I have nothing selected. Now if I click my checkbox, as soon as I click on my search button I see that two records that I have added for my test.
View 1 RepliesImports System.Data.SqlClient
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim connetionString As String
Dim connection As SqlConnection
[code]....
How would I access a specific record and put it into a variable to compare against user input?I have a table CASHIERS and part of that table is a BadgeID and a PIN number. What I want to do is when a cashier swipes there badge to logon to a POS.. it searches the DB to see if the cashier exists. Then, once it establishes that they do exist, it pulls their PIN # and prompts them to enter it. It compares the data retrieved from the DB to the data that they entered.
I am using crystal report to make my report. But problem is that I cant use same SQL Command there in report parameter because its different. I am going to show you my code so that you can understand it. I have a report & a form where I have one text box one button & one crystal report viewer. I have imported all fields by using report wizard. Even I have created parameter(name) there. So that user can get specific record by typing it there in the text box. However here is my code for button1:
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.Shared
Public Class Form1
[Code]......
It means it will not show student`s ID & name again & again. On the top of the report it will show student`s ID & name for once & depending on ID it will show student`s mark on report. I guess I have to use something like that Select * from result where text1.text = name of the parameter. But problem is that I cant use same command there in formula workshop.
i want to create login form in VB.NET i will done a lot of work like inserting data and also retrieving data but i want to know that how can i get specific record from data base and want to match with my input .
Imports System.Data.OleDb
Public Class frmmain
Dim da As OleDbDataAdapter
[Code].....
How can I make an application that can record the audio output of another application using VB.net?
View 1 RepliesI have finally taken the plunge and am trying to get my head around VB 2010 after years of playing with VB6. I am using the free VB 2010 Express edition to get me started I am not an acomplished programmer in VB6 - being totally self taught from books, files , forums like this and internet searches so I am finding the transition to .NET syntax very painfull. Unfortunately,
[Code]....
can i ask how do i insert my records from my textbox to specific column name of my table
IsConnected("Insert into products values(" & _
Me.TextBox1.Text & ",'" & _
Me.TextBox3.Text & "','" & _
[code].....
how do you retrieve a specific record from a database. i have a database with records of stock an i need to be able to check the stock for specific items on the database. The collumn is quantity and im trying to retrieve the integer value based on oledb querry "SELECT Quantity FROM Stock WHERE ItemID=ITemID"
btw i have tried oledb data reader but don't seem to understand it .
I want to know how can I get specific record to make report? For example I have student information there in my program. Its easy to create a report of all students. but if user wants to get & print specific record of a student what should I do? I have another question to ask. I have heard it that its possible to show each specific record there in each page by using NewPageAfter or NewPageBefore. I need to know is there any way that user will select ID number from combo box & when he will click on report button it will create report of that student what has been selected from the combo box?
View 1 RepliesI want to know if is there's a way to update a certain record if it reaches a specific date. [code] I wanted to automatically update the "IN" status to "OUT" status when the date.today = DateUpdate.. I am using MsAccess2003 to connect VB.Net2005express edition (using Odbc Connection) Coded it at back end(no controls)
View 1 RepliesI want it to take the text from the text box and use that to search the badge column from the db and tell me if it exists or not.[code]...
View 3 RepliesI am using the following line of LINQ to drill down into an element. Is it possible to expands this code to drill further down so that I can add content to the <population> element in "Test2". I want to be able to do somthing like element.SetValue(1000000). However I need to expand the code below so that I can pass the entire query results into the variable called "element"'
Dim eles = From c In doc.Descendants("File") _
Where c.Attribute("Name").Value = "Test2" _
Select c
[code]....
I have made a form i want to search a specific record by passing peramiters.
I have tried it by using this code:
OleDbDataAdapter1.SelectCommand.Parameters("CustomerName").Value = TextBox1.Text
Dataset11.Clear()
OleDbDataAdapter1.Fill(Dataset11)
When i use showposition() it gives me error.
I am using oledbadapter to find the record it doesa nothing and also when i tey to insert another oledbadapter it doesn't allow me to insert another olebadapter why?
My application will start (dataset filtered by username/date) and if it's the first time the user has used it today it will be a blank entry form because there is no record for today created. The user can just type data into the blank form and close it. On the form closing event I want it to run a tableadapter.insert(username, date, x,x,x).
If it starts a second time it will load showing today's entry because today's date was inserted previously when they closed the form. So this time when they close the form I want the form closing event to just run a tableadapter.updateall(dataset) command. I need some help with my form closing event...
[Code]....