Home

multiple entry's in 1 acces form box

%3CLINGO-SUB%20id%3D%22lingo-sub-879340%22%20slang%3D%22en-US%22%3Emultiple%20entry's%20in%201%20acces%20form%20box%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-879340%22%20slang%3D%22en-US%22%3E%3CP%3Ehello!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20develop%20an%20MS%20Acces%20database%20for%20a%20company.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EThe%20company%20rent's%20boxes%20to%20customers.%20Every%20box%20has%20a%20box%20number.%20The%20company%20wants%20to%20register%20which%20boxes%20will%20return%20with%20delay.%20Therefor%20the%20following%20data%20will%20be%20registered%3A%20order%20number%2C%20box%20numbers%2C%20delivery%20date%20and%20return%20date.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EIn%20order%20to%20fill%20in%20the%20data%2C%20i%20am%20trying%20to%20create%20a%20form.%20I%20want%20the%20form%20to%20have%204%20fill%20in%20cells.%20cell%201%3A%20order%20number%2C%20cell%202%3A%20box%20numbers%2C%20cell%203%3A%20delivery%20date%20and%20cell%204%3A%20return%20date.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EMy%20question%20is%3A%20If%20for%20example%205%20boxes%20are%20rented%20to%201%20customer%2C%20is%20it%20possible%20to%20fill%20in%20multiple%20box%20numbers%20in%20just%201%20form%20cell%20in%20such%20a%20way%20that%20all%20the%20box%20numbers%20are%20registered%20in%20different%20cells%20in%20the%20database.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EIf%20someone%20has%20a%20solution%20for%20this%20that%20would%20be%20really%20great!%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EKind%20regards%2C%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EDimitri%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-879340%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-880793%22%20slang%3D%22en-US%22%3ERe%3A%20multiple%20entry's%20in%201%20acces%20form%20box%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-880793%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%22Registering%22%20in%20a%20single%20text%20box%20is%20a%20recipe%20for%20error...you%20missed%20a%20space...you%20made%20a%20typo...whatever.%3C%2FP%3E%3CP%3EMark%20each%20and%20every%20box%20individually%20and%20use%20a%20combobox%20in%20a%20continuous%20subform%20to%20mark%20each%20and%20every%20box%20you%20rent.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-882185%22%20slang%3D%22en-US%22%3ERe%3A%20multiple%20entry's%20in%201%20acces%20form%20box%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-882185%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F401564%22%20target%3D%22_blank%22%3E%40tsgiannis%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20reply!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20pretty%20new%20to%20Acces%20so%20I%20had%20to%20research%20your%20suggestion.%20Creating%20a%20combobox%20on%20a%20continues%20subform%20is%20definitely%20something%20I%20will%20use%20for%20this%20assignment.%20Thank%20you%20for%20pointing%20me%20in%20that%20direction!%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EI%20am%20however%2C%20still%20struggling%20with%20something%3A%20(it%20could%20also%20be%20that%20I%20did%20not%20understand%20your%20reply%20correctly).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20make%20a%20database%20in%20which%20an%20order%20number%2C%20multiple%20box%20numbers%2C%20the%20delivery%20date%20and%20the%20return%20date%20are%20registered.%20In%20practice%20I%20am%20trying%20to%20create%20the%20following%20process%3A%20A%20worker%20will%20open%20access%20and%20open%20the%20form.%20He%20will%20then%20fill%20in%20the%20order%20number%20in%20the%20first%20textbox.%20After%20that%20the%20worker%20has%20to%20fill%20in%20multiple%20box%20numbers.%20And%20after%20that%20he%20has%20to%20fill%20in%20the%20delivery%20date.%20(the%20return%20date%20is%20still%20unknown%20at%20that%20moment).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAn%20important%20factor%2C%20is%20that%20all%20box%20numbers%20are%20registered%20in%20a%20separate%20textbox%20in%20the%20database.%20So%20what%20I%20am%20trying%20to%20make%20is%20a%20form%2C%20in%20which%20a%20worker%20can%20type%20a%20box%20number%2C%20then%20press%20enter%20and%20then%20type%20another%20box%20number%20in%20the%20same%20textbox.%20So%20that%20after%20the%20worker%20has%20registered%20al%20box%20numbers%2C%20he%20can%20then%20fill%20in%20the%20delivery%20date.%20(maybe%20good%20to%20mention%20is%2C%20that%20the%20boxes%20that%20are%20rented%20are%20large%20and%20are%20located%20at%20different%20location%20in%20the%20warehouse%2C%20therefore%20the%20worker%20will%20walk%20to%20all%20the%20boxes%20that%20are%20rented%20to%201%20customer%20and%20use%20a%20portable%20scanner%20to%20get%20the%20box%20numbers%20in%20acces.)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20enclosed%20two%20photos.%201%20of%20how%20I%20want%20the%20database%20to%20look%20after%20the%20data%20is%20filled%20in%20via%20the%20form.%20And%201%20photo%20on%20how%20I%20want%20the%20form%20to%20look.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20explanation%20is%20clear%20enough%20for%20you%20to%20be%20able%20to%20help%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20have%20any%20ideas%20on%20how%20I%20can%20create%20this%2C%20or%20have%20any%20alternative%20ideas%20I%20would%20be%20very%20very%20thankfull!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ekind%20regards%2C%3C%2FP%3E%3CP%3EDimitri%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F134100i477AE714B7FACFAF%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22database.png%22%20title%3D%22database.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20945px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F134101i25AD63C1E3CABF58%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22form.png%22%20title%3D%22form.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-885109%22%20slang%3D%22en-US%22%3ERe%3A%20multiple%20entry's%20in%201%20acces%20form%20box%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-885109%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%3BSince%20my%20description%20left%20some%20%22dark%20areas%22%20here%20some%20pics%20for%20explaining%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1st%20set%20Table%20Design%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20800px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F134877i43147DDD19C080E7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Dimitry01.jpg%22%20title%3D%22Dimitry01.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E2nd%20a%20view%20to%20the%20form%2Fsubform%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F134878i423BCEF32B5308E5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Dimitry02.jpg%22%20title%3D%22Dimitry02.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-888043%22%20slang%3D%22en-US%22%3ERe%3A%20multiple%20entry's%20in%201%20acces%20form%20box%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-888043%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F401564%22%20target%3D%22_blank%22%3E%40tsgiannis%3C%2FA%3Ethank%20you%20very%20much!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Dimitri1220
Occasional Contributor

hello!

 

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

The company rent's boxes to customers. Every box has a box number. The company wants to register which boxes will return with delay. Therefor the following data will be registered: order number, box numbers, delivery date and return date.

In order to fill in the data, i am trying to create a form. I want the form to have 4 fill in cells. cell 1: order number, cell 2: box numbers, cell 3: delivery date and cell 4: return date.

My question is: If for example 5 boxes are rented to 1 customer, is it possible to fill in multiple box numbers in just 1 form cell in such a way that all the box numbers are registered in different cells in the database.

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

Kind regards,

Dimitri

 

 

4 Replies

@Dimitri1220 "Registering" in a single text box is a recipe for error...you missed a space...you made a typo...whatever.

Mark each and every box individually and use a combobox in a continuous subform to mark each and every box you rent.

Hello @tsgiannis,

 

Thank you for your reply!

 

I am pretty new to Acces so I had to research your suggestion. Creating a combobox on a continues subform is definitely something I will use for this assignment. Thank you for pointing me in that direction!

I am however, still struggling with something: (it could also be that I did not understand your reply correctly).

 

I am trying to make a database in which an order number, multiple box numbers, the delivery date and the return date are registered. In practice I am trying to create the following process: A worker will open access and open the form. He will then fill in the order number in the first textbox. After that the worker has to fill in multiple box numbers. And after that he has to fill in the delivery date. (the return date is still unknown at that moment). 

 

An important factor, is that all box numbers are registered in a separate textbox in the database. So what I am trying to make is a form, in which a worker can type a box number, then press enter and then type another box number in the same textbox. So that after the worker has registered al box numbers, he can then fill in the delivery date. (maybe good to mention is, that the boxes that are rented are large and are located at different location in the warehouse, therefore the worker will walk to all the boxes that are rented to 1 customer and use a portable scanner to get the box numbers in acces.)

 

I also enclosed two photos. 1 of how I want the database to look after the data is filled in via the form. And 1 photo on how I want the form to look. 

 

I hope this explanation is clear enough for you to be able to help me.

 

If you have any ideas on how I can create this, or have any alternative ideas I would be very very thankfull!

 

kind regards,

Dimitri

database.pngform.png

@Dimitri1220 Since my description left some "dark areas" here some pics for explaining

 

1st set Table Design

Dimitry01.jpg

2nd a view to the form/subform

Dimitry02.jpg

 

@tsgiannisthank you very much!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies