Hi. I have some Members who are lucky enough to have
second homes and would like to alternate their mailing
addresses. There doesn't seem to be enough records
(imagine that!) to add tables, etc.

two tables linked by CustomerID on a CustomerRegistration form as below...
tblCustomerInfo
*CustomerID
tblEvents

I have a continuous form that showing multiple records.  In the form footer I
have a text box that displays total records with the following code =count(*)
which works just great.  I want another text box that displays how many of
the total records are in "Complete" status, which ...

When I started using Access-2000 I had to convert any database for using it
with Access-97.
Now I want to get started with Access-2003 at home, at work I have Access-
2000. Do I have to convert my databases from 2003 to 2000 to cintinue

I
I have a form  FrmMain which contain 2 subforms  SbForm1  and SbForm2
Each of the subform has the same field call N?Emp
I would like the code to put on a button and this code should be able to

Does anyone know a way to automatically refresh one form after adding a
record to a second form without having to add a refresh button to the main
form?
I have a combo box with a list of vendors. I have it set up when a user

Hi all! :-)  Windows XP Pro - Access 2002 XP
The code below is in the NotInList event of a combo box on a data entry
form.
*****Begin Code*********

Is it possible to change the background color of a report textbox depending
on the value of the field value?  Any help will be appreciated.

I apologize this is probably a dumb question but I really can't see the
problem.
I had a perfectly working form that needed changes. I reduced the number of
objects in it, including text boxes and one tab area.

I wanted to create a FIND button (binoculars) on my form so i can search
for a customer's last name and have it pull up that record.
Using Access 2000 (therefore cant use the wizard due to bugs in the program)
.  Is there any other way for me to insert that command?

Recently switched from Access 97 to Access 2003.  I have a form which
contains command buttons to open various reports in Print Preview.  Shortly
after I open any report using these command buttons the Form reappears,
covering up the report I was viewing in Print Preview.  This ...

I have a tab control with four tabs.  I would like to put a two-tab control
on the first tab.
Whenever I do that, it appears on all four.  
I click on the tab to make sure that's the "active" one.  For any other

How can I select/deselect a Yes/No control based on a date control on the
same form. Based on the research I've done through the discussion board. I
think the AfterUpdate procedure on the date control is where I should place
my code. If the date is 30 days passed the Current ...

I have the following as a control source in the group footer section of a
report:
=SecondsToTime(Sum(DateDiff("s",[TimeFirstChart],[TimeLastChart])))
This produces 7:11:04 or 22:44:21 as examples - how can I get a zero to

I'm using Access 2k. I've got a form for entering invoices, each invoice can
have multiple lines and these are displayed with a linked subform. I need a
way to validate that the sum of the entered invoice lines in the subform
equals the invoice total on the parent form. I can't ...