Get the data from a single cell in table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
What do I have to write in my VBA code to get the data from a single cell in
MS Access table. I mean the field which is formed when crossing a column and
a record. I don't know the term for these cells used in Visual Basic.
If someone knows please tell me.
Thank you in advance.
 
Hi,
this works! But I have another problem. I want something to tells me when a
cell is changed and to get the number of the record of the changed cell. Is
this possible and how? If it's not possible how can I create procedures which
runs when I open the .mdb file and when I close the file. It will helps me if
the procedures are about opening and closing a table.
 
How is the cell being changed? Do users have direct access to the table, or
do they change entries through a form linked to the table? Let me know and
I'll try and answer your question.

To run a procedure when the database opens, the easiest way is to create a
form which launches at start-uo (click on Tools - Startup and select your new
form in the drop-down box), then add your procedure to the forms 'On Load'
event.
 
ok, my purpose is: users change entries directly from the table. The previous
cell (the cell is already changed) have to append to a file. That is why I
make an array which consists all entries of a column (the table has no more
than 10 records). This array must be created at every opening of the .mdb
file or the table. I have to find out the ID of the changed cell, to know
which element of the array to append to the file. The other way is to run a
procedure when the table closes which will create another array with the
present state of the column and then I'll compare both arrays.
 
Back
Top