none
Faulty Reports RRS feed

  • Question

  • I have reports with some missing data:

    - for a field reference 2 out of 18 datasets are missing

    - for an expression with some IIf statements 13 show the expected return, 5 give an empty line

    I have tried to repair MS Office from the "deinstall or change programmes" and I have repaired and compacted MS Acces to no avail

    Thanks for any suggestions, boz

    Sunday, October 30, 2016 12:58 PM

All replies

  • If you check the reports underlying recordsource do the proper values appear?

    Can you post the recordsource for us to review.


    Daniel Pineault, 2010-2016
    Microsoft MVP Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Sunday, October 30, 2016 1:29 PM
  • Hi Daniel,

    thanks for your response. the underlying record source is a query built from tables in a different database; the query shows all data as expected. If I use this query and the report on a different computer, I get the correct result.

    By the way I also have reports that give for the expression in the Group Header

    =Left([Title];1) give back #Name?

    while other reports with the same structure and expression give the expected result.

    Sorry for being so naive: how can I post the recordsource for your review?

    Best regards

    Sunday, October 30, 2016 2:06 PM
  • Left([Title];1) 

    Should be

    Left([Title],1) 

    Based on what I'm seeing, I'm thinking that is a regional settings issue.  I've seen such headaches when working on a database on different computers which have different regional settings.  Access does not properly convert certain things, yet it does others, and you end up with a db that works here, but not there.  So the question to you is, are all the PCs involved set with the exact same regional settings?


    Daniel Pineault, 2010-2016
    Microsoft MVP Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net


    Sunday, October 30, 2016 2:47 PM
  • my country settings demand a semicolumn. they are the same for all my PCs
    Sunday, October 30, 2016 3:22 PM
  • OK, as long as they are all the same.

    The control in which you placed the expression, is it named Title?  Rename it to something else.

    Does your code compile without errors?


    Daniel Pineault, 2010-2016
    Microsoft MVP Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Sunday, October 30, 2016 3:50 PM
  • Hi Bo,

    After you follow the suggestion from Daniel to change the Titile, I suggest you check the real value for [Title], you could replace =Left([Title];1) with  [Title] to see whether it is valid value for Title.

    Best Regards,

    Edward


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, October 31, 2016 9:37 AM