473,704 Members | 6,472 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access runtime error 3011 on docmd.openrepor t

4 New Member
access runtime error 3011 on docmd.openrepor t
--------------------------------------------------------------------------------

Access database (file format 2002-2003) generates reports with docmd.openrepor t but returns 3011 runtime error related to the printer. Switching Windows default printer is a work around but need to find out the cause. Help Desk updated printer driver on server and no runtime error for two months but we are receiving it again on three computers.

I think this might be specific to the actual mdb file and what occurs with references, dll's, etc. rather than the printers themselves. Windows default printer works for Outlook, Word, Notepad, etc. so this is specific to the print preview portion of Access reports and it has happened in print preview of Excel.

Received error recently, switched printer to work, switched back to problem printer without help desk and worked fine......

Could be related to XP conversion too, not sure...but need help.
Nov 30 '06 #1
3 7795
Cyberdyne
627 Recognized Expert Contributor
We might want to move this thread to the access forum, would you like me to?

It sounds to me like a problem with your access code not the printers or their drivers, although the excel print preview made me think twice. What happens when you try and print preview a file in excel? Is it the same error?
Dec 2 '06 #2
enough2Bdangerous
4 New Member
We might want to move this thread to the access forum, would you like me to?



It sounds to me like a problem with your access code not the printers or their drivers, although the excel print preview made me think twice. What happens when you try and print preview a file in excel? Is it the same error?

I really appreciate the reply....
I was advised by the Access moderator to post in Windows. The Help Desk here seems to think it is related to the program within Access specifically, not Access and not the printers and/or drivers.

I'm not sure if the program is corrupt or that it was converted from 97 to current version using a newer version of Access than we are actually running.

Didn't receive the same error but the page setup response time in Excel is delayed drastically. For example, when you change the margins, what normally would take a less than a seconds drags on for about 15 minutes.
Dec 4 '06 #3
Cyberdyne
627 Recognized Expert Contributor
Seems to me like its using a lot of processing power from your CPU, can you contact the people that made the program within access and see if they have updates?
Dec 7 '06 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

3
4832
by: Radu | last post by:
Hi. I have lots of processing to do on the server - from the client (Access) I call a sproc which returns a recordset (the sproc is essentially a big "select"). With the obtained data , I need to generate a report. How do I set the Recordsource of the report to the result of the select sproc ? I have tried the following, but it does not work. Private Sub cmdReport_Click()
7
8863
by: dog | last post by:
I've seen plenty of articles on this topic but none of them have been able to solve my problem. I am working with an Access 97 database on an NT4.0 machine, which has many Access reports. I want my users to be able to select a report, click on a command button on a form, which will then automatically create the report as a pdf file and save it to the user's machine. I am using Adobe Acrobat (5.0 I think) and have Adobe Distiller as a
11
6595
by: Grasshopper | last post by:
Hi, I am automating Access reports to PDF using PDF Writer 6.0. I've created a DTS package to run the reports and schedule a job to run this DTS package. If I PC Anywhere into the server on where the job is running, the job runs sucessfully, PDF files got generated, everything is good. If I scheduled the job to run at the time that I am not logged into the server, Access is not able to print to the printer. The error is pretty...
16
48874
by: cyranoVR | last post by:
This is the approach I used to automate printing of Microsoft Access reports to PDF format i.e. unattended and without annoying "Save As..." dialogs, and - more importantly - without having to use a commercial program such as Adobe Acrobat and its associated API. The technique uses Ghostscript and Redirection Port Monitor - two free programs for creating PDF documents provided free by Russell Lang. The actual automation requires VBA...
1
2644
by: ellipsys | last post by:
- Open Access 2003 - Create new database (2000 or 2002/2003 format) - Create a report and insert a label in its Detail section - Save the report as Report1 - Copy Report1 as Report2 - Open Report1 and insert Report2 in it as subreport - Save Report1 - Create a form and use the wizard to insert a button which can open Report1 for preview - Go to VBE and navigate to the Click event of the button
3
2395
by: David | last post by:
Hello, hope someone can help. I have a request to print word .doc check lists with selected records in Access for surgery procedure cards. I have hyperlinked the word doc's to a field in each record, but do not know how to write the code to open the word doc and print it. I assume this code should be put in the list box print button. As you can see, I have two different reports that go out; one (or more) to Surgery, and one (or more) to...
2
14120
by: Dean Slindee | last post by:
Anybody written code in VB.NET to: 1) show a print preview window of reports already written and stored in an Access 2002 database; or 2) execute the print of a report stored in an Access 2002 database? Thanks, Dean Slindee
2
2820
by: enough2Bdangerous | last post by:
Access database (file format 2002-2003) generates reports with docmd.openreport but returns 3011 runtime error related to the printer. Switching Windows default printer is a work around but need to find out the cause. Help Desk updated printer driver on server and no runtime error for two months but we are receiving it again on three computers. I think this might be specific to the actual mdb file and what occurs with references, dll's,...
1
3039
by: resqtech | last post by:
I am having an issue with an Access Database that worked at one time and after a Windows Update that screwed up the profile it stopped working. The following is what VB is stating causes the error. Any help would be greatly appreciated. DoCmd.FindRecord c, acEntire, True, acSearchAll, True, acCurrent, True This is part of another group: Private Sub name_Change() Dim c As String c = Me!name
0
8676
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9266
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9127
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8972
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6602
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5926
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4435
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4692
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2467
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.