I keep getting error messages with the syntax or commas in my IIf function.
I've listed it as IIf(And([Sq Ft]=>70,[Sq Ft]<=280),1,[Sq Ft]/140). What am I
missing or what have I stated incorrectly?

My company has moved forward to deploy Office 2003 company-wide.  Problem
is, I have one Access application that works fine when compiled in Access
2002, but breaks upon insertion of a new record in Access 2003.  This
breakage occurs when in both the .adp and ade. in Access 2003.

I have a form to filter a my rptinventory:
everything is working fine, I set my properties and set the filter and the
report filters properly, but what I sould like to do, is on the "Clear"
function it clears my Filter properties, but I would like the clear to also

Hi. Access 2003. I've been using record validation at the form level for
some
time now.  I'm checking the value of required "category" field(s).
The code for the record validation hasn't changed in about 2 years.

My macros create the entry for the key field, DiaryID. I do not want Access
to AutoNumber.
Is there a way to search the existing records prior to placing the entry in
the table so there is not a duplicate created ?  Prior to getting an error

I need to change the background of each record on a continuous form based on
the value of one of the fields.  From this Newgroup I was led to Stephen
Lebans sample database.  I was able to adopt it to my needs and it works
great.  (Thank you Stephen)  However when I scroll down ...

I currently have an Access 2K application that links to Oracle 9i tables,
but requires a DSN connection.  I cannot seem to get the syntax correct to
get the Transferdatabase method to perform this link with a dsn-less
connection.  Anybody got an example of the right syntax for ...

I have a Users table, and the users can belong to one or more Groups. I made
an integer field called Group and assigned a bit to each group they can join
or leave. Maybe this design is not good, it seemed like a good idea at the
time...

In a few posts back of mine about dependent cbo boxes, Marsh wrote:
Since a continuous (sub)form displays multiple records,
there is no way to keep the RowSource query in a dependent
combo box synchronized with the value in the next "higher

I have a form with 7 tabs that are labeled "Indicator A", "Indicator B",
"Indicator C", etc. Within each tab, there is a combo box, whose choice I
would like to be the label for the Tab. This would change when the user makes
a choice from the combo box, which is called ...

I have a field that has a has a sequencial numbering system that began a A1
and is currently at A2500. I need to be able to sort these numerically when
the form opens. Does anyone have any suggestions?
Thanks,

I have a single Option button on a form used to indicate a "special
circumstance" which might occurr for some of the records, it is bound to a
yes/no field in the underlying table.  What I need is some way to determine
if this button is already selected for a particular record ...

On a form, I have a subform setup as a continuous form.  The continuous
subform is displaying two fields of a five field table.  The three fields not
being displayed are parts of the key and the user does not need to see these.
The driving form builds a select for the subforms ...

I have a main form which 3 sub forms:
- Main form has
- subform "frmSurveyKPILevel_1" which has
- subsubform "frmSurveyKPILevel_2" which has

We just upgraded some "over-the-counter" software that now
uses a mySQL server instead of individual FoxPro dbf
files.  I need read-only access to this data for some
queries and modules I wrote.  With the FoxPro tables, I