I have an OLE Object field in a table.  I want to remove this field
since it is a poor way of using pictures.  I can not delete the
field.  I get a "property not found" error and I can not save my
changes.  If I try to remove and records with items in this field my

I have a text file link table and set up all the fields and data type
when I linked the table.
There is one field has value more than 32767,but I set to integer.
I tried to change the field type from integer to long integer, but MS

I am trying to use the following query as the record source for a form:
SELECT * FROM dbo.tbl_employees WHERE  dbo.tbl_employees.empID =
[Forms]![frm_listCSRs]![empID]
It works fine if I replace the = [Forms]![frm_listCSRs]![empID] with = 697

I'm trying to wrap my head around this.  Currently I have database that
tracks our incoming test for our office.  When tests are entered into the
database, one of the fields is for the  student whom is to take the test.  
Well there could be multiple students.  So, what would be ...

I have a database that I maintain with several forms, tables, queries, macros,
code, etc. that I maintain to keep track of employee education records for
the education dept. in a hospital.  I created the database in Access 2003 SP2.
Our tech staff has begun to upgrade PC's here to ...

I have tried to use MS Office help to create a multivalued field... But I
have a problem with the step Number 6... -
Under Do you want to store multiple values for this lookup?, select the
Allow Multiple Values check box.

I'm working on a database that contains information about how well a
question was scored on an internal assessment. In order to make the
data work for PivotTables, I have it set up as one record per line.
*The field names are Question Name [text], Score [number], Date

I thought there was a template for my book collection but I can't find it.
Anyone know of one?

I have tried to use MS Office help to create a multivalued field... But I
have a problem with the step Number 6... -
Under Do you want to store multiple values for this lookup?, select the
Allow Multiple Values check box.

I have these two tables, in two different mdb files.
http://www.anothermasterpiece.com/help/access2.jpg
I now want to transfer the data from the one table,
to the other. But I get this error -

Dear friends,
I am in the process of developing a database to keep tracks of customers
buying equipment and then maintain this equipment every 6 months.
I will create a table for my customers, a table for the equipment and then

I tried the Data Type AUTONUMBER and It is not working the way I want it.
Maybe I am doing something wrong.
I created a Database and I want the next record to come up automatically and
if I need to delete a record, that record number should not be deleted as it

In a database to capture the results of a survey, what is the best way to
store 3-way values like Yes/No/Dont know options?
Thanks.

any one know the proper  way to add caption to a field name?   the field name
is   Employee Name  
the question ask    type in the field  Employee Name than add the caption  
last name , first name.      any one know  how to add the caption ?

Can you add more then one links to  heperlink field ?