E
El Zorro
I have installed a quick little query on an Access
database. The user selects the month and year from an
imput screen (a form), clicks a Run Query button, and can
view and print data for his selected month and year.
This works great, but the output does not indicate to the
user, as a double-check, the time period he selected. In
other words, a report for March will have the same title
(i.e., the query name) as a report for April. I guess I
could format an actual Report based on the query, but the
query itself provides the info and runs so fast that I'd
like to skip the report writing process and just use the
query.
Is there a way to add some VB code to the Run Query
subroutine that will change the title of the query to the
Month selected by the user?
database. The user selects the month and year from an
imput screen (a form), clicks a Run Query button, and can
view and print data for his selected month and year.
This works great, but the output does not indicate to the
user, as a double-check, the time period he selected. In
other words, a report for March will have the same title
(i.e., the query name) as a report for April. I guess I
could format an actual Report based on the query, but the
query itself provides the info and runs so fast that I'd
like to skip the report writing process and just use the
query.
Is there a way to add some VB code to the Run Query
subroutine that will change the title of the query to the
Month selected by the user?