Pls read and help me !!! (1 Viewer)

[myady02]

guys pls help me
i create a simple library system using ms access
if the student is already borrowed two (2) books then the msgbox will be notice to the student that the maximum of borrow of books is two (2)

give me a sample code or program pls

for example
i borrowed already two books then
iwill try to borrow again
then the msgbox will be pop up and says u have already borrow two books








Pls help me

 

[namliam]

That sounds very simular to a question I saw not to long ago :/

Cant seem to find it real quickly, but I know I seen this question before recently

 

[basilyos]

you should make a query and then when you want to borrow the book you should use dcount to check if there is the name of the client 2 times then msg if <2 than borrow

 

[myady02]

sir can you give me a sample program? pls help me

 

[myady02]

That sounds very simular to a question I saw not to long ago :/

Cant seem to find it real quickly, but I know I seen this question before recently

sir can u give me a sample program too?

 

[Poppa Smurf]

Try making the query as Basilyos stated in his reply. I suggest you look up how to use a query to show totals, then if you have a problem we will try and help you.

 

[myady02]

Try making the query as Basilyos stated in his reply. I suggest you look up how to use a query to show totals, then if you have a problem we will try and help you.

sir can u give me some simple examples because i dont have any idea how to start that program
pls?