Reports

[BILLIE]

I have a Switchboard with a "Create Custom Report" button
on it that I copied from the Access 2000 Inventry sample
database. It works great! Only the newly created reports
become hidden because I have the Database Window hidden
from the users.
I would like to add another Switchboard button that
would allow the user to open a report by choosing from
a list of all the reports (including newly created custom
reports) in the database. How could I achieve this?
Thanks in advance!

 

[fredg]

I have a Switchboard with a "Create Custom Report" button
on it that I copied from the Access 2000 Inventry sample
database. It works great! Only the newly created reports
become hidden because I have the Database Window hidden
from the users.
I would like to add another Switchboard button that
would allow the user to open a report by choosing from
a list of all the reports (including newly created custom
reports) in the database. How could I achieve this?
Thanks in advance!

Add a combo box to the form.
Code it's RowSource property:

SELECT MSysObjects.Name FROM MSysObjects WHERE
(((Left([Name],1))<>"~") AND ((MSysObjects.Type)=-32764)) ORDER BY
MSysObjects.Name;

To run the selected report, code it's AfterUpdate event:
DoCmd.OpenReport Me!ComboName, acViewPreview

 

[BILLIE]

-----Original Message-----

I have a Switchboard with a "Create Custom Report" button
on it that I copied from the Access 2000 Inventry sample
database. It works great! Only the newly created reports
become hidden because I have the Database Window hidden
from the users.
I would like to add another Switchboard button that
would allow the user to open a report by choosing from
a list of all the reports (including newly created custom
reports) in the database. How could I achieve this?
Thanks in advance!

Add a combo box to the form.
Code it's RowSource property:

SELECT MSysObjects.Name FROM MSysObjects WHERE
(((Left([Name],1))<>"~") AND ((MSysObjects.Type)=- 32764)) ORDER BY
MSysObjects.Name;

To run the selected report, code it's AfterUpdate event:
DoCmd.OpenReport Me!ComboName, acViewPreview
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.

I looked up Genuis in the dictionary and all it said was
Fredg
-now I understand why!
Thank You SO MUCH!
This works perfect!
BILLIE