I have a continuous form and want to put a total in the bottom.  As some of
the data fields in the detail can be null, I use =nz([Allowance],0) which
works as expected.  The result is either the value in Allowance, or zero.  
For the sum I use =Sum(nz([Allowance],0))  Which causes ...

Could anyone tell me, is it possible do a summary calculation of a subform
and show the results on the main form. If I have a form and there is a
subform displayed on it. One of the fields on the subform, is say a job cost,
as the additional records are entered on the subform, ...

what would i do if  there are multiple
records and  the user want to enter only once
for example there is a table as follows
Region            Carrier

I have a form with the following subforms:
Subform1 - has a list of procedures that a client was charged for and the
fee for each procedure
Subform2 - is linked to subform1. It has the following fields:

I had crafted an ActiveX control in VB6, embedded in an Microsoft
Office 2k3 database.  It worked great.  Now I'm getting a problem with
the "onmousedown"... access is telling me that property is not
available to embedded form activex controls.

When I open my AC03 database using AC07, my main switchboard (SB) opens, but
when I click on a button on the SB (to open a report), there is an error
popping up saying, "There was an error executing a command."
I try to go to Office Button -> Access Options -> Trusted Center -> ...

I have on my form a combo box which allows the user to enter in an address
and then it will find the record associated with that address and display it
in List boxes containing the City, State, Zip and so on. The problem is that
my City and State list boxes are displaying the ...

I have a form that onload, I have it set to maximize.  On that form, I have a
command button that opens another form with that record.  See code below.  
The problems is that when I click the button, the second form also maximizes
and does not seem to take the properties I have ...

Are there any general design principles I should stick to when designing
forms, in terms of size, fitting it on the page etc? Assuming I am designing
for the smallest screen, what is the best height and width?
I have been having a bit of trouble trying fit a tabbed form on a page. ...

I have an Access 2007 project connected to a SQL 2003 database.  One query
returns 71,074 records whether sorted or unsorted. (Max records = 0.)  When
using this query as the rowsource for a combo box on a form the drop down
only returns a portion of the records IF the query is ...

I have a combo on a form which is a value list. 0,3, 4 are the options
available from the list. I have a query based on a table and the row of the
table that I need to query against has contains values 0,1,2,3 as data. What
I am trying to do is have the query return results when ...

I created a table and form in Access.  I modified the table.  Now when
selecting  the Form view I always get a message "enter perameter value" for
the fields that were deleted.  I have compacted and repaired but still get
the message.  The deleted fields also still appear in the ...

I have a form where I use symbols like ¤ or ¥ before and after a word
so that it could be recognized in another program that changes the
format of the word between the symbols.  That part works just fine.
My question is, if a user highlights a single word in a text box

Hello,
I am having some difficulty, and am not sure of the language to search in
the discussion board.
My form has three date fields to be filled out. The input masks are working

How can I do the following?  Right now I have:
If [field] = "abc" then something...
How can I make it be If [field] = is not a number then something....