Recent content by Knoxville

Just got it. Thanks again Jerry! Knoxville

Thanks Jerry thats great. I'm running 97 and e-mail address is: paul.fairy@virgin.net

Thanks Jerry. Your idea sounds much better and I have created the tables. However being a novice access user I am having difficulty implementing the forms you suggested. Could you please give a more descriptive explanation of how to create them. Any help would be appriciated as the idea...

Thanks for your advice Jerry, I will trry your idea out and post back if I need any more help. Knoxville

Still having problems! My form name is frmBorrowDetails and this has a subform called subfrmBorrowDetails. In the subform there are fields such as CustomerID, BookID, Borrowed(yes/no), BorrowedID, StartDate, EndDate. I have made two queries. qryDelete has BorrowedID as its field and I have put...

My database requires me to keep a record of items that have become damaged. To do this I have made a form that allows me to select an item from a combo box(based on a query). After selecting the item from the combo box I then enter the item as being damaged by the use of a lookup wizard(wizard...

Thanks Jerry Stoner but this is not quite what I need. The problem I have is that my first query 'qryDelete' asks the user to specify which record to delete. I want my second query 'qryUpdate' to perform the its operation (unticking a box named Borrowed) upon the record specified in the first...

Problem solved, thanks!

I have now created two queries. First is a delete query that has has unique BorrowerID in its criteria. This allows the user to select which to delete. I have also made an update query to update the items borrowed when the delete query is run. I want to run these queries at the same time, so...

Still not working. What I need is a code that says something like this: If the borrowed box is ticked then the availible box is unavailible on a form named frmItemDetails.

I have a problem. I have built a database but now changing I to make it more efficient. In my old database I had Borrowed(tick box) and availible (tick box). I had the following code so that when the Borrowed was ticked then the availible tick box was unavailible. If Me.Borrowed.Value = True...

The unique field would be the BorrowerID, what do I put in the query criteria?

I an using a delete query to delete items borrowed by customers in a sub form. However the query I have made deletes all the borrowed items belonging to that customer in the sub form. I want to be able to delete the borrowed items individualy as they will be returned at different times. How is...

Cheers Mitch_____W!

I have a subform that includes StartDate and EndDate. In this subform I want the EndDate to be automatically calculated when I enter the StartDate. I understand an update query will do this and I have made one with the following code, DateAdd("d",21,[StartDate]) How do I go about connecting...