2011年5月5日 · This returns 0, even though the partial orders are showing on the subform. This works: =DCount (" [Status]","tblVendorOrders"," [Status]='Partial'"), but returns all of the Partial orders and not just the ones from a particular Vendor. Thanks for any help.

2012年12月26日 · The problem using dcount () inside of some sql means we executing dcount () over and over. That choice really hurts performance (even without sql server). Dcount is NOT slower than a recordset or query (it converted to sql behind the scenes anyway!). Well as noted, dcount alone not an issue (runs same as recordset or sql).

2011年12月5日 · So I suppose I need to do a DCount line but lost my notes on this. So if there is a record in PurchaseOrderScheduletbl with poID (that's the main form to sub link) and for poPartNoFSC, then make poPartNoFSC combo have a background of light pink.

2014年7月15日 · My code seems to work almost perfectly in normal activities, however, I am saying almost because sometimes when a user click on the button named “NouvelleCommandePièces_Étiquette” on the form named “Détails commandeBT” its happens that the new record isn’t created in the source table named “Commandes”, however, the auto …