Search results

Yes... that is what I wanted. A simple formula to do the work, not a multi-line script. Thanks so much! So .. .I owe you huh ... well, I am going to be in London in a few days. You live in London? Mike

I am sorry to be such a bother. I have never had this kind of problem in all of the 8 years that I have been using forums. I have attached my database. The field in which I am wanting the count of people is called Person Count Box. I am wanting to find the person count (on each form) of the...

Thanks for the reply ... I hope this info will help: Form Name: Form (There is only one!) ALL of the control types are text boxes, both the ones in which I need to count and the one that I need to use to display the count. I hope this helps, Mike

Ok ... Well ... I think the only thing I don't understand of your code is this: 'PUT ALL CONTROL TYPES YOU WANT TO CHECK ON THIS LINE Do I specify the names of the boxes that hold the data or the field names themselves? And can you give me an example of the code to use with a sample control...

I am wondering .... is there not an easier way to simply take a count of cells that don't have a null value? Is there a simple formula that I can place in a text box that is not associated with a field in the table that I can use to count the cells that have values in them? Here are the cell...

Thanks for the help. I am wondering though what you mean by your comment about control types. The form contains many fields, not just the ones I want to count. How do I count only the ones I want? Mike

Dear Friends, I have searched the forum and did not find the answer to this particular question and wondered any anyone could help me. I am trying to create a text box that has a formula which counts those field boxes on a form that contain a value. For instance, if the following fields...

Friends, I am working on creating a donor-ranking report that displays the top 25 donors to our organization based upon a year of giving records. I have a query that displays the contributions made to our organization and it sorts by the donor number. I have no problem showing only the sum of...

Friends, I have a table that contains pledges to various causes. Here is a sample of the fields I want to use and the type of info in each field: PldgCode AmtPerGift 24 10.00 32 15.00 24 10.00 What I want to be able to do is put the number 24 in...

Friends, My web site uses contact data from an Access database I created. Due to security concerns, I don't want all of the tables, forms, queries, etc. uploaded to the web site. I am going to use Winbatch to handle automation of this process but need a macro (or other programming) to take...

Friends, I have a subform that I have attempted to lock all but one field (a checkbox.) Unfortunately, it appears that even though I have made sure (under field properties) that the field is unlocked, I cannot enter anything in directly in the subform. The field in the table is not locked...

Friends, I have created a combo box on a form using the combo box wizard. The combo box is linked to a table, and the combo box user's selection is supposed to be entered into a table so I can use it in reports, etc. The form works great. However, when I go to the table field that is...

Friends, I have an Access database which I am working on that will keep track of employee insurance contacts we make to them/on their behalf. I am attepting to automate the procedure of sending dependent student certifications forms to these employees by e-mail and recording this step as...

Friends, I know that this topic has appeared in one form or another throughout the Forums. However, not being a code expert, I would like some "in my case" help. I am wanting to create a button/etc that will create an email with the following: 1. addressed to joeschmo@his-mailaddress.com...

Thanks Dear FoFa, Thanks for the response. Now, onto the big question . . . how do I create the stored procedure. I have little of any experience with this. Thanks, Mike

Friends, I was not sure where best to post this question (here or on the sql database area) but I thought I would send it here seeing that I have had no replies when I sent to the forms forum. I use an accounting program that runs off an SQL database. In an attept to save considerable time in...

Friends, I was not sure where best to post this question (here or on the sql database area) but I thought I would send it here first. I use an accounting program that runs off an SQL database. In an attept to save considerable time in the creation of checks and electronic transfers, I have...

Yes... Yes, I know they are two different things. Thought, though, that since I was working directly with the server files, I should probably post this here. Don't worry about it ... I just posted the same question to the Access Forms forum.

I am creating an Access database that I want to be able to use to change a header table and its associated detail table. I have created a fmain-form that shows the header table fields. This form also has a subform which shows the detail records which are linked to a field in the header table...

Yes... Yes, I thought that this might have as much to do with the SQL as it does Access.