Re: Labels

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Does the query show a record for each label (not just a record for each or
your original records)?

Yes: Then set the RecordSource of the report to this query.

No: Switch the query to SQL View (View menu in query design), copy the SQL
statement and paste it here.

--
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.

"Ken" <Ken@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1D6F85B9-6654-440C-A73A-940282416E36@xxxxxxxxxxxxxxxx
Hi Allen,
I created the table, entered 40 in the only record and added the table and
my label data table to the query. I set the record source in the report
but
still only get one label. In my query, I set the criteria so I can select
the
label to print and entered set the tblCount field to <=40.

I apparently missed something in the translation. Do you have a clue as to
what that may be? Thanks for your help.

Ken
"Allen Browne" wrote:

Create a new table with just one field named (say) CountID, type Number.
Mark it as primary key. Save the table as tblCount.

Enter 40 records in the table (1 to 40.)

Create a query that has the table you want (the data for the labels) as
well
as tblCount. There must be no line joining the 2 tables in the upper pane
of
the query design window. Since there is no join, you get every possible
combination, i.e. 40 rows for each label. Save the query.

Open the report in design view, and change its RecordSource property to
this
new query.

The report now prints 40 of every label. If you want 40 of one label, you
can add criteria to the query. If you want fewer labels, type the number
you
want in the Criteria under the tblCount.CountID field in the grid.

"Ken" <Ken@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4ADD5BF5-23CD-474C-9709-BE2F961C05F0@xxxxxxxxxxxxxxxx

I have a database to print labels and all is well with that as long as
I
want to print all the labels. A page of labels is 4 wide and 10 down
the
page. I also want to be able to query the database, select a label and
print
a page of labels of that one item.

Problem - How do I set up the report, using the query, to print a page
of
one item (40 labels) from the database or can I? If I just query the
database, all is get a single record and open the report, all is get is
the
one label.

What I guess I have to do at this point is run the query, select the
record
for the label and build a module to run and populate another table 40
times
with the selected record to enable the report to print a page of
labels.

Question, once I run the query and the record from the main table is
selected, where is that data stored and how do I access it to provide
the
module for populating the other table?


.

Relevant Pages

  • Re: Fields in Label dont give correct information
    ... tables where the data was stored in the query the query would not run. ... half the time with very few errors (other than that label problem I had.) ... report all of the information shows up on the report the way I want it to. ... For example in the Room assignment on the report an idividual will be ...
    (microsoft.public.access.reports)
  • Re: Barcode - Query and Print Single Record
    ... Write a query that references the key field of your form as the criteria. ... put a button on the form to open the report. ... If you print a laser label, then to re-use your sheet, just skip position 1 ... Chemical Name from the Chemicals Table. ...
    (microsoft.public.access.formscoding)
  • Re: creating a label report in access
    ... It prints with the label in the 0 position. ... I hovered over the VBA page after running the report, ... Should I email you the whole access database? ... Please respond only to this newsgroup. ...
    (microsoft.public.access.reports)
  • Re: Passing Parameters to Column Headings
    ... You can create a column "label" in a report by using text boxes bound ... Duane Hookom ... > displayed in a report label (or in a query column heading). ...
    (microsoft.public.access.queries)
  • Re: Fields in Label dont give correct information
    ... You need to create a query based on tblRegEvent and tblRegPayment. ... -If your DCountis to count values in your report, ... half the time with very few errors (other than that label problem I had.) ... For example in the Room assignment on the report an idividual will be ...
    (microsoft.public.access.reports)