I want to be able to capture keystrokes on a form in datasheet view, but
anything I include in the keydown event isn't executed.  My guess is that
Access won't trigger this event in datasheet view for some reason.  Is there
any workaround to this?

Good Day All,
(Yes its me again!!!)
I have a Form with a SubForm, the main Form is from tmpHdrRoutes and the Sub
Form is from the source table.

Is there a way to set one form to be exclusive?  The form that I want to be
exclusive automatically posts a number that is required and if two people
enter before hitting the save button, then the second person has to retype
all of the information.

Hi.  I have the following code that works up until Me.Requery.  I
can't get the code to go to the specified record after Me.Requery.
Control name is COFID and control source is COFID. Someone please
help.

Hi everyone! Using A02 on XP.
I have rates to calculate frequently and have to calculate how many years
and months between two dates (day of the month isn't needed but I don't mind
using it).  I made a form with [StartDate] and [EndDate] and a Result field

I have an unbound form with a listbox called "lstCUSTOMER", a textbox called
"txtLIKE", and a Frame with two search criteria.  The problem is with my code
for search criteria 1.  If I type more than just a few letters in the text
box, my ListCount recognizes the number of records ...

I have a form with 5 subforms and am attempting to perform calculations on
the main form based on the information provided from the subforms.  A problem
I am running into is there will be instances where a subform will not appear
as there will be no data, but then I receive a ...

Is it possible to use an Access Form to display specific ranges from Excel
sheets in read-only or print preview format?
My goal is to use a tab control in an Access form to select from an
assortment of  excel sheets, and I want the user to be able to scroll through

Hi legends
I have a subform which is master/child linked to the main form by
'Order'.   In the subform, I have 'order', 'item' and 'Itemname'.  The
'Itemname' field is a DLookup which works fine when I open up the

My app has a form with two subforms.  Main form is bound to a table, both
subforms are bound to a different, but related table.  One of the subforms
acts as a list of items from which the user picks one to edit the details.
The "edit details" subform LinkMasterField is a control ...

I have a form that has user initials as one of the text boxes, I would like
to ask the user to type in their initials and then display only records that
have
their initials, basically I want to filter the records by user initials

Simple query I hope..
I have a customer database in access that is connected to a simple Customer
select form..
there are 3 boxes

Hi.  I have a form that uncludes data from two tables RequesTracker
and NAM.  The NAM table is linked (spreadsheet) the NAM table in an
access table.
The current relationship is Include ALL records from 'RequestTracker'

My form records patient attendance, time of attendance, date of attendance
and a number. These are recorded onto an attendance table called SCAN.
The following code is called in the afterupdate of the number field.
I want it to check the scan table to highlight if this patient has ...

How do I get a drop down to update the entire record after it is
selected?