HP Envy inspire 7955e won't print in Microsoft Access

[Holly_1656]

We have the HP Envy Inspire 7955E and I am having trouble getting it to print from  Microsoft Access. It will print from Word and Excell but refuses to print from Access. When I first set it up, it was setup to run on a USB cable and at that time I could not print PDFs or Access pages. I uninstalled the printer and reinstalled it as a wireless and it then let me print PDFs but still no printing from Access the way it should. We have an order entry program we use in Access (this is the only thing we use Access for) with a print button on the page to print only the page you are working on. If you press the print button the printer will wake up and then say canceling on the screen. The only way I can get it to print is to go to file...print  and then it tells me the following "selection conflicts encountered- do you want to repair" I click yes and it will allow to print. However that is only good for that time. When you go back to the original page you were working on it won't print from the print button and if you shut the program down and reopen it, it starts the same issue over again. Does anyone have any insight into how to fix this issue?

[VikramTheGreat]

Hi @Holly_1656,

Welcome to the HP Support Community.
 

Thank you for posting your query. I will be glad to help you.

Thank you for contacting HP Support regarding the printing issue you are experiencing with your HP ENVY Inspire 7955e All-in-One printer when printing from Microsoft Access.

We understand that while your printer prints normally from Word and Excel, it is unable to print correctly from Access, particularly when using the print button within your order entry program. We also note that the printer was initially connected via USB, and after reinstalling it as a wireless printer, the issue persists.

Here are some steps and recommendations to help resolve this issue:

1. Check the Printer Name in Access VBA

• Open your Access database.
• Press Alt + F11 to open the VBA editor.
• Look for any code like: DoCmd.OpenReport "ReportName", acViewNormal, ,,, "PrinterName"
• Make sure "Printer Name" matches the current name of your HP printer (check in Control Panel > Devices and Printers).

2. Update Default Printer

• Go to Settings > Bluetooth & devices > Printers & scanners.
• Click your HP printer → Set as default.
• Restart Access and try printing again.

3. Repair the Access Report or Form

• Open the report or form in Design View.
• Go to Page Setup → Printer.
• Click Use Specific Printer → Select your HP printer.
• Save and close the report/form.

4. Rebuild the Print Button

If the button is using a macro or VBA:

• Delete the button.
• Recreate it using the Command Button Wizard:
  • Choose Report Operations > Print Report or Form Operations > Print Form.

5. Test with a New Access File

• Create a new Access database.
• Add a simple form and a print button.
• See if the issue persists. If not, the problem is specific to your original database.

I hope this helps.

Take care and have a good day.

Please click “Accepted Solution” if you feel my post solved your issue, as it will help others find the solution. Click the “Kudos/Thumbs Up" on the bottom right to say “Thanks” for helping!

VikramTheGreat

HP Support