I have a database that keeps records on Companies. What I need to do is know
which company can supply other companies products. For example: I could have
the following in my Company Table
Company ID        Company Name            Makes/Manufactures

I have two tables with (1 items) and (2 transactions) on
items in "1". (eg. I have equipment in table"1".
Maintainance on equipment in Table "2"). this two tables
has common ID fields which I reference . I want to make

I have create a number of tables with NSW info in one
Victoria in another and QLD in another.
I am trying to combine all of the data into one large
table then query NSW QLD etc from the one table

I'm trying to establish a medical excel file for my mother.
She has a complicated medical history and everytime I think I've created an
effective excel chart and bring it to the doctors, I find I'm missing
critical data.

Am I right in presuming that setting a database to Compact
on Close is a BAD idea in a multiuser environment?
I can envisage all sorts of problems or am I being too
cautious?

I want to create a database of different magazine articles.  In particular,
articles in Guitar instruction magazines:
1 lessons, concepts
2 transcriptions - band

When I veiw my table, some of the fields have little boxes between the words
instead of spaces.
I cannot copy them.  I cannot find them when doing a replace.
How can I get rid of them and leave the data?

When should a look up table be created?
What I was thinking is in the IT inventory database, for field type, I created a combo box that pulls what is already in the type fields as a choice to use for new entries.  However, if I wanted to add a new type of hardware, I would have a ...

I am building a database to organise lines of conversation.  The
conversations are only displayed based on conditional data.  For example:
"What a hot day."  only displays when weather is hot.  I have a table for
type of conditional types, and a table for each conditional.  For ...

I'm setting up a database that I would like to capture
information from multiple spreadsheets.  The spreadsheets
will contain similar fields, but will be from seperate
users. If the spreadsheets are linked to the database, is

I'm setting up an inventory for IT hardware.  I've been debating on the relationships.
Currently I have the following:
tblhardware
tblemployees

The telephone number field in the database I am working on
uses an input mask, i.e. !\(999") "000\-0000;;_  The area
code is almost always going to be the same so I would like
to display a default value, but continue using the input

I am working with Visio Modeler 3.1 generating a database.
 My OR model appears to be OK, and I'm successful building
the dictionary.
However, I have been unsuccessful when trying to generate a

hello, I have some code for refreshing links. Which is
very slow.. how can I code a refreshing links function
only if the connection is broken?
The code I have now:

i m very new to MS Access but i m familier with other
dataabses.
Now in my application i m going to create a table and its
data is updated every time user is connected to the net.in