I'm trying to play a sound every time the access main swithboard forms opens.

I know how to do a subtotal for the form by using =nz(Sum([Amount])) in the
form footer.  But is there a way to only sum the Amount when the value of
another field is 1,3,5, etc. but not 2, 4?  Kind of like the SumIf function
is Excel.

I have searched the discussion group and all the solutions will not work.
I have a main form with 2 subforms. Both of the subforms are "Continuous
Forms".  When a record is added to the 1st subform, I have code to add to the
table behind the 2nd subform. I cannot get the 2nd ...

i've got a form with a tabpage on it. On one of the tabs there's a second
tab-page. On one of the tabs of that 2nd tab-page there's a subform.
That subform is shown in datasheet view.
One of the fields on that subform is a dropdown with an sql instruction as

I have a form in continuous view. The form has a formula field on it. For
existing records, the formula works just fine, but for the new record which
shows since it's a continuous view, the field shows "#Error."
Is there a way to not show the #Error for the new record...?

Is there anyway to use a form/query/report from one database to another
database?
I have a program here at work that produces a database file once it has
finished what it's doing. I have to take that file and filter through some

please can some one help me I can't make the form in acces ??
First I made a table than when I try to make a form I can't the problem that
write in the window is : The wizards was unable to generate fields form the
record scoure you choose. Perhaps you chose a query that doesn't ...

there was a problem loading community favorites;the request was aborted;the connection was closed unexpectedly

I think this loop is always running because I fields flickering.
I want it to run through all of the records only once, do what its
suppose to do and then stop.  Something tells me that this isn't doing it.
Any help appreciated.

Allen,
I am wondering if you could help understand this a little more. I've tried
using this code you have written for my own database, but when I attempt to
go to a record, I get an error message reading: "Run-time error '438': Object

When I set up form view so that only the subforms attached to the current
main form are available I somehow set Access 2002 up to show only the forms
from the current session.  So even though the records from previous sessions
are listed in the table view, you cannot see them in ...

I have a problem with IIF and IsNull and it annoys me very much.. Maybe you
will now why Access behaves in such a way..
The problem is that if I use sth like that
If IsNull(Sth) Then

How can I remove carriage returns from a memo field ?
I am using DDE and macros to write a form into another application,
but the carriage returns cause the memo data to be written only up to
the point of the carriage return, then the cursor gets moved into the

Sorry for the re-post but the proir thread ended and I'm still dead in the
water.
So again, if anybody can help, I'd be appreciative.
I am trying to pull a form field as criter for the underlying query.  I

My form stopped functioning and will not populate with records from the
attached table.  If I go to the Form properties and re-select the record
source the records appear in the form.  Could this be a corruption issue?