I have an access DB with 3 columns, ID#(Primary Key), Minutes, and Profit/Loss. I'm using the Total feature in access which adds a Row 'Total' to the bottom and shows the sums. How would I get the sum from the 'Minutes' column, 'Total' row, and get that to show in a text box (txt002004Min) ?
Imports System.Data.OleDb
Public Class Form13
Dim cn As OleDbConnection
[code]......
i want to make crystal report of profit and loss statement i have a column of "vr_type" and there are 4 types in it "sale invoice", purchase invoice" now i want that put a 4 formula s where i select that "sum (vr_detail.debit) where vr_detail.vr_type} sale invoice it make Sum of al these types so kindly tell me what formula i should use to get the result in simply i want sum of sale,sum of purchase,sum of expense?
View 2 Replies[Code]....
It is returning all the columns by id. I need only the primary key. When I add the following line it is empty: WHERE SIK.indid = 1 Why is that? Is there other ways to do the same thing and working? Since I am in the rush
I have been working on a web based report from an existing client/server apps mssql database. I have a working query, that pulls this information together from many tables, and can provide the query and a result set if necessary.
The results currently are similar to this.
ID | Name1 | Date1 | Veh | PO | Stops
_________________________________________
1 | Bob 1 | 12/1 | Car | 1234 | 4
2 | Sam | 12/3 | Car2 | 2245 | 3
2 | Joe | 12/4 | Van1 | 5568 | 2
[Code]....
I have a table with a multiple columns (two) primary key. I get an error on tableadapter.Update .How can I resolve that??
View 3 RepliesI am using the following code to alter an table imported from an Excel spreadsheet
Dim SQL As String = "ALTER TABLE receipts ADD payee integer, account integer, category integer, reconciled boolean"
Dim dataread As New OleDb.OleDbCommand()
dataread.Connection = Connection1
[code]....
Both ExecuteNonQuery() actions yields the exception message {"Syntax error in field definition."}The error message does not happen with the first if the boolean column is not there (I tried Tes/No as a definition - but that also failed.The second query to modify the ID column from autonumber to integer I assume fails because it is a Primary KeyHas?
I have a VB.net application that has three project in it. Two of the project are DLL with references in the primary project. I have a public Model "RegSaveGet" in the primary project listed below. When I look for the namespace for the module from one of the DLL projects I can not see it. I want to use this module from the two DLL projects. I can only see it from the primary project.
[Code]...
I want to check in an Access Database if a primary key exists using VB.Net & OleDb:
By primary key name
By number of fields as primary keys
I have a database program, and the first row of the table i'm inserting into is a primary key, just a number that increments by one each row. This is my SQL statement,
SQL = "INSERT INTO Squad VALUES('" & (NUMBER) & "','" & txtfirstname.Text & "','" & txtsurname.Text & "','" & txtdob.Text & "','" & cbxposition.SelectedItem & "','" & lblhiddenid.Text & "')"
I am in the process of creating a system using VB in Microsoft Visual Studio 2008. The system which I am creating is connected to an Access database via a tableadapter.Currently, I am coding a form for a table called Employee and this form allows the user to create a new employee, edit or delete an existing employee. Editing and deleting an existing employee works fine but adding a new employee is causing me trouble. When I specify an employeeID (this is the primary key), the declared value is stored appropriately in memory and it also displays in the form, however once I save the new employee to the database, the employeeID always defaults to 0 for some unknown reason. So, the record which I've just entered has a primary key of 0 regardless of what the the primary key should be.
The employeeID is declared as an integer and the value is obtained by getting the employeeID of the last record in the table and adding 1 onto it. I've also tried hard coding the employeeID and a specific number, but this does not make any diffence. I've reused the code from another part of the system which works fine before, but why it suddenly doesn't work is baffling me. The employeeID field in Access is a long integer.
[Code]...
I'm using vb2005express for forms (front-end) and ms access database. I have a form with a master-detail setup. The problem I'm having is that when I set the primary key column to autonumber, I don't get the pk value generated in ms access database into my master datatable in forms when a new record is created. Then I tried setting the AutoIncreament to True in the pk column of the datatable in my dataset (forms). This generates a number in my pk column but its not the number generated in the database (since I think because the pk column is still set to AutoNumber). So I change the field property of my pk to Number in the access database and on my dataset (forms), i still have AutoIncrement to True.
This works okay since what it seems to be doing is getting the max value for the pk column when the datatable is filled upon form load. The problem now is that I normally don't do tableadapter.fill(datatable) at form load since I think there would be a performance issue if record counts around millions. What happens now is that when I create a new record, the pk generated is still 1 which will cause duplicate violation when saving to database. I'm not quite familiar with access features but in oracle, what I do is I create a sequence in database then I create a function that gets the next value of the sequence. Then at form load I set the datatable.column.default_value = get_sequence. How do I do this in ms access?
i am wondering if it is possible to get the source code for the following:
1. use vb.net code to set on/off primary key when connected to Access database
2. update a particular data.
for e.g: hostname: AES-19 *use source code to check data in Microsoft Access database
if hostname is new, insert into Access. if hostname already exist, update into Access
*so that i will not have duplicate data in Access.
[Code]...
MS-Access Database
Table: myTable
Field1: ID (COUNTER, which is autoincrement in Access)
Field2: SURNAME (VARCHAR)
Field3: NAME (VARCHAR)
I want to get ID returned, whenever I insert a row. Is there a way? (I am using VB.Net)
EDIT: Solution using SELECT @@IDENTITY
'Execute insert statement and return identity (autoincrement ID field)
Public Function executeInsertGetIdentity(ByVal insertStatement As String) As Integer
' Execute insert
[Code]....
I have noticed that whilst in the past using MS Access you could have a primary key field on a form and have it not visible. You could still use it for Dlookups etc using the value in the field no problem even though it is not visible. In Vb if i hide a textbox that is bound to a PK field in a datasource and try to use its value in code i get an error. Making the field visible again prevents the error. My goal is to use a PK bound textbox not visible to the user but still read its contents.
Also, what is the equivalent of a simple DLOOKUP in VS2010? EG. You have the PK and want to know, say 3 other pieces of information from the record based upon the PK you have.
I have managed to successfully create a logon page and have created a form to insert data into one of my tables using text boxes and a "Save" button, however the first field in the table is the named "CustomerID" and is set to Autonumber, this is the primary key of the table. If I enter a record into the table in Access it automatically enters the next valid ID however when I can't seem to make this happen when entering data via my VB form!
View 7 RepliesWhat's the syntax for an Update query for a table without a primary key?Disclaimer: Frustratingly, adding a primary key is not an option. My program is a small program in a much larger system with poor data management. My development time does not include rewriting the other software.
Note: The database is Microsoft Access.
Note: Similar to: Excel: TableAdapter UpdateCommand for table without primary key
UPDATE: Am I correct in saying, "If the table in the database has no explicit primary key, then there can be no valid TableAdapter UpdateCommand?"
On a client i have an anonymous list containing a multi-column primary key previously selected from the DB.Then i need to select all the records from the DB that equals the primary key list i have stored in the memory.[code]
View 1 RepliesHow i can import row from TABLE1 to TABLE2 without primary keyfield or adding correct value to primary key
i tried with two different codes, but result is same, it says: "In the column "Key"a constraint on the uniqueness.[code]...
I'm working on a problem for my class, I've been stuck on this for hours so I've determined I would post here
I need the program to subtract 20% when a non profit check box is ticked (chkNP in my case)
I have the rest of the app functional:
CODE:
Basically the application is a tool or determining the cost of packages from an ISP
Package A: 10 hr access. $9.95 mo. $2 each additional hour
Package B: 20 hr access $14.95 $1 each hour
package C : unlimited. $19.95 a mo
So basically the app needs to apply a %20 discount to each of these when that checkbox is ticked
When I add a new row to an access database, I would like the primary key to be automatically incremented and entered. I've got this to work using a sql database, but it doesn't work with access for some reason. The following code works if I give the code a value for "@key" which is my primary key column. If I leave it out I get the error "Number of query values and destination fields are not the same". I don't want to have to supply the primary key, I want it to generate automatically.
[Code]...
In the database the primary key is type "AutoNumber". Does anyone know what I'm doing wrong?
when i will enter form no. in the text box this should check the on the lost focus event either this form no. is already exsist or not.if exist show msgbox?
View 1 RepliesI am looking for formula that is accurate in converting Minutes to Decimal Minutes i.e 30 minutes is 50 Minutes in Decimals so 1.3 hours is 1.50 and not 1.5 i have used Minutes/60 but it is not accurate as some times i have to Multiply the result by 100 and some time 1000 to get correct results based on single digit Try 1/60, 10/60 99/60 or 100/60.What would be the most efficient and correct way to Convert the time into Minutes ?
View 10 RepliesI had a large application that I needed to develop into two separate applications with different customer needs. I created a new VB.Net application and copied/imported all the forms and classes into the new application. The new application works but, for some reason all the forms have lost their 3d look, all the textboxes have a flat look now in the new application. It is as if I have lost a setting somewhere that controls the 3d look of the controls. I have checked the properties of each control and they still have the 3d option selected, and cannot see what else could be changed to get the 3d look back.
View 2 RepliesI need to compute the percentage of games won and games lost. I keep getting errors and it's driving me up a wall. I've changed my code so many times that I don't really remember what it was like when I started.
Private Sub btnPercentage_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnPercentage.Click
Dim team As String
[Code].....
I m using vs2008 with vb and sqlserver. I just attached a .sdf database file to my project. There is a form to insert data in products table and a dgv to show that data. Everything is working fine, i inserted the data and dgv is also showing the data. But when i tried to see that data from server explorer, thr is no data, table is blank. Then again when i run my project thr is no data in DGV also. So problem is that when i entered the data and retrieve back the data in dgv,evrythng is fine,but when i tried to see my data from server explorer, data is lost. Why data is not comtted to my .sdf ?
View 4 RepliesI trying to create application that can read loss bmp with bmp constructor, what I mean loss is bmp without header, here the sample of loss bmp (zip is including with original bmp):
Download(you can see the different by comparing the original bmp and loss bmp with hex editor, the different is loss bmp don't have 54 bytes header bmp) Height of image is 126 px and width image is 45 px
my question is how I can preview that loss bmp in picture box? someone of my friend say, its need BMP Constructor to preview bmp properly but he doesn't know the code, please give me the code..
I have an application that provides a countdown for 60 minutes and I'm currently using the win form timer and it updates some labels and a progressbar. Now I have to change this to be a countdown for 360 minutes. Will the win form timer be sufficient or should I implement a Timers.Timer instead?
View 6 Repliesi have an ACCESS database with 3 columns. I establish the connection with the VB 2008 Express and put the data in the form but i don't know how to add the text of a textbox in the database.
View 5 Replieshow do i get info from 2 different columns in an Access database and put them together in a drop down menu. (i know how to get data so that i can see it in just a textbox but i dont know how to put 2 data together and then display in a drop down.
another question is how do i save info that has been changed back into the access database i got it from
last question- how do i make a textbox only take numbers
I am Working Windows Appl .Net08.My DB is Access Db.The below image is from Access DB only.In the image the table called Contacts having one of the column called 'ContactMedium'. In this Column having values like 'Mobile' , 'email'.Now i want to saperate these values and create new columns in the same table.How can make these values as a new columns ?If i create Crosstab Query it giving error like Value type is not Aggr.
View 12 Replies
