Report

[Deepa]

Hi Folks,

How do i select a few records from MS Access(letz say a form) & populate the same onto a MS Access Report. I dont want to use a query.
The user has to choose the records (say thro a checkboxes) & generate the report on click of the button.

Please respond ASAP

 

[dgm]

If your talking about a couple of fields from a single record then it would be easy enough to reference the fields from the report:
forms!frmName!txtFieldName

Otherwise the best way would be to use a query...
Any reason why u don't want to use a query?

 

[Pat Hartman]

You are going ot need to use a query. See if this Multi-Select Listbox Sample db helps.

 

[Deepa]

Hey thanks for replying ASAP.

Well want I require is a User Interface where in the user chooses a list of milestones ( i cud use the listbox ), then on click of a button I want a report.

The report should have the chosen milestones. Now each milestone has activities & each activity has tasks. The activities & the tasks should also be shown in the report.

I have created a query where in by passing the milestone id i get the activities & the tasks. Now i want this query to run for each of the selected milestone.

Well, sorry abut the wrong lead abut not using queries.


Regards,
Deepa

 

[Pat Hartman]

Did you look at the sample? I'm pretty sure that it shows you how to use a multi-select list box to create the criteria part of your query.

 

[Deepa]

Yup...it has the solution partly...What i am looking for is a MS Access Report so that i can use formatting..

I donot have Microsoft VB help file installed on my system. Is there a link from which I can download it?

Regards,
Deepa

 

[Pat Hartman]

The help files are on the Access installation cd. You should also make sure all the wizards and samples are installed at the same time.

If you are new to Access you might not know that with A2K, Microsoft got too smart for us and split the help files so that you get different answers from help depending on where you ask the question. If you want help on VBA, you need to ask for help from any code window rather than from the database window.

 

[Deepa]

hey thanks a lot