how can i split a particuler column into two

I am having trouble with my margin settings when opening a word blank
document.  How can I restore to original word, format (margins etc.)blank
document.  The whole normal.dot is a pain and I don't even know how the whole
thing reset itself.

Hi can anyone tell me if it is possible to archive old tables in a database.  
I am using Access 2000 and do not want to see tables from 3 years ago
everytime i open up my database.

I simply want to know when entering data into Access, in the phone field- is
typing in dashes between area code, prefix and the last four numbers going to
mess up the data appearance when printing up documents that include the phone
number?

My database measures a task performed by all staff in the office. All are
date fields - i.e started task on January 1st and ended on January 5th. The
task has only 2 possible endings. Let's call it a) 1 field for turn left or
b) another field for turn right.

I have a contact database that contains information on individuals.
What i am trying to do is relate all people associated with a
particular case to that case. For example, using family members. Each
family member would have a unique record number but i want them all to

I've a few database in text file format that contain some millions of records.
All text files are deliminated in "|"
I manage to open them and view the records in access 2007.
I wish to find out what are the steps I need to do to convert all these text

Hi I am trying to create a unique number field, starting at a specific
number and incrementing by 1 each time a new record is added to the
database via a form (user friendly).
I have tried to do the "change the starting value of an auto number

I am looking for a solution to a need to organize, search and retrieve
documents.  I am the general counsel of a small, start-up company, and I also
serve on the boards of two other small companies.  I want to be able to
organize documents (correspondence, contracts, etc.) -- ...

Something that was working fine has suddenly started chucking out this
error message: -
3211 The database engine could not lock table TM_InvoiceItemGroup
because it is already in use by another person or process.

This is a very simple problem no doubt.  I am totally self taught on this
package and experiencing a problem getting my report to run in date order
rather than by its current setting.  How do I influence the data?  I tried
looking in "grouping and sorting" but seem to be getting ...

I'm having a bit of trouble with some code behind the NotInList event. I
want to the user to have the option of adding a new contact method to a list
after being promted. The problem is however that the list itself is a combo
box that draws its data from a table ...

In VB there is a control "PictureBox" in Tool Box. Is there a control in
Access similar to this function ?
I want to use this property
PictureBox.Print xyz

I have the following codes which open a word template and fill it with data
from current record in Access.
   Set oApp = CreateObject("Word.Application")  
   WordTemplate = "D:\Temp\Merge Letter.doc"