Connecting Tech Pros Worldwide Forums | Help | Site Map

dynamic labels

Newbie
 
Join Date: Mar 2007
Posts: 23
#1: Jul 12 '07
Hi,

I have been using access 2000. I need to develop a report which prints labels from the table. Is it possible to create labels dynamically in access 2000 forms ?
If so, please provide that code.

JConsulting's Avatar
Expert
 
Join Date: Apr 2007
Location: Houston
Posts: 601
#2: Jul 12 '07

re: dynamic labels


Quote:

Originally Posted by kkk1979

Hi,

I have been using access 2000. I need to develop a report which prints labels from the table. Is it possible to create labels dynamically in access 2000 forms ?
If so, please provide that code.


It's possible, but much easier to do if you use your Word program and create a MailMerge. The tools within Word will allow you to create a query using your table to grab the information and it's a lot easier to arrange your data that way as well.

J
Newbie
 
Join Date: Mar 2007
Posts: 23
#3: Jul 12 '07

re: dynamic labels


Quote:

Originally Posted by JConsulting

It's possible, but much easier to do if you use your Word program and create a MailMerge. The tools within Word will allow you to create a query using your table to grab the information and it's a lot easier to arrange your data that way as well.

J

I am sorry, I did n't get you. Can you please send me the code.

Thanks
JConsulting's Avatar
Expert
 
Join Date: Apr 2007
Location: Houston
Posts: 601
#4: Jul 12 '07

re: dynamic labels


Quote:

Originally Posted by kkk1979

I am sorry, I did n't get you. Can you please send me the code.

Thanks


>>Can you please send me the code.

You didn't understand what I explained? or you don't understand what a Mail Merge is?

I'd love to code this all for you....matter of fact, that's what I do for a living. I come here to help YOU learn how. Creating a report in Access to make it look like labels takes a LOT more than just "code". So I guess as a direct answer to your question...no I cannot send you "the" code.

Do you have Microsoft Word?
Reply


Similar Microsoft Access / VBA bytes