var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: counting duplicate values in a field in a textbox
Well it's been a while since I've done anything in MS Access but I thought I'd give it a go.
I've been creating a simple database but have run into a bit of a brick wall.
I have created a form which needs to search a table to find duplicates and input the number found into a textbox.
Simple I can hear everybody saying but I can't find out the best way to achieve this. I want to keep the database as quick as possible.
I've managed to get a query to work it out. Here is the SQL code:
SELECT First(AltDelAdd.BillingID) AS FirstOfBillingID, Count(AltDelAdd.BillingID) AS NumberOfDups
HAVING (((First(AltDelAdd.BillingID))=[Forms]![Edit Cust]![Cust No]));
Can anybody help?
The simplest would be:
=DCount("*", "AltDelAdd", "BillingID = " & [Forms]![Edit Cust]![Cust No])
Hi guys, right I've managed to figure out how to do this using a SubForm.
Is there any way to stop users being able to select the text it generates and scrolling within the subform? I just want the text to appear without it being possible to highlight it within the subform.