I have a form that displays records with a bound date field named Statdate
from a table named Statistics
.
I have an three unbound controls on the form that display the current year,

I have an easy question but I am new and can't figure it out.
I have a main form and on it is a subform. The subform displays the
many record related to the one on the main form. The subform is set as
Single Form, which is what the users want. Whenever you go to a record

I need to call a sub procedure and have it assign a value to a variable that
will be available throughout a module.
I can call a function and have it return a value to the calling procedure.
But I cannot call a procedure from another procedure, have it change the

Where may I find a list of the controls w/ a mousepointer
property?

Is there a way to minimize the access window in code?
I am trying to avoid using the run minimized option in a
shortcut.

In Access 2000, I am wondering if there is a reliable event which triggers
while focus is still on a given row in a subform, but just before it moves
to the next row.
Specifically, when the user goes from one row to the next (maybe new) or

I have a user develop popup toolbar (shortcut menu) and in which I keep
losing the Start Group property.  In order to customize the popup I have to
change it to a Menu Bar or a Toolbar, make my changes and then change it back
to a popup.  I am guessing I am losing the group start ...

I have a user develop toolbar in which I enable / disable certain Command Bar
Buttons based upon the state of various application objects.  And all works
reasonably well with the exception of the random times after I have enabled a
button the button doesn’t light up.  If you move ...

I have a saved query that calls a function as a variable in the WHERE, I've
noticed that every time I use Dlookup to retrieve data from the query, it
requeries that saved query, recalling the function variable, even though the
data is already there that I want.

Using a form in place of a msgbox - is there a way to
not show the form title bar - i.e. the place that prints the caption???

We have a table of contacts with fields FirstName and Surname with usually
between 2 and 4 contacts per company.
What we would like to achieve is to bring the first contacts FirstName and
Surname into a memo field, followed by the same information for contact 2

I've struggled with the correct subject line as it is, so I'll have a tough
time explaining what I need.  I have a form with two fields
Last Visit
Next Visit

I am just curious. I handle my notinlist with a recordset.
I will trap the not in list in the event for that control,
MsgBox to find out if they want it to be added
Yes

I am trying to use a DataSheet view for a Subforms Default View.  I have the
font on the textbox's set to MS San Serif 8 but when I run the program the
subform shows in the main form as a Datasheet with Arial 10 which is the
default for the system.

I know you can open a table, move last and get the recordcount.
But, is there any way to find out how many records are in a table without
opening it?  Some sort of property?