Hi Jean,

We find Access most useful to approach such issues:

DELETE dbo_StatusFlags.*, dbo_StatusFlags.FlagID

FROM dbo_StatusFlags

WHERE (((dbo_StatusFlags.FlagID)=53));

Better make a backup first though.

To add:

INSERT INTO dbo_StatusFlags ( ObjectID, FlagID, OnOff, LoginID )

SELECT dbo_Objects.ObjectID, 53 AS Expr1, 1 AS Expr2, "xricharal" AS Expr3

FROM dbo_Objects INNER JOIN dbo_PackageList ON dbo_Objects.ObjectNumber = dbo_PackageList.MainData

WHERE (((dbo_PackageList.PackageID)=15867));

Do remember that in this was duplicates can occur in StatusFlags for a certain Flag to 1 ObjectID. In that case, you will be able to find it in a query, but is doesn’t show in red in your data entry screen.

Does anyone know how to, or have a script for, batch applying and removing status flags.

Thanks!

Best,
Jean.

Jean J. Libert

Atlantic Art Partners

Tel: 212-292-6422

Fax: 212-292-6420

[log in to unmask]

CONFIDENTIALITY NOTICE:
This email and any attachments thereto are intended solely for use by the recipients named above and may contain confidential information.  If you are not an intended recipient of this e-mail or if you otherwise received this email in error, you are hereby notified that any disclosure, copying, distribution or use of this e-mail or any attachment is strictly prohibited.  Please notify us immediately by returning it to the sender and permanently delete this message and any attachments from your system.  You should not retain this e-mail, nor should you disclose all or any part of the contents to any other person.  Thank you for your cooperation.

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.