What recommendations would you have for a person just starting out learning
to write a Access db.

1.I HAVE EXPENSE CATEGORIES , FOR THE CATEROGY “ REFUNDS” I WANT THE DATABASE
NOT TO ACCEPT POSITIVE VALUES . IS IT POSSIBLE
2.I WANT THE STORED DICIMAL PLACES TO BE SAME AS THE DISPLAYED ONES WHICH IS
THREE DIC PLACES ONLY .( NO DIFF BETWEEN THE STORED ONES AND THE DIPLAYED ONES

I have been trying to design a db for simple stock controll for a housing
assoc.  I want users to be able to select repair materials from a list and
the  quantities required for each repair.  I then want users to click a
button and the system to be able to print out where to ...

how do i convert digits into alphabets for example 150 to one hundred
fifty.Is there a way to do this ?

hellow
I have a table were there are two fields ( FORIGN CURRENCY AMOUNT , AND RATE
OF EXCHANGE ) AND A THIRD COLUMN TO PUT THE RESULT ( fc amount *roe)
IS THERE A CODE OR EXPRESSION TO DO THIS IN A TABLE

i want to share my database with my collegues at work. will it work if i
place it in a shared folder.or i have to do another things for it to work.
note that both of us will use the database at the same time and may use same
form also.

hi everyone
I am dealing with patients sent for overseas treatment
I want some fields to be a must ( should not be blank)
Like country name and patients diagnosis i.e should not move to the next

I have a new Dell Inspiron 1200 laptop running XP, and Microsoft Access 2003.
In datasheet view I should be able to edit data by typing directly
in the table cells.  I could do this on my old laptop with Works database.
According to the Help instructions I should be able to with the ...

Our company has an Access 2000 database, which is stored as one .mdb file on
the server.  20 + users are in the database at any given moment during office
hours.  Currently, when a user request a new report design or needs a new
module created, I design/test in a copy then import ...

I am trying to design a form for payments in and out from varoius accounts,
using the  four tables listed below. I had planned to set up tabs on a form
to have a different tab for different transactions. For example have one
page to filter all lodgements and inputs and the other ...

I've created a database that is now going out to the users who haven't used
access before.  
When they open access, it gives them messages about blocking expressions.  
Mine doesn't do that, either because I turned off a long time ago and don't

I have a database table of 36000 items. I need to keep a record of any
records which have any sort of change applied to them. As I make
frequent additions and amendments , I'd like to automate this if
possible so that Access will keep a log in a field in the relevant

I use Exchange and Outlook 2003. I use Exchange Cached Mode and OSTs.
What does "Synchronize Forms" in Send/Receive Groups mean?
In Send/Receive groups under Tools -> Options -> Mail Setup ->
Send/Receive... -> Edit

The auditing functionality uses the "Go To" box to manage links to other
worksheets / books.  This window frequently cuts of longer links so that the
entire cell reference cannot be seen.  This window should be scalable /
expandable so that users can see the entire cell reference ...

I need to know how to update  or finish certain records in a database. For
example, A record may start on one date and end on another.  Is it possible
to go to selected dates to fill in the end date.  I can do this easily with a
query, but I need a list box on the main form ...