How do I change the font type, size and color of an email msg item with HTML
body format?

I had a dataloss from a main table but had some backup records. I want
to cut&paste say line:
__33__|__01/04/99__|__165_|______KA__|__________WI___|__1251654_____
so that my table gets the record with out having to go field by field

I have a procedure to automate bringing several Excel files into our
Access tables, on a daily basis.
The problem is that if the user has a problem, and tries to run the
import again (maybe 3 files imported then there was a data problem and

Have a MS Access db with queries and tables. There are SQL Pass-thru
queries which is used to get data from the production SQL Server db.
The local access tables are populated using these pass-thru queries.
Local access tables are used for high level local reporting purpose.

I was wondering if there was some property whose
value I could read from a DAO snippet to tell me the
current AppPath in a runtime setting. If I give someone
an installation disk, that person could install the runtime

I am in the process of upgrading an Access database to SQL Server (and
climbing that learning curve!).  The wizard happily upgraded all the tables
and I can link to them OK using ODBC.
The application controls allocation of revisions to aircraft maintenance

I am having trouble figuring this one out... Hopefully someone can
help!
I have a table ("tbl1")
It has five (5) fields:

I'm trying to have an Access 2002 dialog form hide itself automatically
before being displayed under certain conditions. But setting Me.Visible
= False in the Open event has no effect. It's False anyway at that
point, and gets set to True again when Open completes, and the dialog

Hi, i am currently working on a project which requires me to create a
form to allow the user to change their password.
I know there is a user-level security login which is easier and safer
but was told that i could and even must not use it. GOD KNOWS WHY

I have several tables that have numbers displaying 2 digits to the right of
the decimal.  However, when I append these into a common table, all numbers
are suddenly rounded up to the nearest whole number.  I tried to set at a
Fixed format , with the Decimal setting on both Auto and ...

in short here it is my problem:
I have to monitor the prices of a product sold by different shops and I need
a query to retrieve a list of shops with the associated CURRENT price of the
product.

I wondered if there is an easy way in MS access that key words (words I
search for in the query) are highligted somehow when I get the results

I am trying to allow the user to add an item to a list if it is not
found in a combobox.  When the NotInList event is triggered I run a
function "AddItem" that has a custom dialog box to add an item to the
underlying table.  The function either returns "Not Added", or the new

db is split access 2000
trying to replace production front end with the new dev front end
different path for the _be (linked tables) in the dev environment than
in production

I have 3 forms I want to link, so that when I advance 1 record in one
form it will update the other two with the same record in the first
form.
I have tried using the form wizard (I am not an Access pro), but when I