I'm a bit of a newbie to using VB in Access, I have a database in which multiple people need to work specific problems which are separated into records from a form. What I want to have happen is that everytime a person changes the cboStatusName combo box to "Done", it will populate the current time into the DateCompleted field, and then it will lock both of these. Below is the code I'm trying to use through an event.
[Code]...
How could I lock any file in my PC from others access? I am trying to lock some my video, picture, Excel and Word file in my PC by using Visual Basic. I am using Visual Studio 2008 to develop this application but I am unable to do this job. It'll be something like security utility application. Actually without me, some other people also using my computer and I am trying to lock their access in my personal file. And I wish to know the tools which I can use for this job. I am just a Beginner on this development field.
View 4 RepliesMy problem is that I need to use a access database as a backend for my visual basic.net program.
The database will be accessed by a maximum of 10 users but I want to lock tables when a user is updating a record.
I am unable to use the SQL server at the company due to it storing sensitive information.
I have some basic knowledge of ado.net
I have read many articles but I can't find any articles that say how to lock a access .mdb file using Visual basic.net
I want to search the records from the textbox and display the records to the datagridview, if there are no records, just display empty on the datagridview.
this is not working:
Dim sqlsearch As String
sqlsearch = "SELECT * FROM setting WHERE mname LIKE '%" & TextBox.Text
[code].....
I made a DLL that is a UserControl that has a TabControl with one TabPage on it. On the TabPage is a Panel & on the Panel are some controls.how can I access the individual components of the UserControl from the application that is using the DLL? I have added a reference to the DLL & can add the UC to a form, but I would like to have access to the child controls of the UC, ie. change the text of a Label that's on the Panel. Do I need to do something when I create the DLL to cause those controls to be accessible?
View 7 RepliesI have an access database with one table and 4 or 5 different fields.
All I need to do is be able to be able to use a loop to read the values in a specific row and column and store it in a variable (or array).
I don't need the code for the loop or anything, just the syntax for reading the value of a specific row and column in a table to a variable.
Im not too sure if this is the correct place for this question, but I couldn't find anywhere else..Heres what i want to do. I have two tables in an Access DB. TableA and TableB. Each Table has only one column called Picture, and that column is filled with the names of pictures (picture1, picture2, picture3, etc)
Thing is, that The pictures in TableA have equivalent pictures in TableB. They are not named the same, but the pictures themselves are the same i.e.: TableA Picture1 = TableB Picture3, TableA Picture2 = TableB Picture5.
What i Would like to create is a form that has two datagrids, or Listboxes populated with the data from each table. One for TableA, One for TableB. When the User selects a picture from one of these controls, The other control must show which picture the selected one corresponds to (if i select TableA Picture1, TableB Picture3 becomes selected showing that they match)
I think that most of the work will be at the actual DB, somehow linking each and every field, maybe a one to one link between fields/cells in the DB, then in VB calling that one record that was clicked on, seeing what relation it has to the other table,
[Code]...
So I have a code atm that has 2 combo boxes, one to select the make, then it will enable the model, I have 3 model choices, here's code: [code] Once I have selected my model of the car, it takes me to that specific form with a picture of that model, I then want to display individual parts, with individual prices that will add up in a text box above.
View 2 RepliesI'm very new to using VB.Net so I found it quite difficult to understand other answers that I searched for.
Basically, I have an project to develop where a user can create an account, and log in with it.
So far I have :
Created a database in ms access with the relevant fields (2003 edition)[code]...
I have 3 combo boxes full of data. I have an access database with a table and 3 fields. I am using the following code to insert the data from the combo boces into each field of the database. The program runs and I get no errors but the data is not going into the table.
Dim DrawCount As Integer = 0
Dim DateStr As String = ""
Dim TimeStr As String = ""
[Code].....
I am developing a Windows application that reads from a database and creates a total and subtotals for the records in the database. I am supposed to include a Try...Catch statement that reads the records in an Access db table and adds an item to the ListView control for each record. Each field in the record should be added as a column in the ListView control.
I have already gone through and created my Form_Load event that creates the columns needed in the ListView. I have created the beginning of the Try...Catch statement that opens the database connection. I do not know the syntax I should be using to add the record to a ListView control.Normally I would use something along the lines of to read the data:
[Code]...
add edit and delete records in access using vb.net.i got textbox 1 to5 and three buttons which named addnew ,edit, delete.my database is in name records.mdb i want user to enter the information and click addnew button and the system save the records and so on with edit and delete.
View 3 RepliesI have been trying for a month to get a row added to an Access database and can not do it. I have the databindings all set and can select different records, but can not add a new one. I have tried BindingSource.AddNew.row() but can't figure out how to add data to the new row, nor does it show in the database.
I have tried
Dim ds As New myDataSet '<---Change this to the dataset name on your form
Dim dr As DataRow
dr = ds.Tables("Students").NewRow
[Code].....
But that doesn't do anything at all. No data added, no errors. I have tried updating a datagrid to be told it can't be updated when bound. I look on google and nothing seems to relate to adding data to an access database when bound to the project through the datasource wizard.
I am using OLEDBConnection and OLEDBDataAdapter and connected to the MS-Access databasehow can i add the textbox value to the table in database on a button click and want to display it in datagridview??
View 1 RepliesI'm creating an application that adds and deletes records from a microsoft access database. The language I'm using is VB2008. I am importing the database through a wizard. I can add records and delete records, but I cannot delete a newly added record without closing the form first. When i reopen the form, I can delete the record. Here is how I have my database setup:
'Bind user info to the controls.
AUSERDataSet = New BulldogUsersDataSet
AUSERTableAdapter = New BulldogUsersDataSetTableAdapters.UsersTableAdapter
AUSERTableAdapter.Fill(AUSERDataSet.Users)
' Setup the binding source.
AUSERBindingSource = New BindingSource
copying some record from a table in the same table,changing only the fields of the data(month);- copy last month record fields, and the new records have to date, last month+1(actualy month);- i wish to be a button, like update or copy, to do this;- new filds are added every month;- how i do that?
View 16 Replieshow to do it, but the tutorial is not applicable on the program that I wish to do. The tutorial tells you to add 4 navigation buttons so that you can navigate the database(first, last, back, and forward). Then an update and delete button. But if this is what I will do, it would take 10 years to navigate the database and update a record. Now, what I want to do is just for the user to input a unique ID and click search button(which I have already done). Then the update would be easier. How can I update or delete a record using this method?
View 1 Replieswhen this button is click, it will retrieve all the records in different fields in MS Access 2007 and display onto the RichTextBox. But when i run the code and press the retrieve button, an error occurs. (NullReferenceException was unhandled. Object reference not set to an instance of an object.) Plus im sure my code to display records on richtextbox is wrong as i created another project purely with a button and a richtextbox, only the last field in access is displayed.
Imports System.Data.OleDb
Public Class Form1
Inherits System.Windows.Forms.Form
[code]......
I have a project to work with an existing Access 2007 DB table using Access Currency data type fields. I've tried many, many, many variations on what I'm doing, including using a command parameter or using this scheme and trying dOLEc in my command string (as shown below).
Dim dOLEc As Long = Decimal.ToOACurrency(dQ)
It all works fine (db connects, inserts record OK, closes connection) until I introduce any currency variable (WMoney is my example below). Then it returns Syntax Err 5 in INSERT INTO statement. Current VB string for the execute non-query command is:
Dim sdbcommandString As String
Dim dQ As Decimal = 8950.13
'control test--no currency field--works perfectly every time
sdbcommandString = "INSERT INTO Workers (WFullname,WRay)VALUES('George D. Jones','abcdefg');"
'but add the currency data type to it and it bombs
sdbcommandString = "INSERT INTO Workers (WFullname,WRay,WMoney)VALUES('George D. ZZZZZ','abcdefg'," & dQ & ");"
As I said, though perhaps not too clearly, I've also tried variations on this theme:
sdbcommandString = "INSERT INTO Workers (WFullname,WRay,WMoney)VALUES('George D. ZZZZZ','abcdefg'," & dOLEc & ");"
In all cases, I use the same code to connect to my db and use
OLEdbConnection1.ConnectionString = sDBConnString
OLEdbConnection1.Open()
OLEcommand = New OleDbCommand(sdbcommandString, OLEdbConnection1)
OLEcommand.ExecuteNonQuery()
And I've tried it using variations on this theme where :
sdbcommandString = "INSERT INTO Workers (WFullname,WRay,WMoney)VALUES('George D. ZZZZZ','abcdefg',?);"
OLEdbConnection1.ConnectionString = sDBConnString
OLEdbConnection1.Open()
[code]....
I need to use to make it work with a currency field?
how can I delete a records in access dataabse except for sql query my code is this I would like to know if this code is wrong or not
Private Sub BindingNavigatorDeleteItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BindingNavigatorDeleteItem.Click
[Code]...
I'm trying to import all data from an Access DB using Visual Basic 2005. I'm new to Access and so far I can only import one record at a time. Here is the code I have so far
Private Sub BtnLoad_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles xLoadButton.Click
Dim con As New OleDb.OleDbConnection
[code]....
I am trying to insert records in an Access database using VB.NET 2008 using the following code:[code]I get this error Syntax error (Missing operator) in query expression when I try to insert any record that has apostrophes in the name.I have tried everything I can think of to get these types of names intserted into the database with no luck.
View 3 Repliesso now i know i have to use begintransaction to insert records into Access. i've searched for information and it seems that i have to implement Ole.DB and SQL in order for begintransaction to work. My question is, currently i didn't implement any Ole.DB or SQL codes to connect my Access database to Visual Basic.
View 5 RepliesI need to loop through all the records in a column in my access database, Currently my program only views the first record in the column and does not go any further, I tried a While loop but I get a NullException error and it says there is no data in my column, her is my code thus far.
Imports System.Data.OleDb
Imports System.Security
Imports System.Security.Principal.WindowsIdentity
[Code].....
I have a problem when trying to retrieve records from my Access database through WCF. In my application the user enters a Customer ID and the function then searches the database and retrieves all records related to that customer. However, it isn't working as it should. The code behind the search button is as follows:
Private Sub SearchButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SearchButton.Click
[Code]...
this code isn't doing as it should. The DataGridView should display the records relating to a customer but nothing is being returned at all, I'm not even getting any error messages. I've been looking at it so long I must be missing something ,
I'm having a problem setting the maximum number of records that can be saved into Access. The maximum allowance is to be 10. Records are being pulled from a listbox. The whole problem is that if the listbox has 7 items and my table already has 5 records, it still records them, making a total of 12. What I'm looking for is a way to trap that to a max of 10.[code]...
View 2 Repliesi've implemented a system on vb.net 2010 having its database on Ms Access 2010 (.accdb). i have to read records from the tables to a combo box by binding its datasource to the tables directly. the problem is that the data in the combo box is not sorted since in the database itself the records are not sorted. how can i achieve the sorting?
View 1 RepliesI have two MS Access databases (with identical table structures), and I'd like to use a SQL statement (programmatically in VB.NET) to copy records from one to the other. Both databases are locally stored, in the same directory (and this will always be the case). Suggestions?
View 2 RepliesI am making a program that takes Access records and moves them into MySQL then checks to be sure everything is right and deletes the moved records. But, for some reason my delete command isnt working....
Here is the
Dim deleteCommandF As New OleDbCommand
Dim deleteCommandE As New OleDbCommand
Dim deleteCommandO As New OleDbCommand
[code]....
Running the program now to get the exact error message, shouldnt be more than 5 minutes and I'll post it.It says my paremeters are wrong? deleteCommandE.ExecuteNonQuery()
adding the records to Access table which has been entered in the form in vs2010.
When the user fills in the forms the data should be saved in Access table.For eg if the user enters name,age,address in form the same should be saved in access table which has name,age,address fields.
