(using Access 2003)
Hi,
How can I use, or access, variables on several forms?
I'll explain:

I have a field which I would like to change colour using conditional
formatting when a date has elapsed.  So basically I need Access to know
today’s date so that it can apply conditional formatting to this field.
Many thanks Ian

(General)        (Birthdate_GotFocus)
Private Sub Birthdate_GotFocus()
Me.Birthdate".SelStart =" 0
End Sub

The idea of the code is to make a self-updating combo box and it works just
fine until I want to change the entry back to Null.
Then I get Run time error 94 – Invalid use of Null.
This is the code:

Hi
I hope someone in here can help me.
I need to create unique ID's for vegetation samples that I will be collecting.
The Add_Samples form will ask for the number of plots (numeric) and number

Can any one help me pleases ?
I have DB in Access 2000 with some tables and some forms, one of those forms
when I show one record I have command button called "Scan document".
In addition, I have scanner in my PC, acrobat reader pro. Install or paper

Ok,
Well, there were a few Sendkeys statements in an Access database that I
work on, and as everyone in the whole world knows, it raises havoc with
the stupid Numlock key.

How is it possible to find out if a combobox is in a droppeddown state?
I have a continous form where pressing the Down/Up-keys should cause the
form to change row accordingly. But only in the case where a combobox is not
dropped down.

Hello, I posted a question last week and I guess it was too vague, I have not
gotten any response. I will attempt to be more clear.
I am working with Access 2000, I have ADO and DAO both referenced in the
library.

I have a table "employee" and a field [userid].   When the application starts
an inputbox appears and asked the user ot enter their userid.  Currently I
take the value entered and use it as a filter and that works great.  However,
I want to come back with an error message if the ...

Have databases that have been converted from previous versions,
currently running 2003.  Unable to enter the Date function in one of
the form events (or any sub).  It will take the date statement but not
the function.

I have a form that contains a subform that shows invoicing records.  I have
a unbound text box on my main form that I would like to have show the number
of work orders where invoice total < Payout Amount .    Any ideas?
Brent

Is there a way (using VB) to force the cursor to move to the end of text
when a field has the focus.
I have the following code which puts the cursor at the start of the field,
but I want to cursor to be at the end of the field:

hey all, need some help, I am trying to get a total sentence to print on a
report based on if the sentence is concurrent or consecutive.  Example:  If
a defendant is sentenced on 3 charges 2, 4, and 5 years and they are to be
consecutive then I want the total to show 11 years, if ...

All,
In A2000, is there any way to have an ActiveX calendar object default to
the current day?
TForward