it sounds like you are using macros instead of VB. it would be better to convert your macros to VB to make the db run better and faster. do this and then in the click event of the button after you run the append then set the enabled property of the button to no. but remember to set the button to back to enabled at some point or it will not be active next time you need it....
On 1/25/06, rokkeee <[EMAIL PROTECTED]> wrote: > > I have a "Save All" button on a form that when clicked will run a > macro containing two append queries. I'd like to disable that button > after it's clicked once. How can I do that? > > Thanks, > Doreen > > > > > ------------------------------ > YAHOO! GROUPS LINKS > > > - Visit your group "ms_access<http://groups.yahoo.com/group/ms_access>" > on the web. > > - To unsubscribe from this group, send an email to: > [EMAIL PROTECTED]<[EMAIL PROTECTED]> > > - Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service <http://docs.yahoo.com/info/terms/>. > > > ------------------------------ > [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
