A
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
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