is there a way to have a dividing line between every other record in a
report? It's not apparent to me.
Thanks!

I need some assistance with a random number generator question.
First let me outline the data I will be given from the user:
1) The random numbers will be assigned to employees, so the user will
enter the number of employees, such as 8.

I have a form with Customer Data and a subform with Customer Contact
History.
The Customer Contact History subform has a 'Next contact' date field.
I'd like to add code to validate that the subform 'Next contact' date hasn't

With the help of several of the members of this group I think I finally
got my database working!
The only issue is that I have DMAX and DMIN functions to compute the
most distant expected and soonest expected arrival times for items on a

do you ever get so far out in left field that it's hard to find your wasy
back to the dugout where everyone else is sane and speak's english

Anyone know how to do this?  I want the Design Master on the jump drive or at
least be able to run make table query or other commands on the replica.

I have donwloaded this into my Access 2002 DB and set the Reference as
required.
I can open the form "frmMain" and get into the Contacts1 form, then click on
SingleMerge(this record) then I get a VB compile error. It says Ambiguous

I have a form which an employee uses to enter their info so they can gain
access to my database.  I have code which grabs he user's NTUserID or login
name and uses it to grant access to the database.  Those not in the database
need to enter this ID in a form that pops up.  

When I respond with a "Yes" in a Y/N field, I want to be able to see an
additional block of info appear.  With a no, nothing would happen.  How do I
do this?

I have a couple of forms with button controls that bring up other forms
and reports.  The problem is that when I exit the form that was call up
by the button on the original form, the original form has changed size
to full screen.  How do I keep the form at the same size after the

I have a query that when I run it finds 45 records of which there are
15
uniques results.
If I then make it a Top 10 query it returns 11 records, but only 7

Ok, first off, I know the data is organized poorly....but I didnt
organize it.  I'm just trying to cope
heres an example of what i got
Key____SIP1_____SIP2

Is it possible to put a hyperlink in a msgbox message?

Maybe this is not possible but ya never know.
I'm creating a form with very little space (it's for a shop counter
operation - so the screen is "very" small - about 20cm sq).  With this mind I
need to keep the number of controls displayed to a minimum.

If I type an expression in an unbound textbox such as ="The child's date of
birth is "&[Date of Birth]   the date of birth always displays the short date
format.  I need to be able to control the format so that it will display as
September 19, 2000 instead of 9/19/2000/