Marking Boxes that have been returned

%3CLINGO-SUB%20id%3D%22lingo-sub-1055730%22%20slang%3D%22en-US%22%3EMarking%20Boxes%20that%20have%20been%20returned%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1055730%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20am%20trying%20to%20develop%20an%20MS%20Access%20database%20for%20a%20company.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThe%20company%20rent's%20boxes%20to%20customers.%20Every%20box%20has%20a%20box%20number.%20The%20company%20wants%20to%20build%20a%20track%20and%20trace%20tool%20in%20Access%20to%20see%20which%20boxes%20are%20rented%20and%20which%20boxes%20are%20not.%20Also%20the%20duration%20of%20the%20rental%20period%20is%20important.%20Therefor%20the%20following%20data%20will%20be%20registered%3A%20order%20number%2C%20box%20numbers%2C%20delivery%20date%20and%20return%20date.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20am%20trying%20to%20create%20an%20automatic%20mark%20process%20for%20the%20boxes%20that%20have%20been%20returned.%20In%20practice%20I%20am%20trying%20to%20create%20the%20following%3A%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E-%20A%20box%20is%20rented%20to%20a%20customer.%3CBR%20%2F%3E-%20The%20order%20number%2C%20box%20number%20and%20delivery%20date%20are%20registered%20in%20a%20table%20and%20filled%20in%20via%20a%20form.%3CBR%20%2F%3E-%20A%20box%20comes%20back%20and%20the%20box%20number%20and%20the%20return%20date%20are%20registered%20in%20a%20table%20via%20a%20form.%3CBR%20%2F%3E-%20Now%20I%20want%20Access%20to%20recognize%20the%20box%20number%20that%20has%20come%20back%20and%20mark%20it%20in%20the%20table.%20(so%20for%20example%20make%20the%20record%20green%20or%20simply%20set%20the%20value%20of%20a%20specific%20field%20to%20YES).%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThe%20goal%20of%20this%2C%20is%20that%20when%20you%20open%20the%20table%2C%20you%20very%20easily%20can%20check%20which%20boxes%20have%20been%20returned%20and%20which%20boxes%20still%20need%20to%20be%20returned.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EIf%20someone%20has%20a%20solution%20for%20this%20that%20would%20be%20really%20great!%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EKind%20regards%2C%3CBR%20%2F%3EDimitri%20Diboune%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1055730%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1065484%22%20slang%3D%22en-US%22%3ERe%3A%20Marking%20Boxes%20that%20have%20been%20returned%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1065484%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416383%22%20target%3D%22_blank%22%3E%40Dimitri1220%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20you%20familiar%20with%20VBA%20code%3F%20If%20you%20are%20you%20could%20easily%20grab%20the%20information%20that%20is%20entered%20in%20the%20form%20when%20the%20box%20is%20returned%20and%20make%20any%20changes%20that%20you%20need%20in%20another%20table%20or%20form.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hello everyone,


I am trying to develop an MS Access database for a company.


The company rent's boxes to customers. Every box has a box number. The company wants to build a track and trace tool in Access to see which boxes are rented and which boxes are not. Also the duration of the rental period is important. Therefor the following data will be registered: order number, box numbers, delivery date and return date.


I am trying to create an automatic mark process for the boxes that have been returned. In practice I am trying to create the following:


- A box is rented to a customer.
- The order number, box number and delivery date are registered in a table and filled in via a form.
- A box comes back and the box number and the return date are registered in a table via a form.
- Now I want Access to recognize the box number that has come back and mark it in the table. (so for example make the record green or simply set the value of a specific field to YES).


The goal of this, is that when you open the table, you very easily can check which boxes have been returned and which boxes still need to be returned.


If someone has a solution for this that would be really great!


Kind regards,
Dimitri Diboune

1 Reply
Highlighted

@Dimitri1220 

 

Are you familiar with VBA code? If you are you could easily grab the information that is entered in the form when the box is returned and make any changes that you need in another table or form.