Hello, I am having a problem with a text box in the Form Footer. The text box has a control source of =Count(*). I have a command button that when...

Hi Folks, Using Access 2003 with XPSP2. I have designed a form (frmMain) with an embedded sub-form (frmSub). frmSub contains a number of records that are...

I would like to display the number of customers signed-up already on a form. I cannot use a count statement because customers are signing up for...

I am trying to count the number of parcels in a field called in my main form from a field called in my subform (Note: the table name is SBL FP). The...

Hello All Is it possible to have a textbox in the detail section of a continuous form view that simply displays "1" for the first record, "2" for the...

I currently have a form that is Unbound and only contains controls to open 12 different forms. My problem is that each text box must use a different query. ...

I have built a database to track registrations for an event. This includes class sign ups. I currently have to export the data to Excel to check the class...

I have a main form and a subform. I would like to count how many records in the subform meet this criteria. If DateSubmit is between 4/1/2005 and 6/30/2005,...

I need code to count the number of records on my form. Cant use the built in counter because of needing this for code purposes. Form name is Time and...

Here's a little background on my database. I have a form with a couple of buttons that I have grayed out when the database is empty. These buttons open a...

I have a List Box on a form. The number of entries on the list increases as the user enrolls more attendees in a class. There is a capacity limit to the number...

Access 2003 I have a tex box to write long text. I want to limit this text box based of number of lines. Question. How can I count the number of lines into a...

I have in my form text box 'MyDate' and text box 'Month after date'. Quaterly i need count moths in my text box 'Month after date'. For example: next 1...

Hi, I have string like below and i wanna count nos in that string 1st string ;0;80;0;0;39;0;0;0;81;42;5;100;0;0 in this string there are 6 Nos. 2nd string...

I am new to using Access and have created a form that has two time/date fields in the format DD/MM/YYYY. Is there a way to add a third field that will...

I have a sub-form named Time and Hours On this form it has a Text Box with it's Control Source set to Work Date and it's Name is WorkDate Format is...

I have a form where I enter deposits. There are 10 fields to add up (Deposit Amounts) Cust1 Thru Cust9 Plus a single Cash Deposit named ...

Hello, I have a table with number field's 0 through 6. I then need to count all the fields that have a "0" in them and have that total on another field. Is...

Is there a command that can tell me the number of records in my list box.

Is there anyway to determine how many records are selected via the recordselector? I want to limit the user to be able to delete only one record at a...