I imported data to a table and the data in the original text file was all
capitalized. I would like to convert this data to "proper case" because i
use it for merge functions in mail merge. Does anyone have any idea how I
might do this?  I saw on thread on google that mention a ...

What would cause a table to not allow new entries into table

Does anyone know of any in-depth tutorials for Pivot Tables and Pivot Charts -
Online and/or books?
Thanks!

I have develop a small database that would assist me in maintaining a
small shop. I have 4 tables that seem to work perfectly
tblItems
ItemID Number (PK)

I am trying to write a database to record which employees are present during
meetings.  I have an "employee" table and an "event" table and an
"attendance" cross table between them that has a combination of foreign keys
from each of the parent tables.  I want to show the event ...

OK, I had to scrap most of my architecture, due to bad table design.
I'm starting with a simple order entry database " the sample from Ms "
Now, I have a products and orders table and all works so I don't want to
reinvent the wheel. But I have a question .

I'm working on table design for a primary key that allows sorting a text
field.  The field contains values such as 9.21, 9.21(a), 9.21(a)(ii),
9.21(a)(iii), 9.21(a)(iv) etc.  I have converted these to integer aliases to
sort, but I was wondering if there is a better way?

I am trying to set up installment coupons, I need them to print by date due
times the number of payments.
Thanks

What is the correct answer to this function in MS Access: @Prompt(,,,,)

Sorry for the very short question. Here is the situation:
I am using BusinessObjects (version 6), which requires the mid-layer namely
Universe. The Universe is a middle layer between database and BusinessObjects
(BO). I am thus designing a Universe for that purpose. However, for ...

when I link a .dbf file in ms access2000, I recieve a message "the microsoft
jet database engine connot open the file '*****.dbf'. It is already opened
exclusively by another use, or you need permission to view its data"
How to correct this problem?

actually, this is whats goin on, i have many list boxes, like five on a form,
when a new record comes up, i want all of the lists to stop out at the top
choice, instead of starting on the selection i made on the list in the
previous form, for example i have a month and year list ...

Real Estate Database: for condo developer.
Is there a recommended number of fields in an access table?
I have a table with 75 fields and could break it up into 5 tables of 15
fields.

If you have a field labeled "year", in your table, can you set it up so that
you can run the same report for all years, but only choosing one year at a
time?
thx

A have a Frontpage website where I have mantained the links to affiliates
manaully but now want to drive the pages by an Access database and would like
comments as to whether my design is a good way to go.
I was going to download the product feeds, from the affilaites, into one