I am a student and have Office 2007 at home but have 2003 at work.  I am
trying to get the 2007 file to open in 2003 but it doesn't recognize the
file.  Any solutions

I use Access 2003.  When I go to do a mail merge (Micro. Word), whether it is
from a table or a query, and whether I am linking it to a current document or
creating a new document,  the following happens,
1. I am asked to select a table (even if I want to use a query, the table

I'm just learning Access (using 2007) and one thing that troubles me a bit
(aside from learning sub-queries) is "menu-system" in Access.
In fact, even if I use a "custom menu, with sub-groups" it feels cluttered.
1. One thing that would really help would be if I could use more than ...

I have an ODBC linked table (to an AS/400 server). I created a query (make
table) where I inserted a calculated field to know the volume of a marble
block :
Volume:[mextc]*[mextl]*[mexte]. As these values are in Centimeters I need to

I was really surprised by the size of my db, so I split the db and found out
that my backend is below 500k whereas my FE is at about 3,5M with only 7
forms, 11 queries and 3 reports. I guess the forms are the biggest objects...
What do you think? Is this normal or did I forget ...

Our database has stopped storing new records. We have 912 records in a simple
one table access database and new records can be typed in but are not stored.
This happens when typed into the table or input through the input screen form.
I can't see any table properties restricting ...

How do I set tab pages be displayed vertically (left side). By default, they
are set on top, I need them on the left side. Please assist.
Thank you for any tip/help provided.
Adnan

I am struggling with how to query a table with the current structure:
Field1 Field2 ...Field14 Jan Feb Mar Apr...
x         y       ...z           10  15   13  16...
etc,

when I import data from text file to access data, it truncates all the zeroes
in the starting of every filed, I have a field as "Telephone Number" in which
I need these zeroes in the beginning as I have to distinguish between local
call and international calls, please help me in ...

does anyone know of a good template for qc or production databases?

All,
I have a date field in a form that has vba code attached to the 'after
update' event.
Then I setup a hotkey to auto the current date in the same field.

Good Day Group,
I have an access database on WindowsXP that  creates an HTML attachment  and
addresses it from data from the database and sents it automatically to the
mail agent (Outllook) to send it through.  Using the same access database on

I have this SQL in a query:
 sSql = "SELECT *" & vbCrLf & _
  "FROM tblTest4" & vbCrLf & _
  "WHERE tblTest4.Caption_Name LIKE '%" & qryAuthor & "%';"

hello to all
By studying examples in this forum, I'm slowly getting better at
programming.  When I see a line like the one shown below, exactly what does
the (0) mean?  When I look up OpenRecordset in VBA help, I don't see any

I resized (and shrunk) the left pane of Microsoft Access Help and can't bring
the left pane back to a readable size.  When I mouse over the bar separating
the left pane from the right, it turns to a double arrow, but clicking and
dragging right does not change the size of the ...