S
ssblue
i need to capture the results of a parameter query using
wild cards on a report and be able to show it in the
report header.
wild cards on a report and be able to show it in the
report header.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Duane Hookom
You can display a parameter prompt from a query by setting the control
source of a text box to the exact same value as the parameter. For instance:
=[Enter Start Date]
source of a text box to the exact same value as the parameter. For instance:
=[Enter Start Date]
S
ssblue
this is true if you want to capture an item in a
particular field. I need to capture the text entered
using wild cards from a text field. for example i have
500 descriptions of equipment. i want to capture the text
entered using the paramete query. like *robot* or
*HP3324*, is this possible??
particular field. I need to capture the text entered
using wild cards from a text field. for example i have
500 descriptions of equipment. i want to capture the text
entered using the paramete query. like *robot* or
*HP3324*, is this possible??
-----Original Message-----
You can display a parameter prompt from a query by setting the control
source of a text box to the exact same value as the parameter. For instance:
=[Enter Start Date]
--
Duane Hookom
MS Access MVP
i need to capture the results of a parameter query using
wild cards on a report and be able to show it in the
report header.
.
D
Duane Hookom
It seems to me that you want your report to display "*robot*" in your report
some place. Why would my suggestion not do this?
--
Duane Hookom
MS Access MVP
some place. Why would my suggestion not do this?
--
Duane Hookom
MS Access MVP
ssblue said:this is true if you want to capture an item in a
particular field. I need to capture the text entered
using wild cards from a text field. for example i have
500 descriptions of equipment. i want to capture the text
entered using the paramete query. like *robot* or
*HP3324*, is this possible??
-----Original Message-----
You can display a parameter prompt from a query by setting the control
source of a text box to the exact same value as the parameter. For instance:
=[Enter Start Date]
--
Duane Hookom
MS Access MVP
i need to capture the results of a parameter query using
wild cards on a report and be able to show it in the
report header.
.
G
Guest
Duane - coding logic seems to say that this would display the question used in the query, instead of the results. (Because this is what you enter in the query itself to change the popup prompt) but I tried it and it worked. Thanks!