Search results

What I need to do is count records based on 2 criteria(member_id and returned date is null). I have set the below code in the after update event on the member_id field and the result will show in a separte unbound text box. Private Sub Member_id_AfterUpdate() Dim LTotal As Long LTotal =...

All I am trying to do is allow the user to input a code into a an unbound text box, which will then be saved to a table field. After the user had retrieved the member's details via the memmber id. As far as I can tell it must be done via SQL and I am using VB to do this. Anyway here is my...

A piece of code I have ceated refuses to work on a form on my computer only, which I thought was down to my lack of VB knoweldge. A friend who works in programming has had a look at it and he can get the code working on his computer. But If he sends me the same file back(with the same code)...

Hi, I am currently trying to develop a database based on a library system(as part of a college assignment). The problem, I am having at the moment is regarding the customer returning a book. I would like to create a form which allows the user to input the book's ASC number into a text box...

This problem has become the bain of my life, I just cant find a way to resolve it - it should be so bloody simple. Basically what should happen is; the user inputs the library book ascension number which returns all the data of the book included the amount time the book is allowed to be...

I'm currently trying to build a library type DB as part of a college course. The part I cant get to work I thought would be fairly simple, but whatever I try doesnt work. Anyhow I have field named(loan date) which is preset as todays date and then another field which holds the amount of time...