table code

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

Guest

Hi
Can I write code on close of table like a form .
if so where ?
What I would like to do is when a table has been updated to automatically
append some fields of new records to another table.
I know i could use append query but need to run automatically when table is
closed
Thanks
Tina
 
Tina,

No you can't, no events for tables. Tables are only meant for storage,
not for data entry or edits. Users should interface with data through
forms, action queries, VB code amnipulating data or importing it etc,
and this is how you automate anything you need to. If you provide
details of what you are trying to do, you might get a good idea or two,
on how to do it.

HTH,
Nikos
 
What kind of tables are you using Access mdb or SQL Server? If you are using
SQL server, you could write a stored procedure to do this. There are not
really stored procedures in Access. How are you opening the table? If it is
in a form, then you could put your code in the After Update event of the form.
 
Hi
Can I write code on close of table like a form .
if so where ?
What I would like to do is when a table has been updated to automatically
append some fields of new records to another table.
I know i could use append query but need to run automatically when table is
closed
Thanks
Tina
Click to expand...

AFAIK you can't. The thing to do would be to create a Datasheet form so it
would look like a table but has events like a form.

HTH,
RD
 
Back
Top