By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,392 Members | 1,523 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,392 IT Pros & Developers. It's quick & easy.

Hide or disable records

P: n/a
Are there anyway to hide or disable certain records that meet some
criteria ? In my app. after the quantity delivered equal to order
quantity, which means balance=0, i need to hide that record. Pls help.
Thanks.

Regards,
Daniel
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
In the OnCurrent Event of the form showing such records, put code like this:

Me.AllowEdits = (Me.QtyDelivered <> Me.QtyOrdered)
Me.AllowDeletes = Me.AllowEdits
Nov 12 '05 #2

P: n/a
Change the SQl of the form recordsource, or use a filter that restricts
recrds using whatever criteria you need.

Mike Storr
www.veraccess.com

Daniel Tan wrote:
Are there anyway to hide or disable certain records that meet some
criteria ? In my app. after the quantity delivered equal to order
quantity, which means balance=0, i need to hide that record. Pls help.
Thanks.

Regards,
Daniel

Nov 12 '05 #3

P: n/a
On 29 Feb 2004 13:04:48 GMT, DCM Fan wrote:
In the OnCurrent Event of the form showing such records, put code like this:

Me.AllowEdits = (Me.QtyDelivered <> Me.QtyOrdered)
Me.AllowDeletes = Me.AllowEdits

^^
Me.AllowDeletions

Peter
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.