Results 1 to 5 of 5
  1. #1
    elhale is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Sep 2016
    Posts
    14

    Dialog Boxes Pop Up When Running Report

    I am getting dialog boxes to pop up for input for a query that runs when I run a report that gets its data from the query. The dialog boxes are for three fields which I am not requesting data for. there is no criteria set in any of the fields the boxes refer to. I only have a "between" criteria for the date field to use a date range to run the report for, but that is not the field that produces a dialog box. In fact, the fields the boxes refer to are not fields used in the report.



    Any help understanding what's going on would be appreciated.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    either:
    you have mispelled a field in the query, (so it thinks its a param)
    or
    you have a field in the GROUP/SORT that no longer is in the query,

  3. #3
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    What happens when you run the query? If it opens OK, then the problem (as ranman256 pointed out) is likely there. If not, it's likely in the report. You might have, for example, renamed or mis-spelled a report control, or altered it's record source. The prompt you're getting is likely a parameter prompt. The message tells you what it's looking for or can't resolve. The only other thing I can think of that can (rarely) cause this is when Access can't distinguish between the name used for a control and the name of the field it's bound to because they have the same name.
    Last edited by Micron; 03-10-2017 at 10:12 PM. Reason: spelin
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    Athar Khan is offline Advanced Beginner
    Windows 7 32bit Access 2013 32bit
    Join Date
    Mar 2017
    Posts
    63
    I had the same issue. In my case, the problem was that I had some calculated fields in my query. The names of these calculated fields were being repeated after GROUP BY statement.
    I just deleted all the names of calculated fileds after GROUP BY statement and after that I was never prompted for parameters again.

  5. #5
    elhale is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Sep 2016
    Posts
    14
    Micron & Khan, It does appear the problem is in the report as the queries run fine. Am looking through the fields to find the culprit as we speak. Thanks to you both!!

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

Similar Threads

  1. Replies: 2
    Last Post: 07-15-2014, 07:22 PM
  2. Open Print Dialog when Report is opened
    By tylerg11 in forum Reports
    Replies: 1
    Last Post: 01-09-2014, 10:44 AM
  3. Replies: 13
    Last Post: 08-08-2013, 04:52 PM
  4. Running a query based on 2 combo boxes.
    By blessoni in forum Queries
    Replies: 4
    Last Post: 12-12-2010, 02:09 PM
  5. dialog box errors in report
    By Jane in forum Programming
    Replies: 0
    Last Post: 11-20-2008, 01:06 PM

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