how 2 get a form to delete itself

  • Thread starter Thread starter Jeff Clark
  • Start date Start date
can you tell me?

thanks
Click to expand...

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!
 
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.
 
Jeff Clark said:
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.
Click to expand...

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.
 
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.
 
Yes, thanks
Cheryl Fischer said:
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.
Click to expand...
 
Back
Top