I have assembled a large Access 97 database which I want to turn into a standalone file, which I will then distribute as freeware.  I understand there is a Developers kit which will create a standalone file.  My database has quite a bit of VBA code and many forms.  Is the ...

I have a number field that I would like to be able to show
a decimal, but everytime I enter a number like 1.5 it
rounds it up to 2.  
Any help would be greatly appreciated.

Using VBA, how can I change the data type of a field from number to text.
thanks for the hel
Alex

I need to know how to sort a field that contains numbers
and records like this:
A.1.1
A.1.2

I would like to create audit tables for all my main tables.  I have found
some code on the internet that says it will do just that.  However, I have
never created a trigger before.  Can someone provide me with some basic
intructions on how to create a trigger in Access 2002?

I am an absolute beginner at Access and am trying to teach
myself the hard way.
I am designing a database for storing various data
relating to uk shares.

I have two tables: tblEmployee and tblInpsectionRequest.  Included in the
Inspection Request are fields for two employees, the one who entered the
request and the one who did the inspection.  Can I have two one-to-many
links from tblEmployees to tblInspectionRequest?  I probably did ...

When attempting to import a table to a new database from
an Access database every field in every record came
through as #Error with a pop up message of "The decimal
field's precision is too small to accept the numeric you

I have an events management database (MS Access sample)
that allows me to input students names, allocate them to
a range of workshops etc.  The workshops table has a
field which provides for maximum class sizes to be

   I've seen lots of posts from folks whose W2k machines cannot seem to
find XP, but I'm having almost the exact opposite problem. Here is the
scenario:
Machine one:

I am kind of new to Access.  I have created an Inventory
Tracking database and have a questions.  I want to have a
ModifyDate field that shows the last time a change was
made to data within the form.  How can I have it update

I am using Access 2000
Can anyone tell me why, I created a field w/i a table that
gets it's data from a look-up table.  The look-up table,
has only 2 columns; one with a number and the 2nd column

HELP has anyone any tips for adding blocks of records to a
database in table view? please

How do I convert the data in my fields to Uppercase??? I
tried a number of combinations as input masks and it
appears to work for new entries...However for entries
that already exists it converts some to uppercase and

Working in Access 2002. Periodically getting corruption
that causes the unique IDNo (which is an auto number,
primary key, long integer, incremental) to change from
its current 3 figure number to an apparently random huge