Is it possible to have a field in a table ( A) such as social security #
that takes a number as data.  It is linked to a table (B) that has the
Name and SSN in it for the combo box drop down with appropriate
relationship.  But the form for table A does not let you see the SSN

(This was also posted to comp.database.ms-access before I realized this was
the hep group.)
Lets say that my WinXP computer has two users: Michael and Kathryn. One or
the other logs into the computer and opens up an Access database (I happen

I have an app (using Access2000) that prints a daily report and sends that
report automatically to a number of email recipients in .snp format.  I
would like to change the output format to .pdf because of a number of
problems with recipients and snapshot viewer. I use pdf995 as a  ...

I have two tables, USERS and PHOTOS, in a one to many relationship like this...
USERS:
UserID:  Name:
1        Bob

I'm trying to rename a shared network file after uploading the data
using an import data specification.
I tried using NAME oldfilename AS newfilename and got the generic
"File not found" message.  Tried Filecopy using a DECLARE FUNCTION and

With an Access 2000 application, I am trying to find a way for users to be
able to customise
a form letter with their own text and then be able to print out a bunch of
this form letter with

All:
Form A: Main_Form
Form B: Sub_Form (has the control name: Sub_Form_Control_Name)
Form C: Independent_Form

Cardinality?
I hear it spoken of by MySQL users. Does it
matter to MS Access if MySQL tables are
attached via ODBC?

I am using the following SQL to retrieve a value in a list box using a
unique ID held in the list box call cntID.  The list box is used on an
order form to list appointments that have been made for service staff.
My problem is the SQL is not retrieving the value of the listbox.  I

(Using Access 2000)
I have two tables, similar to Customers and Orders. (Not an exact
parallel, but works for this example.)
On a form showing customer data, there is a tab control. One of the

I am trying to send a report to a specific, non-default printer in
code, bypassing the preview mode, but I cannot find the code to do so
anywhere.  Can anybody help?

I'm creating a query with a where statement using VBA to create a DAO
recordset.  I've separated the query to make it easier to read.  This
is the query:
SELECT [test].Race, Count([test].Race) AS CountOfRace

A client of mine is using Outlook (2002, I believe), and is getting prompted
for confirmation that another program is sending e-mail in his name. That
confirmation has to go, as it's part of an automated process.
I originally used SendObject. But, according to MS, that doesn't ...

The application is at present a 'classic' FE on each workstation, BE on
server split. Both Access 2000. Windows 2000 Server server, Win 2K pro
workstations.
1. I've been getting quite a few 'Disk or Network error' messages. On

I have an error message in an Access 97 database & I was hoping
someone may be able to help me get rid of it (bearing in mind I only
have an average understanding of Access & absolutely none of VB
coding). Originally, this database was in Access 2003 format. I opened