I dont know what you mean "does it work the same way..." but the code to disable the button is
me.commandbuttonnamehere.enabled= false and to re-enable is me.commandbuttonnamehere.enabled= True Todd On 1/25/06, rokkeee <[EMAIL PROTECTED]> wrote: > > Thanks Todd! > Yes, that's what I would like to do, but don't know the "code > specifics"...although I'm working on learning it! Can you help me? > By the way, after converting the macro to code, does it still work > the same way? > > > --- In [email protected], Todd Hannemann <[EMAIL PROTECTED]> > wrote: > > > > 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]<ms_access- > [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] > > > > > > > > > > SPONSORED LINKS > Microsoft access > database<http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+database&w1=Microsoft+access+database&w2=Database+development+software&w3=Database+management+software&w4=Database+software&w5=Inventory+database+software&w6=Membership+database+software&c=6&s=190&.sig=hc7Za8QzEj1t7F8GW0yzhA> > Database > development > software<http://groups.yahoo.com/gads?t=ms&k=Database+development+software&w1=Microsoft+access+database&w2=Database+development+software&w3=Database+management+software&w4=Database+software&w5=Inventory+database+software&w6=Membership+database+software&c=6&s=190&.sig=i5H8GCn7HzmglwpvhJg19w> > Database > management > software<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Microsoft+access+database&w2=Database+development+software&w3=Database+management+software&w4=Database+software&w5=Inventory+database+software&w6=Membership+database+software&c=6&s=190&.sig=kzlRmjQuUTEFLTjkEd6-kg> > Database > software<http://groups.yahoo.com/gads?t=ms&k=Database+software&w1=Microsoft+access+database&w2=Database+development+software&w3=Database+management+software&w4=Database+software&w5=Inventory+database+software&w6=Membership+database+software&c=6&s=190&.sig=CoCmr_EubT5Xd83NiQjcpg> > Inventory > database > software<http://groups.yahoo.com/gads?t=ms&k=Inventory+database+software&w1=Microsoft+access+database&w2=Database+development+software&w3=Database+management+software&w4=Database+software&w5=Inventory+database+software&w6=Membership+database+software&c=6&s=190&.sig=DHnS8Uu1ImyGVg1J4k0BMw> > Membership > database > software<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Microsoft+access+database&w2=Database+development+software&w3=Database+management+software&w4=Database+software&w5=Inventory+database+software&w6=Membership+database+software&c=6&s=190&.sig=uEGHlFpqbscHu8mCHe7tzg> > ------------------------------ > 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/
