Hi I hope someone can help....
I have a "BookingPayments" Table that I wish to redesign to be "normalized".
Each booking has it's own reference by autonumber created in a "Bookings"
Table. For each booking there could be up to 10 payments made on 10 different

Does anyone know how to return the name of a field index in an access
database from within the front end?
I have code to programmatically delete fields in a table to achieve design
changes but the index name varies and I need to check this before deleting

I added a field for an actual year - the old data is based on the yea
data as 98 99 00 01, etc.  I was hoping I could find out how to fil
in this new blank field (lots of records) with the actual year dat
after I do a filter

I have a student database and wish to generate a report based on a query
that contains:
Student Last Name (from Family Info table)
Student First Name (from Student Info table)

I have been working on this database table design for about a month or so.
Finally had some slower period here, so I proceeded to diagram it all out.
And with the help in these newsgroups, this one in particular, I believe I
might have my design finished.

Need help with the recall of a task that has the wrong dates on it.

I have a small home business making name bracelets from silver beads,
crystals (available in different colors), and silver alphabet blocks.  The
most critical component of my database is my letter inventory.  This allows
me to know if I can fill an order immediately, if I have to ...

I’m trying to build a table with custom fields specific to each company.
I have 60 company names.  Each company has fields that only belong to that
company.  But also, several companies can share the same fields.  For
instance:

personal tele phone diary or  directory in access or in excel

Early this am I posted a question on Access - Forms.
Now I can not get back to the site to see if anyone was
able to help me.  All I get is "Newsgroup not available".
In fact this is all I get on several of the site within

I have a textbox for a name.  I would like to put an input mask to force a
capital letter for the first letter in the name, but I have a problem with
names where there is another capital in it.  If I do >L<LL it forces the
last two letters to be lowercase, even if I want it to be ...

I'm in the midst of designing a comprehensive database for archaeological
materials including tables for reports, notes, and photographs, but also
integrating an artifact cataloging system.  I'm having trouble with the
Artifact table(s)- the table I have is tending towards having ...

Hello to all.
I need to design a database for tracking supplier's prices.  I order items
on an as-needed basis but there are humdreds of them.  Basically I would be
working with a part number, a description, a date, a price, and an invoice

The problem I have is that this database was already started and I am trying
to get it to work and going crazy. The person who started it had lookups for
Contacts and Organization. I removed those due to seeing comments about
lookup fields. Now I have different issues going on.

Hi.  
I need to go back to the proverbial well again.  Thanks for being here...
I am creating a tooling database to track programs, tools, and part numbers.
I cannot seem to figure out how to set up the relationships to get my forms