Weed Out Inactive Forms

[Guest]

Hi Everyone.

Is there a simple flag I can enter into a table which will keep various
records
from showing when updating forms? I don't really want to remove them from
my table. The table contains many entries, but we only need to update
current records. I want to try this before getting into an append query.

Thanks!
Karen

 

[benyod79 via AccessMonster.com]

Add a Yes/No field to your table.

YourTable
Field1
Field2
ynShow Yes/No


Then your append query would have criteria for ynShow "Yes" and it would only
show those records with Yes.

 

[Guest]

criteria for ynShow "Yes"
will not work. Comparing a boolean data type to a text string.
should be ynShow = True

 

[benyod79 via AccessMonster.com]

You're right. Remove the qotes around the Yes

However, for a boolean field you can use {Yes, True -1} all of which return
the same thing in a query.

criteria for ynShow "Yes"
will not work. Comparing a boolean data type to a text string.
should be ynShow = True

Add a Yes/No field to your table.

[quoted text clipped - 16 lines]

 

[Dirk Goldgar]

In

Hi Everyone.

Is there a simple flag I can enter into a table which will keep
various records
from showing when updating forms? I don't really want to remove them
from my table. The table contains many entries, but we only need to
update current records. I want to try this before getting into an
append query.

No need to remove them from your table. Just add a boolean "Inactive"
field to your table, set it to True for the records you don't want to
see any more, and change the recordsources of your forms to queries that
retrieve only records where Inactive = False.