I have a text box on a subform, that I am using an IIf statement in,
so that if the field ([IUSA]) on the parent form Is Null, returns "No
data for this record", else returns "IUSA Data" as a caption.
The code:

Hi everyone.  I have a yes/no field on my form with 3 number fields related
to the the yes/no form.  If the the yes/no form is True then i would like at
least one of the three number fields to have a number greater than 0.  I have
it set so that if the yes/no is false it ...

I have an MS Access input form that is based  on a query that is based on a
table called Training. The Training table is actually an SQL Server table
that is linked.  There are three fields  in the table:  ID (The primary key),
CustomerName and TrainingDate.  I  added three ...

Hopefully I'll be able to make this easy to understand.  I have
several tables in my db, but the ones I'm concerned with at the moment
are tbl_Plan and tbl_Distribution.  tbl_Plan contains information
about an employee's retirement plan.  tbl_Distribution contains payout/

I have one form with a command button. When this command button is
clicked I open another form - I then want to change some of the
controls on this form from the code of the starting form:
      DoCmd.OpenForm "cFrmDocFullDetails"                         '

Greetings folks.  I have made a form's allowadditions property = false.  I
have made navigation buttons also.  Is there a way I can change the message
from 'You can't go to the specified record' when the user is on the last
record and they hit the next button, or when they are on ...

I want to be able to increase my ID field for each new record I enter, but I
don't want to use an autonumber field in my table. I have used the following:
ID = Nz(DMax("[id]", "tblNames")) + 1
and put it in the On Current property of the form. The problem is that when

    VL    L    M    H    VH
VH    0    0    0    0    0
H    0    1    0    3    0
M    0    2    4    6    0

I have setup data access pages and they work fine for over a year. I've just
got a new PC, and when I went to edit the pages the connection is lost. I can
not even view the pages. I'm now using IE 7. Is that the problem? The
computer out of the box connected fine and I was able ...

i have a form where you need to enter a name in a field which, at some point
generates a warning. when this warning appears you have to click a button to
check how many times this name appears in the databse. this button activates
a subform in the forms footer area and at the ...

Microsoft,
May I strongly advise NOT to release further SP3 of MSOFFICE?
My MsAccess application developed using MsAccess 2003 SP2 is not working
anymore after the upgrade to Office SP3! The only resolution to my problems

I have eliminated the navigation buttons on my form and replaced them with
command buttons.  Now how do I make a textbox show a record count just like
the standard record counter?  This counter would not be bound to any field
in the table, but would just be a count starting with ...

How can I specify the position in which a form will always appear in the
window, when opened?
I have several small forms which need to be open and visible all at the same
time and I would like to specify the position of each one in the window, so

On my Orders form I want to have a command button that will open my
InvoiceCreate form in Add mode, so that I can build a new invoice.
The Command Button Wizard includes opening a form but only if you link a
field or display all records - it doesn't seem to provide the option of

I would like to hide/show a line based on the value of a control in a
continuous form.
Conditional formatting is only enabled for text boxes. So how can that be
done?