Anyone out there, need help with Design

I apparently lost the person helping me so I will start over here in hopes of
getting some help from someone that is more familiar. Once I do it once, I
learn it, but this is my first time for setting up a database with access.

I have 7 facilities... I want each facility to have a simple form to enter
data with. I want each facility to only have access to their own facility's
database. I want each of these facilities information placed into a master
database to run reports, queries, etc. for analysis.

Thus, I want the table Main_DB (the main database) to contain the informaton
for tables Facility1 through Facility7. How do I do this? All fields are
the same in every database. Please use the names of Facility1-7 when writing
code so I can better understand it.

Brad,
I think I posted something in your original thread but Brett was doing a
fine job of working with you so I didn't interrupt. Basically, you need to
only have one field that stores the facility name (Facility1, Facility7,
etc.) and use queries to make that information available to the users at
each facility. That way, all the information is available to whoever also
needs to run reports for ALL or Multiple facilities.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Brad_A" wrote in message
...
I apparently lost the person helping me so I will start over here in hopes
of
getting some help from someone that is more familiar. Once I do it once,
I
learn it, but this is my first time for setting up a database with access.

I have 7 facilities... I want each facility to have a simple form to enter
data with. I want each facility to only have access to their own
facility's
database. I want each of these facilities information placed into a
master
database to run reports, queries, etc. for analysis.

Thus, I want the table Main_DB (the main database) to contain the
informaton
for tables Facility1 through Facility7. How do I do this? All fields are
the same in every database. Please use the names of Facility1-7 when
writing
code so I can better understand it.

Yeah, Brett stopped responding for some reason. I need a step by step on how
to do this.

"Lynn Trapp" wrote:

Brad,
I think I posted something in your original thread but Brett was doing a
fine job of working with you so I didn't interrupt. Basically, you need to
only have one field that stores the facility name (Facility1, Facility7,
etc.) and use queries to make that information available to the users at
each facility. That way, all the information is available to whoever also
needs to run reports for ALL or Multiple facilities.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Brad_A" wrote in message
...
I apparently lost the person helping me so I will start over here in hopes
of
getting some help from someone that is more familiar. Once I do it once,
I
learn it, but this is my first time for setting up a database with access.

I have 7 facilities... I want each facility to have a simple form to enter
data with. I want each facility to only have access to their own
facility's
database. I want each of these facilities information placed into a
master
database to run reports, queries, etc. for analysis.

Thus, I want the table Main_DB (the main database) to contain the
informaton
for tables Facility1 through Facility7. How do I do this? All fields are
the same in every database. Please use the names of Facility1-7 when
writing
code so I can better understand it.

BTW, I do have a DB that has each facility name as a column field. I just
need a step by step no how to get it all connected and how to restrict access
so that each facility only gets access to their own information.

"Lynn Trapp" wrote:

Brad,
I think I posted something in your original thread but Brett was doing a
fine job of working with you so I didn't interrupt. Basically, you need to
only have one field that stores the facility name (Facility1, Facility7,
etc.) and use queries to make that information available to the users at
each facility. That way, all the information is available to whoever also
needs to run reports for ALL or Multiple facilities.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Brad_A" wrote in message
...
I apparently lost the person helping me so I will start over here in hopes
of
getting some help from someone that is more familiar. Once I do it once,
I
learn it, but this is my first time for setting up a database with access.

I have 7 facilities... I want each facility to have a simple form to enter
data with. I want each facility to only have access to their own
facility's
database. I want each of these facilities information placed into a
master
database to run reports, queries, etc. for analysis.

Thus, I want the table Main_DB (the main database) to contain the
informaton
for tables Facility1 through Facility7. How do I do this? All fields are
the same in every database. Please use the names of Facility1-7 when
writing
code so I can better understand it.

Brad,
I think you misunderstood me. You don't want a separate field for each
facility. Rather you need to have ONE Field -- let's call it Facility. You
will need to enter the appropriate facility number in that field. Then, to
make it possible for Facility1 to see only their data, the simplest thing to
do is create a separate Frontend that has a query similar to the following
as the recordsource for their data entry form.

SELECT Field1, Field2, Field3, .... FieldN
From YourTable
Where Facility = 1;

Start off with giving that a try and then post back if you have further
questions.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Brad_A" wrote in message
...
BTW, I do have a DB that has each facility name as a column field. I just
need a step by step no how to get it all connected and how to restrict
access
so that each facility only gets access to their own information.

"Lynn Trapp" wrote:

Brad,
I think I posted something in your original thread but Brett was doing a
fine job of working with you so I didn't interrupt. Basically, you need
to
only have one field that stores the facility name (Facility1, Facility7,
etc.) and use queries to make that information available to the users at
each facility. That way, all the information is available to whoever
also
needs to run reports for ALL or Multiple facilities.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Brad_A" wrote in message
...
I apparently lost the person helping me so I will start over here in
hopes
of
getting some help from someone that is more familiar. Once I do it
once,
I
learn it, but this is my first time for setting up a database with
access.

I have 7 facilities... I want each facility to have a simple form to
enter
data with. I want each facility to only have access to their own
facility's
database. I want each of these facilities information placed into a
master
database to run reports, queries, etc. for analysis.

Thus, I want the table Main_DB (the main database) to contain the
informaton
for tables Facility1 through Facility7. How do I do this? All fields
are
the same in every database. Please use the names of Facility1-7 when
writing
code so I can better understand it.

I have the Facility Name as a pull down option so each field column heading
is the facility name in the "Facility" database. Where exactly do I enter
that code at? I have one main DB, and a seperate form for each facility.


"Lynn Trapp" wrote:

Brad,
I think you misunderstood me. You don't want a separate field for each
facility. Rather you need to have ONE Field -- let's call it Facility. You
will need to enter the appropriate facility number in that field. Then, to
make it possible for Facility1 to see only their data, the simplest thing to
do is create a separate Frontend that has a query similar to the following
as the recordsource for their data entry form.

SELECT Field1, Field2, Field3, .... FieldN
From YourTable
Where Facility = 1;

Start off with giving that a try and then post back if you have further
questions.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Brad_A" wrote in message
...
BTW, I do have a DB that has each facility name as a column field. I just
need a step by step no how to get it all connected and how to restrict
access
so that each facility only gets access to their own information.

"Lynn Trapp" wrote:

Brad,
I think I posted something in your original thread but Brett was doing a
fine job of working with you so I didn't interrupt. Basically, you need
to
only have one field that stores the facility name (Facility1, Facility7,
etc.) and use queries to make that information available to the users at
each facility. That way, all the information is available to whoever
also
needs to run reports for ALL or Multiple facilities.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Brad_A" wrote in message
...
I apparently lost the person helping me so I will start over here in
hopes
of
getting some help from someone that is more familiar. Once I do it
once,
I
learn it, but this is my first time for setting up a database with
access.

I have 7 facilities... I want each facility to have a simple form to
enter
data with. I want each facility to only have access to their own
facility's
database. I want each of these facilities information placed into a
master
database to run reports, queries, etc. for analysis.

Thus, I want the table Main_DB (the main database) to contain the
informaton
for tables Facility1 through Facility7. How do I do this? All fields
are
the same in every database. Please use the names of Facility1-7 when
writing
code so I can better understand it.

I am getting all kinds of parameters. Not doing me any good.

"Lynn Trapp" wrote:

Brad,
I think you misunderstood me. You don't want a separate field for each
facility. Rather you need to have ONE Field -- let's call it Facility. You
will need to enter the appropriate facility number in that field. Then, to
make it possible for Facility1 to see only their data, the simplest thing to
do is create a separate Frontend that has a query similar to the following
as the recordsource for their data entry form.

SELECT Field1, Field2, Field3, .... FieldN
From YourTable
Where Facility = 1;

Start off with giving that a try and then post back if you have further
questions.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Brad_A" wrote in message
...
BTW, I do have a DB that has each facility name as a column field. I just
need a step by step no how to get it all connected and how to restrict
access
so that each facility only gets access to their own information.

"Lynn Trapp" wrote:

Brad,
I think I posted something in your original thread but Brett was doing a
fine job of working with you so I didn't interrupt. Basically, you need
to
only have one field that stores the facility name (Facility1, Facility7,
etc.) and use queries to make that information available to the users at
each facility. That way, all the information is available to whoever
also
needs to run reports for ALL or Multiple facilities.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Brad_A" wrote in message
...
I apparently lost the person helping me so I will start over here in
hopes
of
getting some help from someone that is more familiar. Once I do it
once,
I
learn it, but this is my first time for setting up a database with
access.

I have 7 facilities... I want each facility to have a simple form to
enter
data with. I want each facility to only have access to their own
facility's
database. I want each of these facilities information placed into a
master
database to run reports, queries, etc. for analysis.

Thus, I want the table Main_DB (the main database) to contain the
informaton
for tables Facility1 through Facility7. How do I do this? All fields
are
the same in every database. Please use the names of Facility1-7 when
writing
code so I can better understand it.

I have the Facility Name as a pull down option so each field column
heading
is the facility name in the "Facility" database.

That's the problem. You should not be storing data in your field names.
Naming your fields Facility1, Facility2, Facility3, etc. is doing just that.
You need ONE column named Facility and then store the data in that column
appropriate to the Facility. Thus, a record might look like this:

Field1 Field2 Field3 Facility
Jack Smith Salesman 1
Dave Jones Programmer 2

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Brad_A" wrote in message
...
I have the Facility Name as a pull down option so each field column
heading
is the facility name in the "Facility" database. Where exactly do I enter
that code at? I have one main DB, and a seperate form for each facility.


"Lynn Trapp" wrote:

Brad,
I think you misunderstood me. You don't want a separate field for each
facility. Rather you need to have ONE Field -- let's call it Facility.
You
will need to enter the appropriate facility number in that field. Then,
to
make it possible for Facility1 to see only their data, the simplest
thing to
do is create a separate Frontend that has a query similar to the
following
as the recordsource for their data entry form.

SELECT Field1, Field2, Field3, .... FieldN
From YourTable
Where Facility = 1;

Start off with giving that a try and then post back if you have further
questions.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Brad_A" wrote in message
...
BTW, I do have a DB that has each facility name as a column field. I
just
need a step by step no how to get it all connected and how to restrict
access
so that each facility only gets access to their own information.

"Lynn Trapp" wrote:

Brad,
I think I posted something in your original thread but Brett was
doing a
fine job of working with you so I didn't interrupt. Basically, you
need
to
only have one field that stores the facility name (Facility1,
Facility7,
etc.) and use queries to make that information available to the
users at
each facility. That way, all the information is available to whoever
also
needs to run reports for ALL or Multiple facilities.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Brad_A" wrote in message
...
I apparently lost the person helping me so I will start over here
in
hopes
of
getting some help from someone that is more familiar. Once I do
it
once,
I
learn it, but this is my first time for setting up a database with
access.

I have 7 facilities... I want each facility to have a simple form
to
enter
data with. I want each facility to only have access to their own
facility's
database. I want each of these facilities information placed into
a
master
database to run reports, queries, etc. for analysis.

Thus, I want the table Main_DB (the main database) to contain the
informaton
for tables Facility1 through Facility7. How do I do this? All
fields
are
the same in every database. Please use the names of Facility1-7
when
writing
code so I can better understand it.

I am getting all kinds of parameters. Not doing me any good.


Brad,
You have to keep in mind that I can't see your database. It's impossible for
me to know what is causing the prompts for parameter input without seeing
the SQL statement behind your queries.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Brad_A" wrote in message
...
I am getting all kinds of parameters. Not doing me any good.

"Lynn Trapp" wrote:

Brad,
I think you misunderstood me. You don't want a separate field for each
facility. Rather you need to have ONE Field -- let's call it Facility.
You
will need to enter the appropriate facility number in that field. Then,
to
make it possible for Facility1 to see only their data, the simplest
thing to
do is create a separate Frontend that has a query similar to the
following
as the recordsource for their data entry form.

SELECT Field1, Field2, Field3, .... FieldN
From YourTable
Where Facility = 1;

Start off with giving that a try and then post back if you have further
questions.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Brad_A" wrote in message
...
BTW, I do have a DB that has each facility name as a column field. I
just
need a step by step no how to get it all connected and how to restrict
access
so that each facility only gets access to their own information.

"Lynn Trapp" wrote:

Brad,
I think I posted something in your original thread but Brett was
doing a
fine job of working with you so I didn't interrupt. Basically, you
need
to
only have one field that stores the facility name (Facility1,
Facility7,
etc.) and use queries to make that information available to the
users at
each facility. That way, all the information is available to whoever
also
needs to run reports for ALL or Multiple facilities.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Brad_A" wrote in message
...
I apparently lost the person helping me so I will start over here
in
hopes
of
getting some help from someone that is more familiar. Once I do
it
once,
I
learn it, but this is my first time for setting up a database with
access.

I have 7 facilities... I want each facility to have a simple form
to
enter
data with. I want each facility to only have access to their own
facility's
database. I want each of these facilities information placed into
a
master
database to run reports, queries, etc. for analysis.

Thus, I want the table Main_DB (the main database) to contain the
informaton
for tables Facility1 through Facility7. How do I do this? All
fields
are
the same in every database. Please use the names of Facility1-7
when
writing
code so I can better understand it.

Okay, I will describe the whole thing.

I have a master database with 10 fields. So, for an example use Field1,
Field2, etc. One of the fields is facility, in which there are seven. It is
done with a pull down menu that receives its data from the Facility database,
which has the 7 facility names (Facility1, Facility2, etc.). This form
needs to be easy to fill out.

I want to send the database to each facility (or host over internal
network). I want them to fill in their data, and form information about the
facility individually as well as all facilities.

The only database that I have made is of the simple one user variety. I am
trying to learn how to do one that requires 7 users to have seperate
databases, yet one big one for me. The best way to learn is to get a step by
step so that I fully understand what each step is doing and its purpose.





"Lynn Trapp" wrote:

I am getting all kinds of parameters. Not doing me any good.


Brad,
You have to keep in mind that I can't see your database. It's impossible for
me to know what is causing the prompts for parameter input without seeing
the SQL statement behind your queries.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Brad_A" wrote in message
...
I am getting all kinds of parameters. Not doing me any good.

"Lynn Trapp" wrote:

Brad,
I think you misunderstood me. You don't want a separate field for each
facility. Rather you need to have ONE Field -- let's call it Facility.
You
will need to enter the appropriate facility number in that field. Then,
to
make it possible for Facility1 to see only their data, the simplest
thing to
do is create a separate Frontend that has a query similar to the
following
as the recordsource for their data entry form.

SELECT Field1, Field2, Field3, .... FieldN
From YourTable
Where Facility = 1;

Start off with giving that a try and then post back if you have further
questions.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Brad_A" wrote in message
...
BTW, I do have a DB that has each facility name as a column field. I
just
need a step by step no how to get it all connected and how to restrict
access
so that each facility only gets access to their own information.

"Lynn Trapp" wrote:

Brad,
I think I posted something in your original thread but Brett was
doing a
fine job of working with you so I didn't interrupt. Basically, you
need
to
only have one field that stores the facility name (Facility1,
Facility7,
etc.) and use queries to make that information available to the
users at
each facility. That way, all the information is available to whoever
also
needs to run reports for ALL or Multiple facilities.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Brad_A" wrote in message
...
I apparently lost the person helping me so I will start over here
in
hopes
of
getting some help from someone that is more familiar. Once I do
it
once,
I
learn it, but this is my first time for setting up a database with
access.

I have 7 facilities... I want each facility to have a simple form
to
enter
data with. I want each facility to only have access to their own
facility's
database. I want each of these facilities information placed into
a
master
database to run reports, queries, etc. for analysis.

Thus, I want the table Main_DB (the main database) to contain the
informaton
for tables Facility1 through Facility7. How do I do this? All
fields
are
the same in every database. Please use the names of Facility1-7
when
writing
code so I can better understand it.