RE: Asking for old field

Tech-Archive recommends: Fix windows errors by optimizing your registry

I didn't find that field there also; actually both these properties were
blank. Moreover, the query when run on its own, doesn't prompt for that
field...only the report wants it...

"'69 Camaro" wrote:

> Hi, neeraj.
>
> > There is no other place in the report that field is called for. Yet when I
> > open the report in print preview, I am prompted for value of that old field.
>
> Open the report in Design View and then open the Sorting and Grouping dialog
> window. In the "Field/Expression" column, look for the previous name of your
> field. If you find it, change it to the field's new name.
>
> If it isn't in the report, check the query. Open the query in Design View
> and right-click in the upper pane (where the tables are) and select
> "Properties..." on the pop-up menu. Look at the "Filter" and "Order By"
> Properties for the previous name of your field. If you find it, change it to
> the field's new name.
>
> HTH.
>
> Gunny
>
> See http://www.QBuilt.com for all your database needs.
> See http://www.Access.QBuilt.com for Microsoft Access tips.
>
> (Please remove ZERO_SPAM from my reply E-mail address, so that a message
> will be forwarded to me.)
> Beware to those who use munged addresses: known newsgroup E-mail harvesters
> for spammers are Ripley@xxxxxxxxxxxxxxx and scott@xxxxxxxxxxxxxxxxxx
>
> - - -
> When you see correct answers to your question posted in Microsoft's Online
> Community, please sign in to the Community and mark these posts as "Answers,"
> so that all may benefit by filtering on "Answered questions" and quickly
> finding the right answers to similar questions. Remember that questions
> answered the quickest are often from those who have a history of rewarding
> the contributors who have taken the time to answer questions correctly.
>
>
> "neeraj" wrote:
>
> > My report is based off a query. I tweaked the query to change the name of one
> > field. I have made the corresponding change in the report to that field.
> > There is no other place in the report that field is called for. Yet when I
> > open the report in print preview, I am prompted for value of that old field.
> > I have closed and saved and yet the same result. Please advise...
.

Relevant Pages

  • Re: Criteria prompts
    ... how do I specify a "name" prompt? ... report, which is linked to a query. ... set this criteria to come up as prompts when the report is run? ...
    (microsoft.public.access.reports)
  • Re: Criteria prompts
    ... how do I specify a "name" prompt? ... report, which is linked to a query. ... set this criteria to come up as prompts when the report is run? ...
    (microsoft.public.access.reports)
  • Re: UPDATE DATE FIELD IN QUERY
    ... In the Date Field of my Query I have entered the following into the Criteria ... I can open the query, and it does prompt start & end dates, but it opens the ... When I open the report it opens the same parameter window & not my form, ... End dates 6 times & it just kept bringing up the prompt. ...
    (microsoft.public.access.macros)
  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • RE: Search memo field using criteria from a Form
    ... I've set the record source to be the query... ... using the prompt box as a key word search for a memo field so I want to be ... able to display on the report the value the user entered in the prompt box. ...
    (microsoft.public.access.queries)