I have a text box in my form that the user inputs a policy number for
example "P128945"  the problem is the user input the policy number as
"p128945"  How can I have the first prefix letter be capitalize
automatically when the user inputs the policy number?  Any tips will be

I would like to provide my users the ability to 'attach' a document from Word
or Excel to a record.
Is this possible?

I have a form with fields like -
Order No.
....
OrderPackList, etc.

I have a simple Access database for tracking the location of 'books'
within an office.  I would like to use a form to allow people to check
the books in and out and enable others to see where the books are
(Checked In to the 'library' or checked Out to a User). The form has: a

I want to open a connection to another database, copy certain records from a
table
to a table in the just opened database and then close the connection again.
The reason I want be linked to the other database all the time is that

I have a form that I created that is to add a new employee to our database.
We deal with insurance, so I want to be able to add a dependant to that
person's record. I have a form for new employee and a form for new dependent.
Once a person has filled in the new employee information, ...

I am converting a MS Access database to a Access Project to see if the
performace and functionality is better.  My current Access DB is a front end
to a MS SQL 2000 database using linked tables so it should be a perfect
candidate to covert to a Access Project, but I have run into ...

I want to be able to allow users to input info into a DB using an Access 2003
form, but not be able to change or delete the information once they input it.
If corrections have to be made, they should add add another record so that a
history of changes can be maintained.

Hi I am currently making a system for a church which allows them to
book out the church for a certain service for the day.
The problem is that I cannot get the Double Booking to work. I want to
make sure that the BookingDate field does not have the same date in 2

Im very new with access and i was hoping someone can help me out - im
creating a booking system that allows staff members to book yogo classes for
different types of people in one booking. All bookings are processed by staff
members of the club (customers must approach staff) and ...

I am developing an application to assist a number of analysts within my
organization to analyze data from several databases.  As part of that
process, I am forced to duplicate the data to an Access database.  Several of
the routines use bulk inserts to insert several thousands ...

I am trying to have my form "frmMoveToProd1" to use the SendObject to
populate an email I send to users with the fields that are within the
form and a subform.
I need to include the field: Moved_By on the subform:

I have built a database that links to a client table from another software
package.
For some reason, however, client #'s in this other source sometimes have
spaces in front of them.  There is a pattern however.

I am working on a few things and functions for my current form. I currently
have the following fields on the form. Associate Name, Issue Date, Expiration
Date (filled in based on [Issue Date] +30) and a check box. I have a macro
that will open a message box if the expiration date ...

Interesting one this, possibly its a bug that has been reported but if
anyone has a solution then great.
Well I have a form with a two page tab control, the first page is for
display purposes only and all the fields have tabstop set to 'No'. On the