New user of Access.  I am getting an error message and need to redefine the
index to permit duplicates entries.  I have searched everywhere and can't
find out how to do this.  Help?!

I have a query that is prompting for entry of a parameter (maybe not a
parameter but it is prompting for information) that it shouldn't be.  The
data that it is prompting for is DayDate:
 DayDate: DatePart("d",[POST_DATE])

I have 2 computers both running Access 2003 and Vista Sp1. On one computer
only (new Sony laptop) in one Access application only and only on one form a
msgbox appears behind a popup form. I thought the program wasn't working and
tested all the data etc. making sure that the ...

I have changed a password to open a access database.  When I type the old
password it tells me it is not correct.  Someone came in on the night shift
that did not know the new password, used the old one and it opened.  Any idea
what I did wrong in changing, I opened exclusive and ...

I have a form that has a command button with the following event
procedure:
Private Sub btnPrint_Click()
   DoCmd.printOut (acSelection)

We recently had to switch towers, for my work station, because of a hard
drive crash (old computer). Anyway, since the switch, I cannot access any of
the Access Databases that are on the networks share area. Everytime I open
one, I get a read only message. No one else has the ...

I have 2 columns with dates in a table. BMT date and Exp date. I need to
claculate the overall survival in a 3rd column in the table whether it is:
           BMT to EXP date (if patient still expired)
                         or

Hi, I'm relatively new to access and I've been using it to compile a Gene
Database for my research.
I have a database of approx 16,000 gene entries. I'm trrying to find a way
to search this data for multiple entries.

I have an input form that passes information to a query, which then in turn
passes that extracted information to another form. This form has command
buttons e.g. main menu, etc on it. However, when the input parameters produce
no records (i.e. where data is selected which has not ...

Access Learner. Access 2007.
If I create a database in Access 2002-2003 file format in Access 2007
and then split the mdb file into BE and FE, can I use copies of the same
FE in both Access 2007 and Access 2003? Or I have to modify it to use it

I have a job number field in which I would like to prevent typographical
errors.
Some one has suggested that I use validation rules.  Can some one give
me a sample?  Thanks in advance.

I want to make a copy of some tables to save them before I run some
queries so I did "save as" on the table and I named table 1, for
example,  copy of table1.  It won't let me do this, it says "invalid
argument".  Is there a prohibition on saving copies of tables?  I

How or where do I use a SQL lookup to retrieve the [Company] field
from the Northwind dbase by the [Customer ID] field via the Orders
table?
I don't know where to start and would appreciate any guidance

Are there any common mistakes that people make when managing SysCmd's
meter?
I' m trapping out with a 7952 (illegal function call) partway through
a loop that increments the meter.

I've got an Access 2007 application that links to MS SQL 2005 DB via
ODBC connections. The SQL DB is used for a Microsoft Analysis Service
database.
Is there any way I can query the database metadata via Access front-