I have an Access 2002 database which is accessed by multiple users at
different locations. The SendObject command, (DoCmd.SendObject acSendReport,
stDocName, acFormatSNP, stToName & ", ", "John Doe" & ", ", , stMailTxt, ,
False), is used to email a Snapshot format of reports via ...

Greeting,
I have a form to input a data in a table. In this form there is a filed for
employee ID which is the primary key. What I want to do is if the user inputs
the employee id which is duplicated that a message box appears and shows user

I have a button on a form that open a report
As I don't want that the report open when there is no data, I have
used a small script on the OnNoData event of the report
I just add   msgbox "Sorry there is no data"

I'm having a problem with the following:
Not Like ("BAX")
Not In ("BAX")
The above does not seem to work with the follwoing:

I have Bill To Companies which pay bills for several Customer so that many
customers can have their bills paid by one Bill To Company.
I want to be able to have a customer form with a tab for the Bill To
Address.  So essentially I'm looking up the child and seeing the parent.

I am looking for some advise. I created an Access Database for a church
directory.  We would like to put the information on the churches web site. I
was thinking maybe we should create a PDF, but I have no idea which way to
go.  I know there are a lot of smart people here, so I ...

I would like to use some VB to do a simple comparison within a sub form that
changes the back color of the subform cell to red.  I have tried to manually
change the subform property to red, but that entire column still stays a
normal white.  It appears that while in the data ...

I am using Access 2007 and am unable to find specific instructions on how
to sort a table by more than one field,  I would like to, for example, sort
records by city and then within each city by name.
I know I can do it with a query or report but would like to be able to work

I have created a form that filters a report using two combo boxes - cboCC and
cboEAN. The user chooses the cboCC first (CostCenterID), then the cboEAN
(ExpenseAcctID) and then hits cmdFilterReport which opens the report and
filters the report.

Sir i want to design a table where i need to store the data of individual
with their clothing details.
Suppose a employee is issued 50 types of different clothes after specific
durabiility of that particular clothes. like if i issue a overall to a

I have a checkbox which is displayed in a continuous form. What i need to do
is set different DEFAULT values of the check box for each record. Is this
possible? i can't seem to think of a way to do it.
TIA

I would like to create a vacation log for my department.  This is what I'm
invision to be like:
Name:
Date:

I have access 2007  Why when I click on the builder it does not open in any
of my databases or any of those downloaded from microsoft.  Do I need to
reinstall Office 2007 and if I do will I lose anything in Outlook such as
emails or addresses or customization of folders in ...

Dear Sirs,
I would like to see a custom icon with a Form.
I did the following:
I created a module with the name "favicon"  in the DB "Mainswitchboard -

This may already be answered in other threads but I can't get my head round
the answers so hope you can help.
I have a very simple report in Access 2000 and a simple parameter query
which when opened prompts for start date and end date and successfully works