Hi,
I set up a form with age calculation using following formula
=DateDiff("yyyy",[DOB],Date())+Not (Format(Date(),"y")>=Format([DOB],"y"))
It works great, the only trouble is that those values are not exported to

Access 2003 Import Text Wizard returns the error message "The search key was
not found in any record."  What search key is it looking for.  I am trying to
imported a text file delimited by |.

I am attempting to export the results of multiple queries to a single
pre-existing, formatted 'data' worksheet in and existing Excel workboo
using VBA. This means that I need to be able to specify the range tha
will be populated by the export process.

when I relinked tables in access 97, I only had to tell it once where the
backend was....   in Access 2002, I'm prompted for the backend location with
EVERY table.. I have a few hundred tables [all in the same backend] and this
is a pain....

Does anyone know the correct syntax for the SQL "Create Table" statement when
you want to create a field with the OLE Object data type?  I tried  
dbs.Execute "CREATE TABLE TagGraphic (TagGraphic OLE Object);" to no avail.

I need some help with excel.  I am putting info into various tables
(using excel) and sending them to a data base (in excel)with a macro.
the data base has many variables and there is never a situation when
all the variables are used when entering info into the table.

Using MS Access 2003 I am looking for a function that will search the
entire Tables Collection for a specific string in text or memo fields.
For example if I enter "widget" it interrogates the entire tables
collection and returns the table name and column name where the word is

I just recently switched from windows 98 to windows XP.  As a result I don't
have use of Microsoft Word as I knew it.  I used to create documents using
tables so I can have many "boxes" with information in them.  I was used to
being able to customize how it looks easily.  

I am trying to import an Excel spreadsheet. The fields in the
spreadsheet include a 6-digit code, some with leading zeros. These
cells are formatted as text. In the Access import wizard, the data type
in the field options is grayed out and it is importing the field as a

I am new in VBA Programming on my Access 2003 of Office 2003 that is built
on Windows XP Pro-Microsoft NT 4. I got a Run-Time error
'2147217900(80040e14):
Invalid SQL statement: expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT',

When I use an insert query to insert data from excel into access table the
error: "Numeric Field Overflow" occurs.
Please help

New here so please help
i am looking to automate inputs on a access form to outlook calender,
We are entertainers and i am try to design a booking program.
please help

is it possible to find out (Before import) what datasheets in an excel file
contain data.
In addition can you find the first active coloum & row
also the last coloum & row of an active sheet

How do I get into hotmail account to transfer it to dottie.r@comcast.com

I am trying to export a query to Excel using TransferSpreadsheet.  I am
running the code from a button on a form.  The code works beautifully, but I
need to add a search criteria.  I want the user to be able to choose a year
from a combo box on the form and then have the code ...