VBA, Self delete

Self delete

Author	Message
John H #1 / 5	Self delete Hi, The question sounds weird but I really need some advise on this. User has requested a module to calculate a time taken to prepare some computer board. What I'm trying to do is that when user clicks a Calculate button on my main form, it will close the main form first, then delete the main form from the .mdb follow by running a procedure (on the module), and last close the database. Any guides? Thanks, John
Mon, 01 Mar 2004 12:56:02 GMT

michk #2 / 5	Self delete Well, first I would go to http://doityourself.com/tools/toolhammer.htm and purchase a tack hammer. So you can instruct the person who wants that sort of self-modifying code to hit themselves in the head until they are thinking sensibly? why on earth do you want a form that deletes itself??? -- MichKa Michael Kaplan (principal developer of the MSLU) Trigeminal Software, Inc. -- http://www.trigeminal.com/ the book -- http://www.i18nWithVB.com/ Quote: > Hi, > The question sounds weird but I really need some advise on > this. > User has requested a module to calculate a time taken to > prepare some computer board. > What I'm trying to do is that when user clicks a Calculate > button on my main form, it will close the main form first, > then delete the main form from the .mdb follow by running > a procedure (on the module), and last close the database. > Any guides? > Thanks, > John
Mon, 01 Mar 2004 13:11:40 GMT

John #3 / 5	Self delete The form itself acts like a security plug. If anything does happen, user just need to pull the plug. The form is needed only once. Quote: >-----Original Message----- >Well, first I would go to >http://doityourself.com/tools/toolhammer.htm >and purchase a tack hammer. So you can instruct the person who wants that Quote: >sort of self-modifying code to hit themselves in the head until they are >thinking sensibly? >why on earth do you want a form that deletes itself??? >-- >MichKa >Michael Kaplan >(principal developer of the MSLU) >Trigeminal Software, Inc. -- http://www.trigeminal.com/ >the book -- http://www.i18nWithVB.com/ >> Hi, >> The question sounds weird but I really need some advise on >> this. >> User has requested a module to calculate a time taken to >> prepare some computer board. >> What I'm trying to do is that when user clicks a Calculate >> button on my main form, it will close the main form first, >> then delete the main form from the .mdb follow by running >> a procedure (on the module), and last close the database. >> Any guides? >> Thanks, >> John >.
Mon, 01 Mar 2004 15:54:25 GMT

michk #4 / 5	Self delete Well, you cannot delete a form is it is currently on the call stack. You need away to let your program ro on and delete the form at some other point. And you should also realize that homegrown security has only one characteristic: it is even weaker than Jet's built-in security. -- MichKa Michael Kaplan (principal developer of the MSLU) Trigeminal Software, Inc. -- http://www.trigeminal.com/ the book -- http://www.i18nWithVB.com/ Quote: > The form itself acts like a security plug. If anything > does happen, user just need to pull the plug. The form is > needed only once. > >-----Original Message----- > >Well, first I would go to > >http://doityourself.com/tools/toolhammer.htm > >and purchase a tack hammer. So you can instruct the > person who wants that > >sort of self-modifying code to hit themselves in the head > until they are > >thinking sensibly? > >why on earth do you want a form that deletes itself??? > >-- > >MichKa > >Michael Kaplan > >(principal developer of the MSLU) > >Trigeminal Software, Inc. -- http://www.trigeminal.com/ > >the book -- http://www.i18nWithVB.com/ > >> Hi, > >> The question sounds weird but I really need some advise > on > >> this. > >> User has requested a module to calculate a time taken to > >> prepare some computer board. > >> What I'm trying to do is that when user clicks a > Calculate > >> button on my main form, it will close the main form > first, > >> then delete the main form from the .mdb follow by > running > >> a procedure (on the module), and last close the > database. > >> Any guides? > >> Thanks, > >> John > >.
Mon, 01 Mar 2004 20:29:44 GMT

Dev Ashis #5 / 5	Self delete Quote: > The form itself acts like a security plug. If anything > does happen, user just need to pull the plug. The form is > needed only once. Instead of deleting the form, include a checkbox "Display on next startup". As an example, see the wz_frmExplainWiz form in the following wizard. [ http://www.mvps.org/access/modules/mdl0032.htm ] -- Dev
Mon, 01 Mar 2004 20:32:55 GMT

Page 1 of 1

[ 5 post ]