I have downloaded A2KConditionalFormattingVer27.mdb and imported the class
modules etc in order to try and have the datasheet view in a subform use
alternate row colors. I have renamed the appropiate text box in the code and
added the events to the form as well as used the ...

I am trying to do code that will only run if a field is present on the
screen.activeform and will be ignored if the field is not on the form.  How
is this done?

On my main form I have a subform that I would like to refresh or requery
every 10sec.  
When I add the expression for the me.refresh in the subforms timer event.  
All the forms refresh and cause the afterupdate events to go off if a record

I remember seeing an earlier post (my apologies in advance if I am in the
wrong forum) about someone who had created an add-in called "Albert Kallal
Database Statistics" which could generate a report indicating lines of code
and other useful statistics.

I need to run a report from a form based on the current record I am on in
the form.  I only want it to print that one record, not the entire database.  
How would I do this?
Thanks,

Hi all, I'm fairly new at this and need a little help.  
I have a form with a number of fields on it and a button.  When I click on
the button, I want to be able to grab a number of field values and enter them
in a brand new record on the subform.

I've got a switchboard that I use to open other forms.  The other forms get
opened in a Maximized state, but I want the opened forms to be on top of the
switchboard form, AND for the switchboard form to remain in it's original
non-maximized state.

I am using Access 2000. I have a table that contacts ITEMS purchased on a
DATE at a particular QUANTITY and COST.
I have an empty field UNIT_COST
I would like to update the UNIT_COST field by taking the COST field divided

I have a database program that has a create table querry. I have a form for
one of the table made from the querry and i want to see if there is an easy
way i can allow users to select the table and use that form. Can i just set
the Record Source to be the name of an input field. ...

I am using the Date() function in a series of forms for a shared database.
All the forms work just fine on my development PC but when I run the form on
a staff PC I get the #Name error when the Date() function is used. There are
other functions that do not work as well.

I have a calendar database that allows users to click on the calendar and it
displays tasks due for the user for that day.  I have now been asked to
create a calendar that displays the tasks due on the calendar itself instead
of opening a form with the tasks due.  So, I have all ...

I have an access database with two tables: Main1 and Main2.
Main1 has a field named "firstname". Main2 also has a field named
"firstname. Table Main1 "firstname" has names in it; however, the Main2
table field "firstname"  is null.

I would like to be able to send an email to multiple people but not have that
list of people on the emails.  This way I would not be sharing the name and
email address of all recipients with the other ones that I am sending it to.  
I have seen this used on bellsouth.net.  I use ...

Hello. I have a form which keep track if my clients got paid or not. I am
trying to highlight (or change font color) of the name (which is a text box)
on the form when I clicked the checkbox  associate with that record.  I put
EventProcedure on that checkbox onClick and change ...

I have a form with with about 35 controls on the form. The datatype of the
forms are Text type, Date type and Number type.
Now while posting data, the user does get all the information so he only
able to post some of the control and many of them are blank.