Hi there, I have a database that has entries going weekly from 2002 to
present.  I want to count the number of times a given person's name comes up
by month, so that would be How many times did Jim's name come up in Jan (but
for all Januarys)?  How many times did Joe's name come ...

Hopefully someone can help me with this one.  I have designed a number
of 'Prime' user forms which have a number of questions posed via
command buttons.  The user simply 'pushes' the relevant buttons to
generate a text string dependent on the button pressed.  Along with

I have a software package that I've developed for schools using Access 2000,
and is distributed using the Sage distribution package.
I've recently made changes to the database, so when it is opened, it copies
one of two possible forms to a usable name depending upon the resolution ...

I'm developing a form that uses a listbox to display records.  Record data is
displayed in a variety of fields, which are organized into tabs.  The user
clicks on a record in the listbox to populate the form fields.
One of the tabs has some dtpicker fields for choosing dates.  ...

I have two tables. First table containe fields:
ID            POGONI          GAZOLIN
          (Primary Key)
In second table I have two lookup combo boxes:

I'm getting a Missing Operator message on this statement.
Any Input is appreciated.
Thanks
DS

When creating a new record, I want a couple of my fields to update
from the previous record depending on the name selected in staff name
field. This is not exactly copying from the last record in the
database, but the last record of the relevant staff name selected in

please help me,
I have this coding in a yes/no files named paid.
I want to get confirmation from use, before he updates this field. The macro
is not trigerred when, I make changes to the field.There is somethign wrong

dear friends,
i would like to know
(1) is size of .mdb file of 2007 version also 2GB ?
(2) i decided to purchase it because microsoft giving free runtime of it ,

I have a form (frm_Reprints) with a subform (frm_ReasonCodes_subform).  When
I added code to the subforms control "Enter" Event, I get an Error 40036
Application defined or User-Defined Error.  It seems to be not recoginzing
the main forms name.  The reason I believe this is because ...

I want to create a text box where the user enters hours and minues as hh:mm,
where hours could be more than 24 hours. I want to convert that value to
minutes before saving it in my table. Is there a function that will do that
or do I need to parse the string myself and convert ...

I'm developing a table in Access 2007, and want to add a lookup column to
flag records as red, yellow, or green...depending on how close they should be
watched. It's such a simple function in Outlook...to add flags and color them
based on type. Is this possible in Access?

Can I Have Scrolling Text Box but it dispays Query Results is it
Possible?
Ive Searched for scrolling text, and ive seen certain ways of using
labels to create scrolling text,

I have a tab control on a form with several tab, each containing a chart on
Cost, Quantities, Hours, etc.  Because the data changes, I would like to have
a group of lables in the main form footer that change as each tab is clicked.
For example, when the "Quantity" tab is clicked, ...

I made a form (account number) containing a tab control with a subform on
every tab some of them are charts .... consequence: opening the main form
takes sometimes a lot of time especially if the data are accessed via the
network and the queries involve a lot of data.