I've been reading some of the posts but haven't found anything that has
helped my situation so far.  I have a form with a subform.  When going to a
new record, I want the focus of the cursor to be the first field (Emp Name).  
I have tried "me.EmpName.set focus on the after update ...

Hopefully a very simply one. Basically i have a command button on an Access
form i would like the data and time ( Now() ) to display in a text box or
preferably a label on the form which marks when the button was last clicked,
and to remain until its clicked again when its ...

I have a Leave of Absence table that has Employee ID, type of leave, Begin
date, and End Date.  
I have another table that has all employees.  This includes Employee name and
Id.  I want to add to this table a yes/no box.  

I have created a form that allows the user the enter beginning and ending
dates for a report.  The form I am currently using was created from the
Microsoft Help topic called "Create a form to enter report criteria". I need
to add additional criteria to the form.  

There appears to be a maximum limit of 64k items in a combobox list. Is this
correct? And is there a method to override this limit?
I know it is normally a large enough number, but in my application for a
storage warehouse, I am using a combobox to enable selection of a valid

My database is an employee listing showing name, building, room, phone, etc.
and I have a main form which indicates a particular organization and a
subform that lists all names, etc. assigned to that org.  The subform also
has a combo box called "Status".  "Status" has three ...

Dear forum,
In my database, I have one instance where a specific collection of 7
forms are expected all at one time, so I tried to build an entry screen
where the entry form for each individual form is present as a subform

I have a table with lots of different objects and each one has a colour
defined in Hex and RGB format.
The problem is that I would like to use the relevant colour on my access
form but I don't have the access colour code.

Hi
I was wondering if there was a quicker/shorter way of doing this -
I have lots of textboxes, when a user is 'focused' on it, the border width
expands.

What I would like to do is auto add 1 to my report numbers, not sure if it's
possible the way I have things set up.  I have a database for construction
projects, a table that list Projects and another for daily reports.
Presently I have a Main Form for selecting a project from a ...

I have several forms (6 to be exact) where i need them sorted by a certain
field within each for...so I went to the form's properties, click on the
"ALL" tab, and in the ORDER BY field, i enter the name of the field i'd like
it sorted by, and then i check the results.....It ...

I've read through a thousand posts concerning this topic, but can't get
it to work.
I'm trying to get a subform total onto my main form with following
details:

How would I go about making a clock on a form that shows when a record
was last updated or added?
ie Last Updated on the Thursday 5th August 2006
Thanks.

I am not familiar with VBA or any of the coding for Access... I found this
code on mvps.I had been disinclined to use code *even from a good source*
because I wasn't sure I knew enough to apply it to the database I am trying
to create...  I had a hard time reading through it but ...

Someone please point me to the link where  I can learn about filtering a
subform based on a combo box.  I am having a hard time with the what to do
part.
Thanks