Print Access parameter query on report

Thanks for the responses, I tried the text box in the header and couldn't get it to work. I finally did a access help search on report parameters and found what I needed and with a little working with it got it all set up, works very well as what I am prompted for by the query prints in the text box in the report header.
thanks again
dennis
----- Original Message -----
From: Gary Kacher
To: 'vantage@yahoogroups.com'
Sent: Thursday, August 29, 2002 11:13 AM
Subject: RE: [Vantage] Print Access parameter query on report


Actually, I've done this alot. This is what I do:

Query:

Select ......From ..........Where [partnum] = [Part Number];

** A popup window will ask for the value of [Part Number] when you run this
query.

Access Report:

Add a TEXT BOX to your report header section (or wherever you want) and set
the
Control Source property to something like:

="This reports on part number " & [Part Number]

It works for me. It won't work on LABELS though.

Hope this helps.

-----Original Message-----
From: Dennis Houghton [SMTP:dennis@...]
Sent: Thursday, August 29, 2002 8:50 AM
To: vantage
Subject: [Vantage] Print Access parameter query on report

Hi all,
A quick question to the group a little off subject but here goes, In
Access, does anyone know if you can add the report query parameters to the
header or somewhere on the report like "RB" or Cystal Reports? Can't seem
to find anything on this.

Thanks

dennis


[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


Yahoo! Groups Sponsor
ADVERTISEMENT



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
Hi all,
A quick question to the group a little off subject but here goes, In Access, does anyone know if you can add the report query parameters to the header or somewhere on the report like "RB" or Cystal Reports? Can't seem to find anything on this.

Thanks

dennis


[Non-text portions of this message have been removed]
Actually, I've done this alot. This is what I do:

Query:

Select ......From ..........Where [partnum] = [Part Number];

** A popup window will ask for the value of [Part Number] when you run this
query.

Access Report:

Add a TEXT BOX to your report header section (or wherever you want) and set
the
Control Source property to something like:

="This reports on part number " & [Part Number]

It works for me. It won't work on LABELS though.

Hope this helps.

-----Original Message-----
From: Dennis Houghton [SMTP:dennis@...]
Sent: Thursday, August 29, 2002 8:50 AM
To: vantage
Subject: [Vantage] Print Access parameter query on report

Hi all,
A quick question to the group a little off subject but here goes, In
Access, does anyone know if you can add the report query parameters to the
header or somewhere on the report like "RB" or Cystal Reports? Can't seem
to find anything on this.

Thanks

dennis


[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/