I have a work around for debugging a form. I'm not sure if this is optimal
but this will have to do until I learn how to debug with the Visual Basis
tools. I declare my variable and set it to a value. I create a textbox and
place the variable init to show the value on the form. ...

I have a subform that shows results of a combo box, the subform contains CD
information linked to a customer selected from the combo box. I book the CD's
out to certain people and want to flag if the CD is booked out. I book out
the CD by ticking a yes/no tickbox.

Is there a way of finding out (in Access 2000 VBA code) whether or not a
control has the focus?
TIA Trev

The company i work for builds racks for the automotive industry.  each rack
"job" is individually numbered.  In one of my forms there is a "job search"
field, so when i put in a specific number it automatically go to that job.  I
had help in making this work.  This is my problem, ...

how do you check for an existing document in Word 2003 from a command button
then if it is present open it?

I am trying not to get this access triggered error message if an item is not
part of the list
_____________________________________________________________
Private Sub cboSearch_NotInList(NewData As String, Response As Integer)

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 have an application that I am working on where the user will attach files
& then I need the ability to Open what they attach.
I am able to do this by using the SHELL function, where I am first checking
the File Extension, example if its FileName.xls, I check for the XLS & then

I have a data entry form that records empl_no, gross_amt and startdate and
end date. I am trying to alert my users if they have already entered a record
for a giving date. If the employee only worked 1 day they only have a start
date otherwise they have a start and an end date. I ...

Hi
I am trying to have a button to clcik and open a form can
someone tell me what to put on the buttons click event.
thanks

When using the Windows Common Dialog Box Control, is their any way to change
the Caption of the Save/Open button to read "Attach" ?
Any help would be greatly apprecaited.
Thank you,

I have an unbound form in which users input the Start Date and End Date to
use for reports that open based on the button clicked.  When the user enters
a date syntax wrong (ie. 1//2/03), it seems the place to capture the 2113
(invalid entry) error is in the form's OnError event, ...

I am an IT professional who is helping out the local Food Bank. I have been
struggling with this new DB for over a month.  They can have donations from 3
types of entities: another non-profit, a business or individuals.  There can
be multiple individuals per mailing address ...

Hi I have a textbox and the formatting of it is ok but i
want to have the date validated as being today or earlier
so like <date()  how do i do this?
thanks

I have a text box named [date3] that has the date of the future in it
like 9/9/2005
How do you fiqure how manny days are left until that day?
Thanks