making labels

[Jim]

I am looking for the best way to accomplish the following
task; I need to print mailing labels by the sheet. I
have 16 fields that will be printed on each label. 10 of
these field are will remain the same for each sheet. 6 of
the fields will change each time a sheet is printed to
info input by an employee. I need to have an icon on the
desktop that can be selected, which will bring up an input
screen, which will in turn update the sheet to be printed
for each sheet. there will be 10 labels on each sheet.

I originally attempted to do this in Access, everything
worked as I wanted it to, EXCEPT when the form came up and
you input the needed info in the fields, it would not
update the table to print out the new labels as a form I
had set up, it just would not update the table.

Any suggestions would be greatly appreciated.

Thank You

 

[DL]

If the table wasnt updated, either you did not setup the table correctly, or
yr report is printing the incorrect record.
It should be a reasonably simple process for Access.

 

[Guest]

What might I possibly not setup correctly in my table?
Where might I look? Any Suggestions?

 

[DL]

You have a form linked to a table for inputing records, I take it when you
input data this data is not added to the table - You can check this simply,
by using datasheet View
Assuming no data added, if using datasheet view are you able to add records?
If yes, then in the properties of the Form (Design View) Format tab,
Navigation Btns to 'Yes'
In Form View use nav.btns to scroll through the data, click '*' btn to add
data
If you are unable to add data in datasheet view it means you have explicitly
coded it to prevent data being added - unlikely I think.
However having done that, when you choose to print a report, and I assume yr
using the Label wizard, allthough you could design a report formated in the
way you require, you would need first to design a query to retreive the data
you require, and use that query as the report data source.
Therefore for each data entry in yr table you need some specific entry that
is unique for that particular record and can thus be used in the query.
I'm not sure that I understand yr requirements enough to offer advice on
this particular part.
I would say I have often found it usefull to layout the db structure, tables
etc, by pencil and paper first. That way you can see how tables need to be
linked and fields created etc.

hope this is usefull to you