get text box contents from table cell

[Arne]

Hello,

I am trying to make a small Access-application for the following problem. I
work for a company that produces powder which is stored in silos (4) by the
operators processing. Every hour or so a sample is taken and analysed. This
information can be useful to the operators of the packaging department if
only they knew where the powder with these properties is located in the
silos. I have some VBA-experience with Excel, and currently there is a shared
Excel workbook running that shows a visualisation of the silos with 10
accesible cells, one for each 10% of powder level in each silo. These cells
are not directly accessible, but the can be filled in by the operators
processing via macros, and deleted by the operators packaging also via
macros. Unfortunately, the solution of a shered workbook regularly leads to
data loss and other nuisances and I am told that Access is a better tool for
this sort of work. Unfortunately I have no Access-experience whatsoever, and
the help functions and user guide do not answer my question (at least, I
cannot find the answers there).

Now the question: I want to store the current contents of the silos in four
tables with the following three columns: silo level (each table has 10 rows),
mineral content and moisture. On a form I have visualised the silos and on
each I have placed 10 text boxes. The contents of the text boxes has to be
linked to the contents of the four status tables. How do I link the contents
of a text box to a certain cell of a table?


Regards,

Arne

 

[Tom van Stiphout]

On Mon, 15 Sep 2008 03:28:01 -0700, Arne

Four tables? That's where you go wrong. Access is not Excel. What is
appropriate to do on four worksheets is not appropriate to do with
four tables. More than likely this can be done with a single table
with an extra SiloID field that is a foreign key from the tblSilos
table.
Also having 10 fields for each 10% is a violation of an important
database design rule that says "no repeating groups".
It may be best to get some professional help setting up this project.
"Microsoft Solution Provider" in your yellow pages is a good place to
start. Once a proper foundation is created, you may be able to take it
the rest of the way.

-Tom.
Microsoft Access MVP