Search results

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...

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...

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...

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...

I have an access database that I would like to upload daily to an ftp page on the Internet. I need to come up with a way to automate this process so that a secretary that knows little about uploading will simply have to click a button and the database will automatically upload. I know the...

Years ago I created an Access database that holds employee information. There are multiple reports, queries, etc. I am working on a project and realize that I was not very smart in giving some of my database field names two words (i.e. First Name, Last Name, etc.). I should have used an...

Friends, I want to create an if-then-else expression that will determine the number of people in a family. It is assumed that there is a head-of-household in all cases. Also, if there is a spouse allowance, there must be a spouse. I thought that determining the number of people in the family...