Hi.  I have a form with a label (lblNavigate).  The text (caption) is
supposed to state, either, "New Record" or "xxx of yyy" (where xxx =
current record number and yyy = total number of records).  I set
me!lblNavigate.caption in the Form_Current( ) routine.  If I don't trace

On 10/31 I responded to a post, "How Do I Set Up A Small Business Database",
by 78cryj in the MS.Public.Access.TablesDesign newsgroup . The poster
requested help " ...if you know any database programmer that will charge me
less please let me know!!" Kevin Hill of 3NF Consulting ...

I had some considerable help from people in this forum a log while ago
whilst developing a databse for use in our business.  The database has
developed beyond my wildest dreams over the last 3 years and I am very
proud of it.

I have an Access 2000 query that "sees" the Outlook 2000 Inbox. This
works fine until an email arrives where the subject field is empty
(Null)
This causes a type mismatch message.

I am using the Outlook library to send emails from Access.  I have
Outlook open and run a program to respond yes to the security question
(Express click Yes).
It seems to take about 5 seconds for each email to get sent.

Can anyone help.
I would like to create a table that contains references to a series of
JPG files, so that I can view each image and related data in a form,
page by page.  It seems that the only way to insert the reference to the

After upgrading to Access 2003 (from 2000) I now get a strange new
runtime error on part of my longstanding Error handler code.  This
error ONLY happens when I try to run a new form with my same old error
handling code I've used for years.  Here's the proc ...