so far i have this for my code:
Using myConnection As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & databasePath & ";User Id=admin;Password=;")
[Code]......
This did not work but did when i just tried creating the table and not the fields.
I have the code I am using below. On 3.5 framework Access 2003 database vb net 2008
I already have the database created but need to be able to add Tables and fields with the correct datatypes. So far it's not working but i don't know why or where the error is.
Private Sub MDIParent_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Try
[Code].....
How do i find out the number, names and datatype of fields in an Access table
View 16 Repliesi am trying to create a program that connects to a database and shows table fields in listview in windows form i manage to do that but i want now to have a button to take the total of a column in a list box ,lets say from the column "money"?
View 9 RepliesI am trying to create a form which will be fed by an underlying database to create multiple form fields for each entry in an underlying database table. This is for a program to monitor patients under anesthesia, and prior to surgery, the doctor will choose which monitors they will be using. Then, on the actual monitor screen which will pop up every X minutes, there will be a text box and a check box for each chosen monitor. I am relatively new to VB, so I have tried to illustrate what I am needing but using the logic that I know from my previous life in PHP.
I am using DevExpress's layout control to place the form fields, so that is the code in the middle of the first loop (on_load), and I know that part works, I just need to know how to name the fields and then recover those fields and commit the values to the database. (the text boxes are added to the database, the check boxes are used to determine if an entry is made for that monitor- i.e. at the end of surgery if a monitor is turned off). I know that my syntax for naming the fields is no where close to correct, and it probably would not work in PHP, but I remember doing something like this in a PHP application I built long ago. [Code]
I'm trying to create a table in Word using data from a table in Access. There are four fields in the access table that I need. 3 fields are text which I can populate the Word without any issues. However the fourth field is a memo with >255 characters.I'm struggling to come up with the proper code to allow me to populate the Word field with the memo data that has more than 255 characters. The code I have so far is listed below. But when it hits the memo field, it crashes on the line I marked with **. I know it's not text, but I've tried many different field types, but nothing has worked so far.[code]...
View 1 RepliesDetails: I want to compare these above two table1 and 2 . The unmatched records should be save in a new table .
objectives
1 Should take input the table and fields we want to match each other.
2 Then after searching or reading the record from table and selected fields save the unmatch records in a new table
I want to create a new MS Access database table using ADOX. On this page, is code in VB.NET, but obviously it's not working in C# (when I want to "convert" the code). I'll be grateful if someone converts it correctly.
View 2 RepliesIm working on a prog for my work. however, im stuck. I come to a spot where i need the prog to copy a sample table to an existing database. we can either simply copy the sample table, or as a last resort, create a new one from scratch.
View 6 RepliesI have made an Access database complete with a report/form UI, however I am now looking to take this further to Visual Basic. In my Access database I have a log-in form to access some secure reports. I am now trying to do the same thing in Visual Basic, with no luck. I have created the UI elements i.e. buttons and text boxes, but am now stuck at how to implement the code.What I want to do is make the login button check what's in the username/password boxes with a table in my Access database.
View 1 RepliesI have to update some fields of a table of access according to the value of parameter. If this paramter is "true" I need to update.
Table
idInvoice
price
[Code].....
how to execute this SQL Statement
Scenario:
Given Tables T_Data, T_AllDesc, T_System1, T_System2
Given Fields:
T_Data= f_id, f_Desc, f_CreationDate, f_CreationTime, f_System1, f_System2
[Code].....
I have used VB (versions 2 - 6) through many years; however, I am crash-course training myself into the VB2008 / VB2010 world kicking a screaming. I would like suggestions as to what SQL database access method should I focus more on in my learning process without making me feel that I'm a million years behind. I know I have WinForms where I can create a datasourse and drag / drop fields or tables on a form to create a grid (not really what I'm looking for).
My trouble isn't so much designing the form but in how I access the database. Theres XML, LINQ to SQL, ADO.NET, and many other methods. Not only do I need to grasp these methods quickly but I also need to know what type of projects I should create. What I mean is...I was thinking that I would design a WinForm app; however, I see that there are WPF apps and others to chose from. This is getting deep. I know it depends on the project that I'm working on. My plans are to write an app based off of either an SQL Express 2008 or SQL Server 2008 database. This first app will be standalone for now but may later become multi-user. I know I'm far behind on my learning curve coming from VB6. I have read a bit on VB2005 / 2008 / 2010. I own
both VB2008 and VB2010. I use VB2008 at work. I know ADO.NET is still alive but by what I read online, it's a dying method and is only kept for backward compatibility. XML and LINQ to SQL and other methods are all pretty new to me.
I am using the code shown below to compare two Access databases with two fields each and write the results to a third Access database. I am getting an error at the "Do While DMReader02.Read = True" line: "Invalid attempt to call Read when reader is closed." Why would the reader be closed at this point if I am using different DataReaders in the two loops?
Imports System.Data.OleDb
Partial
Class Form1
[code]....
Why MS Access adodb in .NET returns 34 in fieldcount when table has 42 fields ?I see 42 fields in table of my MS Access mdb database. But ADODB layer in .NET sees only 34 fields. The Outofrange exception occures when I am calling method getOrdinal("FieldName") of reader class.
View 1 RepliesRe DataGridView Sorry don't really have any code - just a whole project. Basically I changed the underlying Access (accdb) Table by adding a new field, The new field shows up in the DataSources section of the Solution Explorer and in the "Edit DataSet with wizard" page but when I attach the binding source to a datagrid view, the new field is not there. I also created a new bindingsource but still not there.I just noticed I've another table where I changed the names to something more meaningful, and the old names are still there and the data for those fields doesn't display in the DataGridView
View 2 RepliesI want to select column 'F1' from an excel spreadsheet and dump the data into my datatable 'oleDT'. How do I map the column F1 to the column i've added called 'colTest' ? When i call Fill, the dataTable has 2 columns, which are 'colTest' full of nulls and a created column called F1.[code]...
View 1 RepliesI am create a mysql table with TIME Data type fields. Like FROMTIME and TOTIME. And some insert data to that table. And that data is view through DataGridView. I can show all data in DATAGRIDVIEW. But, Have a error data, when current row click time ( Error data is : DataGridViewTextCell {ColumnIndex=0,RowIndex=0}.
How to store TIME types to Variables or Control;
I have an SQL statement which i need to code in vb:
CODE:
Notice the fields prodno1 and prodno2 in the table structure.. this is part of a number of sql statements i need to run and put inside a loop. my problem is i want to automatically use this same code such that on the next loop, this sql statement is going to be:
CODE:
Note that in this "2nd loop"
- the table name is now r3 from r2 in the first SQL statement
- there are now prodno1, prodno2 and prodno3 instead of just prodno1 and prodno2
- in the WHERE clause, the p.prodNo becomes p.prodNo2
And so on and so forth.. so for the 3rd loop
- there's going to be r4
- there's going to be prodno4
- in the WHERE clause i will use p.prodNo3
Is it possible to fill a Combo Box with the names of the fields of a table(from a database)?
View 6 RepliesI'm looking for a way to combine a field from multiple tables into a single field in a new table. Because the data populating the tables is coming from an outside source, I would prefer not to change the data in the original files. I have a separate table for each year because this is the way the data is provided. The field layout is not consistent from year to year, but each year there is a field that we'll call "score." I'd like to pull the field "score" from each year's table and have it populate a "score" column in a new table along with the year of the data so that all the years' scores are in the same place. Is there a way to do this using Visual Basic + Access?
View 3 RepliesI want to add a new table in my accdb and copy the content tfrom an existing table into the new one.
Is there an easy way to do this?
I am trying to enter a record into an Access database via visual basic programatically.I had this working fine when I had the datagrid bound to the database but now I have decided to do it all at runtime to save on resources at runtime.When I unbound everything and tried running it with my existing code
Try
ds.Tables(
"tblProduction").Rows.Add(row)
[code]....
This is the line of code that has to have another 30 entries in it.
I have been tasked with writing a program for our yearly reviews. We want all of the information gathered in the form to be submitted to an access database. I have created the form and the database. I can send info to the database but it is put on a new line everytime it is submitted. I would like to check the first column of the table to see if the user login is already there. If it is there I would like to update the information. If it is not there I would like to create a new row. This seems simple, but I can not figure out how to see if the user login is already there.[code]...
View 4 RepliesI have created an windows application which stores it data in a database. What I would like to know is how do I access the tables in the dataqbase and transfer the data in them into textboxes on the forms in my application. I can connect to the database and view the tables, but I have'nt got any idea how to get the data from the fields in the tables into the appropriate textboes on the application forms.
View 2 RepliesI use the following code in vb.net to search across several Access database fields, which works well, is there a way to find out WHICH field had the search data in?
[code]
Public Function Incomming_Number(ByVal strNum As String) As String
Dim oConnect As New OleDbConnection
Dim sql As OleDbCommand
[code]....
I've been attempting to tinker around with connecting a MS access database to a vb 2008 app. I've successfully connected and can access the data by using the add data sources tab. But what I'm trying to do is create a form that has a (1) single line text box, (1) button, and (1)multi line text box. I enter a name in the single line text box, click the button(search db), and when the info is found, it is displayed in the multi-line text box.
View 1 RepliesI have finished my database using Dreamweaver ASP VBScript and Access, the only thing left is to create the searching system. My search form works fine when posting just one filed. The results page Recordset goes as follows.
Code:
I need 7 different fields on my search form, this what I did but it doesn't work.
Parameters:
Name: MMColParam
Type: Text
Value: Request.Form("Ref")
Default value: 1
Name: MMColParam
Type: Text
Value: Request.Form("New_resale")
Default value: 1
"Price" is a special one because this is a list menu with different amounts, like 50.000, 70.000, 90.000, and so one. The idea is to make this list menu post to the result page, only to display records under or equal to the given value. less or equal > than 50.000 or 70.000, etc.
how to update fields in an Access database through VB. What I'm supposed to do subtract the quantity of the daily orders from the inventory quantity. My textbook is a little bit vague at this point, because the only way it describes updating the DB is manually through the BindingSourceNavigator. I don't want to enter it manually, I want it to subtract the quantity from the orders table.
Public Class frmMicroland
Private Sub frmMicroland_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code].....
I am using VS 2005 and MsAccess 2003. I am already having some fields in the table, and i want to add more fields from the .NET application. Is it possible to add more fields from the application to the Ms-Access Database. Also it is possible to change the order of the fields from the application?
View 1 Replies