Does anyone know a good way to automatically populate one
field with a certain value based on the value entered into
another field via form?
Thanks much.

Hi everyone-
I have a question in regards to deleting the ldb file.
From what I understand this file is a tempory file that
is created to keep track of the users in the Database.  I

I am trying to formnat a cell to the following format Jun03.  No matter what I have tried so far I can not get it so I can make the date appear that way.  If I put a date in and then change the format it will appear that way but if I have the format the way I want it and the ...

I need to import files from Excel and MS Project that have
duplicate fields - project name, project id, task name,
task id, etc. The Excel file then has cost, revenue fields
and Project has start date, end date, task complete

I am making my tabels, queries,reports or 2004.  I copied
and pasted the current reports and just changed the names
and delted the old information.  I did go in and change
the name of the table in the forms and reports.  I keep

I have a dataview subform (based on a query) and it's
displaying the columns much too wide. I can adjust them
manually in Form View but they revert. No matter what I
set the individual field widths to in Design View, the

HELP
I need to know how to allow users to edit fields in an existing record that has no information in it and only allow permissions for certain fields to be updated.  I've set permissions to allow users to add new information but once they get out of the record they can't edit ...

I am presently working on a Acess 2002 database being
designed for Windows and Office XP Professional based
computers.
I have developed an activities manager to manage tasks

Hello: Can someone tell me how to create a database/table,
that will use the following functions. I am not sure how
to design it. This is just a sample, database/table I need
to create to test queries. The following functions I will

I have a database that is used by several people.  At any
given time, someone has the database open for use.
I need to be able to perform database maintenance
(compact) to reduce the size of the file.

The autonumber in one of my tables (set to increment) has started to reuse
existing numbers. This has caused problems for the users who were unable to
enter records, and for me as I've spent ages tracking down the problem.
Once I identified what the problem was, I found that it has ...

The reason I asked the question again (not on purpose as
anonymous, I just forgot to put my name)was because I
still need an answer to the question "Is there a way".
I realize this is not the correct way to set up the

I keep my contacts in Access in a form view. With the form
opened, how can I link with Microsoft Word so that when I
open Word, the details of the contact that are opened are
displayed in Word?

Does anyone know how can I display html (with active link
that users can click and open the html page) in a text
box? One of the columns in my database is a text box
allows users to type in text.  Sometimes users type in a

I entered a control source for one of my form inputs.  
But now the calculated amount won't show up in any tables
or queries.  How do I fix this?