Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Print setting of accde file
John Yeung 
     
3 years ago
I have made an accde file with forms and report and distributed to someone. However he is using a printer that is different from mine and cannot print the report.
I want to fix for him via Teamviewer but the report in accde file cannot be edited .
Any solution?
Thanks
Richard Rost  @Reply  
          
3 years ago
Unfortunately, you're correct that ACCDE files are compiled and their design elements like forms and reports cannot be edited. However, there are a few ways to address this issue. You could make the necessary adjustments to the report on your local ACCDB file, then recompile and distribute a new ACCDE file. This, of course, would require you to understand the specifics of the new printer's requirements.

You could design the report in a separate ACCDB file that only contains the report object. You can link the tables from the ACCDE, make your edits, and then he can use the ACCDB file just for printing. This would keep your main application secure in the ACCDE format. I've actually got a video coming out about this exact thing pretty soon. You'll just basically launch a second database that has the report or reports customized for his system in an ACCDB file. He could then customize that file for himself so if you want to make modification so the report he could but he could save his printer settings in that file. The only problem after that would be of course if you make changes to the report on your end you'll have to distribute that file to him as well.

You could even programmatically have Access create a blank new database ACCDB file copy the report to it using VBA or even create the report completely in VBA there's a million things you could do. It all depends on how much time and effort you want to put into it.
Kevin Yip  @Reply  
     
3 years ago
Have your user print to PDF, then print the PDF on his printer.  What exactly is the problem that prevents that report from printing?  Printer margins, that sort of thing?  Just make sure your report is printable to PDF, and make sure all your users have a PDF printer driver on their PC.
John Yeung OP  @Reply  
     
3 years ago
thank you guys. I have drug reports designed to print in a drug label printer such as Zebra, Brother and other letter reports to normal inkjet or laser printers such as Hp, Cannon. If I set drug label to pdf print, I dont know whether my friend's computer can print the drug with his Zebra label printer (his default printer is Hp). Meanwhile I will be exploring it, thanks
Kevin Yip  @Reply  
     
3 years ago
What exactly happens when your user "cannot print the report"?  Does he get garbled output, misplaced text, etc.?  Did you test the problematic printer at your end, and did you duplicate the same problem?

In my old job, we used a Zebra printer to print thermal labels.  We bought a third-party label-printing software (Wasp Labeler) to do the job instead of doing it in Access because the complexity of the tasks required a separate app.  You may consider that option as well.
John Yeung OP  @Reply  
     
3 years ago
the problem is I use Zebra printer and set the report to be print by Zebra . My user uses Brother printer. No correction in .accde file
Kevin Yip  @Reply  
     
3 years ago
Either you have the user use a printer that you know will work, or you make another accde for his printer.  Making another accde seems much easier.  Find out the exact reasons the report isn't printing (margins, positions, etc.) and design your report accordingly.

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

Next Unseen

 
New Feature: Comment Live View
 
 

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 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/8/2026 10:16:22 AM. PLT: 1s