Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-13-2019, 12:30 PM   #1
got_access:]
Newly Registered User
 
Join Date: Jun 2018
Posts: 83
Thanks: 2
Thanked 1 Time in 1 Post
got_access:] is on a distinguished road
How to add avery template to Access

Hi All,
I've noticed my Access 2016 only appears to have one label template.
What I see there now is called "Label1"and its size parameters are 1.00" x 1.50"

I'm assuming Microsoft provides a source for downloading and installing Avery labels?

Thanks in advance!

got_access:] is offline   Reply With Quote
Old 08-13-2019, 12:42 PM   #2
June7
Newly Registered User
 
June7's Avatar
 
Join Date: Mar 2014
Location: The Great Land
Posts: 2,144
Thanks: 0
Thanked 503 Times in 499 Posts
June7 will become famous soon enough June7 will become famous soon enough
Re: How to add avery template to Access

I have no idea if label templates can be downloaded and added to Access (doubt it). However, templates are not necessary. This is just a wizard to help building a specialized report.

A "labels" object is just a report. You can modify as you see fit.

I see what looks like couple hundred label templates in Access 2010, many of which are Avery. Perhaps MS decided to quit trying to keep up with the variety of manufacturer products.
__________________
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by June7; 08-13-2019 at 01:15 PM.
June7 is offline   Reply With Quote
Old 08-13-2019, 12:57 PM   #3
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,080
Thanks: 110
Thanked 2,737 Times in 2,499 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: How to add avery template to Access

Avery label templates aren't (or at least weren't when I tried them over 10 years ago) designed to be importable to Access.

Have you contacted Avery to see whether they now supply an add-in?

I created my own reports to fit Avery labels L7160 (7x3) and L7163 (7x2).
You just need to create reports that are the exact size of whatever labels you want to use

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 08-13-2019, 04:13 PM   #4
got_access:]
Newly Registered User
 
Join Date: Jun 2018
Posts: 83
Thanks: 2
Thanked 1 Time in 1 Post
got_access:] is on a distinguished road
Re: How to add avery template to Access

Oh I see - you just make your own customized labels and then name them using the standard avery number system.

Interesting!

I have a business I visit occasionally and they have a number of Access installs which all include labels which I'm told are according to the avery number/naming system.

So I assumed label templates were downloadable.

Thanks
got_access:] is offline   Reply With Quote
Old 08-13-2019, 04:43 PM   #5
June7
Newly Registered User
 
June7's Avatar
 
Join Date: Mar 2014
Location: The Great Land
Posts: 2,144
Thanks: 0
Thanked 503 Times in 499 Posts
June7 will become famous soon enough June7 will become famous soon enough
Re: How to add avery template to Access

The 'label' formats came with earlier Access versions - as noted in my previous post, there are a lot.

You can name the report whatever makes sense to you.
__________________
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
June7 is offline   Reply With Quote
Old 08-14-2019, 07:32 AM   #6
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 27,953
Thanks: 13
Thanked 1,534 Times in 1,460 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: How to add avery template to Access

I guess it's been a while since I made new labels. It sure was convenient to have the Avery form numbers to pick from. Oh well, as the others have said, you can make your own.
__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Old 08-14-2019, 07:50 AM   #7
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,080
Thanks: 110
Thanked 2,737 Times in 2,499 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: How to add avery template to Access

I've also not needed to do this for several years. However, I've just checked in both A2010 & A2019(365). The label wizard still contains a HUGE number of labels you can use to make your reports. This is a tiny part of the available list:

Attached Images
File Type: png LabelWizard.PNG (13.9 KB, 35 views)


__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
hello avery one sazuelos Introduce Yourself 0 06-24-2012 08:31 AM
avery label problem powellm1976 Reports 1 08-26-2002 07:43 PM
[SOLVED] Avery 5160 - Help!! nicksfan Reports 1 04-03-2002 03:35 PM
Avery Label Printing jbeasley Reports 1 12-21-2001 10:56 AM
[SOLVED] Avery Label Report kbf Reports 4 12-05-2001 07:38 AM




All times are GMT -8. The time now is 01:47 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World