Printing Error Message
Jun 21, 2006
Hi all,
I am in the UK and the company i work for moved to Budapest and so did my access database and is now on their server. Today a user in Budapest has come with a problem (see attachment). I really don't understand what has happened here...all the user is doing is clicking on a button, which has a hyperlink to another form, no printing involved at all. One of their colleagues in Budapest can run the report with no problems, do you think the problem is most likely to do with their computer settings...thanks for any responses.
View Replies
ADVERTISEMENT
Mar 12, 2006
Hi all,
I am building a simple db from scratch using the limited knowledge i have, and a lot of the information gained from searching these forums as a guest. I've now reached a point where I can't seem to find what I'm looking for, so any help would be gratefully received!!
I have a single table, single form and single report (told you it was simple;)). The table has nearly 2000 records and 2000 pictures (linked). On the form I can print every record with a single click of a command button. This is great, but I would like a message box to popup and confirm the print action, as this is gonna be expensive if its clicked on every record!!
If anybody can help, I would be chuffed!! I searched the forums and can't seem to find anything on this!!
j
View 2 Replies
View Related
Mar 31, 2006
Does anybody know what this error message refers to?
"Reserved Error (-1517); there is no message for this error."
It just started happening today, and I haven't even made any changes to the database. It occurs when I hit a button I have to run a macro.
the macro does the following:
1) Shows all records
2) Requery
3) ApplyFilter.
The Where Condition for the filter is:
Right([tblContracts].[JobNum],4)=Right([Forms]![FrmContProc].[txtFindJobNum],4)
The weird thing is that it only occurs if the Form window is taller than 1/2 of my viewable area. If the Form window is 1/2 the viewable area or shorter, it works OK. This was running fine earlier today, but about 4:00 pm (03/31/06) this started happening.
If anybody knows what this error means, or how to get rid of it (I really need to use this window in full-screen) then please let me know.
-Thanks, Sean
View 10 Replies
View Related
Dec 18, 2006
Out IT department updated to SP2 this weekend and about half of my reports are no longer working. I cannot view, print or go into design mode. The error I am receiving is this:
There was a problem retrieving printer information for this object. The object may have been sent to a printer that is unavailable.
As soon as I change my default printer to a different one everything works normally. After talking to our IT department I received the helpful reply:
"Not at this time . This would take a lot of research to see why some reports print vs this one that will not."
After about three minutes of checking all of the affected reports are pointing to one printer. I found a way to manually fix an individual report by opening it up with a new printer set as default, saving the report and then changing the default back to the original printer. The problem is volume, this appears to be affecting about 50 or so reports.
It seems like a driver or network issue, these are network printers, but I do no have the access rights to try and fix this.
Any thoughts?
View 2 Replies
View Related
Feb 11, 2005
Hello every one, it is great to find a place like this.
Please I need help. When I print a form from Access 2000, all the fields on the printed form show #Error, eventhough in the screen the fields show information.
Can somebody help me????
Thank you
View 2 Replies
View Related
Feb 1, 2006
Hello All,
I have been developing my database all one seems to be well exept for an error message which is attched.
If anybody can help me trap this error or offer some advice i would be greatfull.
Alastair
View 6 Replies
View Related
Dec 5, 2014
I am getting an error message when printing a 2 part report. It does not appear until I have already printed the first part and I am ready to print the second. I have 6 users and all seem to experience intermittently with the exception of 1 who it is constant. The message is as follows;
"There isn't enough memory to update the display. Close unneeded programs and try again."I have tried deleting the registry "KEY_ CURRENT_ USER SoftwareMicrosoftVBA" with no avail and have installed all available updates from MS.
View 3 Replies
View Related
Jun 14, 2005
I have recently changed computers from a WindowsNT to and XP. When using the NT machine, I am able to print my Access report. However, when I hook up the XP machine and request a report from one specific database, I get the following message....this message also comes up if I try to open print preview or page setup.
"There was a problem retrieving printer information for this object. The object may have been sent to a printer that is unavailable."
I don't think it is a printer error as the error is occurring in this one database. I have successfully printed a test page and can open up other Access databases and print. I also tried converting the database to the 2002 format....but that did not make a difference either. There must be a setting in the database that is causing the error.....
Does anyone have any suggestions???
View 5 Replies
View Related
Apr 25, 2012
I am receiving the following error when printing different reports to several different printers in Access 2007: "The section width is greater than the page width, and there are no items in the additional space, so some pages may be blank. For example, the report width may be wider than the page width." According to my co-workers this issue began immediately following the upgrade to version 2007 from 2003.
View 1 Replies
View Related
Sep 28, 2005
While going to the design mode of a form, I regularely get the following message :
Microsoft Access can't run the macro or callback function 'fDesign'.
In my Dbase there is no macro with that name.
Can anyone tell me what this messages means and how to get rid of this thing.
Running Win XP, Access 2003 Sp1
View 2 Replies
View Related
Jan 23, 2006
I have attached a screen print of an error message I recieved on my access database. I finally got it to come up, but only after a few pop up boxes with this error message.
I do know the shared drive it is housed on went on the fritz. So I copied it and pasted it to my desk top. Grrr...I thought this message was due to the flipping shared drive. But now, I recieved it on my desk top too.
Anywho...can someone look at it and tell me what it means.
Thanks alot.
PS, i know my desktop has to much stuff, so don't go there. ;)
View 2 Replies
View Related
Apr 3, 2006
Hi can anyone help i keep clicking on a qry and it comes up with this message "Syntax error (missing operator) in query expression 'tblSTSLimits.Max Short'. but Max Short is correct can anyone help
View 1 Replies
View Related
Aug 9, 2006
Hi all,
I face a problem while openning a form.
It gave me this error message:
The expression On Load you entered as the event property setting produced the foolowing error:
User-defined type not defined.
What to do?
Sorry for bothering you.
Thanks & Regards
Mark K.
View 3 Replies
View Related
Aug 23, 2006
I get an error message when I open access 2003 database "database contains a missing or broken reference to the cacview.ocx version 1.0
All help so far says to go to tools>references.
My tools in the help menu does not have references
anysuggestions
View 1 Replies
View Related
Oct 9, 2006
I have a table that keeps crashing. The only error message I get is "Invalid Argument". Each time, a single record will turn into "#Error". Each field says this in the row. When this happens, Access won't let me delete just that row,
Any ideas how to delete them?
View 2 Replies
View Related
Jul 11, 2005
I am getting the following message:
"you tried to execute a query that does not include the specified expression qryMaxDays.Days Between 0 and 50 as part of an aggregate function."
I have other queries just like this and they run with no problem. any ideas? :confused:
SELECT Count(qryMaxDays.Days) AS [Number Of], qryMaxDays.Days
FROM qryMaxDays
GROUP BY qryMaxDays.Days
HAVING (((qryMaxDays.Days) Between 0 And 50));
View 1 Replies
View Related
Mar 6, 2006
I am trying to Right Join two queries which are basically from the same exact table, but when I do that I get the following error.
ODBC--called failed.
[Microsoft][ODBC SQL Server Driver][SQL Server] The column prefix 'MS1' does not match with a table name or alias name used in the query. (#107).
The following is a copy of my SQL
SELECT PqryExpiredPolicy.Policy_Number, PqryExpiredPolicy.Orig_Exp_Date, PqryExpiredPolicy.Insured_Key, PqryNewPolicy.Policy_Number, PqryExpiredPolicy.Name
FROM PqryNewPolicy RIGHT JOIN PqryExpiredPolicy ON PqryNewPolicy.Insured_Key = PqryExpiredPolicy.Insured_Key;
I have looked for this MS1 and cannot find it. Any ideas where I should be looking or what this means?
View 3 Replies
View Related
Jul 21, 2005
I get the following error message when I open a form, but I cant see anything wrong:
Run Time Error '2447':
There is an invalid use of the . (dot) or ! operator or invalid parenttheses.
This is the code that causes the problem:
Private Sub Form_Activate()
If Me.SumOfTotalGVS > 16 Then
MsgBox "You have exceded the total amount of GVS on the CATT site"
Let Me.SumOfTotalGVS.BackColor = 255
Me.SumOfTotalGVS.ForeColor = 65535
Else
Let Me.SumOfTotalGVS.BackColor = 16777215
Me.SumOfTotalGVS.ForeColor = 0
End If
End Sub
View 13 Replies
View Related
Feb 27, 2006
Can anyone tell me what is wrong with this line of code please. Im trying to count the number of records on another form that is open. This is an On_Click command from another form.
Me.lblCount.Caption = "You have " & Forms![Armour_Selection].RecordCount & " Armoured Squadron(s)"
View 1 Replies
View Related
Aug 11, 2006
Hello all,
I have an access application. I imported a form to it with all related tables and queries and modules from another application. Unfortunetaly, it didn't work.
It gives me this error message when openning the form:
The expression On Load you entered as the event property setting
produced the following error:
User-defined type not defined.
Sorry for bothering you.
Thanks & Regards
Mark K.
View 7 Replies
View Related
Nov 28, 2006
Hi folks,
i have a form that allows me to save mobile phone details.
The problem with this form is that if its incomplete and i click 'x' it shows me the validation message followed by an error message (which is attached with this thread).....
why is that? is there anyway i can exit the form (incomplete) without the valdation message or error message occuring???
View 14 Replies
View Related
Sep 7, 2004
Function Age(varBirthDate As Variant) As Integer
Dim varAge As Variant
varAge = DateDiff("yyyy", varBirthDate, Now)
If Date < DateSerial(Year(Now), Month(varBirthDate), _
Day(varBirthDate)) Then
varAge = varAge - 1
End If
Age = CInt(varAge)
End Function
I get # error in the field. Help?
View 2 Replies
View Related
Sep 24, 2004
I get this error when I try to run a query. I have attached a screeen print of the problem. Every thing else works just fine it is the same query I copied it and just change one of the fields. the other query orks fine.
View 1 Replies
View Related
Oct 17, 2007
Can anyone help me wit tis error message,
When i try to add in new things, it appear...
Server object error 'ASP 0177 : 8007000e'
Server.CreateObject Failed
/admin/cd_add_action.asp, line 11
Ran out of memory
View 1 Replies
View Related
Jul 6, 2005
hi,
the below scrip was taken from another forum member.
i have put this in the Forms / error VBA
but i still a little lost
i have set 3 fields to be indexed not to allow duplicate information (Forename, Surename, DOB)
i was then advised to error trap so it would highlight that i have enterd a duplicate record on typing in the DOB (As that as third feild to be entered)
so i then used the below script, however this doesnt highlight that it is a duplicate it just doesnt let me go on to the next record, the only time the error message is highlighted is when i go into design mode.
anyideas on where to go from here.
Private Sub Form_Error(DataErr As Integer, Response As Integer)
If DataErr = 3022 Then
Response = acDataErrContinue
MsgBox "Tis MerID alredy exist!"
Exit Sub
End If
If DataErr = 2169 Then
Response = acDataErrContinue
MsgBox "Tis record will not be saved!"
Exit Sub
End If
End Sub
View 3 Replies
View Related
Oct 25, 2005
I have an Access project that when it starts, lets you pick a folder and a file to open as input (done with VBA code), and that works beautifully. My project then processes the opened file and that works fine also. However, when I run the project a second time, pick another file (with the same format), my project then dies on me. If I get completely out of my project and thenre-enter it, it runs fine. I've enclosed a screenshot of the error I'm getting.
Any help is greatly appreciated. And yes, I did a search on this and several other forums as well as on Microsoft's site and could not find anything related to the error I'm getting.
View 2 Replies
View Related