Report Link

[Ctt847]

Hi I am new to the forum.

For work I am trying to link reports to a main page. For example I have a database of chemicals, these chemicals are broken down from input template by various factors. When I open the Access database I want the first page to be able to click to link to a report or the input form. I have no idea how to do that. I have made my data input form, and all of my reports. Any help would be much appreciated.

[ranman256]

Make a form for reports.
on the form ,put a list box,this is the list of reports to print. (From a table)
user picks an item,then clicks a print button.
the button code is:
docmd.openReport lstBox,acViewPreview

If you want controls on the form to filter the report,
docmd.openReport lstBox,acViewPreview,,"[dept]='" & me.cboDept & "'"

[Ctt847]

Thanks for the help. When I try to make a form for the report I use Form Wizard but it will only let me link the form to a query or a table not the reports.

[aytee111]

You need to link a button to a report, not a form.

Create a new empty form (Create > Form Design), add two command button controls (Design menu). In the wizards, for the first command button say Open Form and give it your form name, for the second button say Open Report and give it your report name.

[ranman256]

the form does NOT link to any table /query.
you make a table , tReports, enter all reports into it to use. (i also have an enabled flag to turn on/off items)
enter report names manuallly
link the listbox to this table.

[Ctt847]

Thank you so much ! That works - ok last question(s). When I try to put a name at the top of my new form it will not let me adjust the size of the font, and if I select Text Box under form view it comes up with an error saying Name with an upside down question mark. Additionally, how can I make the database so the form to run reports or add new records is the only page they see and can navigate from ?

[aytee111]

Use a label control to put a name at the top of your form, any size or type of font.

Go to File>Options>Current Database and add the form name under Display Form - it will open this form when the database opens.

[aytee111]

Not sure what you have done with the suggestions above. In case you used Ranman's option, instead of a table for the list of reports, use a listbox.

In form design, add a listbox control. Add this in its Row Source property:
SELECT MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Type)=-32764));
This will give a list of current available reports. Then when you click on the button to open the report, use Forms!Formname!Listboxname as the report name.

[HiTechCoach]

I have an example that can even be imported into your own database and used:

Report dialogs and menu examples

[Ctt847]

That is awesome OK last question - I have my database built and all now I want to protect it so when someone opens the file all they see is the one form which links to reports and the input form - how do I do that ?

[HiTechCoach]

That is awesome OK last question - I have my database built and all now I want to protect it so when someone opens the file all they see is the one form which links to reports and the input form - how do I do that ?

You really should post this as q new question since the question is not related to your original post. Also, search and you should find lots of post on the subject. Keyword: Split database, deploy, lock down.

By keeping a post to a single question it help build a better knowledge base. Searching and finding solution is much easier for everyone in the community.