populating txtboxes with specific tbl info

[perryclisbee via AccessMonster.com]

I have a table (tblProducts) of vending machine products where it displays
the [machinelocation], [machinegrid], and [product]. I have a corresponding
form that shows 50 different txtboxes, laying out a vending machine diagram,
10 fields across by 5 fields down. Above the txtboxes is a field that
displays the machine location.
I want to show products in the txtboxes that correspond with the machine grid
in the table. For example:

On the form: txtbox [A1] would show the [tblProducts].[product] for the
[tblProducts].[machinegrid] of A1.

Any ideas on how to do this?

 

[Jeff Boyce]

You've described what sounds like a table based on a form. In Access, if
you want to get the best use of the features and functions offered, you
start out with well-normalized tables, then come up with a way to display
that data (i.e., in a form).

If your table is not well-normalized, or if this term doesn't ring any
bells, consider stepping back and spending time learning about relational
databases and normalization.

Or is there a chance that you could do what you need to using, say, a
spreadsheet?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[perryclisbee via AccessMonster.com]

I'll try to clarify better.
As an Example: I am a vendor that has three vending machines (10 rows wide
and 5 rows high each), each at a different location. I have a data entry
form where I enter products for each machine. Each machine is divided into
"cells": A1 thru E10 for example, with a product listed in each cell. this
information is of course transferred to the table that now holds information
on each "cell" of each machine. This table is good to go. I now am looking
to place the values from this table for a given location, showing the product
that is associated with each cell, and display this in a certain way on a
form, via txtboxes.
I was thinking about having a qry that references the table, comparing it to
a field on the same form that displays a selected location, and gives results
that are in turn populated inthe txtboxes (all 50 of them), product and cell
specific.

that was probably just as confusing, but I just can't seem to get the
specific table data into the specific cells.

Any ideas?

You've described what sounds like a table based on a form. In Access, if
you want to get the best use of the features and functions offered, you
start out with well-normalized tables, then come up with a way to display
that data (i.e., in a form).

If your table is not well-normalized, or if this term doesn't ring any
bells, consider stepping back and spending time learning about relational
databases and normalization.

Or is there a chance that you could do what you need to using, say, a
spreadsheet?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a table (tblProducts) of vending machine products where it displays
the [machinelocation], [machinegrid], and [product]. I have a

[quoted text clipped - 11 lines]

Any ideas on how to do this?

 

[Jeff Boyce]

I'll suggest again that you consider using a spreadsheet. Your "cells" (A1
through E10) notation is very spreadsheetly, and I suspect your data may not
be particularly well-normalized.

Why would this matter, you ask?

If you want to make Access work for you, you need to work for it first. If
you feed it spreadsheets, it won't be able to do as much, as well, as easily
(nor you either!).

If you need to find a way to get data into controls on a form, it helps if
the data is well-normalized. If it isn't and won't be, you'll probably have
to spend considerable thought and effort writing code to do what you're
asking.

Good luck!

Jeff Boyce
Microsoft Office/Access MVP

I'll try to clarify better.
As an Example: I am a vendor that has three vending machines (10 rows
wide
and 5 rows high each), each at a different location. I have a data entry
form where I enter products for each machine. Each machine is divided
into
"cells": A1 thru E10 for example, with a product listed in each cell.
this
information is of course transferred to the table that now holds
information
on each "cell" of each machine. This table is good to go. I now am
looking
to place the values from this table for a given location, showing the
product
that is associated with each cell, and display this in a certain way on a
form, via txtboxes.
I was thinking about having a qry that references the table, comparing it
to
a field on the same form that displays a selected location, and gives
results
that are in turn populated inthe txtboxes (all 50 of them), product and
cell
specific.

that was probably just as confusing, but I just can't seem to get the
specific table data into the specific cells.

Any ideas?

You've described what sounds like a table based on a form. In Access, if
you want to get the best use of the features and functions offered, you
start out with well-normalized tables, then come up with a way to display
that data (i.e., in a form).

If your table is not well-normalized, or if this term doesn't ring any
bells, consider stepping back and spending time learning about relational
databases and normalization.

Or is there a chance that you could do what you need to using, say, a
spreadsheet?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a table (tblProducts) of vending machine products where it
displays
the [machinelocation], [machinegrid], and [product]. I have a

[quoted text clipped - 11 lines]

Any ideas on how to do this?