I'm in the middle of converting what is essentially an
Excel database into an Access db.  I work in a production
facility, and the supervisors need to be able to access
data easily, as they have limited computer skills.

Trying to create two tables or two questions with the same name results in an error
Trying to create two fields with the same name in a single table is not possible
I have a few tables that relate to each other in such a way that they form a circle
In one of these I have a primary ...

I was recently given Microsoft Office 97.  I have created
a database in Access 97.  I want to add another field and
I want to create address labels and a form letter.  I
haven't figured out how to do any of those things.  Will

This has happened a couple times before.  We have Office
XP, jet 4.0 SP8. User 1 goes and creates a new record and
gets a new autonumber (6611).  He works on the record for
awhile and haven't saved it.  User 2, in the mean time,

Can someone help me with table design. In my old Q&A Database (a Symantex
Product) I used to put my address entries into categories: friends, work,
school, computer, etc. Everybody could be a member of one or more
categories. So I was able to produce reports in which I could select ...

Andrew Smith has kindly given me some suggested coding
for a module to form the basis of a query in Access.  See
his reply post for the "TextToDate" coding under Access
Newsgroup Item: "Multiple date formats in a Table" (dated

I have one specific query which causes Access (2K) to crash whenever I attempt to save it (even if no changes have been made).  I am able to save other queries without a problem.  I tried copying the SQL statements into a new query, but the problem followed.  I suspect the ...

Has someone used the table validation rules in Access 2k.
Are the validation rules bound for the current table or is the rules
effective as well for a related table?
Eg:

I have a table where I manage information for hot air
balloon flights at a local balloon festival.  I want to
be able to have a field on that table (the "Passenger
Capacity",) to dictate the number of slots on that record

Hi as for the more information ok here goes....
Basically I have now set up my One - To - Many
relationship from tblMP3List (The main Table) to
tblMP3Title (Which has the MP3 Titles in)... To get the

I do mass mailouts for salesmen...I just get XP
Professional...
question: do I use Access, Database for mail merge
purposes?

Excuse the double post but I don't know which group to post to.
Could Someone PLease advise me on this?
I have a table with fields set.
FieldName      Data Type   Format   Decimal Places   Default Value

Got no response last time, so was hoping this time I could get a "stop wasting your time Baz" or, if I'm lucky, maybe a tip
1. Is there any code I can run on db startup that will maximise the current instance of Access in windows
2. Can someone shed some light on events at startup? ...

Hey, I have 2 Number field in a table, the autoformat is
set to currency. It keeps rounding to the nearest dollar
amount (all settings are default other than the currency
type). What's the deal? Thanks in advance.

When I update a table used for the combo boxes on my form,
Access changes all my old records.
Put in another way.
I have a thousand form enries with the following data or