RE: Asking for old field

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi, neeraj.

> 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...

Then the report is hiding the previous name of the field somewhere. To find
it, use the built-in Documenter wizard to document the report, making sure
that the "Options" selected include everything but the "Permissions by Users
and Group" item, and then export the results to an Excel spreadsheet. Run
"Find" on your field's previous name. You'll find it.

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:

> 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)