Label Reports

[Webbenstein]

Hi there, I've had a good search around and couldn't find anything related to my question so I'll start off a new thread.

Firstly, this is what I would like to achieve: I need a simple report for address labels which will be sent out with monthly summaries to employees. I can easily create a label report using the wizard by selecting the label type and saving the report. But this means I'm dictating the label size the system generates. What I'd like to be able to do is allow the user of the system to choose the label type they have and save it as a default - into a settings table or something along those lines. Then if they want to change it they can select the new label type and update the setting.

I've had a play around with label reports and I don't think they actually store the label type used to create them, rather the wizard generates the report detail size and text placement based on the dimensions of the label type you choose. So...

Really what I think I am asking is how can I access the list of label sizes access uses in the wizard, so I can display them in my own combo box on a form. Then, when the user makes a selection I can format my label report accordingly.

Any ideas or pointers would be greatly appreciated.

 

[Rickster57]

Labels

Most companies I have been at typically only use between 1 and maybe 5 or 6 different types of labels(sizes) . What I have done in the past is just create 5 or 6 different label reports such as report1,report2, etc. Since labels contain a small amount of data this takes very little time to do.

I create a combo box that holds the 5 or 6 different label types and based on what the user chooses that particular report gets run using the docmd. This takes very little effort to do and also limits the tpyes of labels the company has to purchase.

 

[Webbenstein]

Hi thanks for the reply. Really what I'm getting at here is how to programtically create label reports. The application I'm developing in intended for distribution to multiple companies. We'd rather not say you need to use predefined label type(s) to print labels from this app - rather allow the user to specify at least the dimensions of the label they are using, prefereably the manufacturer and product number. The hope is that this will save us time adding in custom label reports for each company that is using the app and make the app more flexable.

But I'll definitely be using something along the lines of your suggestion until I can get this figured.

Many thanks for your help again.