I have a report with a calculated "Total" field (totals the invoice subtotal
plus calculated taxes field).  This field is currently set as currency.  Can
I set the field to NOT round up?
Your help is appreciated.

I have a database with tblMain and a related tblLink, represented in my
application by a form/subform.  The subform fsubLink is for adding links to
files that are relevant to the main form's record.  The trouble comes when I
attempt to view the links using Application ...

I can only get the first one (in tab order) to display in datasheet
view.  IF I switch to form view both show.  Is this a limitation of
access, or something I can change by setting properties correctly?

I have a simple form which allows updates to records in an employee
file.  Each time a record is changed I would like to create an audit
record in a separate file.  I do not need any input from the user when
creating the record as all the information is implied (date, time,

I have a subform to be viewed in both datasheet and form view.
When the form is viewed in form view, no problems. When viewed in datasheet
view the following code generates a 'Property not found' error. The offending
line of code is 'CheckMDBF = False' in the function (Well at ...

I have a form that I use to print all my reports.  The reports are actually
in Word and use different queries as the datasource.  The queries create
temp table.  When the code runs it gives me a warning about deleting the
table even though I have Warnings set to False.  Here is ...

With the code below I'm trying to clean up nulls on close (via cmd button),
its propting for a parameter:
"Forms!frmPtDemographicNew!frmVisitNewEdit!fsubRNnotes.Form!fldRNnotes."
DoCmd.RunSQL "DELETE * FROM tblRNnotes WHERE [fldRNnotes] = [Forms]!

Does anyone know how to compare data?
If same update the quantity else just ignore it?

I have a misbehaving bound combo box on a form. The field to which it is
bound is neither required nor part of the primary key in the table, yet the
form generates a 3162 error ("You tried to assign the Null value to a
variable that is not a Variant data type") when I clear the ...

To be eligible for a study, a patient has to meet certain criteria.
There are 7 things that could prevent the patient from being eligible
(e.g., "Patient is ill," "Patient is pregnant," "Patient is on
medication," etc.).

With the code below the cmdVisitEdit is always invisible. this is in the on
current event. It shouldn't be always invisible if the tests work. If the out
of room time is over 30 minutes or if visit date is not today, then the
cmdVisitedit should be visible. Anybody have any ideas as ...

This if statement in a Query always returns the first value.....any
help is appreciated.
Thanks
DS

How can I combine these two statements into one?
Thanks
DS
=Nz(DSum("-(CDFinalPrice*CDDiscountPercent) *

I am trying to open a form to a specific record based on dbl clicking
a record on the sub form of another form. Here is the situation.
Form1 (SelReceditFrm ) is open with a date field where user enters
date

Hi Im getting the error "(missing operator) in query expresion" .... it then
prints part of my join
Full text of the join from the immediate window is
SELECT r.ID, FirstName, LastName, Gender, DateDiff("yyyy",DateOfBirth,Now())