Group of Items using one form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kelly - 24 May 2008 04:55 GMT

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!

Reply to this Message

Robert - 25 May 2008 02:45 GMT

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.
[quoted text clipped - 27 lines]
>
> Thanks!

Reply to this Message

Kelly - 25 May 2008 14:14 GMT

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
[quoted text clipped - 41 lines]
> >
> > Thanks!

Reply to this Message

Robert - 25 May 2008 20:50 GMT

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
[quoted text clipped - 62 lines]
>> >
>> > Thanks!

Reply to this Message

Kelly - 29 May 2008 01:13 GMT

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
[quoted text clipped - 67 lines]
> >> >
> >> > Thanks!

Reply to this Message

Robert - 30 May 2008 00:29 GMT

You're welcome.

> HI,
> I was able to fianlly get somewhere with having the form Load with the
[quoted text clipped - 92 lines]
>> >> >
>> >> > Thanks!

Reply to this Message