Inventory Labels

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

hi
assuming you use a report to create the labels, add 2 new textboxes to the
label structu
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

Building Buildings wrote:
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

--
May all beings be happy.

Message posted via http://www.accessmonster.com

See:
Print a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Building Buildings" wrote in
message ...
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

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.
"ErezM via AccessMonster.com" wrote:

hi
assuming you use a report to create the labels, add 2 new textboxes to the
label structu
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

Building Buildings wrote:
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

--
May all beings be happy.

Message posted via http://www.accessmonster.com