My users all want their auto-numbers to start with the year....07...and
that's going to last for the next two years.  I have a text field that I am
trying to make default to 07 for this year and then another field with an
auto number to increment it.  

dear sir ,
i would like to know the code that can exit from the sub form on exit its
lost field
and return to main form tab 0 field and save the records

i'm looking for a way to produce a phone book like template which means i can
type in the information i am looking for and it will come up. Similar to how
you type in 's' on your mobile and it comes up with all your contacts
beginning with that letter. Is this possible to do on ...

i'm relatively new to access and appreciate any help you can give...
what i THOUGHT i wanted to do was set up dependent fields, but then read
that "In the ideal database design, the fields are not dependent on each
other, so if you are comparing fields, you might consider whether ...

I am trying to build a special data base to track attendence in study groups.
?Sometimes people attend different groups than what they've commmitted to,
but still deserve credit for all groups attended.  I have created a form
which identifies who should be in that group with ...

I am trying to build a set of tables to allow "types" to be assigned
to specific items in a plant.
The grouping of these items would follow this kind of pattern.
Division - the major craft group dealing with the item, Group - the

I have a problem with a combo box on a form which is bound to a query.
I have used On Got Focus in the combo box to set values based on other
fields in the record. The fields which contain the criteria are not changed
on the form so that is why On Got Focus was used.

Hi people.
I am attempting to develop a new database and I’m new on Access.
It will work (I hope!) like this:
Database has 4 Tables:

I am new ACCESS user and have some questions.
1. What kinds of joins (eg. next loop join, merge join etc..) Jet Engine
provide? and could someone give me some links for the information?
2. Is Jet Engine a CBO? Could you link some pages?

I could use some help in creating constraints.
I have created a db (access 2003) containing an overview of all cd's in my
collection. Within the db I have created a table Storage (StoragID,
StorageDesc) and a table Disc (DiscID, DiscName).

I'd like to create a look-up field in a table that uses data from the same
table.  According to Access 2003 Help, this is possible, but no instructions
are given for how to accomplish this.  When I try doing it the same way I
create look-up fields that use data in other tables I ...

Hello! While I'm not new to flat databases, I am new to relational databases.
I've been trying to build a database to keep track of my inventory of
scrapbooking supplies which is getting to a point where i can't remember what
i own or what's left of a particular product. I discussed ...

I have 3 databases and I would like to move from one database to another
without closing access. I have been able to do so with 2 of my databses but
not with the third. I have ctrated buttons on my main page. when you click
one database closes and another one opens. Below is the ...

I am tring to make some sort of data base that will allow me to use multiple
speadsheets in one print outable report. What i am dealing with is i have one
sheet that has the pricing of materials and three more that has part numbers
and what materials go into its packaging. i want ...

I have tried in different design view mode and yet I can't display text
automatically in in a field in the pages view.