Can this form be made in ACCESS?

[B Blue]

here's the situation:
a produce dept at a grocery store needs to generate a weekly sheet for
ordering. This is how it looks:
5 columns across with the following headings:
Product Description, UPC code, Case Quantity, Case Price, Retail Price
- Product Description, UPC code, Case Quantity, are all to be drawn
from a table containing 100 records.
-Case Price, Retail Price are fields which will appear empty but allow
data entry

would it be possible to choose the item in the Product Description
field from a drop-down list of all values in the table and then have
it's corresponding UPC code and Case Qty also appear in that row?

There will be 20 rows each with a different product Descrip chosen.
Can each row have a drop down list from which the product can be
chosen?

After the selecting the contents of the 20 rows showing which will be
ordered, then that form can be printed and be the weekly order form.

hope this is clear. is it possible, if so, how does one go about it?

[Mike Storr]

On 8 Feb 2004 15:11:20 -0800, B Blue wrote:

here's the situation:
a produce dept at a grocery store needs to generate a weekly sheet for
ordering. This is how it looks:
5 columns across with the following headings:
Product Description, UPC code, Case Quantity, Case Price, Retail Price
- Product Description, UPC code, Case Quantity, are all to be drawn
from a table containing 100 records.
-Case Price, Retail Price are fields which will appear empty but allow
data entry

would it be possible to choose the item in the Product Description
field from a drop-down list of all values in the table and then have
it's corresponding UPC code and Case Qty also appear in that row?

There will be 20 rows each with a different product Descrip chosen.
Can each row have a drop down list from which the product can be
chosen?

After the selecting the contents of the 20 rows showing which will be
ordered, then that form can be printed and be the weekly order form.

hope this is clear. is it possible, if so, how does one go about it?

Explaning how in any detail would take some time (probably faster just to
build it), but yes this can be done using a datasheet or continuous form
attached to a query or table. With some minor code, you can have the
desired fields fill in after a choice is made, and the table emptied after
use so that it will open empty next time by running a delete query. The
form can be printed. Look through the help files for the following topics
and design away.

ComboBox - Properties
RowsourceType
Rowsource
Column
AfterUpdate
ColumnWidths
Continous Forms
Datasheets
Action Queries

If you are planning on storing the data that is filled in, then how you set
the form up becomes a little more involved.

--
Mike Storr
veraccess.com

[NB]

Yes, it is possible
And why can't it be made? ;-)

In other words, for basic questions like this, you should first try to
do it yourself. Then if you get some trouble or difficulty that you
can't solve (after you have RTFM - excuse my French), ask the NG.

NB

[B Blue]

ni******@lycos.com (NB) wrote in message news:<5c**************************@posting.google. com>...

Yes, it is possible
And why can't it be made? ;-)

In other words, for basic questions like this, you should first try to
do it yourself. Then if you get some trouble or difficulty that you
can't solve (after you have RTFM - excuse my French), ask the NG.

NB

I have been trying to set it up myself. Please excuse the fact that
i've been working alone for a long time in ACCESS and don't know the
correct terms.

I've gotten stuck on the combo box (which unfortunately is the
starting point). I've set up the whole form so it looks the way i
want.
i've three fields : [ProductDescription][UPCcode] [CaseQty] across the
top.
I want to make the ProductDescription a drop down list from which I
can choose a product and have it's corresponding information in that
record show up in that row.

For that ProductDescription field I have a an unbound field that I've
turned to a combo box. In the properties of the that field:
Control Source: ProductDescription
Input Mask: ?
Row source Type: Table/query
Row Source; ProduceTable (which didn't work)
The rest of the properties I've no idea what to fill in.

if I could just get started I could start to figure out what to look
up.

[Mike Storr]

On 9 Feb 2004 16:54:14 -0800, B Blue wrote:

I have been trying to set it up myself. Please excuse the fact that
i've been working alone for a long time in ACCESS and don't know the
correct terms.

I've gotten stuck on the combo box (which unfortunately is the
starting point). I've set up the whole form so it looks the way i
want.
i've three fields : [ProductDescription][UPCcode] [CaseQty] across the
top.
I want to make the ProductDescription a drop down list from which I
can choose a product and have it's corresponding information in that
record show up in that row.

For that ProductDescription field I have a an unbound field that I've
turned to a combo box. In the properties of the that field:
Control Source: ProductDescription
Then it's not unbound. It is bound to the ProductDescription field.
Input Mask: ?
Row source Type: Table/query
Row Source; ProduceTable (which didn't work)
Use the builder button to create a query for this property.
Something like
SELECT tblName.ProductDescription, tblName.UPCcode, tblName.CaseQty FROM
tblName;
The rest of the properties I've no idea what to fill in.

if I could just get started I could start to figure out what to look
up.

I think your recordsource for this form is not on the right table or query,
or not set at all. If it is bound to the products table, then each line you
create will add a product to that table - should it go into an OrderDetail
table or something like that? Even a temporary one that can be emptied
afterward will do.
Add in the AfterUpdate the following...

Me!UPCCode = Me!ProductDescription.Column(1)
Me!CaseQty = Me!ProductDescription.Column(2)

--
Mike Storr
veraccess.com

[B Blue]

Mike: thanks so much for your help on this.

I've figured out how to set up the combo box using the wizard. I'm
not sure if I want to include all three fields I want to show up in
each row or just the field from which I want to choose the record.
i.e. choosing [Product Description] from drop down list will get it's
corresponding [UPC] and [CaseQty] to show up in that row

I can get it to work in the first row. how can I have 20 rows where
in each of the rows a different product is chosen so that record only
shows in that row and doesn't change the first row whose product
you've chosen. In other words I want a different record to show in
each row.

you mentioned adding in the AfterUpdate the following:
Me!UPCCode=Me!ProductDescription.Column(1)
Me!UPCCode=Me!ProductDescription.Column(2)

With how I described I set up the first row, would that code still
work and would I copy that row of fields (including the combo box i've
got for the product) and past it into the form 20 times and then put
the code you wrote in each row's combo box's AfterUpdate property?

[Mike Storr]

On 10 Feb 2004 18:55:53 -0800, B Blue wrote:

Mike: thanks so much for your help on this.

I've figured out how to set up the combo box using the wizard. I'm
not sure if I want to include all three fields I want to show up in
each row or just the field from which I want to choose the record.
i.e. choosing [Product Description] from drop down list will get it's
corresponding [UPC] and [CaseQty] to show up in that row

I can get it to work in the first row. how can I have 20 rows where
in each of the rows a different product is chosen so that record only
shows in that row and doesn't change the first row whose product
you've chosen. In other words I want a different record to show in
each row.

you mentioned adding in the AfterUpdate the following:
Me!UPCCode=Me!ProductDescription.Column(1)
Me!UPCCode=Me!ProductDescription.Column(2)

With how I described I set up the first row, would that code still
work and would I copy that row of fields (including the combo box i've
got for the product) and past it into the form 20 times and then put
the code you wrote in each row's combo box's AfterUpdate property?

The simplest thing to do here, is to have this form bound to a table. If
there is any static information on this form, then you should be using a
Mainform / Subform arrangement, with the static info on the main. The form
that requires 20 rows, would be bound to a table and placed on the main as
a subform in Datasheet or Continous views. Doing this allows you to create
only one "row" of controls in the Details section of the subform, and this
row will automatically replicate itself (code and all) whenever a new row
is needed. Each row will pretend it is the only one there, and your code
will affect only the row that is current.
If you do not want to store the info that is entered, the run a query on
form closing that empties the table the subform was based on.

--
Mike Storr
veraccess.com