Results 1 to 4 of 4
  1. #1
    Robert2150 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Sep 2013
    Location
    Sparks, Nv
    Posts
    104

    Unable to view some reports

    I have a database program that allows the user to view various reports created by using data from a specific property.
    All works well except I am unable to view certain reports from some of the properties. I have assigned each property a property number. The data entered is place in a table where the property number identifies which property that data belongs too. When the query is run for the report it only selects data that has the current property number. This works well for all of the properties except two or three. When I hit the button on my main form to "view report" on the two or three of the properties the view reports screen opens but there is nothing there, and the program goes back to the main form. Is there something wrong in the data? or should I look elsewhere?

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,556
    I would be looking at your data.
    Surprising the number of people who post a query like this, only to find that the data is not there? :-(
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    Robert2150 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Sep 2013
    Location
    Sparks, Nv
    Posts
    104

    Thank You

    Quote Originally Posted by Welshgasman View Post
    I would be looking at your data.
    Surprising the number of people who post a query like this, only to find that the data is not there? :-(
    Thank you, I will check out the data.

  4. #4
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,556
    Try putting some code in the Report_NoData event of the report.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 10
    Last Post: 02-06-2018, 02:37 PM
  2. Replies: 8
    Last Post: 04-29-2013, 11:23 AM
  3. Unable to view query in design view
    By vemi007 in forum Queries
    Replies: 7
    Last Post: 01-19-2012, 11:36 AM
  4. Replies: 2
    Last Post: 01-05-2012, 11:52 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums