Search results for query: *

Thanks for the help. I got it workig. I declared a global boolean variable and had the click_event code check to see if it was false, if so, it didn't run the code. When the form was loaded, the variable was set to true so that it would run the code if someone click the check box. Maybe this...

tried that, still calls the click event :(

Is there a way to change the value in code of a check box without having it call the click event? I have an array of check boxes that add a record in a database when you click that box. When I change the value in code (say in the form_load to see which boxes have the corresponding records in...

First off I will explain the design of my form. I have a sub form to show the records for a each client. In each record is a cost field which is inputed by the user. In the form footer of the sub-form is a text box set to invisible. This box calculates the total for that customer using the...

First off I will explain the design of my form. I have a sub form to show the records for a each client. In each record is a cost field which is inputed by the user. In the form footer of the sub-form is a text box set to invisible. This box calculates the total for that customer using the...

sorry, that should read the same form...

both of the fields are on the same report. one is in the details section (the quantity * cost) and i need the one in the footer to make a sum of the one in the details section.

Here is a description of the situation. I have a sub form that i need 2 calculated fields on. The first is calculated from the quantity and the cost of the record and is in the details section of the form. I have this one working fine. The second one is in the form footer and must do a sum of...

I need to place a text box on the form and the data needs to be the sum of a field in each record of the sub-form. How do I do this? Ex. "Amount" is the field in sub-form and "Total" is the text box on the form which needs to add the Amount for each record together.

never thought of that, but how would you select multiple people (maybe on the dbl-click event)?

Thanks, I'll try it

I have a training database here and for the fields in the table I have firstName, LastName, CourseName1, CourseName2......there are like 80 different courses courseDescription, Instructor etc. These CourseName fields are yes/no fields, so for each person the courses that they have completed are...

Every time I close a form or add a record a blank record is added. I have to do a requery as well. Can anyone help?

When I try to add data to a 3 tables using a form I get the following error.<br><br>&quot;Can't add or change a record because a related record in table 'table name'&quot;<br><br>What do I do? I've tried changing the relationships etc. but to no avail.<br><br>If you can help, it would be...

When I create a shortcut to an existing database and run it, my computer shuts down to a black screen with a flashing cursor. However, I can open the database no problem by going through access itself. I can't right click on the file and select properties or it does the same thing. I'm...