Manual selection of items, creating report from them..

[kroenc17]

Got a couple steps for what should be a simple issue, but me + Access do not = simple

Access '07, btw.

1. I need to create a form that lists all the Projects in my database. They need to have a check box next to them.

2. I need to be able to select multiple projects and then generate a report based on which projects are selected.

3. I need a report which shows the selected projects most recent update. I already have a query to do this, but it's not based off of the above form which limits the projects to only those selected.

Thanks for any help!

[ajetrumpet]

1. I need to create a form that lists all the Projects in my database. They need to have a check box next to them.

create a cont. form

2. I need to be able to select multiple projects and then generate a report based on which projects are selected.

check the boxes on that cont. form

3. I need a report which shows the selected projects most recent update. I already have a query to do this, but it's not based off of the above form which limits the projects to only those selected.

"recent update" means what?? we can't read your mind in terms of the what the data looks like. this is mentioned in one of the bullet points here

[kroenc17]

Thanks for the reply.. 'Projects' table contains a 'Status' Column. I already have a query made that will show the most recent 'Status' entry for a project.. but I need to make a report that shows only the projects I selected in the form I have to make, and then modify the query for most recent 'Status' to include only the selected projects.. Make more sense?

[ajetrumpet]

not really, but if you want to loop on through the recs in that form to check for those recs that are checked, use the "name" attribute of the checkbox that you want of your cont form. so do something like:

dim rs as dao.recordset
set rs = me.recordsetclose

rs.movelast
rs.movefirst

with rs
   do until .eof
      'iterate here, using "me.checkboxname" to capture the checked items
   loop
end with

rs.close
set rs = nothing

make more sense to you as well??

[kroenc17]

No, I have no idea what you're talking about.. I don't know any coding.

I want to make a form with a list of items, be able to manually select as many as I want, and create a report that shows information about the items I selected.

I have a template for the report I'm trying to make, which is a report we commonly use to show certain details about all of our projects. I can use this same report except I need to have which projects are shown on it determined by said form.

I'm sorry I don't know how else to describe this.. what am I conveying confusingly?

[ajetrumpet]

yes you are, but the only reason you are, is simply because what you want to do is impractical, especially for beginners.

looping a cont. form is the only way (practically) that you can do this. the report has to be based on a criteria clause, and you can only get that from those checks on your form, and the only way to do THAT, is to loop the dataset from which that form comes from. make sense??

thus, looping require vba code and/or skills.

by the way, noone will give you a better answer here: http://www.access-programmers.co.uk/...d.php?t=204603

trust me, I've been part of that site for a long time. More pros can be found there than found here...

[kroenc17]

Well somehow I've got to figure this out.. any other suggestions/advice?

I've done something similar to this a few months ago using requery actions on the afterupdate event but only for a single drop-down box, not for multiple selections.

Right now I can't even get all my projects to list on a form with a checkbox next to them >:|

[ajetrumpet]

I don't know anything about the previous matters.

But I've already said what to do to get the "list" your looking for. Highlight your table that you want to show and go up to the "create'' tab and click on "continuous form" in the dropdown list of autoforms that you can create. you're using 07, right?

you can see what I'm talking about simply by doing that short task

[kroenc17]

Okay thanks.. that gets me started on that I guess.

My boss just wants a report like one we already use (It's a generic Projects summary report), except he wants to be able to filter it to show only certain Projects (sometimes).

I'm going to suggest just modifying the reports data query with the ID's #for the projects desired in the Criteria for the query.. sure it's not automated but.. it's pretty easy!

[ajetrumpet]

Okay thanks.. that gets me started on that I guess.

My boss just wants a report like one we already use (It's a generic Projects summary report), except he wants to be able to filter it to show only certain Projects (sometimes).

I'm going to suggest just modifying the reports data query with the ID's #for the projects desired in the Criteria for the query.. sure it's not automated but.. it's pretty easy!

very good solution. that's basically like the interface approach to the code option of doing it.

at the very least, show him THIS thread. I've been working with access for so many years I can't count. good luck with it! I'm unsubscribing from this thread now...

[kroenc17]

Thanks for the help