I have a toolbar button that opens a form that is used for notifications.  
I'd like to code this button so that, when there is a notification, the
button's caption turns red.
Normally the notifications form is blank (no records).  This is because, as

Hi to all,
I have code that jumps to records that meet criterior of what's typed into a
text box. The way it's supposed to work is a user types a few characters in
the text box and any record(s) meeting the criterior become the current

I've built a query form that returns a string I want to apply to the main
form.  Sometimes that works fine, other times I get the message "You can't
use the ApplyFilter action on this window".  To try to be sure I'm on the
correct window I do a docmd.SelectObject command first, ...

I have a db on an MS Access 2003 machine that will not let you see any
reports.  It gives you an error message about printer object not found.  This
only happens when it is set on this one specific printer set as default.  It
has happened with the two last releases.  If I change ...

I am trying to print address labels from my Outlook Express addresses. How do
I import the addresses into a program, such as Microsoft Word so that the
addresses come up in individual labels on the screen. I am using Avery lbels
3X10.

Is it okay to use a MS Access 2000 version front end and 2000 back-end with
MS Access 2002 and 2003?  Why or what could happen?

Can anybody assist ?
I have a diary type application where a subform contains
time slots for 0700 - 1900
I can only see about half of the slots at any time

I'm using the code below in a form control.
 Dim mess As String, answer As String
 mess = "Are you sure you want to change this?"
 answer = MsgBox(mess, vbYesNo, "Subject ID")

where can I make calculations in bound text boxes on a form work,
I'm building a cash register form with these text boxes bound to a table:
SUB TOTAL
GST

I am using me.myfield.setFocus to put the cursor in myfield when my form
opens. myfield is on a subform within my form. No problem with that.
I then have some validation that cuts in when a value is input into myfield.
If the validation fails I blank out what was entered and want ...

New to forum, hoping you can help.
I have a datasheet view subform that I have configured so that, when
you double click on certain fields it will open up a second form that
allows you to modify the value for that record.  When you submit the

Can i run two queries from the same button.
The button at the moment runs an append query from a temp table into a permanent dB table, but does not delete the contents of the Temp table afterwards.
So i have put another button on the form to run a delete query to empty the Temp ...

I have the simple continuous form with several fields.
When entering data I want to fill some of my fields with data from another
table based on the value entered in
my first field "FIELD1"

I notice that the locked property of a control prevents typed input and if a
subform is locked then this is true for all controls in that subform.
However, record selectors can still be used to select a row and the delete
key will still delete the record.

How to automatically close a form upon opening another.
I have two forms, the first prepares data for the second form, and have the same table.  The second form is opened from a control button on the first.
I would like the first form to be closed when that button is hit, if ...