UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Print A Tag, Access 2010    
 
   
rizmin
post Feb 20 2018, 01:52 AM
Post#1



Posts: 148
Joined: 10-August 17



Hi UA Nation

Good Day!

I have got a big challenge to print a tag for our final product:

We have a few types of product and the pieces per bundle is limited for transportation purpose:

We have a product Code called H100 and for this product allowed max of 72 pieces per Bundle. If we are produced 26640 Pieces mean total Number of bundles will be like 26640/72= 370 Bandles.

Then we should divided this bundle Qty to Lot qty for delivery purpose, Each Lot qty should have maximum 140 Bundles. So here we will have 2 Lots (280 Bundles) and 90 bundles.

Now each bundle should have tag contained this Lot Number and the bundle number:

Lot Number consists with 9 letters, Ex. 11802N001: (1- Plant No., 18-Running Year, 02-Running Month, N-Night Shift, 001-Serial Number); can be obtained from the production details except the Serial

Number. The serial Number should be changed for each Lot, In this case the Tag Lot Numbers for first 140 bundle:11802N001 and second 140 bundles: 11802N002 then 11802N003 for 90 bundles.

Then the bundle number should be counted respectively for each Lot No. i.e. 1 to 140 in each tag (Please see attached sample tag FYR). Once the month changed in the Lot number again the Serial Number Should be started with 001 and continue, Bundle number will follow the Lot Quantity regardless the month.

Any method in ms access can be used for this? Please advise

Thank you all
This post has been edited by rizmin: Feb 20 2018, 01:59 AM
Attached File(s)
Attached File  Tag.pdf ( 196.6K )Number of downloads: 9
 
Go to the top of the page
 
rizmin
post Feb 20 2018, 03:09 AM
Post#2



Posts: 148
Joined: 10-August 17



Hi all

In relations to the below request i have an idea to do this in this way. We can calculate the Number of bundle and the number of lot manually to print the tag

EX: for Qty 26640 Pieces the total No. of bundles will be 26640/72=370 Nos. and the Lot Qty will be three 140+140+90, So the tag can be printed manually three times.

For 1st & 2nd Lot Qty the Bundle No will be 1 to 140 and the Third will be 1 to 90.

What I need here is, If i use input box to print the tag, the Lot Qty & the bundle Number range will be enter manually the tag should be print for each lot Qty at once? Ex I will enter Lot Number like 11802N001 in the first input box and then the no .of bundle like 140, Then I need 140 Tags with same Lot Number but the bundle Number to be continued 1 to 140 in each tag, I will do this till complete the three Lot Qty.

How I can do it in this way?

Please help me someone

Thank you all
This post has been edited by rizmin: Feb 20 2018, 03:09 AM
Go to the top of the page
 
rizmin
post Feb 21 2018, 01:31 AM
Post#3



Posts: 148
Joined: 10-August 17



I All

I have done this already,,, pullhair.gif pullhair.gif

Thank you all
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    24th June 2018 - 02:28 AM