Results 1 to 2 of 2
  1. 05-24-2010, 01:22 AM #1
    okakopa
    okakopa is offline Novice
    Windows XP Access 2003
    Join Date
    May 2010
    Posts
    1

    Report won't open

    My queries are built from ODBC linked read-only tables. Some data are not always present in the tables due to changing personnel parameters. My reports sometime look for the non-existent data and refuse to open. For example, if no individual has a specific type of training, my training report won't open since the report can't find the particular bound control. How can I make the report open anyway?
    Reply With Quote Reply With Quote
  2. 05-24-2010, 04:09 AM #2
    Datagopherdan
    Datagopherdan is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Dec 2008
    Posts
    220
    You need to add some error trapping such as the "No Data" event in your report.

    Quote Originally Posted by okakopa View Post
    My queries are built from ODBC linked read-only tables. Some data are not always present in the tables due to changing personnel parameters. My reports sometime look for the non-existent data and refuse to open. For example, if no individual has a specific type of training, my training report won't open since the report can't find the particular bound control. How can I make the report open anyway?
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Open Report or Form depending on condition
    By jheintz57 in forum Forms
    Replies: 5
    Last Post: 03-12-2010, 08:16 PM
  2. Code to check if form1 is open, then open then opoen form 2
    By ser01 in forum Programming
    Replies: 2
    Last Post: 02-26-2010, 08:14 AM
  3. Creating a Switchboard button - search for record and open up specific form / report
    By diane802 in forum Access
    Replies: 3
    Last Post: 01-14-2010, 08:32 AM
  4. open report from a vb form
    By tracamonali in forum Reports
    Replies: 2
    Last Post: 08-10-2009, 01:55 PM
  5. Can't open .mdb from icon, have to open within access
    By Divardo in forum Access
    Replies: 1
    Last Post: 06-04-2009, 07:43 AM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums