the ingredients of my situation consist in three tables
a) Audit Reports (parent): PK = "IRB Number"
b) Evaluations: PK = "IRB Number" and "Date of Audit"
c) Patients: PK = "IRB Number", "MedRecNum" and "Date of Audit"  (where

I am trying to set the focus (SetFocus) of a find button to default to a
specific field.  I have done so successfully in other Access Files.  However
one file will not let me do it, leaving me with "Value" as my only option.
I am using Access 2003

Hi, in MS SQL after inserting a record in a table, the newly generated
identity value for the record can be retrieved from the @@IDENTITY variable,
and returned to the calling code.
The equivalent of the identity in Access is the autonumber value. How can

I have a database that tracks my writings.  The main table contains,
among others, the following fields.
WorkID
Title

Windows 2K
Access 2K
I have designed a database which contains about six one to one
relationships.  My original thinking was this design would keep the database

I have "inherited" a database that has the main table maxed at 256 fields
defined.
Is there an easy way to clean up this mess?
Thanks

I am a novice regarding Access...
I have created a database with a form and a report.
The main database pulls information from a number of mini-tables.  
I've realized that some of the table's fields have to be increased in size -

   I have a field which is first name and it is obvious that only text
should be entered, i tried validation and input mask and i tried to find the
solution but i just can't find me, could you tell me how to do it please.
Thanks.

I've created a "holidays" table for use in a "working days" function. I have
a split database, FE/BE. I understand that sometimes tables are stored with
the FE rather than the BE for reasons of efficiency. I believe a "settings"
table is a typical example (though I could be wrong ...

Using 2000:
Trying to display just a short date in a date field. It is now showing date
and time. I changed the field format to short date and even change the mask
to short date but it is still displaying both  date and time.

I am using Date as one of the fields in a Access table. Now when I am tring
to run a update query (UPDATE tblExpense SET Date ='03/15/2005',
contractedServiceExpense='15', travelexpense='20', pesonnelexpense='5' WHERE
tranid='2') , I am getting an error with a highlight on Date. ...

I have a table called password. it has three fields, the username, password
and accesslevel.I also have a form that is used as access control screen for
authenticating the users who have been defined in this password table. the
form works perfectly, however i need to add one more ...

I have an Excel file that I want to set up a link to in my Access DB.  The
problem is I only want to use it as a reference (never to be updated through
Access).  When I Link to it, it locks it from others using it in Excel on
their workstations.

Access 2002.  I have built a form for retrieving inventory part information.  
The main form pulls in the basic static information of the part.  Then I have
10 subforms, each pulling more dynamic info like order status, history,
demand, etc.  It seems that each subform adds about ...

I am new to access and am trying to duplicate a program that was no
2000K compliant.  The first problem I have encountered is:  fou
fields i.e. 041-04-291-001  I would like these four fields to b
numbers yet find that the number “0” will not show up if I enter i