I have an unusual looking Excel spreadsheet that is produced by our IT
department.  I am looking for some help as how to configure the import
into Access.
The layout of the Excel spreadsheet is listed below.  I am using the

I have a FE BE Db for handling membership of various clubs. The Db is split
into a FE & BE, with all the active tables in the BE. The only tables in the
FE are pretty static (such things as paths to various files e.g. where the
front end is stored for each club and which fields ...

I am looking for a quick sanity check, to make sure I my view of a
problem is reasonable.
Our organization just upgraded from Access 2003 to Access 2007.  One
of our MS Access databases is not working the way it used to.  It is

I have a combo box with several names, once a name is selected then it
goes and gets a report of the name of the person that has been
selected.
I would like to put this and date selection on one form, the query

I've been asked to build a system that is considerably larger than
anything that I've done before and I'm trying to determine if an mdb
backend is up to it.  The system is not mission critical to the point
where the loss of a day's data would be a catastrophe.

In AccessXP I created this if statement
If Me!bxEntryTyp <> "pe" Or "ptu" Then
and when it runs I get a 'Type Mismatch' error,   why??
I tried If Me!bxEntryTyp <> "pe" Or Me!bxEntryTyp <> "ptu" Then

I have a main form and a subform. The main form has  a combo box
control and the subform has a textfield.
What I want to do is when the main form loads it should check the
value of the combo box and if it, lets say "MZ" then the textfield in

I'm not 100% sure that this is an Access problem. A friend of mine has
an Access 2003 database. Occasionally he brings a copy to me so that I
can import some of his data into my Access 2003 database. For years he
has done this with no problems by bringing his copy on a CD.

In the table there are 2 fields in which I wish to limit (i.e. No
Duplicates)
Although I do not want to limit them to "No Duplicates" separately.
I need them to be limited to "No Duplicates" as if they were one

How I can start my M$ access form with last edited record? What I must put
in "on load" field?
Tnx. for advice.

Hello'
I have a table with a column for each year.
I have a form that will be writing a date (from a cbo in a form) to
these columns.

I am trying to dynamically populate the module name in the error
message.
Currently I populate a variable with hardcoded text:
   strModuleName = "cmdFlushWorkTables_Click"

I really think it's a shame ms access has such a buggy memo field :(
A database that can't store even a paragraph of contiguous text in
2008. M$ rocks!

I have several projects that have been working for at least four
years.  Last Thursday, the connections for these projects began
dropping immediately upon opening the project.  When I test the
connection, the connection will succeed.  However, upon closing the

 I am trying to print address labels. I have a form which asks for
the user to input the first name, middle initial, and last name. On
the button click to print the label, I have an event procedure which
is called. The problem seems to be having two different reports in the