I would like to prevent a user from entering a duplicate company name in a
form.  I know this can be done by setting a unique index on company name in
the company table and I have done this.  But I would also like to give the
user a message when they attempt this.  I've tried ...

Hi. My database records patient attendance on a daily basis. I have one form
to record patient number and it automatically records date and time, and
saves this info to an attendance table. I would like a message box to pop up
if the same patient number is re-entered on the same ...

Creating a form in Access 2007

How can I capture todays DateTime when the user click the Status Closed
radio button on a form?  I don't want the user to type the date. Only
collect the DateTime of when the status was changed?
I have a radio button = Status

Not sure if this is the right place to post this but here is my problem.  I
have a multi user database, all info is inputted by forms,  all a sales
persons records are sorted by a query and displayed on their screen with a
form.  recently i started getting random entries that do not ...

I am a novice user of Access. I am using an employee vacation database that
has been in use, but would like to add another feature to further enchance
the reports that are retreived.
When I open the file in forms view I am clicking on Design View. In Design

access 2k;
I've read a million "why doesn't on focus / activate work". I'm very
well aware that on focus doesn't work as most expect.
Here's what I don't understand:

I've got a calendar control on the main form, and I want a subform to be
filtered to the date selected on the calendar control, but can't get the
syntax right.
The subform needs to display all dates at first, until the date is selected

I need help!!! I thought I was changing my menu bars File section and instead
of my menu bar I changed the Access default menu.  Now I don't have the
standard Access menus under the File section.  Is there anyway to get the
defaults back?

I have created a simple database with a query that is getting its
parameters passed to it from a form I made.  The issue I am having is
twofold....
First, I can't get the "ALL" choice in my dropdown combo box do do

I have created a form where it has a text field that is only for IT use.  So
when you click on the text box, it asks for a password.  The only problem I
am having is that when you enter an incorrect password, it still allows you
to type in the text field.  It will come up with a ...

We are changing from Access 97 to Access 2007. Most of my forms work with no
problem. I have a couple of minor glitches that I could use some help with.
Main form "NEW_ORDER_ENTRY" with a subform "CUST ID subform FOR NEW ORDER
ENTRY" for looking up parts. When I double click in ...

Access03
Have an Order Main form and a Customer Subform - their link is the customer
key.
When I start a new order the Order form will autonumber increment its order

I have a combo box of queries so when I choose a query it opens separately.
I found a database with a dynamic form that places a query result into a
text box. It is similar to what I would like but my queries are "totals"
queries with calculated percentages.

In Access 2007, when I design an option group with a few options, everything
works fine with option boxes but NOT with toggle buttons: Clicking on another
toggle button (in the group) keeps the 1st button activated. All buttons are
perfectly positioned inside the option group and ...