I am trying to update my form once the delete button is clicked. There are several fields like Name, Date, Date of Birth and so on. Once I delete a record I want the form to automatically load with new / updated data. This form fetches data from MS Access using OLEDB I have spent a long long time trying this but did not get any solution.
View 3 Replies
I have a datagrid being filled by the data adapater connected to my database.I have a delete button on the form, i cant figure out how to delete the selected row on the datagrid when the delete button is clicked.
View 1 RepliesDim cnn As OleDbConnection = New OleDbConnection
cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= C:Documents and SettingsJennieDesktopCWK 1Game Shop.mdb"
cnn.Open()
[code]....
I am trying to delete a row from the datagrid when a button is clicked, however the line which I have BOLDED shows an error which is its not a member of the system.windows forms. Any ideas on what I should change it too? I am aware that that line of code is for a datagridview not a Datagrid which is what im using.
So, I'm working on a simple game in Visual Basic, and I have 2 labels. One named "pointsLbl" and one named "pointsleftLbl":
pointsLbl.Text = "Points: " & points
pointsleftLbl.Text = "Points left: " & pointsleft I also have two integers, one named "points" and one named "pointsleft". The problem I'm having is that when the point boost button is pressed, the labels don't update and also don't show the new points and new points left. Private Sub boostBtn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles boostBtn.Click
[Code]...
I have already done the creation of button and the dragging of button at runtime already.But now i need to know how do i save the last dragged button on the form and also detect the name of the last clicked button.so lets say i now drag a button to coordinates 25,254. so when i exit the form and the next time i launch it, the button will still be at 25,254. and this one will go on for the number of button i created like 100. so when i launch the form the 100 button will be at the exact position where i last saved them.the second part is lets say i created button1 and button2 on the form in runtime. so when i clicked the first button, it should display button1. and if i clicked on button 2, it should say button2. same goes for like 100buttons.
[code]...
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]....
i'm new in vb.net and i have problem with my project. cthis problem.
-update button
Dim con As New OleDb.OleDbConnection(My.Settings.TREViS_03_ConnectionString)
Dim com As New OleDb.OleDbCommand
[code].....
How do you fix this code so it works?
Code:
Public Sub btnExit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExit.Click
[code].....
My Problem is that I have a form that when a button is clicked loads a new form - code below. I want to fill a list view with data from a database in columns but that isn't the problem: Whenever I run the program and try to open the new form, the program runs up to the Rec = Connection.execute line before going back to the first form where I opened it up.
Public Class Form2
Public Const ConnectionString As String = "Data Source=PeopleBase.sdf"
Dim connection As New ADODB.Connection
Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code] .....
I should also explain that the database is a local one and there are no errors or warnings that show up, it just runs like the while loop part isn't there.
I want to know how to Update / delete the table records in ASPNETDB.MDF in single update / delete query ?
View 1 Repliesokay on my main form i created an instance of another form
Dim secondform As New frmSecond and i called it with this
secondform.ShowDialog() okay now when the secondform pops up there is a "OK" button and "Cancel" button. how can i tell which button was clicked? If "OK" was clicked i want to perform a task, otherwise nothing happens..
I have created a form in VB and have coded a Clear Form button into it. The issue I am having now is coding the 'Submit Form' button to have it email the completed form to 2 employees in the bank that I work at. The form will be uploaded to our server for other bank officers to complete and then submit.
View 11 RepliesI'm making an equation program and I want to have a main menu where the user can select an equation and then when one of the buttons is clicked, it closes the "selection" form and opens the appropriate form. For now I just have it set to show the proper form (for example, Form3.Show) but when I try to do something like Me.Close() after it, everything closes instead of keeping Form3 open.
View 2 RepliesI also need to know how to make the same button create a folder to save a txt file in. I havnt yet figured out how to save changes made into my program, that way next time i open it, i can continue where i left off.
View 4 Repliesprogrammer and anything related with IT. i'm trying to create a program for my internet cafe wherein i would need 2 forms, 1 which will contain the transactions and 1 to log in/out customers. I was able to make this using excel but am currenty having a hard time now creating the program with VB2010, because syntax/formulas seemed different from that of excel2010... i have so many questions that i would like to ask, but i'l start with loading a form(for logging in/out) by clicking the Log-in button.
what i used before when i created a userform in excel is this:
Private sub LogBut_Click()
logForm.show
[code]......
I have used this form to add new records on my database(ms access) in my database I have a column name 'ID' which is my primary key 'ID' is set as auto number. Now I am having a trouble on creating my update and delete button it's always saying "cannot be delete/update"
Here's my code on add, update and delete
Public Sub SaveRecord()
Try
Dim dbConn As OleDbConnection
Dim dbInsert As New OleDbCommand
Dim str1, str2, str3, str4, str5, str6, str7, str8, str9 As String
[Code] .....
Note my add is working perfectly fine. I just can find the error on my delete and update. Also I have used this to view it to my datagrid I don't know if its the right thing but it's working fine too.
'declared dbpath globally'
Dim dbPath As String = "Provider=Microsoft.Jet.Oledb.4.0; Data Source=../VG.mdb;Persist Security Info=False"
[Code] .....
Another thing is how to code each textbox and combobox to bind it to my records so that when I click on the datagridview each column will be distributed on each respective textbox.
how to code for the save button in vb.net datagrid view by using insert into sql and update sql statements (it should be able to insert & update the data grid and save the changes) when the save button is clicked .
View 2 RepliesHow would i make a form grow down vertically like say 200px when i click a button ?
View 5 RepliesI am creating a visual basic program, which acts as a very simple GUI for another program. I have built the whole Visual Basic project, but I am unable to do one part, the most important part you could say. I have a button (button1) on a form, when the button is clicked, I want it to run a program, named 'mover.exe' which is located in the SAME FOLDER that my visual basic program will run from. The directory of this folder will change. So, there are two problems I have:
1 - To make the program run the .exe program when button1 is clicked (it also must be run with administrative privileges).
2 - To make the program always look for 'mover.exe' in the folder in which it is started from.
A Maximized windows form contains a button (Button1) that when clicked upon executes following code:
Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim Bfrm As New frmB
With Bfrm
.Top = 100
[code].....
form1 have four buttons, i want to set a label text in form2 according to which of the button on form1 is clicked.below is what i tried so far.on form1 each of the button click event i made it focus
Private Sub Answerbtn3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Answerbtn3.Click
Me.Focus()
Form2.Show()
and on form 2 load event i have
Private Sub FinalAnswer_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If Main1.Answerbtn1.Focus Then
Label2.Text = "You choosed option '
[code]....
the above code displays only the first condition ("You choosed option 'A'"") on the label when any of the button is clicked?
I am currently working on a program in VB that is 480,600 and am using a panel with a picturebox inside of it so that I can use scroll bars to view a chart in the picturebox since my form will be so small. Since viewing a large chart is pretty irritating using scroll bars to some, what properties can I enable or disable to get the panel and picturbox to expand also when the Form Maximize button is clicked rather than staying the same size up in the top corner?
View 2 RepliesI'm trying to create a save button on my infopath form that when clicked, it automatically saves the infopath form to a directory. I'm running into some issues, I thought it would be simple but is quickly becoming confusing. [code] I've tried searching all over but couldn't find an answer that pertained to xml documents such as an infopath form.
View 4 RepliesI am not sure if I can do update, delete and insert in one form. The problem is that in this one form I have 3 textbox and 1 combobox which the user have to enter each column and click on the submit button which is for insert. So how can I do this with delete and update.
View 6 RepliesIs there any way to skip a the validating event of the active control when the close button of the form is clicked. It is very annoying when user wants to close the form, but due to the validate event of the active control, it asks for the valid input. The user is forced to give valid input to close the form. I have searched a lot for this on net but no any proper solution could be found.
View 5 RepliesI have a windows applications. Form 2 is child form of Form1 . Basically when button on form2 (child form) is clicked, it raise an events, which writes something in testbox on form1 (parent form). This is my code
parent form form1
Public Class Form1
Public mycount As Integer
[CODE]..............
This is the first time I am tring to use events.. I am not sure what's going wrong.. the textfill event is never called from form1.
I'm using Microsoft Visual Studio 2008 to create an application (.VB). The application connects to a Microsoft Access 2007 database. When the user starts the application, the application pulls in the data from the database via the "TableAdapter.Fill" method. The user can then add/update/delete records in the form and those changes are saved and confirmed in the database. The problem is when the user close completely out of the application and restarts it, the modifications that were made and originally sent/saved to the database are wiped/deleted. It appears that the dataset in the application never saves the modifications and when the program restarts it uses the data that was originally loaded into it during the design/build phase of the application.
View 3 RepliesUsing 2 forms how would I click one button, from another form? ie In VB 4,5,6, I would used to do it as:-
Form 1:
private sub Command1_Click()
msgbox "Say Hello"
End Sub[code].....
If I clicked the button in form2, it would automaticlly, click the button in form1. Do I, do it the same way in VB Express or has it changed?
I already created a button "enjoy button" that i want to move in a form when the "timer start button" is clicked.how do link the timer to the "timer start button" and make it move?
this is what i tried so far..then am blank first
Code:Public Class MainForm
Dim DX As Integer
Dim DY As Integer
Dim X As Integer
Dim Y As Integer
[URL]...
Using VB 2008: I have two command buttons on a form called "cmdOK" and "cmdCancel" with respective captions of "&OK" and "&Cancel". The cmdOK command button is not linked to the form's AcceptButton property, while the cmdCancel button is linked to the CancelButton property.
The code below illustrates the contents Click event of the cmdOK command button which correctly handles cmdOK.Click
The form is opened with a ShowDialog() method.
Whenver the cmdOK button is clicked, the form closes, even if txtExpression = "" and the Exit Sub is consequently triggered.
Try
If Me.txtExpression.Text = "" Then
MsgBox(
[Code]......
