My combo box has the following 3 columns:
FabricID (which is an autonumber), Pattern, Color
Typical data could look like this:
1, Plaid, Green

I need a query to be updateable, but than cannot lookup values for several of
the columns.
The query has a user input race finishes in a column.  Automatically I need
the points column to be updated.  For each finishing position, there is a set

MsAccess 2003,
we set primary key as AUTO INCREMENT,
e.g .
ID :

I have a database with customer info with linked to purchase orders, linked
to contracts, linked to commission.  The form with the customer and the PO #
has a subform listing the individual items in the PO.  I have placed this
form on the Main Customers form to make it easier to ...

How do I make a chart for farm expenses for income taxes?

We have an application in Access 2000, front end/back end design,
10-12 users.  I want to save the dates and times they enter and exit
from the app from their workstations in a table in the back end.
How do I get the name of their workstation to save to that table?  The

I've locked a form options field, using forms properties, but users can go to
table and edit.  Options field on form does lock as needed.  I've tried
changing user permissions, to prevent any modifications by table, but it does
not work.  It either prevent editing to whole form ...

How do I set up a form so only one person can enter data at a time?  If the
form is open I want it to be read only for all others that open the form.

In Access 2000, in thee VBA IDE, how do I change the font size in the project
pane?
Thanks

Suppose I want to add all the numbers in one column, with the
following caveat:
All values should be capped at some high threshold level.
As an example, suppose the threshold is 10000 and the numbers in the

I have a rather large database that tracks past and current medical
residents. There are several other users, so I have designed it with lots of
buttons and automated links. I downloaded the 2007 Office version, but when I
take the 2003 database into the 2007 version, none of my ...

All my data in Access is now upper case.  I wish to change it all to lower
case (even better would be to keep first letter of each word upper and make
all other letters lower).

I was wondering if the following is possible:
I have a table which contains about 30 different shop items. What i
wanted is to create a macro which when clicked would automatically
create a report on each item (thats 30 seperate reports) and then

I run a weekly query using access and I export the resulting table (Co-Sync)
into a folder using TransferSpreadsheet. I would like the table to be named
with the date of the export. i.e: Co-Sync-03-15-2007.
Is there a way to do this using macros? I'm clueless when it comes to VB ...

Hi i have a macro which is executed when i click the button. I want to
add two options to this though.
Before the macro is executed i would like a warning of my desired text
to be displayed offering the user to cancel.