Hello everyone..
Im Lost, totally lost. Maybe some 1 can show me the right path and tell its possible or not what im doing now.
etc.:
Simple text:
i have cell A (named "Pallets") and cell B (named "quantity_on_pallet")
so 1st question:
its possible to add extra entry in form if Cell A and Cell B are with values and i need add another value for different numbers like cell C and cell D, ..
Life moment: im working at warehouse/stores and we are using access database to register all the pallets in and out.
So its simple , sometimes suppliers send 5 pallets total of lamps 11.000,
and 3 pallets are with 3000 lamps on it, 1 pallet 800, 1 pallet 1200 lamps on it.
So when i add to my database quantity of lamps : 11000 . and other required info . and created reports for that , l press button than open report view with customised table on it with all the details tooked from main form. but its ok if only equal quantities cames on pallets so i just make x same prints and i have what i need , but sometimes it cames in 5 pallets in different quantities on each, i cant enter the value every time , i want to make something like:
(cell A = pallets. Cell D = quantity_lamps on pallets)
b=Pallets, e= quantity
c= pallets, f= quantity)
so
If A<1, then print 1 copy of report with null values in report text box named Pallet quantity
else if a>1 then print A* times copies with value D linked on each A copy in cell named Pallet quantity (report).
and if B<1 then close report window
else if B>1 then print B* times copies with value E linked on each B copy in cell named Pallet quantity (report)
and if C<1 then close report window
else if C>1 then print C*times copies with value F linked on each C copy in cell named Pallet quantity (report)
then close report window.
so i would like to ask its possible to make this with 1 single click?
Like i got 500 lamps on 2 pallets 300+200 so i just enter data to my A and B cells with 1 and 1 and assign quantities in D and E with 300 and 200 and i get 2 same reports printed with my extra values added 300 and 200 in specified text box in report. and then if 3rd cell is less than 1 so it close report window.?
i hope ive explained . if not then im doomed L(
thank you in advance.
RZ
Im Lost, totally lost. Maybe some 1 can show me the right path and tell its possible or not what im doing now.
etc.:
Simple text:
i have cell A (named "Pallets") and cell B (named "quantity_on_pallet")
so 1st question:
its possible to add extra entry in form if Cell A and Cell B are with values and i need add another value for different numbers like cell C and cell D, ..
Life moment: im working at warehouse/stores and we are using access database to register all the pallets in and out.
So its simple , sometimes suppliers send 5 pallets total of lamps 11.000,
and 3 pallets are with 3000 lamps on it, 1 pallet 800, 1 pallet 1200 lamps on it.
So when i add to my database quantity of lamps : 11000 . and other required info . and created reports for that , l press button than open report view with customised table on it with all the details tooked from main form. but its ok if only equal quantities cames on pallets so i just make x same prints and i have what i need , but sometimes it cames in 5 pallets in different quantities on each, i cant enter the value every time , i want to make something like:
(cell A = pallets. Cell D = quantity_lamps on pallets)
b=Pallets, e= quantity
c= pallets, f= quantity)
so
If A<1, then print 1 copy of report with null values in report text box named Pallet quantity
else if a>1 then print A* times copies with value D linked on each A copy in cell named Pallet quantity (report).
and if B<1 then close report window
else if B>1 then print B* times copies with value E linked on each B copy in cell named Pallet quantity (report)
and if C<1 then close report window
else if C>1 then print C*times copies with value F linked on each C copy in cell named Pallet quantity (report)
then close report window.
so i would like to ask its possible to make this with 1 single click?
Like i got 500 lamps on 2 pallets 300+200 so i just enter data to my A and B cells with 1 and 1 and assign quantities in D and E with 300 and 200 and i get 2 same reports printed with my extra values added 300 and 200 in specified text box in report. and then if 3rd cell is less than 1 so it close report window.?
i hope ive explained . if not then im doomed L(
thank you in advance.
RZ