Ms Access Report Overflow Error
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 20 Oct 2016 19:39:03 GMT by s_wx1202 (squid/3.5.20)
your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the
Access Round Function
selection below. Results 1 to 13 of 13 Thread: Overflow Error when opening a report Tweet access convert text to number Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 07-08-08,04:38 #1 sokolln View Profile View Forum Posts Registered User Join Date Jul 2008 Posts 15 Unanswered: Overflow Error when opening a report When I go to open one of my reports directly, I receive an Overflow error. I http://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_other/access-2003-overflow-error/bb9e4c66-661c-4de3-990f-15112836c77a can open the report via a command button in one of my forms with no problem. This is extremely perplexing. All my values in my tables are stored as Double. The query that the report uses as its source runs fine. Any idea what's going on? Much thanks Reply With Quote 07-08-08,06:34 #2 gvee View Profile View Forum Posts Visit Homepage www.gvee.co.uk Join Date Jan 2007 Location UK Posts 11,422 Provided Answers: 10 What's the code behind the command button look http://www.dbforums.com/showthread.php?1631965-Overflow-Error-when-opening-a-report like; anything interesting happening there? (filtering, etc?) George Home | Blog Reply With Quote 07-08-08,07:02 #3 sokolln View Profile View Forum Posts Registered User Join Date Jul 2008 Posts 15 The command is pulling up just one record of the report. Maybe that's the issue? Here's the code for the command: Code: Private Sub cmdPrintReport_Click() Dim strReportName As String Dim strCriteria As String strReportName = "Organizational Profile" strCriteria = "[Ultimate Parent]='" & Me![Ultimate Parent] & "'" DoCmd.OpenReport strReportName, acViewPreview, , strCriteria End Sub Reply With Quote 07-08-08,07:08 #4 healdem View Profile View Forum Posts Jaded Developer Join Date Nov 2004 Location out on a limb Posts 13,692 Provided Answers: 59 I think what georgev is suggesting is the coide in the reports on opne event..not the code that calls the report an overflow error is usually a type conversion problem ..of course it could be that access is just lying and it may clear with a compact and repair on the db. it possible the error may occur with nulls, its possible the error could occur because you have some rogue maths statements which are not sufficently protected with error traps I'd rather be riding on the Tiger 800 or the Norton Reply With Quote 07-08-08,08:00 #5 sokolln View Profile View Forum Posts Registered User Join Date Jul 2008 Posts 15 There actually is no code inputted by me on the open event. The report was created via a wizard. I
get tips & solutions from a community of 418,595 IT Pros & Developers. It's quick & easy. "Overflow" P: https://bytes.com/topic/access/answers/209934-overflow n/a Spook Running a particular Access report or the query associated with it brings up the warning "Overflow". What does this mean? WhatI have I done wrong? Both report and query were fine before lunch and the only thing I have changed is updated the data from one of the tables it pull info from. HELP!!!!!!!!!!!!!!!!!!! PLEASE Nov 13 overflow error '05 #1 Post Reply Share this Question 4 Replies P: n/a Allen Browne Overflow means the number is too large for the data type. As an example, open the Immediate Window (Ctrl+G), and enter: ? 200 * 200 It overflows, because the default data type in VBA is Integer (16-bit), which runs out at 32767. 40000 is too big, so ms access report we must convert one of the numbers to a Long Integer (32-bit) so it does not overflow: ? CLng(200) * 200 Use CDbl() to convert to a double, CCur() to convert to Currency, CVDate() to convert to date. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Spook"