T
TechyGal
Hi there,
I have an Access 2007 project (.adp) which is used for many different
projects. There is a report that is generated for these different
projects, which I need the following information to change when the
report is run:
1) Project Name
2) Document Status (version)
This information is usually entered onto the report in Design View but
I would like the user to simply type in this information in a
Parameter window which pops up before the report is run. Thus
preventing the user from having to view the report in design view at
all.
Is this possible and how would I go about it?
I have designed an Unbound text box on the report and entered =[Please
Enter Project Name] in the text box's control source but #Name?
appears in the textbox.
I have also tried creating a Form that collects report parameters and
a module and macro which run using the OnOpen event on the reports
properties (as suggested in the Microsoft help file on using
parameters in reports). However, because the parameters are not in the
underlying query which forms the basis for the report I am unsure of
how to assign the values obtained from the Form into the text box on
the report.
Any ideas or suggestions would be greatly apprecaited!
I am not an extemely confident database developer yet, although I am
incredibly keen to learn and would really appreciate any step by step
guidance anyone can offer!
Many Thanks, in anicipation, TechyGal
I have an Access 2007 project (.adp) which is used for many different
projects. There is a report that is generated for these different
projects, which I need the following information to change when the
report is run:
1) Project Name
2) Document Status (version)
This information is usually entered onto the report in Design View but
I would like the user to simply type in this information in a
Parameter window which pops up before the report is run. Thus
preventing the user from having to view the report in design view at
all.
Is this possible and how would I go about it?
I have designed an Unbound text box on the report and entered =[Please
Enter Project Name] in the text box's control source but #Name?
appears in the textbox.
I have also tried creating a Form that collects report parameters and
a module and macro which run using the OnOpen event on the reports
properties (as suggested in the Microsoft help file on using
parameters in reports). However, because the parameters are not in the
underlying query which forms the basis for the report I am unsure of
how to assign the values obtained from the Form into the text box on
the report.
Any ideas or suggestions would be greatly apprecaited!
I am not an extemely confident database developer yet, although I am
incredibly keen to learn and would really appreciate any step by step
guidance anyone can offer!
Many Thanks, in anicipation, TechyGal