delete database

[Guest]

how can I have an onform close event that will automatically delete three
different tables after the form closes and possibly delete another database.

 

[Guest]

Put the code you need in the Close event of the form.

 

[Guest]

LOL That's just it. I need the code I'm not sure how to write it. If I
had an example I can re-write it but don't know how to write from scratch.

 

[Van T. Dinh]

To delete the Table in the current database, use DeleteObject Method.

To delete another database, use the Kill Method to delete the MDB / MDE (I
guess you should use this *with caution*).

Check Access VB Help on the above methods.

 

[Guest]

Van is correct.

LOL That's just it. I need the code I'm not sure how to write it. If I
had an example I can re-write it but don't know how to write from scratch.