How do I fix this error?
The database has been placed in a state by user 'admin on machine
n350013205 that prevents it from being opened or closed.

I have 1 combo box and 5 other Controls. I am pulling using a query to
pull the records and putting them into combo box. I want to be able to
select an item from the combo box list and then populate the other 5
controls with it's corresponding recrods. Does anyone know how I can do

Whenever I enter the record and then go to a report based on that
record the record does not show up in the report it is blank.  Its
there but it appears that the table has not accepted the record when I
print.  If I go back and then select another record and go back to the

I created a continuous form, but I want the blank record for data entry
to appear at the top of the list of records rather than the bottom of
the list.  Is there a way to get it to move to the top of the list?  I
tried sorting the list on the Id field but that did not work.

When I link to a Excel using Access I had a mismatch.  So I went into Excel
and changed the column from a General type to Text type and saved the file.  
I then opened the linked Table in Access and noticed that the field type was
a number.  I retried the process and it gave me ...

I have an application where I retrieve access 97 data with a query, export
it to an excel spreadsheet (test.xls) and use a button on my form to open
excel.  I need some help with the code to have excel open directly to the
file test.xls.

Since switching to Access 2003, every time I open a form, report, table, etc,
a new tab shows in the task bar.  Is there anyway to turn this off?

I have several unbound fields named: "SetNum1", "SetNum2", "SetNum3"... in my
form, I need to do the same thing for each of these fields, say:
Private Sub x_delrecord_Click()
   Dim dbs As Database, rstCustomers As DAO.Recordset

HELP!!!!!!!!!
Thank You
Sheila Wells

I develop in .NET, typically using a 3 tier approach where I have client
machines connecting to SQL server.   Anyways, I got pulled onto a project
where they want Access to connect to a SQL server so that the users may have
a great deal of control over the queries and reports ...

I have 2 list boxes.
The 1st loads from a query.
I need to load the 2nd list box based on the bound filed #1 of the 1st
listbox.

I have one table with product number, product description, and product price.
I want to create a simple order form in which I can enter the product
number(and it will automatically fill in the entire number as I type) and the
description and price will be pulled from the table ...

how do we set up email  via microsoft when we have radrunner as our service?

In various tutorials the one and many symbols (infinity sign) are
displayed at the end of the lines connecting two tables key fields. But
in my MS-Access (2002) there is only a line with no "1" or "8" (turned
90 degrees).

I need help.  I have set up a form and it works okay, except that I have 3
dlookup fields.  When I look at the table all the data is there except the 3
lookup fields.  How do I fix this?