I have an Access 2003/WinXP application with a number of custom toolbars.
Each button on each custom toolbar has tooltip text ("screentip" on the
property screen).
When the application runs, the tooltip displays for only a second or two and

I have a form that has a couple drop down lists and one drop down that uses
the results of a query for it's choices (for example if I chose "Fruit" in
one drop down, the next one would list only types of fruit but not meats or
vegetables).  This form works fine alone.

Ok I have been tasked with doing this and am very new to Access. So if I dont
understand please bear with me. Here is what i am trying to do. I want to use
a form with a combo box or list to display only that information selected on
a report. I have the combo box and command ...

I'm trying to detect whether a date has been typed into a box (cboFILTERS):
   Select Case cboFILTERS
       Case "NEED A LETTER"
           blah

I have a form that has three unbond combo boxes (age, sex, city).
These combo boxes have a select all option and are used to fill the
parameters of a query.  The query sql is
SELECT tblClubInfo.Name, tblClubInfo.Leader, tblClubInfo.ContactPhone,

I wish to create an unbound control to show a person's age. However, I find
that Access doesn't have a floor (or ceiling) function (unlike Excel &
Foxpro).
Is there an alternative?

I'm using Access 2002 and Jennings' book, Using ....
I want to force all caps to be stored in the first and lastname fields of my
Author table -- and also allow for hyphens in the lastname field.  I've tried
using a combination of symbols from Jennings' table in the Input Mask and ...

I am creating a command button on my switchboard form.  I have many buttons
and no problems.
Now I am attempting to add another "open form" command button and get the
message --

I have a sub form the I want to be able to move the top position to a
different place on the main form depending on a switch that is set.  I've put
the code subformname.top = xxxxx but it doesn't seem to want to move I also
want to make the height different.  I've been able to ...

add one day to input date (parameter)?
=Format([Input Date?]+1,"dd mmm yy") - generates an error
any tips?

I have a products table that list the product id #,desc., and some quality
control limits.  I would like the production operator to select the product
id (may be in the main part of the form) and then have it populate the recipe
ex. 3578 for sugar, 4990 is flour, 9036 is red dye, ...

I have the following code in my form and when I make a change the form locks
up. Am I missing something.
#########################################
Private Sub Form_AfterUpdate()

I am trying to add command buttons to a form and I am receiving the following
message:
Method 'Module' of object '_form_roster_udate_TBL'failed.
Can anyone PLEASE tell me what that means?  I think it has to do with the

How do i get the form to open to a new blank record on initial startup,
rather that the first record of the DB?
Thanks

Hello to everybody.
If possible I would like to copy a text value to a text box (CellInfo) to
another (PositionInfo) text box if the value of the last one is 0 (default
value in the table) and