The State agency where I work uses Office Pro 2003. I recently upgraded my
home PC to 2007. I frequently use my home PC to work on an Access 2003
application and each time I do, the Microsoft Outlook 11 Object Library (no
longer available on my home PC) is replaced with that for ...

How can I do this without sending all of the records?

Is there some way to iterate thru a group of selected records (using ctrl and
shift to select multiple records) contained as a subform in datasheet view.
I have a hotkey which performs some action on the current record, but would
like to perform the same action for all selected ...

I have setup a report in access that needs to have an inside margin of .5"
and an outside margin of .3125", but when I go to page setup and margins, I
don't see the mirror margins option.
Is there any way I can programmically setup based on an "OnPage" event or

I have a form that I need to track if the data on the form has changed (so
when the user closes the form it can write the changed date/time to a field).
I have a sub that runs OnCurrent to 'take stock' of all of the data on the
form and write it to an unbound field.  I then want ...

I need to be able to take a report that I'm creating and export each page as
a new .rtf file using one of the fields in the report as the filename. Is
this possible? I'm pretty good with VBA, but I haven't worked with it in
Access that much. There will be about 800 files created, ...

I've inherited an Access Application with many tables, forms, reports,
querries, and macros.
I want to change nearly every table name as well as many column names.
What is the most efficient way to go about doing this?

I am having an issue with an "If...Then...Else" statement, can anyone help?
*-*-*-*-*-*
Dim db As Database
Dim LPassThrough As QueryDef

Hello again and thanks in advance.
I am trying to get my application to open showing only a splash screen
(frmSplash) with a progress message for what it is doing (ex. "Testing Server
Connections...").  I have put a 1x1 pixel bitmap in the folder (to replace

I know this has been done by many people before me, and I can remember
reading about how to solve my little problem at one point or another, but for
the life of me I can't find it now.  Please help...
I hid the access window using fAccessWindow on my startup form, which is a

Can soneone tell me what I am doing wrong or what is wrong with this function??
Public Function IsEnrolled(dEntry as Date, dExit as Variant, ReqMon as
Integer, ReqYear as Integer) as Boolean
On Error GoTo Err_IsEnrolled

I have the following code to check if a productID exist. I get runtime error
3021 when there is no match product ID. Could someone assist me?
Public Function CheckIfProductExist(ProductCode As Long) As Boolean
Dim dbs As DAO.Database

Using Office 2003 and Windows XP;
Let me start by stating that this forum is wonderful and I very much
appreciate everyone's input and assistance.
I am presently working on a genealogy database project. I need to develop a

I have a combo box that selects the fields available from a table.  In some
instances there will be null values so I write some SQL in the Row Source of
the combo box to show "(Blank)" where the values are Null.
This is the code I have on the on click event of the combo box:

Some security program popped up on Vista Home Premium which I immediately
thought was a good idea.  Now it blocks many of my start up programs.  I want
to put some of them in an OK, do not bother list. Have been able to do it on
a temporary basis but not permanent. I am forever ...