Thanks.
<mailto:nig.nig@ntlworld.com>

My new Microsoft Access adp database appears to close when I quit but is
actually still running.  I know this because I cannot re-open it and a look
at the running processes in Windows Task Manager reveals that MSACCESS.EXE is
still running.

I attempted entering a macro in my database for a table, however, it did not
work as I had intended so I tried to delete it.  My attempt was not
successful.  I keep getting a message that informs me that I have a macro
attached to my table which is erroneous.  The macro does not ...

I need to design a database that will hold contact information about our
investigator sites, contacts we meet at conferences, contact information
about our advisory boards. If the contact is an investigator site, there will
be mulitple people whose names will need to be entered ...

I am working on a database with employee details in Access. I need to write
a outer join query. But I know access does not support outer join query, is
there any other code which is equal to outer join? If anyone can send a
sample that would be a real help.

Is there a way to enter data into a record that updates another database?  
What I need to do is enter information on the amount of revenue received for
work performed, then consider the parts used on the job to then be able to
pull a job cost report.  So if I used 3-gadgets, 2 ...

This is the situation....I am setting up a database for a warehouse
situation.  Sales Orders are issued initially for orders which may include
several part numbers.  When these orders are completed, they may be shipped
in part or in whole.  This means that the same invoice number ...

I have a table that needs to hold the monthly grade of our members
locations.  There are 6 aspects to this grade.  Now, each inspection will
always give a grade for each of the 6 aspects.  Do I keep the 6 columns in
the main table?  Or, do I create a child table with each row ...

Long ago, I found a cool solution for listing tables and fields.  It creates
a TABLE of tables and fields, that can be sorted and printed.  It consists of
a table called tsysFields, a module called basReportTools, and a report
called rptTablesAndFields.  

I want to change the data type of certain fields in certain tables using VB6
code.  I currently use code like this to modify some of the field attributes:
                   Set tdfTableDef = db.TableDefs("SpecialTesting")
                       Set fldTemp = tdfTableDef!Field1

I am having trouble designing a data base to keep inventory of our material
used in manufacturing our products.  I want to be able to keep track of the
length and weight of the material and it's value based on our costs.

My data is not populating related tables.  For instance, the sales order
number in the Orders table is not populating the sales order field in the
Order Detail table. The order sequence of my tables is Customer -> Orders ->
Shipping -> Shipping Detail with trunks off of the ...

In my database about emoloyee vacation details, I have their time off marked
in hours. I need to get a report of their remaining days in vacation sick
etc. RIght now I get the report in hours example for 2 days remaining
vacation the report would show as 15 hrs, I want to convert ...

I am still working on my training records database. I have got my three main
tables sorted out (hoorah! LoL).
To get a list of supervisors, it was suggested to me that I put a checkbox
in the employee table and then create a query. At the moment I have a list of

I have fallen into the trap when throwing together a database a few years ago
of not using appropriate naming conventions in what has now become a very
large and quite complex database. I now have legacy field names such as
[Category code], which has a space in the name, rather ...