Placing Temp Field on Form - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Placing Temp Field on Form

Jerry Fowler

4 years ago

Been googling and not finding what I need.

I would like to place a temp field on a form that is not stored anywhere. For instance say I have a invoice form and if I go to print all I have a continuous form come up that show all that will print. I would like a temp true/false field that defaults to true. then I could go through and change to false any I don't happen to want to print on this run.

I tried just putting a field on a form that had no controlling source and defaulted it to true. but it is not unique for each record.

And again I do not want to store the value anywhere just used once.

	Richard Rost @Reply 4 years ago
Jerry, to do what you want, you need to store that value in a table. I would just add a yes/no field to the table you want to print, and you can base a query off of that, and use that to feed your report. See Select Multiple Records.

	Jerry Fowler OP @Reply 4 years ago
Richard, that's kind of what I figured but for some reason (not sure why) I didn't want it saved. Thanks for confirming it.

	Kevin Yip @Reply 4 years ago
You could create a temporary table with Yes/No fields plus the primary keys of your table, then join it to your table to accomplish what you need, and then delete the temporary table afterwards. The temporary table could be created with, say: SELECT PrimaryKeyFieldFromYourTable, False as Flag INTO temp_table FROM YourTable; When you finish: DELETE FROM temp_table;

Scott Axton @Reply

4 years ago

Jerry -
Why would you NOT want it saved?  Sorry but that doesn't make sense to me.

Say that you enter invoices all day.  Then print them.
Then you come in tomorrow and enter invoices.  When you go to print you would have to check off all of yesterdays invoices because they were already printed.  Now imagine months or years of invoices to 'turn off'.

If you have an IsPrinted field you can make a query to show only the invoices that need printed ( IsPrinted = NO ), print them, then as they are printed mark them YES.

That would save you a ton of work .

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View