Weed Out Inactive Forms

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

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.



kalyhan wrote:
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200710/1

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

--
Dave Hargis, Microsoft Access MVP


"benyod79 via AccessMonster.com" wrote:

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.



kalyhan wrote:
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200710/1

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.


Klatuu wrote:
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]
Thanks!
Karen

--
Message posted via http://www.accessmonster.com

In ,
kalyhan wrote:
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.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)