In that order - years, months, days
=DateDiff("mmddyyyy",[BirthDate],Now())+(Format([BirthDate],"mmddyyyy")>Format(Now(),"mmddyyyy"))
I got the above from a post but when I try it I get #Error
Help

I am attempting to create a tool that will select specific records,
determine whether there is an email, and depending on that will either email
or create a printable report.  Here is what I have:
Dim rst1 As DAO.Recordset

Not sure if this is the best group for this...
I have an access application that needs to send emails.  Some of the emails
will require an attachment (may be more than one).  The attachment will
always be from a defined directory.

Access 2003
I have a button on a form to open another form with 2 tabs.
What's the code to open a form with 2nd tab focused instead of default 1st
tab?

I manipulate memo field which stoores text only in my VBA code to assign a
string variable in VBA application.
The string only keep part of the string.
What is the maximum characters memo fields information may assign to a

I want to make a combo box requery after I've closed a pop up form.  
Basically the combo box shows a list of sites.  I've added a button that
opens a pop up window to allow the user to create a new site.  Once the user
clicks "save and close" the pop up form saves the record and ...

I am trying to reset references to Excel and Word from Access 2007 i.e. code
developed on 2007 with office 2007 but when dstributed to users the reference
is broken because they are on say office 2000.
I have read the link provided in previous posts on this subject but it

I have had some success with the help received here in making controls in my
forms locked if they have already been filled in and unlocked if they are
empty to allow the initial data entry.
I now have another problem.  Two of the controls in question have default

Here's my code.  Now, nothing is happening at all.  I've checked the table
and there's no new records.  Did I use the insert statement correctly?
____________________________________________________________
On Error GoTo Err_cmdAdd_Click

I am trying to put in 5 five names in the SendCC and it works fine for the
first three but when I drop to the next line to add the other two, I get a
syntax compile error and the last two name appear in red. Could someone
please help me. I'm sure I am not adding something in the ...

I want to be able to look at the average of a field when there is a entry in
another field and again when there is no entry in the other field.
So for no entry in "fldSupplierID
=DAvg("[TurnAroundTime]","qryQualityListRepairsShippedByDate","[fldSupplierID]is null") '  which seems ...

I have a main form with buttons that launch forms for manipulating tables in
my database.  I launched a form named frmEditIssues by clicking one of the
buttons and filtered the data to modify it.  When I tried to shut
frmEditIssues down I was prompted to save changes and selected ...

The code below alerts the user that some fields are blank.
It works until the last line!!!
How can I make it keep the form open an go to the first blank field, then
the second etc..(I'll be adding more)???

I have a many to many relationship between security clearances and billets.  
a clearance can be associated with more than one billet and a single billet
can be associated with many clearances.  That; however, may not have anything
to do with my problem.

I'm using sql 2000 and Access 2003.
I have a table contains all the payroll data and a table that contains
current payroll data. Each paydate I need to replace the data in the current
payroll table with the current payroll data.