In the join below, all fields from tblPMHlookUP are populated with data (it
is a lookup table after all). When I run the query I get the info I want from
tblPmhDX but I only get the fldDxDesription from tblPMHlooUP. fldICD9code and
fldTypeCode come up with no data. These fields ...

I have on a form an option group with two check boxes. On occasion, I may
want to clear both check boxes. Is there a way to do this?
Ivor

Hi Somebody,
thanks if you could help me generate an expression to caculate values from
two fields whose answer will determine a value in another field.
an example is;

Is there a way to add If-Then statements to the Access Query SQL?  My
code below is taking way to long to run, and I would like to have
Access not search for the items which are null.  For instance if
PROBLEM3, PROBLEM4 and PROBLEM5 are null, I would like the query to

I have set up a form using three db's linked as two sub forms. The are opened
from a single pc by a single user. When attemping to delete the master and
the associated linked records, i get a message that one of the linked records
"is already opened exclusively by another user, ...

I have a table that has columns setup with 3 decimals, however when I export
the file to a .txt it is only exporting out two decimals and I'm losing the
3rd decimal which is really causing a problem.  Does anybody know what is
causing this and how I can fix it.

I have a database invoice that I have spent over a year creating. So far I
can use it but not the way I want to. I have the following fields that I
manually enter the data for each invocie.
Item Number,      Qty.        Product Name,          Price Each,

Hello, All!
I need to link with VB a table from database that protected by workgroup
file (mdw) to unprotected db. I have full access to this files, users and
passwords.

I am working on a database that somebody else created.  This person used a
LOT of VB that I am not very familiar with but I am hoping I can solve this
problem without having to resort to hiring a VB person.
There is a form that is using a query to populate a subform, and the query ...

I would like to send a mass email to each person in my table showing only
their contact info and any blank records and asking for any updates.

Is there an easy way how to determine record selector's width?

in A2002 i have a form with a subform that I need to initialize on Form_Open
(I set subform controls' position & visibility & finally subform's width).
In some cases (when I interrupt the code and go to form designer) the
subform saves it's last appearance (and all controls' ...

How do you use Ubound and Lbound in the Expression Builder?  If possible can
you list some examples?
Thanks for your help,
Cage

I have a continuous form which had in it two check boxes. I added an option
group frame, then cut and pasted the two check boxes to the option group.
The check boxes seem to work properly in that only one or the other can be
chosen. Problem is, changing the value in a checkbox in ...

I have a combo box list in a form, I was wondering is there a way to
change the color of some of the records listed in the box.  Like I
want to flag certain records as closed and change the color to red and
leave the rest of the list in black font.