Group of Items using one form

[Kelly]

I have a database that I had assistance in creating and was tutored with on
the code used.

The main form has buttons on it to select the station or cell name. The form
"frm_Job" that it calls up is the same form used for every cell. The form
contains the job number along with the current start time and end time of the
job.

All the information entered is based off (1) form and all information
entered is related to the cell or station button that was selected. This all
works perfect!

I am also familar with all of the code entered in this form, but possibly
not understanding the process that make this work. I know that it's based off
the ID with some code defining the Station or Cells.

The problem I have is this;
I created a button on the frm_Job form, which runs a query and creates a
chart based off the throughput of the job time.

How do I get this to relate to the correct cell or station? I tried to
create it based off the Cell Id, but I cannot figure it out. I'm not quite
understanding the procedure to make this happen?

If there is an easy way to control this, please help.

Thanks!

 

[Robert]

You can pass the cell id to the chart in the open statement (the where
condition) or you can reference the cell id in the query itself. Which you
would use would depend on your own situation and it's difficult to tell from
the information you have given.

When you dropped the button on the form, do you recall being asked if you
want to see all the records in the query or just some of them? That is for
setting up a where condition a.k.a. a where clause.

A reference to a field on a form looks like:
[forms].[yourformname].[yourtextboxname]

Robert

 

[Kelly]

Hi Robert, Thanks for the quick reply.
I have tried a few things, but was unable to get it to work yet. In the
Where condition using a query, I'm assuming this could be done using an sql
statement? This I have not done yet. I will see if I can figure this out and
get back to you.

thank you,

You can pass the cell id to the chart in the open statement (the where
condition) or you can reference the cell id in the query itself. Which you
would use would depend on your own situation and it's difficult to tell from
the information you have given.

When you dropped the button on the form, do you recall being asked if you
want to see all the records in the query or just some of them? That is for
setting up a where condition a.k.a. a where clause.

A reference to a field on a form looks like:
[forms].[yourformname].[yourtextboxname]

Robert

I have a database that I had assistance in creating and was tutored with on
the code used.

The main form has buttons on it to select the station or cell name. The
form
"frm_Job" that it calls up is the same form used for every cell. The form
contains the job number along with the current start time and end time of
the
job.

All the information entered is based off (1) form and all information
entered is related to the cell or station button that was selected. This
all
works perfect!

I am also familar with all of the code entered in this form, but possibly
not understanding the process that make this work. I know that it's based
off
the ID with some code defining the Station or Cells.

The problem I have is this;
I created a button on the frm_Job form, which runs a query and creates a
chart based off the throughput of the job time.

How do I get this to relate to the correct cell or station? I tried to
create it based off the Cell Id, but I cannot figure it out. I'm not quite
understanding the procedure to make this happen?

If there is an easy way to control this, please help.

Thanks!

 

[Robert]

In query design view, where conditions are entered on the line which says
"criteria". When you type in a criterion, a where clause is created in the
SQL view. You can go into SQL view and modify the where clause if you want.
In an OpenReport command, the where condition is one of the parameters.

Hi Robert, Thanks for the quick reply.
I have tried a few things, but was unable to get it to work yet. In the
Where condition using a query, I'm assuming this could be done using an
sql
statement? This I have not done yet. I will see if I can figure this out
and
get back to you.

thank you,

You can pass the cell id to the chart in the open statement (the where
condition) or you can reference the cell id in the query itself. Which
you
would use would depend on your own situation and it's difficult to tell
from
the information you have given.

When you dropped the button on the form, do you recall being asked if you
want to see all the records in the query or just some of them? That is
for
setting up a where condition a.k.a. a where clause.

A reference to a field on a form looks like:
[forms].[yourformname].[yourtextboxname]

Robert

I have a database that I had assistance in creating and was tutored with
on
the code used.

The main form has buttons on it to select the station or cell name. The
form
"frm_Job" that it calls up is the same form used for every cell. The
form
contains the job number along with the current start time and end time
of
the
job.

All the information entered is based off (1) form and all information
entered is related to the cell or station button that was selected.
This
all
works perfect!

I am also familar with all of the code entered in this form, but
possibly
not understanding the process that make this work. I know that it's
based
off
the ID with some code defining the Station or Cells.

The problem I have is this;
I created a button on the frm_Job form, which runs a query and creates
a
chart based off the throughput of the job time.

How do I get this to relate to the correct cell or station? I tried to
create it based off the Cell Id, but I cannot figure it out. I'm not
quite
understanding the procedure to make this happen?

If there is an easy way to control this, please help.

Thanks!

 

[Kelly]

HI,
I was able to fianlly get somewhere with having the form Load with the
correct data output. I used your example in a query to reference the form and
also added some code to the form when loading in a few areas. I followed the
steps used in launching the previous form which (1) form is used for the (8)
Stations.

Looks like I'm good for now. Thank you for your help.

In query design view, where conditions are entered on the line which says
"criteria". When you type in a criterion, a where clause is created in the
SQL view. You can go into SQL view and modify the where clause if you want.
In an OpenReport command, the where condition is one of the parameters.

Hi Robert, Thanks for the quick reply.
I have tried a few things, but was unable to get it to work yet. In the
Where condition using a query, I'm assuming this could be done using an
sql
statement? This I have not done yet. I will see if I can figure this out
and
get back to you.

thank you,

You can pass the cell id to the chart in the open statement (the where
condition) or you can reference the cell id in the query itself. Which
you
would use would depend on your own situation and it's difficult to tell
from
the information you have given.

When you dropped the button on the form, do you recall being asked if you
want to see all the records in the query or just some of them? That is
for
setting up a where condition a.k.a. a where clause.

A reference to a field on a form looks like:
[forms].[yourformname].[yourtextboxname]

Robert

I have a database that I had assistance in creating and was tutored with
on
the code used.

The main form has buttons on it to select the station or cell name. The
form
"frm_Job" that it calls up is the same form used for every cell. The
form
contains the job number along with the current start time and end time
of
the
job.

All the information entered is based off (1) form and all information
entered is related to the cell or station button that was selected.
This
all
works perfect!

I am also familar with all of the code entered in this form, but
possibly
not understanding the process that make this work. I know that it's
based
off
the ID with some code defining the Station or Cells.

The problem I have is this;
I created a button on the frm_Job form, which runs a query and creates
a
chart based off the throughput of the job time.

How do I get this to relate to the correct cell or station? I tried to
create it based off the Cell Id, but I cannot figure it out. I'm not
quite
understanding the procedure to make this happen?

If there is an easy way to control this, please help.

Thanks!

 

[Robert]

You're welcome.

HI,
I was able to fianlly get somewhere with having the form Load with the
correct data output. I used your example in a query to reference the form
and
also added some code to the form when loading in a few areas. I followed
the
steps used in launching the previous form which (1) form is used for the
(8)
Stations.

Looks like I'm good for now. Thank you for your help.

In query design view, where conditions are entered on the line which says
"criteria". When you type in a criterion, a where clause is created in
the
SQL view. You can go into SQL view and modify the where clause if you
want.
In an OpenReport command, the where condition is one of the parameters.

Hi Robert, Thanks for the quick reply.
I have tried a few things, but was unable to get it to work yet. In the
Where condition using a query, I'm assuming this could be done using an
sql
statement? This I have not done yet. I will see if I can figure this
out
and
get back to you.

thank you,


:

You can pass the cell id to the chart in the open statement (the where
condition) or you can reference the cell id in the query itself.
Which
you
would use would depend on your own situation and it's difficult to
tell
from
the information you have given.

When you dropped the button on the form, do you recall being asked if
you
want to see all the records in the query or just some of them? That
is
for
setting up a where condition a.k.a. a where clause.

A reference to a field on a form looks like:
[forms].[yourformname].[yourtextboxname]

Robert

I have a database that I had assistance in creating and was tutored
with
on
the code used.

The main form has buttons on it to select the station or cell name.
The
form
"frm_Job" that it calls up is the same form used for every cell. The
form
contains the job number along with the current start time and end
time
of
the
job.

All the information entered is based off (1) form and all
information
entered is related to the cell or station button that was selected.
This
all
works perfect!

I am also familar with all of the code entered in this form, but
possibly
not understanding the process that make this work. I know that it's
based
off
the ID with some code defining the Station or Cells.

The problem I have is this;
I created a button on the frm_Job form, which runs a query and
creates
a
chart based off the throughput of the job time.

How do I get this to relate to the correct cell or station? I tried
to
create it based off the Cell Id, but I cannot figure it out. I'm not
quite
understanding the procedure to make this happen?

If there is an easy way to control this, please help.

Thanks!