how 2 get a form to delete itself

[Jeff Clark]

can you tell me?

thanks

 

[John Vinson]

can you tell me?

thanks

You can't. If there is code on the form, deleting the form would
delete the code while it is executing.

Could you explain what you are trying to accomplish? Deleting a Form
would be a design-mode operation and certainly should not happen
routinely!

 

[Jeff Clark]

yes, i use a form that has a text box and a button.

Enter a tablename in the textbox and Acces goes out to a remotes SQL Server
and downloads the table. When we are through downloading, I don't want the
form lying around for the users to whom I give the Acces database.

This method allows me to easily download many tables into many databases.

 

[Rick Brandt]

yes, i use a form that has a text box and a button.

Enter a tablename in the textbox and Acces goes out to a remotes SQL Server
and downloads the table. When we are through downloading, I don't want the
form lying around for the users to whom I give the Acces database.

This method allows me to easily download many tables into many databases.

But how unintelligent are your users? All they have to do is make copies of
your Access file *before* they use it and they will be able to download as many
tables as they want.

 

[Cheryl Fischer]

In your SQL Server, you might want to investigate using the Wizard that
creates DTS Packages/Transformations. One of the options allows for the
creation of Access tables, IIRC.

 

[Jeff Clark]

Yes, thanks

In your SQL Server, you might want to investigate using the Wizard that
creates DTS Packages/Transformations. One of the options allows for the
creation of Access tables, IIRC.