I have built a realational database in Access 2007 with 9 tables,
queries and forms for the 9 different types of tools we use. Each type
of tool is or can be in many different locations, so I have a field
called 'Location' in the tables for the tools, as well as 6/7 other fields.

si am using access 2003 and I have a field in the table called city
i want to create an input mask to automatically capitalize the first letter
of city names even if they have two parts such as New Cambridge or
North Canton

I have 2 tables both are the same fields, I want to put them in 1 query, but
when I include the numbers fields, and use the Total: Sum some of the total
makes no sense, look like repeating values in one side if the other side has
more records. How can I solve this problem.

Okay, I have a question about denormalizing.  I have an activities table.  
One particular activity that may take place is the setting of traps, each of
which has many captures.  Another activity is hunting, which may also have
many captures.  The problem I'm running into is ...

All
I have borrowed code from the web and it works wonderfully in developing
cascading combo to 2 levels - what I need is a macro to go to a third level.  
the code I am using now is

Hi ...
I have got a database that several users work on. I want to know how do i
set an option that appears a confirmation massage upon attempting to save/do
any changes on current record before seving them - like "Are you sure you

Hi
I have 2 tables, with sea temp per date, how can i join 2 tables one with
data from 01/01/2008 until 30/03/2008 and another table with data from
01/03/2008 to 01/11/2008. i don't want to cut the tables and don't want to

Can I open a new instance of a form and move it to a new record?  If so,
could any problems arise if a user opens two instances in this way (set to
new records)?
Thanks,

Is there a way to setup different install options for a split DB using Access
2007 Runtime?  install both frontend and backend, install just backend,
install just frontend.  From what I can tell it only allows one setup option.
Any information would be appreciated.

I'll try to describe the situation pretty thoroughly and then I have a pretty
specific question.  For an Inventory database, we are trying to keep track of
2 pieces of information.  One piece is the quantity of each item (each item
is defined by an SKU number).  The other piece ...

Front end vb6, back end Access.
Program makes reservations for my library.
4 rooms, length of reservation will be in half hour increments
I need to be sure two events are not booked with overlapping times.

let's say i have 2 tables with identical structure, date and value for
example. These 2 tables contains overlapping data for example, the first
table ends at 30/04/2005 and the other one starts at 01/01/2005. there is no
option in the relationships to join 2 tables with the ...

Hello -
I want to create a "Browse..." botton, and beside it a "path" text box.
The "Browse..." botton should open a dialog box to choose the file and its
location.

I have a table with minimum and maximum values to find out the ideal weight
for each heigth of the Client's Table.
I wan't to put the client hight and need access to Lookup on the other table
wich is the ideal weight for that person.

Is it possible to synchronize 4 combo boxes? If so, would I have to create
four tables and link them?  Please help, I am in a big rut...Thanks!