Running Reports from forms using access 2003

[Willie78]

Hi Everyone

I'm building a form structure from which reports will be run. Currently I have a combo box from which the user selects a report they want this will either run (using a conditional macro) it or give them another form from which parameters are then selected, either by combo box or calendar objects. In doing this I found I couldn't reference the calendar objects unless I passed the value to another object i.e. a text box is this correct?

From your experience is it better to use a table with the reports listed and a key assigned to each to populate the combo boxes or to type out the value lists.

Kind Regards

Wills

 

[TheAceMan1]

How are ya Willie78 . . .

If after the parameters are chosen you next run the report, its a matter of leaving the form (with the parameters) open for referencing . . .

[blue]   Forms!FormName!CalendarObjectName.Value[/blue]

. . . or you could store the value in a global variable.

It all depends on how/where your using the value!

[blue]Your Thoughts?[/blue]

See Ya! . . . . . .

 

[Willie78]

Cheers Ace Man

I'm good.

That works fine. I still counldn't see the calendar objects using the expression builder. This is why I assumed(wrongly) that it had to placed in another object.

Cheers again

Wills

 

[TheAceMan1]

Roger That Willie78 . . .

[blue]From your experience is it better to use a table with the reports listed and a key assigned to each to populate the combo boxes or to type out the value lists.[/blue]

You'll have to [blue]be more specific about how your using the combo[/blue]. To relieve yourself of typing, the following SQL (entered in the [blue]RowSource[/blue] of the combo) will return all reports:

[blue]SELECT Name
FROM MSysObjects
WHERE ([Type]=-32764)
ORDER BY Name;[/blue]

See Ya! . . . . . .

 

[Willie78]

That is awesome much appreciated Ace Man.

That will get so much use.

The combo box thing is all sorted now. I was undecided whether to build in some admin tables to store the report names and categories or to type in the values in the combo box control source.

Having had a word with myself I created the table's.

Thanks again

Wills