I have a form with subforms with data validation in the main Form's
Before_Update Event.  The problem that I am encountering is when the user has
not updated all required data but enters the subform the Form Before_Update
Event fires and the validation will fail.  Is there a way ...

A Few Months ago i had some help and creating some code that
automatically generated a number for each project which was recieved,
its been working fine untill We hit the Year 2008,
The Code Made up a Value for example

I need some help in VBA coding..
I have an application in which my backend data is stored in SQL Server 2005 .
Front end has been written in MS-Access 2002, so it is obvious that the front
end is an Access Database which contains forms, reports and queries.  

I have this in a module,
Public Sub HidePointer()
  Do While ShowCursor(0) >= -1
      DoEvents

I have a Clients database, and I've created forms to clean up duplicated
data. There's tblClients and a main Clients form (frm022-01_AdminPeople1).
There are ten tables that are related to tblClients, each is represented by
a subform.

I can’t figure out how to run this for the life of me.
Trying to run a function that updates the combo boxes for all open forms.
Here is what I have with asterisks marked on what I think is the problem line.
Have tried many permutations and gotten all sorts of new and exciting ...

I have an unbound textbox, txtAmount.  I want to make sure that user
enters only two decimal places, and that the input is numeric.
I tried using InputMask 99999999.99 which works for positive numbers,
but that mask won't allow the minus sign (or plus sign) to be used.

All I want for this week is to understand why this code does not work.  I
have a text field named "EmpFirstName", when I leave this field, if for any
reason the field is blank I would like to see a msgbox.  I get an error when
I use the "Cancel" code, but when I don't I can just ...

We have more than one location that is entering data into a form. The
'yard' field is where the location would go. I can I code it to where
the system knows where the person is entering information. Basically,
I can I have Access recognize where the data entry clerk is an

Can you run both a Event Procedure and a saved Macro in Before Update Event?
I am trying to run my Event Procedure along with a new macro and so far I
can only run one or the other.
Thank you

I created a button to save a report in a designated folder.  The date
parameter is a box on the form the query for the report runs off of.  I want
to include that date field in my report so I know what parameters I ran the
report on by looking at the contents of the folder.  I ...

I have a database for our non-conforming materials. There is a NCR Master
Table where I use a form called NCR Generation to allow data entry. I use a
combo box which displays item number, description, revision, and unit cost
which is drawn from our item information in a separate ...

I have a combo box that brings a list of Names from a query. When
clicking on the down arrow it shows a list containing two columns;
Last Name and First Name. When you chose a name from the list though
it only pulls in or leaves in the box the Last Name. Does anyone know

Three forms, a parent, "DirectoryItems" and two
sub-forms, "FamDirItems" and "PermissionBoxes".
When ANY of the controls in "FamDirItems"  get
the focus, Sub ShiftPB (code below) is called to

hello to all
Some of my procedures have code like this:
Select Case n
  Case is = 1