im sorry for my ignorance but i need help with i suppose a quite simple
problem.
i got two imported text fields.
These two text fields got date informtion presented in yyyymmdd ie 20060802

--------------------------------------------------------------------------------
Hi,
I am using office 2003 pro. I have an Access database that I would like to
change the title of. I would ilke this change to be applied to forms, reports

I have a birthday list which I need to publish without the birth year
displayed.
How do I show 1st Jan 1970 as 1st Jan?
Thanks,

I just installed Access 2003 as an upgrade from access XP. Now, in all office
programs, files and folders open very slowly (15 to 40 secs.) Anyone know of
any solutions?

we need a database that has raw material as well a finished goods. and the
raw material needs to be relationed to the finished goods.

If the foreign key is just a link to the other table how do I get the Data
transfered there without retyping all of it?

I have two tables created and I have a one to many relationship on them. The
table I am using in my report has two foreing keys to draw information from
two places in the other table. Why is it that when I view the report it just
shows the autonuumber i used to call it with? What ...

Ok, a request, plain english replies with a minium of code, thank you.
Now, I have a linked mdb to a SQL server application which has around 150
tables.
I need to find out which tables contain a particular field, in this case

i think i'd like to use a hot key combo to invoke an error reporting tool.
when the hot key is pressed i'd like a form to open that would automatically
recieve a value from the form that was currently open and in focus.
i just need a tip how to use a hot key combo, open a form, ...

Just opened an access db (Access 2003) that I have been working on for
some time.  when I am in a code window and declaring objects, for
instance Dim db as DAO.Database, it no longer prompts me for the member
that follows the full stop.  Previously, if I entered DAO., a list

I have made a aplication in Access 2003. I know when I buy Access Developer
Extension 2003 I can make .mde run-time aplication and distribute it to my
Customer. This Application can work without Access 2003.
But I do not know if I can make with Access Extension 2003 .mde ...

I thought I posted this, but can't find my posting so please forgive if this
is a duplicate.  I have a field that I need to change from text to memo to
allow additional characters.  I have gone in under table design and changed
it to memo, but it will still halt the characters at ...

How can I unshade a toolbar so I want to be able to use the buttons?

I am trying to use the switch function to recognize a value in one
field,(USER ID), and based upon that value change the value in another feild,
(text box 43).  The user id feild is a drop down type feild and the switch
function does not seem to recognize the values in the drop ...

I am using the query example by Mr. Browne to duplicate a record in
form and subform.
This is for a database storing data about music cd for a small library.
They don't have money to buy a problem, but would like to have a