Ziyoda, thats not what I meant. I already created an access database and make its 1 of the columns as primary key and assign autonumber as its property. What I am trying to do is to get the newly generated number of the autonumber field after I execute an Insert query from vb.net
How can I get the newly generated number in autonumber field of the current insert query in MS ACCESS? I use Visual Studio .Net 2003 and MS Access as database.
Thanks
This is what Im trying to do
How to create reports in crystal reports with multiple data from two interelated table?
e.g.
Table1: Customer
CustomerID Name
1 Jebb Domingo
2 Jennylyn Corpuz
Table2: Account
AccountID CustomerID Date Debit Credit...
...table only.
Here's the code:
Dim Rpt As New CrystalReport1()
dsStudentAccount.Clear()
daStudentAccount.SelectCommand.CommandText = "SELECT * FROM student " & _
"INNER JOIN account ON student.StudentNumber = account.StudentNumber"
daStudentAccount.Fill(dsStudentAccount)...
Hi! good day, I would like to ask if how can I get the SUM of the numbers that a specific column in a table contains? I use MS Access Database. Is there a built-in function in MS Access query that I can use?
Thank you and God Bless
How can I know if the present date is less than or greater than the specified date?
For example:
July 1, 2007 > August 16, 2007
How can I add days to a date?
For example:
July 1, 2007 + 24 days = July 25, 2007
I would like to ask how to close an active form from its own command button. I have a main form then from there I can open second form, the second form has a button to close itself. What code should I placed in the second form's button click event to close itself (second form)
How do I insert data to multiple related tables
How can I insert data to multiple related tables in access database using vb.net? For example, I have two tables that are related to each other namely:
1. Group table
2. Member table
all members in Member Table are belong to a specific group in...
Yeah thats what I mean SphyNxXx, but?
Yeah SphyNxXx, thats what i mean. Can i ask you another question? How can I insert data to multiple related tables in access database using vb.net? For example, I have two tables that are related to each other namely:
1. Group table
2. Member table
all...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.