I know the initial answer to "how do you sum a total from fields on a form"
is use the fields equation to get a sum total.
But what about when you have 33 fields that you need to sum and so the
expression is too long? For example:

I have a combo box that looks up three fields in a table, (Lastname,
firstname Middle name).  I have a notinlist procedure that strips the entered
data (removes the comma and space and produces three distinct fields FName,
Mname, LName, then adds the data into the table ...

I currently have a form that opens up displaying the first record in my
table (in read-only mode).  I would like it to open up blank and NON-EDITABLE
until  one of the command buttons (add or find) is clicked.  Is there a way
to accomplish this?

I have a report that is based on a crosstab query that leaves spaces in
columns with no data.  I have tried the Nz function in the value field of the
query (e.g. Nz([payment],0) and in the report fields (same approach) but to
no effect.  How do I get Access 2003 to place a zero ...

My database is used to track circuit board shipments. The serial no. field is
set to "No Duplicates Allowed", as a way to ensure that our serial numbers
aren't duplicated for any one customer.
The problem is that we get returned circuit boards that have to go through

I have a main form, frmDSSF, that is used to submit SCRs to a software build.
I display the possible SCRs in a list box, lstSCRs, for the user to select.  
I display the selected SCRs in a subform, frmSCRs_for_DSSFs, on frmDSSF (the
subform is based on a table tblSCRs_for_DSSFs). ...

I have a main form (frmCharges) with subform1 (frmChargeAddSub) and subform2
(frmBankSub).
Subform1 is used to enter new record and subform2 is used to show all the
record including the one recently entered using subform1.

How do you call a fuction when you start a db in access 2007
Thanks

I have a main form where I enter data for an auction.  The subform is to
enter info for the buyers.  As there can be more than one buyer the subform
takes any number of buyer number, premium and base_price for as many buyers
as want to split that item.  I have to tab out of the ...

I have the code below to open a form of contacts, and I want the button to
open the form only displaying active members, but it is only opening a blank
form (the bottom does say 1 of 1 Filtered).  
The information that I want to test in my code is a check box.

I wondering if someone could please help me with a situation. I am asked to
create a database where the user fills in Customer Name and Address and also
select numerous documents needed to complete the loan. Then click a button to
create an email with that information in it. So ...

I have the code below to open a form of contacts, and I want the button to
open the form only displaying active members, but it is only opening a blank
form (the bottom does say 1 of 1 Filtered).  
The information that I want to test in my code is a check box.

I need to block the user's ability to right click on any form they have
loaded.
I don't want them to have the opportunity to get to design mode via right
click on a form or by pressing F11.

I have a form that has a subform on the main form. I also have a tabbed
section on which is another subform. The main form contains txtSSN which is
linked to the subform sfrmConsult via master and child. sfrmConsult has
txtConsultNumber which is pulled back onto the main form in ...

My problem is that I have creates a few forms. I have them set to search for
information and then display on the subform that is on the main form. Well it
seems to work fine in some of the forms, but then not in some others. I have
checked the property sheet on the working ones ...