I need to be able to color a single text box on a continous form based
on user criteria. I can't get this to work without it coloring every
text box whether it matches the criteria or not. If there are any
suggestions please help. Thanks

I want to create a search form where the user can input a certain report name
and the report is pulled up.  In the form, I have a combo box that has a list
of two record types (PTP, TSP) and then in the second box the user inputs the
4 digit number of the record type (ex. PTP ...

I have an Access 2000 database that has worked OK for some years, but about
once a week or so, when I open it, none of the butttons on the main menu
form work.  I click them and nothing happens.  Their function is to open
other forms or run reports.  However, if I close the form ...

I have an MS Access 2000 application that I would like to be able add a form
that will display the contents of a folder that is on a shared network.  The
user needs to be able to open the files displayed from the MS Access form.
Does anyone have any suggestions on how this can be ...

 I have an odd issue going on and I am not certain what is up. I have
searched around and I can not seem to find out what is going on.
 First I have 2 tables, the first table has employee information in it and
the second has information for work locations. So my tables would ...

I have 2 forms with what I would call slight discrepencies.  Both issues are
strictly appearance issues.
frmShipmentReport is a form that users enter parameters into 2 controls,
StartDate and EndDate.  They have default values which are used the vast

I created a form for my business to track customers but, the form will not
let me move to the next page.  Although the entry record box is dispayed at
the bottom of the page, it's not active, it stays on page one.
Any ideas on how to fix the problem?

Access 2003
Hi, I have a sales tracker table with fallowing fields. Employee ID, Date,
Model and Number of models sold by an employee. Employee ID is pulled from
another table using Lookup function. Same is the case with Model also.

I have created a simple form and want to put a short cut on the user's
desktop so they can double-click and open directly to my form.  Is this
possible?  
Do I have to create a switchboard?

Hi, I have a form set up, among other fields in the form is a Weekly update
free form field. I have another field called Historical Weekly updates. What
I want to happen is that when a user clicks in the Weekly updae field, the
text that is in there should pop down to the ...

I am not an Access person but I have been volunteered to help another
group with their database.  They have a table/query/form which holds
data needing to be exported to Excel but they only want to Export new
entries. My thought is to add a new "STATUS" field to the table and set

I am trying to access, if this is possible, a property of Leban's Calendar
to set the background color of the individul dates.  I would like to be able
to color them differntly depending  on what dates I have stored in one
table.  Does anyone know if this is possible, if the ...

This is a really silly question which I hope someone can put me straight on.
I have an option group with five possible options. The group is unbound to
any field but is used to run different code depending on the option selected
and then this completes a field. The problem is that ...

I have a form with many fields and an Add Reord command button.  When I enter
data on the form and only fill in some of the fields then press the Add
Record button
the fields on the form are cleared like I would expect but the cursor stays

I have an mdb db stored on the server and every employee access this DB from
his PC over the network by openning his/her form, few days ago some emp.
received an error message saying that "the Jet stoped the process becuse
another user is updating the same record" but actulay no ...