I wish to make a conditional formatting in the monthly overtime
report. For that in my report there is an average overtime percentage
'txtAverage', each employee's overtime percentage 'txtPercentage' and
each employee's overtime Total 'txtTotal'. If any employee's overtime

I have this code in the before update event for a textbox of a customer's
first name.  My thinking is that if I tab past the first name I should get my
MsgBox.  That does not happen.  Could someone tell me if I'm thinking
incorrectly or if this code is incorrect.  Thank You Very ...

I have two combo boxes (Vendor & System) on my form.  If I select a
particular vendor from the combo Vendor, then the second combo System should
get the list of all the systems for that Vendor. But currently if I select a
particular Vendor it fetches only the name of the first ...

I have a form Address and a subform (continuous form) Hold.
The relation is one-to-many (one address many holds). I am using a combo box
to enter hold. How can I prevent that a hold from the combo box is entered
more than one time? Address and Holds store data in 2 different ...

The following is driving me crazy. The first half of the code is fine
but the ElseIf isn't working. It doesn't matter if Percent IsNull or
Null - I can exit either way.
I've tried several things but can't get it.

I have a form for which I want different things to happen depending whether
the record exists or is new.
When the record is new I want to enable and disable 2 text boxes  based on
the value of a combo box executed through a nested IF statement.  When a new

Is there a way to declare a variable whose scope is the entire form module?
For example, I want to set a form variable and not have to re-set it with
each procedure. I tried using a constant:
Private Const frm As Form= Me.frmBrCorrespondence2_Sub.form

I created an input form and added validation code as the form is close;
however, the error message do not keep the form from closing.
What do I need to do?
Private Sub save_Click()

my database allows the user to store general information about his
trip (MainForm) and add bird observations through a datasheet-like
subform (SubForm).
Currently the new bird is inserted through a combobox with

In Access 2003 I am trying to meet a user's requirement to store rich
text (bullets, bold font, a table with borders etc - typical MS Word
formatting) in a field. When I attempt to add the rich text control
the well know (according the numerous posts that I see in this news

Who can give me a hand?
In a subform, displayed on a tab control, I would like to hide/show several
fields, based on the value of one of the fields in this subform. If the field
'Description' contains a specific value, some fields on the subform should be

Are the pivot tables in Access 2007 basically the same as the OWC that
could be used with Access 2002 and 2003? The OWC was buggy and
documentation was very thin. But it was still useful in some cases.
Licensing for the OWC was not great either; you couldn't use it with the

I'm using this code to open a form with a filter/criteria:
DoCmd.OpenForm "41_form_Cria_Planos_Expedicao", , , "Id = " &
Me.[43_form_Visualiza_PlanosExpedicao subform].Form.ID
and then on the form I have a code that checks if the record is closed or

I have a subform that declares some string form variables Private and loads
them in the form.open event, as in:
Private AgendaDIR As String
(I have also used DIM AgendaDIR As String with the same effect)

Hi--
I have a form with a combo box that selects distinct from a lookup table,
called cboStates.  When I select an item from it, a list box populates with a
list of values that match .