A co-worker has a long heading title for a column in an Access
database she's designing.  She wants to use the whole title but
doesn't want a wide column.  Is there any way she can have a two line
heading?

I used to be able to do this, but now can't find the way:
When I view my queries (tables, forms, etc.) in Detail
mode, I want to remove some of the headings. By default I
get Name, Description, Modified, Created, and Type. I

I have two forms;
FORMA displays a list of suppliers and various generic details for each.
FORMB displays transactional information for suppliers. The supplier is
selected from a combo box list.

Hope you can point me in the right direction.
For simplicity's sake, assume one table with the following fields;
<table_customers>
fld_customerID (autonumber)

I am a teacher and wish to compute student exam averages in a form or
report.  I have sought to use the "avg" function in Access as I would the
"average" function in excel, but find it does not work in a comparable way.
Is there a way to use the "avg" function in a form or report to ...

How can I go to the SQL command window using MS Access
2000.
Thanks in advance
KD

I have a friend who is a childminder. She has a heavy load of
paperwork to keep up with. I've been asked to try to help her with
computerising her record keeping system. I 've found numerous
childcare software programs on the Web but they seem to be mainly

How does one generate unique id composed from first 3
letters of last name and first 2 from first name.  I
assume this is common as I have seen it but don't know
how to program it. Thanks!

Is there a good link for a standard naming convention in
Access?  
Microsoft says anything that is 64 characters or less.  
SQL says, no spaces.  I'm beginning to have a lot more

I have made a database and I want to search the database
of names by typing in a search by name ie SMITH.  I want
the search to show all of the records for the name smith
how do i do this I am working in access 2003

i have a one to many relationship in my db.
i can add two related tables to query and get data but
when i add a third related table to the query design the
query will only return column heads and no data?

hi there, can someone pls help me?
I have a parts inventory form and I'd like to find an
specific part number by creating a text box to enter the
parts number and when I hit enter it's going to show me

I have a subform in a form. The subform contains the
datagrid (as datasheet). When returning from another
screen I can not use to gotorecord method in the subform
(object is closed). How can I go back to the desired

      i'm trying to code in VBA an import
routine that will write the data from an Excel csv file
into a table in Access XP. I have this code :-
DoCmd.TransferSpreadsheet acImport,

I need to generate an ID number which will be stored in a
table created in my database. The ID comprises 3Alpha +
3Numeric (two fields)contained in this table created.
How do I reference this table in my procedure in order to