Inventory Labels

[Building Buildings]

Hi there,

I'm trying to create an inventory file for our archive job projects. I need
to put labels on the boxes that will read Job No., Job Name, ProjMgr., Super,
Description, and the part that I'm having trouble with is the box 1 of
????(records) This will let me know how many boxes I have for that
particular project so when it comes time to shred I will know I have 1 or ???
boxes.

Can someone help me with this? Is this done in the query mode?

I would appreciate any help someone can give me.

Tina
Building Buildings

 

[ErezM via AccessMonster.com]

hi
assuming you use a report to create the labels, add 2 new textboxes to the
label structure:
set textbox1 properties as follows
controlSource="=1"
RunningSum="Over Group"
and textbox2:
controlsource=" Of " & Dsum("projID","Projects","ProjID=" & [projID])

now add a new group that will group by ProjID with no headers and footers
this will start the counting in textbox1 everytime the project is changing

so now you have textbox 1 saying "1...2...3" and textbox2 saying " Of x"

i hope it's clear enough
good luck

 

[Allen Browne]

See:
Print a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

 

[Building Buildings]

Thank you so much for your reply. I must have missed a step.

It came out =1 of project id# instead of 1 of 1,2,3 or 2 of 1,2,3. My 1
stayed at one regardless of multiple records for the same project ID # and
the of part is the ID # instead of a running number.

The below is what I typed in the controlSource.

="of" & DSum("projID","Schultze projects","projid=" & [projid])

I hope I made sense up top. This is a little difficult for me.

I tried to use the other method given by Mr. Brown but it was a little over
my head. I didn't understand the part of entering the records in the
tlbcount record manually if you only had one line item. CountID.

PLEASE HELP ME....I'm desperate for help. OH I used a query to create the
labels because I needed an archive date which I could only get thru a query
(or so I thought).
Again, thanks for your help. I do appreciate it.

hi
assuming you use a report to create the labels, add 2 new textboxes to the
label structure:
set textbox1 properties as follows
controlSource="=1"
RunningSum="Over Group"
and textbox2:
controlsource=" Of " & Dsum("projID","Projects","ProjID=" & [projID])

now add a new group that will group by ProjID with no headers and footers
this will start the counting in textbox1 everytime the project is changing

so now you have textbox 1 saying "1...2...3" and textbox2 saying " Of x"

i hope it's clear enough
good luck

Hi there,

I'm trying to create an inventory file for our archive job projects. I need
to put labels on the boxes that will read Job No., Job Name, ProjMgr., Super,
Description, and the part that I'm having trouble with is the box 1 of
????(records) This will let me know how many boxes I have for that
particular project so when it comes time to shred I will know I have 1 or ???
boxes.

Can someone help me with this? Is this done in the query mode?

I would appreciate any help someone can give me.

Tina
Building Buildings