Can I disable the X Close button in the database window? Jeff Stroope 6/7/2007 7:23:01 PM Hi, I have a report in an Access database that takes a couple of minutes to run. I added a status bar showing the report progress based on the number of records in the data source, but the users freak out and hit the X Close button on the database window because they think it's hung up. Is there any way to disable that button and still show the status bar? -- Thanks, Jeff

Re: Can I disable the X Close button in the database window? "biganthony via AccessMonster.com" <u31673[ at ]uwe> 6/10/2007 7:35:50 AM Jeff, Would this be any use? http://www.mvps.org/access/general/gen0005.htm Anthony Jeff Stroope wrote: [Quoted Text] >Hi, > >I have a report in an Access database that takes a couple of minutes to run. > I added a status bar showing the report progress based on the number of >records in the data source, but the users freak out and hit the X Close >button on the database window because they think it's hung up. Is there any >way to disable that button and still show the status bar? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-multiuser/200706/1

Re: Can I disable the X Close button in the database window? Jeff Stroope 6/11/2007 3:38:02 PM Hi Anthony. Yeah, I tried this one and it works...for a while. I used it because I have one report that takes a long time to run. I've provided a status bar and hourglass, but the user gets nervous and x's out of the application while the report is running and it corrupts the database. With the fix below implemented, the x-close is disabled until you click 3 times on it. At that moment the x button on my report form (which was disabled) lights up and so does the Access x-close button. Next the Windows error pops up that I'm trying to end a non-responsive application with yes/no buttons. If you have a solution for this, I'd appreciate it. I'd like to make the whole Access application container window disappear and just see the forms, but there doesn't seem to be any way to do it. -- Thanks, Jeff "biganthony via AccessMonster.com" wrote: [Quoted Text] > Jeff, > > Would this be any use? http://www.mvps.org/access/general/gen0005.htm > > Anthony > > > > Jeff Stroope wrote: > >Hi, > > > >I have a report in an Access database that takes a couple of minutes to run. > > I added a status bar showing the report progress based on the number of > >records in the data source, but the users freak out and hit the X Close > >button on the database window because they think it's hung up. Is there any > >way to disable that button and still show the status bar? > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-multiuser/200706/1 > >

Re: Can I disable the X Close button in the database window? "Tony Toews [MVP]" <ttoews[ at ]telusplanet.net> 6/11/2007 7:30:51 PM Jeff Stroope <JeffStroope[ at ]discussions.microsoft.com> wrote: [Quoted Text] >Hi Anthony. Yeah, I tried this one and it works...for a while. I used it >because I have one report that takes a long time to run. I've provided a >status bar and hourglass, but the user gets nervous and x's out of the >application while the report is running and it corrupts the database. Corrupts the database? The FE or the BE? >I'd like to make the >whole Access application container window disappear and just see the forms, >but there doesn't seem to be any way to do it. I'd check at www.lebans.com. I don't know if he has such a solution though. Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Re: Can I disable the X Close button in the database window? Jeff Stroope 6/11/2007 7:52:01 PM Hi Tony, Well, I didn't have the database split when the user x'd out. I've since split it. It's on a Citrix network shared folder. I haven't been able to save the FE into a .mde yet because we are upgrading to newer Citrix servers and have MS Office version mixing right now until all sites are upgraded. Some users are running Access 2002 and some 2003. I'll check the link you provided below. -- Thanks, Jeff "Tony Toews [MVP]" wrote: [Quoted Text] > Jeff Stroope <JeffStroope[ at ]discussions.microsoft.com> wrote: > > >Hi Anthony. Yeah, I tried this one and it works...for a while. I used it > >because I have one report that takes a long time to run. I've provided a > >status bar and hourglass, but the user gets nervous and x's out of the > >application while the report is running and it corrupts the database. > > Corrupts the database? The FE or the BE? > > >I'd like to make the > >whole Access application container window disappear and just see the forms, > >but there doesn't seem to be any way to do it. > > I'd check at www.lebans.com. I don't know if he has such a solution > though. > > Tony > -- > Tony Toews, Microsoft Access MVP > Please respond only in the newsgroups so that others can > read the entire thread of messages. > Microsoft Access Links, Hints, Tips & Accounting Systems at > http://www.granite.ab.ca/accsmstr.htm > Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ >

Re: Can I disable the X Close button in the database window? "Tony Toews [MVP]" <ttoews[ at ]telusplanet.net> 6/12/2007 4:57:02 AM Jeff Stroope <JeffStroope[ at ]discussions.microsoft.com> wrote: [Quoted Text] >Well, I didn't have the database split when the user x'd out. Ah, interesting. > I've since split it. It's on a Citrix network shared folder. Have you given each user thier own copy? I specifically created the Auto FE Updater utility so that I could make changes to the FE MDE as often as I wanted and be quite confident that the next time someone went to run the app that it would pull in the latest version. For more info on the errors or the Auto FE Updater utility see the free Auto FE Updater utility at http://www.granite.ab.ca/access/autofe.htm at my website to keep the FE on each PC up to date. In a Terminal Server or Citrix environment the Auto FE Updater now supports creating a directory named after the user on a server. Given a choice put the FE on the Citrix server to reduce network traffic and to avoid having to load objects over the network which can be somewhat sluggish. > I haven't been able to >save the FE into a .mde yet because we are upgrading to newer Citrix servers >and have MS Office version mixing right now until all sites are upgraded. >Some users are running Access 2002 and some 2003. A2003 will happily run MDEs created in A2002 and A2000. Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Re: Can I disable the X Close button in the database window? Jeff Stroope 6/12/2007 3:34:00 PM Thanks Tony. -- Thanks, Jeff "Tony Toews [MVP]" wrote: [Quoted Text] > Jeff Stroope <JeffStroope[ at ]discussions.microsoft.com> wrote: > > >Well, I didn't have the database split when the user x'd out. > > Ah, interesting. > > > I've since split it. It's on a Citrix network shared folder. > > Have you given each user thier own copy? > > I specifically created the Auto FE Updater utility so that I could > make changes to the FE MDE as often as I wanted and be quite confident > that the next time someone went to run the app that it would pull in > the latest version. For more info on the errors or the Auto FE > Updater utility see the free Auto FE Updater utility at > http://www.granite.ab.ca/access/autofe.htm at my website to keep the > FE on each PC up to date. > > In a Terminal Server or Citrix environment the Auto FE Updater now > supports creating a directory named after the user on a server. Given > a choice put the FE on the Citrix server to reduce network traffic and > to avoid having to load objects over the network which can be somewhat > sluggish. > > > I haven't been able to > >save the FE into a .mde yet because we are upgrading to newer Citrix servers > >and have MS Office version mixing right now until all sites are upgraded. > >Some users are running Access 2002 and some 2003. > > A2003 will happily run MDEs created in A2002 and A2000. > > Tony > -- > Tony Toews, Microsoft Access MVP > Please respond only in the newsgroups so that others can > read the entire thread of messages. > Microsoft Access Links, Hints, Tips & Accounting Systems at > http://www.granite.ab.ca/accsmstr.htm > Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ >

Re: Can I disable the X Close button in the database window? "Tony Toews [MVP]" <ttoews[ at ]telusplanet.net> 6/26/2007 6:21:13 PM "Tom Wussernark [MSFT]" <tw[ at ]microsoft.com> wrote: [Quoted Text] >yeah use ADP and don't make your users wait 2 minutes > >seriously-- even Microsoft admits that ADP is better performance than MDB >for all situations Note that this person is really A a r o n K e m p f and that he is not an employee of Microsoft. Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Re: Can I disable the X Close button in the database window? "Keith Wilby" <here[ at ]there.com> 6/27/2007 8:26:33 AM "Tom Wussernark [MSFT]" <tw[ at ]microsoft.com> wrote in message news:eQb7Dg9tHHA.4612[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > > I mean duh > Yes. Yes, you do.