Can't locate source of prompt

[Guest]

I assumed responsibilities for this database. There are about 50 reports and
at least that many queries. When I run a certain report I'm being prompted
for 2 pieces of information...the date format and date. I can't figure out
the source of the prompts. I want to remove them. I'm wondering if there's
an easy way to find the source. Maybe a macro that executes when a prompt is
displayed? Any suggestions?

 

[Roger Carlson]

You need to look in the controls on the report, the query behind the report,
and the Grouping and Sorting settings.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Franck]

usually these prompt apply filter to the report. First open the report
in edit mode. Check the query source that fill the report. Now open in
edit the query and check the line saying criteria. You should find in
the 2 of them one of these 2 possible prompt code

first look like this =[please enter date]
if you see something between [ ] it's a prompt you can have anything
before or after like: fld_date <= [before :]
the [before :] gonna actually be replace by what the user type.

the other possibility is function calling example : calculmydate(1,
[mydate])
in this case you can also remove it but it's possible that something
vital could be hiding in this function for the good sake of the
database. To see it you gonna need basic knowlegde in programming. But
usually for dates you wont find such a parameter prompt. it will be
more just [bla bla bla] format.

 

[Roger Carlson]

I guess I should clarify. In addition to actual prompts in the query
(parameter queries), you can also get this behavior is certain information
is missing.

For instance, this can happen when a query references a field that is not in
the table. This happens most often when a field is deleted from a table and
not from the query. A prompt can also appear if a control on your report
(ie textbox) is bound to a field that is not in the query (happens for the
same reason.) Lastly, it can happen if there is a field in your Grouping
and Sorting that has been deleted from your query.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

I use Speed Ferret to effectively find stuff like this. Although its utility
is waning as they have never published the 2003 edition, and you have to have
either 2000 or XP installed in addition to 2003 in order for it to work.

You might try the following web site (
http://www.rickworld.com/download.html ) . Although I have not used this
tool, I have spoken to a couple of individuals that have recommended it.

If this happens in more than just the one report, you might want to write
some code to loop through all of the querydefs, and examine the SQL property
for the exact text that you are getting in your prompt. Unfortunately, since
not all Report Record Sources are saved queries, you might also need to loop
through all of the reports and examine the RecordSource property as well.

Another consideration is that the problem may not be a record source, but
may be the control source of a control on the report. If the report was
created, and the field name in the underlying query was changed, the control
source may be pointing at a field that does not exist in the query.

HTH
Dale

 

[Franck]

I guess I should clarify. In addition to actual prompts in the query
(parameter queries), you can also get this behavior is certain information
is missing.

For instance, this can happen when a query references a field that is not in
the table. This happens most often when a field is deleted from a table and
not from the query. A prompt can also appear if a control on your report
(ie textbox) is bound to a field that is not in the query (happens for the
same reason.) Lastly, it can happen if there is a field in your Grouping
and Sorting that has been deleted from your query.

--
--Roger Carlson
MS Access MVP
Access Database Samples:www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

if your biing a missing field from the query or int the query your
point out to a non existing table field it's normal to receive popup
lol.
it's not an super intelligent thing access he wont read your mind that
to not take in consideration X field becasue it's not in the table you
have to tell him to not taking it by removing from the query

 

[George Nicholson]

The prompt could also be in code somewhere (Report_Open event, etc.)

Open the VB editor, open a code module, Edit>Find (entire database) on the
prompt string.

HTH