First, I am not am IT guy. Im just a regular end using Joe who somehow got
confused with someone who knows a lot about Access. My question is this...
I have a database on a shared drive that is being used by maybe 5 people.
Its not split. It seems that the database is corrupt but ...

How inportant is data validation?

adding numbers to the bottom of each page

I changed the start up to initiate the Access Database with an incorrect form
name. When attempting to open the database Access gives the message to
correct the form name but will not allow you to open the database.  How can I
change the form name.

Thanks for taking the time to read my question.
I have been using Access97 until now.  I now have Access2003.
When I start Access2003 I can go to Options - Advanced and choose either the
2000, or 2002-2003 file format.

I have been using Access consistently for about 4 years now. I read the
description "Build with Access 2003 Developer Extensions" aritcle located in
Microsofts "Office Developer Center" and I was very interested in what was
described. However, when I clicked on the link to the ...

I am trying to create an numbered list of names with the names remaining
alphabetical.   Example: numbered list alphabetical say from 1 to 20. If
number 8 passes away the spot will be filled with all other names remaining
in order.  Any new name entered would be entered in the ...

what I am trying to do is get an average price for a product.  I have set up
a form called products which tells me the units on hand/ units on order etc.  
my subform to this shows me date/po/#order/#recieved/Unit price.  What I want
to do is on my main form I want a text box that ...

iif([eeloca] In ('AMRL','ECON','LUMB','SCIL','TWIS'), 20050301, [eeloca] In
('BOAS','BUHG','JBHT','LBLK'), 20050401, [eeloca] In
('CARD','FRON','AFTY','STHF'), 20050501, true, 99999999)
TANKS so much - Newbee

When I enter a number with decimal places on my form, they are displayed as
whole numbers on my table. I have tried various number formats and decimal
place settings.

While creating a new database in Access 2003 and in the coloumn "Date
Updated" of the new record when I type the date 14th April 2005 the date
returns as 5th April 2014. The format is dd/mm/yy
This does not happen to for eg. 12th April 2005 entry however.

Hi.  I want to use a pull down menu to select data that will then be used to
run a query.  The selected pull down data will act as a filter limiting the
results of the query.  My problem is I don't know how to do that.
I have a form setup.  I have the pull down setup.  And I have ...

I have two tables in the same database that have the identical fields. The
only difference is the second table has an additional date field for an
archival date. I need a way to move the data from one table to the other and
prompt for the archival date. Any suggestions on the ...

I am designing a db for a small non-profit, and am fairly new to Access.
The NP receivea donations in three ways 1) at events, 2) through members
(not at events), and 3) through miscellaneous donation from non-members (not
at events).  Currently, the structure is: