What code do I put when I want to set focus in a subform and in should go to
a record

I am having a syntax problem that seemes easy but I don't understand it. I
have the following SQL statement:
DoCmd.RunSQL "INSERT INTO tblDiscrepantItems (prod, qtyonhand, qtycnt,
SXExt, CountExt, DollarDiscrepant, PercentDiscrepant)" & _

I have read most of the data from the site concerning this and I still cannot
get anything to work.  I am trying to check for duplicate data entry when
user input the information.  I tried several ways using the before update
event.  This is what I have.

I feel like I've tried everything and I can't seem to make this work... I
want to display all records where the "LastPurchaseDate" is greater than 60
day's.
The ultimate goal is to display all accounts (and their list of loaned

I have some code that checks if a table exists and if it doesn't then
reattach the linked table.  However it doesn't work as it just attaches the
table anyway.
Can anyone help?

I need to change existing text data in a field to number data  in access 2007
I am trying to move (or just chane) the text data from  Fax2 (10 char text
all numbers, no "-", etc) to Fax3 as 10 char number.
I have Fax3 as number field but if I try to update from Fax2 (text field)

What code can I use to identify the name of an active report on the screen
(preview)?

I have a combo box in which I have coded a dropdown event, i.e.
combo1.dropdown, after entering some text.  However, after updating the combo
box the dropdown box does not disappear.  I would like to add code to my
combo box update event to make it go away.  Can anyone suggest ...

Within Access, I am trying to check if an instance of Excel is open.  If one
isn't, then I would like to open one.  Although the Autotext feature allows
me to key the following:
Dim objXl As Excel.Application

How do I copy all of the forms from one access database file to another.  
I am already copying the tables using the following
Dim t As TableDef
For Each t In CurrentDb.TableDefs

I have code to automate sending emails from Access but I need to know the
code to include my auto signature in the email.
Can someone help?

I am getting some odd results when using the int() function within
VBA.
Here is what is happening:
quantity = dblTransactionQuantity

I am using the code below to try to import data from Excel to Access but keep
getting: "Run-Time error '3274'   External Table is not in the expected
format"
VBcode:

I have two DB set up as follows - the first is called TYPE and the second is
NOTES:
There are only two records in this example, but there will be many more
records for each when done. I want to be able to type MAJ and find the right

Can i rename a control on the fly ? For example, if Me!Office = 6 Then  Me.
Branch9 = Me!Branch. Both branch9 and branch are fields in the table products