Search results

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...

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...

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...

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...

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...

Hi, have created a form that contains my customer details. On this form I have placed a command button to open another form(already created) so that I can select items for them to take out. I want this new form to load in with the CustomerID from the the previous form. When making the command...