wonderful lesson I saw your brilliant methods to make a list for labeling customers, but i wanted to have a way to the same and have a list of all customers and have a check box which I can check who should be included and who excluded, because the way you do it we need to come in to each customers name and run that macro, so it whould be nice when we have a list of customers and just tick a yes/no box who to include and how manytimes to include
Abraham BreuerOP
@Reply 5 years ago
I also saw the preview for the mailing labels seminar, you cover how to put blanks or delete labels, a full sheet of one customer, and a list of all active customers, but what I wanted is to pick out of a list and then ask the user how many labels do you want for this customer, and so on, so my sheet of labels will have 5 labels of customer1 nothing of customer 2 and 3, 7 for customer 4 and so on
That would certainly be possible. I might add that to the next Developer class. It would be a good use of a Recordset. I can't think of a non-VBA way to do that.
Abraham BreuerOP
@Reply 5 years ago
watched now the drag and drop Lesson advanced 5,
whats about this idea
ListBox1 ListBox2
ListBox1 bound to all customers names and listBox2 bound to LabelsT
make an external macro that sets the value of Line 1, 2, 3, and 4 for the LabelsT
OndblClick Event when selecting a name of List1 that runs the external macro and asks "how many Labels do you want for this customer?"
A button to print List2
That's without VBA!!!
Sure. If it works, great! Sometimes once you get used to VBA, it's hard to think of non-VBA solutions. A lot of the time when I'm preparing my TechHelp videos, I get asked something by a user, and there's a VBA solution I can think of, but then I also try to put together a non-VBA way for beginners to do it, and that can often times be more challenging.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Advanced 5.
