I have an Access 2002 system with a number of reports which all run
fine.  However, sometimes reports in Landscape format appear in Portrait
when you first open them.  To get the correct (landscape) formatting all
we have to do is to close and re-open the report (no other ...

I'm a newbie at Access. I have an Employee Database and i want to print
out only one record from the form. Can someone help

Apologies if this is a duplicate posting
We are using A97 and it does what we want it to.
Is there any compelling reason to upgrade to the latest version?
If we do, it would probably also involve upgrading all of

I have a report for which each record is a product.
I have the fields: ProductName and GroupCode
There may be several variants on each ProductName, BUT, with the same
group code

Hi I wonder if anyone could help me with my grand-daughters home work?
We are using a form to add data about personnel who work for our imaginary
company.
Each record has the employee's ID, Name, Job title, and the amount on money

Legend of a Kind
================
Tony Toews's dead.
   No, no, no, no,

Dear Access 2003 users,
Can anyone assist me with creating either code (preferred) or a query
that would remove a single field (called ID) from a table?  And as a
bonus question, can anyone assist with adding a field (called ID) to a

I have a form that has a combo box on it. The combo box is based on the
following query:  SELECT DISTINCT GLDESC FROM GL_Code_Desc  This query is in
the Controls Data>Row Source property. This build a list of the department
names. (No Duplicates)

Seems so simple.....
Show rows where:
X  >  (X -Avg(X))/StDev(X)
How does one do this in Access?  I've spent hours, and can't get it.

Hi to eveyone in the group, Can you please help with a problem I have.
I have a form with an unbound subform on it that I use just to display
data. This works fine. When I query the data it filters no problem IE:
Like "*" & [ Enter Album or Artist Name] & "*" This also works for the

I have a main form that has a subform which also has a subform:
the main form is [POG-01 Employees]
the first subform is [POG-02 Contracts Subform]
the second subform is [POG-03 Work Subform]

Hi.  I have a routine (BldEmail) that is causing an error on my user's
PC but not on mine.  HELP!!!  I have to fix this tonight.
She reports an error with err.number=429 and the error message "ActiveX
Component can't create object" out of my BldEmail routine.  

I'm working with an Access application which functioned as a split
database (front end, back end). The back end has recently been upgraded
to SQL-Server 2000, and all the minor bugs have been worked out, except
for one.

A web design client of mine has been developing an Access database with
me for the last few months. His intention was to clean up a very messy
paper-based workflow consisting of many location / many event calendars.
We cleaned up the data, made tables and normalized it. So far so ...

Access 97 and SQL Server 2000.
Reports in this system are driven from a parameter form. Parameters
are used to make a WHERE clause. If no parameters are selected,
strWhere is a zero length string. All reports are based on a stored