Anyone out there, need help with Design

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.

That sounds pretty good then. For the Facility field, create a combobox with
the following rowsource (change fieldnames appropriately):

Select FacilityName
From Facility;

Then the users will need to select that for each record they enter.

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

Where exactly is the

Select FacilityName
From Facility;

placed? Where would I enter that information?


"Lynn Trapp" wrote:

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.

That sounds pretty good then. For the Facility field, create a combobox with
the following rowsource (change fieldnames appropriately):

Select FacilityName
From Facility;

Then the users will need to select that for each record they enter.

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

in the RowSource property of the combo box.

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


"Brad_A" wrote in message
...
Where exactly is the

Select FacilityName
From Facility;

placed? Where would I enter that information?


"Lynn Trapp" wrote:

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.

That sounds pretty good then. For the Facility field, create a combobox
with
the following rowsource (change fieldnames appropriately):

Select FacilityName
From Facility;

Then the users will need to select that for each record they enter.

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

Is this in the main_db, form design, or some quiery? Where is the combobox?
I have the combobox in seven form names right now. When I open Facility1
Form, it automatically places Facilitiy1 name there. The problem is I can
flip through the entered informaiton from other facilities and see the
information.

"Lynn Trapp" wrote:

in the RowSource property of the combo box.

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


"Brad_A" wrote in message
...
Where exactly is the

Select FacilityName
From Facility;

placed? Where would I enter that information?


"Lynn Trapp" wrote:

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.

That sounds pretty good then. For the Facility field, create a combobox
with
the following rowsource (change fieldnames appropriately):

Select FacilityName
From Facility;

Then the users will need to select that for each record they enter.

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

Brad,
The way you describe it, you probably don't want to use a combobox at all.
You should only have ONE form and the recordsource behind that form should
be a query that limits what is seen to the specific facility a user is at.
You will need to create a type of log on form that has the user identify
initially which facility he or she is at -- you might even add password
protection to it, giving each facilty it's own unique password.

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


"Brad_A" wrote in message
...
Is this in the main_db, form design, or some quiery? Where is the
combobox?
I have the combobox in seven form names right now. When I open Facility1
Form, it automatically places Facilitiy1 name there. The problem is I can
flip through the entered informaiton from other facilities and see the
information.

"Lynn Trapp" wrote:

in the RowSource property of the combo box.

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


"Brad_A" wrote in message
...
Where exactly is the

Select FacilityName
From Facility;

placed? Where would I enter that information?


"Lynn Trapp" wrote:

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.

That sounds pretty good then. For the Facility field, create a
combobox
with
the following rowsource (change fieldnames appropriately):

Select FacilityName
From Facility;

Then the users will need to select that for each record they enter.

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

Lynn,

Is it possible to get detail no how to do all of this? At least how do I
code and password protect the queries? What query type should I use and what
is the code for it? I apologize for not understanding, but this is my first
time, and I haven't been through the system and database design classes yet.
However, I need to set up this database, and learn/understand it for future
use as well.

Trying to make sure I have all of the right parts:
1. One password form that will signal the facility that is logged on - I
have no idea on how to do this
2. One entry form (would already have facility name filled in for quicker
and easier entry)
3. One main database that holds all of the information
4. Queries - how many, what type, etc. do I need?

Looks like 1 and 4 are the areas in which I need detailed help.

Regards,
Brad

"Lynn Trapp" wrote:

Brad,
The way you describe it, you probably don't want to use a combobox at all.
You should only have ONE form and the recordsource behind that form should
be a query that limits what is seen to the specific facility a user is at.
You will need to create a type of log on form that has the user identify
initially which facility he or she is at -- you might even add password
protection to it, giving each facilty it's own unique password.

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


"Brad_A" wrote in message
...
Is this in the main_db, form design, or some quiery? Where is the
combobox?
I have the combobox in seven form names right now. When I open Facility1
Form, it automatically places Facilitiy1 name there. The problem is I can
flip through the entered informaiton from other facilities and see the
information.

"Lynn Trapp" wrote:

in the RowSource property of the combo box.

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


"Brad_A" wrote in message
...
Where exactly is the

Select FacilityName
From Facility;

placed? Where would I enter that information?


"Lynn Trapp" wrote:

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.

That sounds pretty good then. For the Facility field, create a
combobox
with
the following rowsource (change fieldnames appropriately):

Select FacilityName
From Facility;

Then the users will need to select that for each record they enter.

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

Is it possible to get detail no how to do all of this? At least how do I
code and password protect the queries? What query type should I use and
what
is the code for it? I apologize for not understanding, but this is my
first
time, and I haven't been through the system and database design classes
yet.
However, I need to set up this database, and learn/understand it for
future
use as well.

Brad,
I actually think that I will do better to "teach you how to fish" than to go
fishing for you. It looks to me like you need to get to that database design
class or, in lieu of that, get a copy of Database Design for Mere Mortals by
Michael Hernandez. You can also search the Microsoft website, or do a google
search, for "database design".

1. One password form that will signal the facility that is logged on - I
have no idea on how to do this

The simplest way to do this would be to have a simple form with 2 textboxes
and 2 command buttons (OK and Cancel). You would put code similar to the
following in the Click event of the OK button.

Select Case Me.txtFacilityName
Case "Facility1"
If Me.txtFacilityPassword = "SomePassword" Then
DoCmd.OpenForm "YourFormName"
Else
MsgBox "You do not have permission to log on"
End If
Case "Facility2"
If Me.txtFacilityPassword = "SomeOtherPassword" Then
DoCmd.OpenForm "YourFormName"
Else
MsgBox "You do not have permission to log on"
End If
........Add Case statements for all the facilities and then this
Case Else
MsgBox "You Must enter a valid facility Name"
End Select

2. One entry form (would already have facility name filled in for quicker
and easier entry)

Just base this form on a query where the criteria for the facility field is
the value in the Log on screen in txtFacility

3. One main database that holds all of the information

To be accurate, the "database" is the entire file that you have open, while
a "table" is what you are referring to.

4. Queries - how many, what type, etc. do I need?

That depends on what you need to do.


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

What is the Me.txt?

Do you mean txtFacility.Text on that Select Case? Shouldn't
txtFacility.Text be assigned to a variable.

I am a person that learns by doing it. I am learning as I am adding. It
just seems hard because some of your instructions just say "do this" without
providing the instruction to do it.

I created the password form. Just need to tweak the coding based on the
questions above.

Regards,
Brad

"Lynn Trapp" wrote:

Is it possible to get detail no how to do all of this? At least how do I
code and password protect the queries? What query type should I use and
what
is the code for it? I apologize for not understanding, but this is my
first
time, and I haven't been through the system and database design classes
yet.
However, I need to set up this database, and learn/understand it for
future
use as well.

Brad,
I actually think that I will do better to "teach you how to fish" than to go
fishing for you. It looks to me like you need to get to that database design
class or, in lieu of that, get a copy of Database Design for Mere Mortals by
Michael Hernandez. You can also search the Microsoft website, or do a google
search, for "database design".

1. One password form that will signal the facility that is logged on - I
have no idea on how to do this

The simplest way to do this would be to have a simple form with 2 textboxes
and 2 command buttons (OK and Cancel). You would put code similar to the
following in the Click event of the OK button.

Select Case Me.txtFacilityName
Case "Facility1"
If Me.txtFacilityPassword = "SomePassword" Then
DoCmd.OpenForm "YourFormName"
Else
MsgBox "You do not have permission to log on"
End If
Case "Facility2"
If Me.txtFacilityPassword = "SomeOtherPassword" Then
DoCmd.OpenForm "YourFormName"
Else
MsgBox "You do not have permission to log on"
End If
........Add Case statements for all the facilities and then this
Case Else
MsgBox "You Must enter a valid facility Name"
End Select

2. One entry form (would already have facility name filled in for quicker
and easier entry)

Just base this form on a query where the criteria for the facility field is
the value in the Log on screen in txtFacility

3. One main database that holds all of the information

To be accurate, the "database" is the entire file that you have open, while
a "table" is what you are referring to.

4. Queries - how many, what type, etc. do I need?

That depends on what you need to do.


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

What is the Me.txt?


By default, Access gives a textbox control a name such as Text1 or the name
of a field it is bound to. To make it more readable I use the convention of
adding "txt" to the front of the name of any textboxes. Therefore, my
recommendation was that you would rename the textbox (on the Other tab of
the property pallette) to txtFacilityName. "Me" is a shortcut way of
referring to the Form object.

Do you mean txtFacility.Text on that Select Case? Shouldn't
txtFacility.Text be assigned to a variable.

The .Text property is the default when referring to a textbox and, thus, you
don't need to add that. You can simply reference it by typing
Me.txtFacilityName. In other words, Me.txtFacilityName is exactly the same
as Me.txtFacilityName.Text.

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