Hello developers, I would like your assistant, I m developing a system using visual studio 2010 express with access 2007 database. I have a problem of how I can make formula of calculation that has to calculate the fine of members who have delayed with the books.
My database has many table but the tables in charges of that are 3 tables. the first table is called lending_table it has id,loan_type(long or short loan),loan_period, loan_date, return_date, overdue_days, member_id, address_id, title(for lending table I've already did the query where the overdue_days are calculated) the second table is return_table that has id, member_id,address_id, book_id,Title, Loan_date,return_date,charge(this will be charge of a member in two categories for long 10000 shillings and for short loan 3000 per day), returned( just yes or no) and amount_id
the last table is amount_table that has id,member_id, Address_id,Amount(I wanted this to hold the amount charged by a member I tried to calculate using the logic below
overdue_days * charge equal to amount, I did that in query but that did not work, but exactly that what I wanted to perform) and return_id.
I was even suggest if possible long loan if there is a way It can has the value of 10 000 shillings automatically without typing numbers of 10 0000, and like wise short loan for 3 000. I need your help.
My second question it's about how I can call Query table in vb.net using data bound control code not ADO.net control because I tried as I always do for others tables but it failed to be update, so that I can save something on it, the vb.net worn message is telling that is not a member of the database.
The third question is how I can make query so that, when someone lend a book that reduce a number of it copies of the books, when return back increase copies of the books, that is all about queries in access database.
And then I would like to know how I can make worm message in vb.net form for any field to be filled with a record, how to do that through properties of text box? please I want your help.
I hope you will try the best to help me and God will also bless you.
thank u
Submit an article or tip