How can i have the running sum for the recordset as we get in Access?
In access report i can insert a textbox and say controlsource=1 and running sum propery at overall so i get the serial no for all the records in that recordset
i want the same in VB
can anyone help?
if i use
Data1.recordset.Bookmark = data1.recordset.lastmodified it woks
what changes will have to make if i want the same effect for ADODC control Please help.
I am working on a Visual Basic Database project the Database has two tables as
1) tblBillMaster
a)BillNo
b)BillDate
c)CustomerID (Lookup)
2) tblCustomer
a)CustomerID
b)Name
c)Address
when I add new record to the BillMaster table I am using the CustomerID from Customer table
What I...
I have a BillMaster table which has a lookup field (combobox) which fills the custemerID field from Customer table. If existing costemer is there I don't have to type the name, address etc again and it works fine
But if it is a new customer then how can i add new customer from the same form...
I have a dbgrid to add new records and one of the column has one-to-many relationship from other table
I have inseted a button to the column
Can someone give example code to populate the column from other table so that clicking the button will show all the records from that table and user can...
Thank you for the reply
I am beginer with VB and database my project will run on a stand alone machine and no server is needed
Employee will have a unique ID i want to use that in the other table as one-to-many type relation and save the shift say employee number 309 on 06/08/2001 worked in...
Sorry for not being specific.
I have Employees table and i have to asign all the employees of that table to a specific shift e.g.morning,afternoon or night and these shift only change after a six day week. Insteed of asigning the shift daily which i do now i want to say the program that a...
I am using access database in my VB project I can update shift shedule for an employee on daily basis I would like to know wheather it is possible to update six records (for whole week) so that i can save my time for next 5 days I tried the from date and to date values but i can not get data in...
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.