Results 1 to 4 of 4
  1. #1
    khughes46 is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Grapevine, TX
    Posts
    231

    Fields keep showing up asking for a parameter value

    I had 24 fields that were misnamed. The fields concerned an assessment. When abbreviating the names I used asses instead of assess. I changed all 24 fields. These changes appear in two reports, 1 in English the other in Spanish. When I first created the reports I did the one in English, copied it and replaced the verbiage with Spanish, and both worked just fine. After making the field name changes, I updated the reports. The English report worked fine but the Spanish asked for a parameter value for 4 of these fields that were changed. I tried deleting and replacing the fields in the report, I tried the report without the fields in it and still got asked for parameters. Any ideas how this happened? How might I fix this?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,522
    Either the query or the report is still looking for the old names.

    If you changed all the query and report names, then the report could still have SORTING using the old names. (or even functions if very complex rpt)

  3. #3
    khughes46 is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Grapevine, TX
    Posts
    231
    All the names are changed and they work in the English report, but not the Spanish report. The only difference in the two reports is the language. There is no sorting, especially by these names. This is a 2 page in length letter. The English letter goes from page 1 to page 2 with a problem. THe Spanish report is putting a blank page between page 1 and page 2. This just keeps getting more challenging.

  4. #4
    khughes46 is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Grapevine, TX
    Posts
    231
    I found my blank page problem. It was jus a little too wide.

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

Similar Threads

  1. Replies: 15
    Last Post: 04-16-2014, 01:15 PM
  2. Combobox refrence showing up as a Parameter
    By littlejib in forum Access
    Replies: 6
    Last Post: 04-09-2014, 11:33 AM
  3. Showing parameter fields side by side
    By sebgrb in forum Queries
    Replies: 2
    Last Post: 03-07-2014, 02:25 AM
  4. Replies: 42
    Last Post: 11-27-2013, 08:55 PM
  5. Report showing wrong parameter
    By Andrea in forum Reports
    Replies: 1
    Last Post: 09-28-2012, 12:04 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
  •  
Other Forums: Microsoft Office Forums