Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Oct 2006
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hello

    I am experiencing an overflow error when trying to execute the following line
    strReportName = Application.Screen.ActiveReport.name

    This database is Access 97 SR2, running on Windows XP.

    I have tried the following already
    Debig.print's to ensure that the .name property is valid (it is, and its 14 characters long according to LEN()
    Hard coded the report name (ie strReportName = "rptLateStatsA4" and run it successfully.
    I have also done all the usual including repair/compact, and importing the object from somewhere else.

    Does anyone have any thoughts on what might be causing this?

    Thanks in advance for your help

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I can't reproduce the error.
    Can you attach a stripped and zipped version of your db so we can test it and see if we get also the error ?
    See Post 401925 for instructions
    Francois

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •