Whenever I write a Form_Resize() routine, I define a constant "botMargin"
and set it to something that works.
Problem is, I don't have a clue as to what values are involved and it's
usually a trial-and-error process.   Works...and it goes pretty quickly with

OUTLOOK 2000 - CALENDAR
The day of the week not appear next to the date on the top bar for day and
week views?
Monday - Sunday is  visible only in the month view. Is there a setting? I

Sorry if this has already been posted, but a quick google search did
not show it in the Access newsgroups.
Please read here for an important petition regarding the long-term
future of "classic" VBA:

In my form I have calculated a field to show years of service. It is
calculated as follow,
=DateDiff("d",[Hire Date],[Todays Date])
Formated:  yy"Y "mm"M "dd\D

I have found from experience and from posts to the group that a change
to the Windows font size under Display Properties often trashes the
appearance of forms in Access.  Is there a way to programmatically
check if the Windows font size had been changed by the user to

Can anyone help with some code which will enable me to enter the first
cheque number and the last cheque number and to determine if there are
any cheque missing from the sequence?
Any help would be greatly appreciated. TIA - Chesne

I have encountered some interesting crashes lately (Access97). Here is
the symptom (after several days of different kinds of rebuilds
including import and LoadFromText, all resulting in databases with the
same symptoms).

Hi.  I have a Microsoft Access 97 database (DB 1) that contains some
tables and a report.  There is another Access 97 database (DB 2) that
is linked to some of the tables in DB 1.  After the user presses a
button on a form in DB 2, I need DB 2 to make a call to run the report

I have a small form that pops up when a user moves off the current
record of a rather sizeable data entry form.  The purpose of this form
is to list warnings about various fields on the entry form that may be
incomplete or inconsistent before the user exits the record.  These

Can anyone help me with the following ?
I have a table like this....
User_ID       User_name     User_email
1                     Steve                 stelil@test.com

I am looking at creating  list of letter combinations.
letters a-h
6 letters per combination
letter can repeat its self in the combination, but not next to its self

I need some help.  How can I automatically fill my combo box in a new
record with data from previous similar record.  My form has a option
group button with two check box.  What I'm trying to do is that a user
will first select a record, then click the inactive check box, a new

Is it to build an expression in a query that puts several, text field
together.  For example I have client information and I have their home
address, school address, court house address, doctor's address etc. What I
want to do is create an expression in a query, that "puts" these ...

I have made some alterations to my company's database so that variable
rates are calculated on postcode area.
This is currently been expanded from a query which featured 12 IIf
statements to one which now features 48 IIf statements. The basis of

Is there a way to determine the size of the user's screen minus the
Windows task bar?
I am trying to maximize an Access popup form that is also resizeable
and it is causing me problems since it maximizes to full screen size