Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
Home > Courses > Access > Advanced > A05 > < A04 | A06 >
Back to Access Advanced 5    Comments List
Check Box For Labels Upload Images   Link   Email  
Abraham Breuer 
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 Breuer 
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
Richard Rost 
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 Breuer 
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!!!
Richard Rost 
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.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Advanced 5.
 

 
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 3/28/2024 7:14:24 AM. PLT: 0s