I would like to make a sample database that limits the
amount of entries. How can this be acomplished.

I have a field in a table that has a Short Date format
with an Input Mask: 99/99"/03".  The dates we are trying
to enter are "03" dates but they are automatically being
changed to 2004.  What's going on and how can I still

I'm trying to setup a field in my table so that its contents changes based
on the value of a field in the same record.
Specifically, I have a table detailing IT work that has been performed on
various computers called "IT Completed".  One field in this table is

Hello dear ACCESS-users,
my problem is, that I want to operate an MS ACESS database with connected
tables
to a second MS ACESS database via a DSL (flat-rate) connection, but the data

Firstable, excuse me for my English. I have to build an application that
calculate the balance of a stock.
I have the choice with 2 tables design.
First possibility with 3 tables :

Access 2000 - I am having trouble setting up a new database. I'm sure
there must be an easy solution, but I have not had enough experience
building databases to know. I feel like I am in over my head, but don't
want to give up; I will be grateful for any help you can offer.

Can a fieldsize for a text field be set to a value greater
than 255?  How can this be done?
Thank you.

I am trying to create a table that uses the current year
plus a sequential number example (2004001, 2004002, etc.)  
Then next year I would like the number to reflect the
current year and start the sequence over again. I tried to

I'm creating a database to track prospects and buyers of
houses being built.  I need to tract prospect info,
house/model info, and buyer info.  So my basic table
structure is something like this:

Whenever I carry out the first search in my Access table I
get the following error message: Invalid Argument. Once I
click on ok the data I am searching for is found, so it
does actually work. I just wondered why on each initial

I need to link a table to the Contacts within Outlook.  
That much I've done.  But, I also need to create
additional custom fields within that table, or in another
table, to store additional information about those

I'm currently using Access 2002.  I've linked a table from
another data base. My database has grown to more than it's
original plan and I need to change the linked table. My
first instinct was to replace it with a new table.  

Is there a way to link an Access field to a spreadsheet,
sort of like a hypertext link? I'm using Access 2000.
Thanks.
Larry

I am using Access 2000
I created a database with an autonumber field that
consists of the year - dash - 4 digit incremening number.
In the format field I put "03 - "&&&&.  This gave me 03 -

I have a couple of calculated fields that the values are generated off of one field.  They are showing up in the form but are not being transferred to the table.
[Hire Date] is the entry field, [Probationary End Date] is [Hire Date] +90 days,
[Annual Review] is [Hire Date]+1 yr and ...