selected items

[fajita]

Would like to select (tick box) items from the form input-
Enter screen, and later print items that have been
selected. Do I need to create a query, and report? What
if any would I need to filter? Is this possible?

 

[Steve Schapel]

Fajita,

Probably you should add a new field, Yes/No data type, to the table that
your form is based on, and then represent this field on your form with
the tick box. For printing out, I would say Yes, a report is probably
the way to go. And normally a report is based on a query. If you make
a query, include your Yes/No field in the query, and put -1 in the
Criteria of this column.

 

[fajita]

Any other solutions in printing selected items? I've
added a tick selected items box to my action input form,
I've added the tick to my table with yes/no. and created
a query with -1 in the column. their are items selected
to print, but nothing shows up on form view of query. so
i made a report thinking that might be an answer and
still nothing. what am i doing wrong?
Please Help

 

[Steve Schapel]

Fajita,

In the design view of the query, please go to the View menu, select SQL,
and then copy the contents of the SQL window and send a reply here to
the newsgroup with the SQL pasted in.

 

[fajita]

Here is my SQL View for my query:


SELECT [AI Information].Tick, [AI Information].[Action
Item #]
FROM [Contact Names] INNER JOIN [AI Information] ON
[Contact Names].[Contact NamesID] = [AI Information].
[Contact NamesID]
WHERE ((([AI Information].Tick)=Yes))

Thank You for you Help!

 

[Guest]

I've added one more to the query. here is the new SQL
View:



SELECT [AI Information].Tick, [AI Information].[Action
Item #], [Contact Names].[Contact NamesID]
FROM [Contact Names] INNER JOIN [AI Information] ON
[Contact Names].[Contact NamesID] = [AI Information].
[Contact NamesID]
WHERE ((([AI Information].Tick)=Yes));

 

[Steve Schapel]

Fajita,

Ok, the process of elimination... Both of these queries should work
fine, as long as Tick is a Yes/No data type, and as long as there are
records in the AI Information table with the Tick = -1. So, if you have
a look directly at the table datasheet for AI Information, or if you
remove the criteria from the query and then run it, like this...
SELECT [AI Information].Tick, [AI Information].[Action Item #], [Contact
Names].[Contact NamesID]
FROM [Contact Names] INNER JOIN [AI Information] ON [Contact
Names].[Contact NamesID] = [AI Information].[Contact NamesID]
.... do you see any records with the Tick field ticked?

By the way, a completely unrelated comment... it is not a good idxea to
put a # as part of a field name.

 

[fajita]

Thank you Steve, the query and report are running. I have
one more question, is there a way ro deselect items that
have been selected to print in a report. Clear the
selections for another user?

 

[Steve Schapel]

Fajita,

You can do this with an Update Query. If you are using a macro or VBA
procedure to print the report, you can run the Update Query as part of
this, after the report is printed. Or another option might be on the On
Close event of the form which you are using to select the items. The
SQL view of such a query would look like this...
UPDATE [AI Information] SET Tick = 0