Search results

Thank you so much this worked perfectly. I have been trying to figure out a way to do this for days. At first I tried on the form and this is by far the simplest way. Thank you so much for your help.

I have a query that has 4 yes and no fields. In the query I want to add all the yes values. ie... [FieldA]=Yes, [FieldB]=No, [FieldC]=Yes, [FieldD]=Yes, [SumField]=3 I know there has to be an easy way to do this. Any help would be great. Thanks!

Thanks for the help with the coding. I have added a little bit of both of your code and it is working fine. The only thing is that the [Text Box B] field is not technically required. You can go to the next record without having to complete it. Is there any way to do this or is the only way...

Before update event of what. [List Box A], [Text Box B], or for the form?

I have a question about conditional formatting. I am using Access 97 and I am trying to make a field required or not depending on a certain list box (whose values are yes/no). So basically I have [List Box A] whose values can only be yes/no. And when the value is yes I want [Text Box B] to be...

WayneRyan, Ok, I added the code to the form. But the boxes aren't check boxes. They are text boxes with a list of either yes or no. And the default is to yes. I am assuming that would change the code that you gave me. Also, in total there are 45 of these list boxes. I have 4 different...

I know very little about coding. I am still a new user and try to avoid code at all cost. Can you explain a little bit what this is supposed to do and maybe a little more detail on how to do it? Sorry, thanks for the help though.

The two boxes that are not working have a default value of Yes. And the Control source counting these as 2. There are a total of 30 boxes that are being added in one control source. Everytime I change a yes to no the number drops by 2. Why does this happen? Any help would be great. Thanks!

I am still fairly new to access and I am not really sure what you are telling me to do. It appears to be working with two of my control sources but not with the other two. And I did the exact same thing on both. The two that it is not working on have default values of Yes. Would that make...

Related to thread http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=43238 I have put this formula into my control source. Dcount("[Field Name]","table/query","[Field Name] = [Textbox/Combo]") And it wasn't until after that I realized it wasn't exactly want I wanted. I...

Works but doesn't I have put this formula into my control source. And it counts the number of Yes's in a record as it should. But the number does not change when I move to a new record. Is it the same as the number in the 1st record. What am I doing wrong?

Hello- I am having trouble setting up my tables. I was given the general appearance of how the form should look and am now trying to work backwards to come up with the tables. General Background - When the company I work for brings on a new mutual fund group there are 184 tasks that...

The macro that I have now puts info in a field. And according to the Help you have to type the information in for the on change event to work. So how will this be different than after update?? Or am I missing something. Here is what help says-- Setting the value of a control by using a...

Network Drive I am not sure if this will help you or not, but...Are you running this database off of a network drive? Because I have a database where I have to run simple macro to update things etc and it was taking hours to update on column to 0 etc...so I saved it to my harddrive insted of...

I went to this link http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=36332&highlight=update+field+on+current+form+only And I basically want to do the same thing. I want the date to be the current date when the field is entered. However, I tried to set the date field to...

*I have a form where if the word "SEI" appears in a certain field a command button will appear. This command button will appear after this field is updated and on the on current event of the form. *However, sometimes this field is not updated manually. Most of the time this field is input...

I have a main form with several subforms. The main form is linked to a query which asks you to select a code which relates to a specific company. So when you load the form it asks you to enter the company code (ie CA for Company A). Some people at my work are printer happy and want to have...

I would say that someone could have that table open which is causing a problem. However, the table is hidden and the only computer it can be seen on is my own. And even if my computer does not have the application open people get the same error message.

I have a database with two front ends and one back end. Up until yesterday this was working fine. Both front ends have tables, queries, forms, reports, and macros. Yesterday, front end A worked fine. And everything on front end B worked find EXCEPT for the a certain form. Everytime anyone...

If you are going to put text in the Expression box you have to put a ' in front and back of the expression. Then it works.