I get the concept of a two key Primary key making a unique identifier.  Love
that.  When I test my database though and put in a record with identical
primary key fields, the database throws an errors and freezes up.  Putting in
records more than once is just the kind of thing ...

Access 2003 adp:
In my VBA code, I create a new table in SQL Server and then want to access
that same table later in the same sub procedure. After the table has been
successfully created, I then get an error in Access saying it can't find the

Anyone know any good references or setup techniques for starting a data
warehouse using Access exclusively?  I need to take data from many different
tables and queries and store that info in a separate db or tables, then be
able to write queries and reports that users can select ...

I am creating a database where my primary key is a panel number.  From there
it breaks down into cells.  So it is possible for a panel number to be listed
more than once.  For example:
Panel number: 111111

Can someone recommend a sample database that I can look at that will show the
table relationship (one to many) and entering in data that will bring up the
company name with all its info on a form that you enter customer info.  I
can't seem to get this going correctly.  The links ...

This question is blazing across America and many from all walks of
life and child support situations are reading the best selling book:
"The Child Support Battle"
Reduce or Suspend Child Support

I’m relatively new to Access but I have a fairly good understanding of the
basics. What I am faced with is creating an application to create, maintain
and modify “Base House” information for tract home projects.
Our customers give us “rack sets” of plans of houses that they build. ...

I have two forms linked to different queries. I want to add the values
of both the forms in one form so want to copy the values in one
form.how to write the expression?

Is there a (EASY) way to convert a database rfom Lotus Approach to MS Access?
I would like to avoid rebuilding it if possible.
TIA!
Julie

I'm trying to build an ms-access application (mdb) with different languages
support. So the user can select the language that he want (understands) to be
displayed at all forms, queries, reports, messages etc. (Languages i mean:
English, Spanish, German, Italian etc! (not ...

I have a really simple structure for an ISP. I just need to get weekly
utilization figures. The problem is  when the node is over utilized it
gets segmented and the field divides.   I get the weekly data from a SQL db.
Actually it comes from SQL to another Access db.  I have to ...

Looking for a template to record, report and organize data for Masonic
Lodges, Grottos, Sword of Bunker Hill and Shriners. Would appreciate any help
with any applications already developed. I don't know enough to start from
scratch on this.

Hi,  Please forgive my long sad story of confusion and near despair,
but I hope you can hang in there with me and help me figure this out.
I don't mean to be long winded, I just want to get all the details in
here so I can get some meaningful replies.

Is there a place in access that I can print all the field statistics for a
database.  I want a way to get it all rather than looking at each field and
getting size, type, etc.
TIA!

I am new to Access and have the daunting task of creating a DBase in Access
2003.
I have created 2 tables one for File Information (file name, client, billing
information, comments etc) and one for Client Information (contact