>>>Hi! I need to give my users the ability to create labels. They should be able to select a standard Avery format and then choose which fields to print from a list I provide. Has anyone done this? Can I do this without having to create a template for each of the 75+ available formats? I have unsophisticated users who need a very simple interface.
>>>
>>>Thanks
>>>Elyse
>>
>>Elyse,
>>
>>You can include CREATE LABEL in your application to allow users access to the VFP label creation functionality.
>>
>>HTH,
>>
>>George
>
>I don't think my users can handle VFP's Label Designer. I can't let them choose fields on their own. Any other suggestions?
>
>Elyse
I didn't work with Labe Designer much, but assuming that it's similar to Reprot Designer I would suggest following:
1. Prompt users to select fileds in custom label definition form.
2. Then your code will collect values of these fields into a cursor with fixed field names (running some SELECT-SQL).
3. Now you can have one label form for any field selection, printing form the cursor.
Edward Pikman
Independent Consultant