Does an Acces table with a Date/Time field formatted to Short Time have
a date stored in that field as well?  If so, how can I extract it in a
Query?
Thanks

In my form I have it bringing up record information from 2 differant
tables and that works just fine.  The problem is when I try to add a
new set of information it only adds the key to the one table and not
the other.

When writing to a work DB  under C:\Documents and
Settings\[UserName]...., what is the best way to handle MakeTable
queries?
The only approaches I can think of are:

For those of you that are using the Access 2007 Beta, can I ask, comparing
Access 97:
What's the size of the runtime?

This is an Access 97 objective...
If one manually goes to carfax.com, enters
the VIN number shown below, the info blurb
under FREE Record Check Results is then

I am creating an image-management database.  I want my users to be able
to double-click on an image (a preview of what exists in a network
subfolder), and for the code to open the image in its associated
application (say, Microsoft Photo Editor), then wait for the user to

I would like to calculate a person's age in years (between 2 dates).  I
am using the following function for this calculation (source:
http://www.mvps.org/access/datetime/date0001.htm)
_________________________________________

I have this newly designed app here (A97)
This app is 7.298 kb wich seems like a normal size to me.
But zipped the size is 7.262 kb which I consider *very* strange.
I am used to a zipped size of 3-4 times smaller than the original mdb

I am using OutputTo  to export a query to excel, prompt the user to save as
and then open the excel file.  See below:
DoCmd.OutputTo acOutputQuery, "q701ExportFields", acFormatXLS, , True  'Opend
Excel Automatically

I am new to access can someone tell me how do we send the data entered
from an inquiry form to a table.
say i have  a form which has fields
client name

I have a table with the following fields:
FATHERFIRSTNAME
FATHERLASTNAME
CHILDNAME1

Can someone tell me if this is possible? I have 2 fields in an Access 2000
db - one is the product name, the other is the product description. If the
product name is contained in the product description, I put bold tags around
it (<b> </b>). Would it be possible to do that with a ...

For those of you that are using the Access 2007 Beta, can I ask, comparing
Access 97:
What are the major new features compared to 97?

I have an access application that has been working fine for the past
few years.Access 2000 is used for the user interface and Oracle the
database.
Recently the application was moved to a citrix environment. On this

I am migrating two large databases from .mdb files into an MS SQL
database. I would like some information on how to automate the process
of moving the data over.
The two original databases store similar data so the goal of my work is