Hi, I run Access 2002. I have a multi tabbed main form with a blank
datasheet view subform embedded (for user data entry)
When I use the cursor keys to scroll to the end of the last column in
the subform it focuses on a button on the main form. How do I trap

I have set the field I want to have focus and then wish to copy the data to
the clipboard. Can someone help me with the code for this.
Forms!frmExhibitorInfoVerification!Email.SetFocus

Info:
I have the following table that stores the total amount
available for a particular Document:
tblTotalAvail:

Please forgive me for my limited knowledge of Access 2003.  I would like to
know how I can look up a record on a form then select that record and edit
it.  I would like to have one form that allows me to search then if the
record is there I can select it and it takes me to a ...

I have a table in A2k3 that is a current list of pieces of equipment. And I
need a form so that the user can change and update the list of equipment.
When a change is made a copy is appended to the history table so a current
equipment record which can be selected and linked to a ...

I'm trying to create a dropdown box, that is half a field list and
half Table/Query.
I'm working on a database for a conglomerate of labs. Four of these
are major labs, the other 22 are branch labs.

I’m creating a database for budgeting purposes and because I don’t want
budgeting managers to see the salaries for other departments, I’d like to
restrict access.
I have essentially created 3 tables:

I may be trying to be too ambitious with my limited knowledge (because we
know that a little knowledge is a dangerous thing!).
I mastered Martin Greene's 'cascading list' idea, found here:
http://www.fontstuff.com/access/acctut10.htm

From: "Abay" <abcd@aol.com>
Subject: Passing data between forms Access 2000
Date: Wednesday, April 25, 2007 11:46 PM
Hello,

I have calulations like (below) that need to round down within a form (not a
query)
=IIf([INSTALLS]=0,0,[CHSI I]/[INSTALLS])

I'm creating a table where its records
will be append to another 3 table.
I have done with the query and the form
But when creating the code I always got aproblem

I have a form that shows what is normally needed by the user.  I want to be
able to click a button labelled 'Extend' to widen the form to the right,
revealing details not normally needed.  Why doesn't this code fragment work
in the button's On Click event?

that's say I have a form, there are 10 fields in this form, how do I make
user complete all the fields before exit the database, if user only enter 9
fields, the screen will popup a message like "can not exit unless all the
fields are compete.." please help, many thanks.

I have a form that I want to set a text box so I can use it to sort on.
I tried to set the Me.orderby = "txtbox" but this resulted in an error.
I then tried to set the orderby using the field name:
  Me.orderby = "field1, field2, field2"

I inserted a subform with 5 tabs.  When I open up my form the subform is
empty.  If I click on a different tab within my subform the text is then
displayed (and highlighed in black background)
How can I get the text to show up without having to select another tab and