 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / July 2005Modify Access menu commands when no database running.
Is it possible to override menu functions with custom codes when there is no database loaded in the Access window? Sorry, to add: Specifically, I want to override the 'New..' menu item. In Word / Excel / Powerpoint, it is a simple case of having autoexec run in the default template. But I cannot find a similar way of doing it in Access. Many Thanks > Is it possible to override menu functions with custom codes when there is no > database loaded in the Access window? I do not believe so, but why do you want to prevent users from creating a NEW database. > Sorry, to add: > [quoted text clipped - 6 lines] >>Is it possible to override menu functions with custom codes when there is no >>database loaded in the Access window? Rather than preventing the user from creating a new database, I need to run a routine that formats the new database's filename to a certain format. When my db that contains the code is open and I go File->New..., it correctly creates a new database with the right name, but I do not know how to get the code to run outside of the test database. > I do not believe so, but why do you want to prevent users from creating > a NEW database. [quoted text clipped - 9 lines] > >>Is it possible to override menu functions with custom codes when there is no > >>database loaded in the Access window? Why do you need the DB name to follow a certain format? > Rather than preventing the user from creating a new database, I need to run a > routine that formats the new database's filename to a certain format. When [quoted text clipped - 15 lines] >>>>Is it possible to override menu functions with custom codes when there is no >>>>database loaded in the Access window? A new requirement at work requires all documents to follow a certain naming convention and because we use an NT4 domain, we are unable to use document management software. I have a dialogue box comes up asking for the subject, then it formulates the filename based on that. I have sorted out Word / Excel / Powerpoint, just Access giving me headaches. Thanks for the help. Thhhppptt! to the person who made that decision. Anyway, I do not believe that it is possible to do that within Access. > A new requirement at work requires all documents to follow a certain naming > convention and because we use an NT4 domain, we are unable to use document [quoted text clipped - 5 lines] > > Thanks for the help. Thanks David, I was thinking that, but hoping otherwise... Oh well, guess the users will have to remember the name format themselves. Jason > Thhhppptt! to the person who made that decision. Anyway, I do not > believe that it is possible to do that within Access. [quoted text clipped - 8 lines] > > > > Thanks for the help. Actually, I take that back. It *MIGHT* be possible if you were to create some sort of solution using VB that invokes the Access Object Model to create a new database. At that point, you have the ability to control how the database is named, however the users would still have the ability to change the name *AND* they would still be able to create a new DB directly in Access that bypasses the naming schema. > A new requirement at work requires all documents to follow a certain naming > convention and because we use an NT4 domain, we are unable to use document [quoted text clipped - 5 lines] > > Thanks for the help. And for that matter... As a developer I would wash my hands of the whole thing and communicate the new (however stupid) standard it is to the end users leaving up to them to comply. In the end, they can still rename the files (Access/Word/Excel/PowerPoint) or do a Save As... or Copy and trying to fight that would be a waste of time. I would leave any noncompliance issues up to the compliance police and the end user. David H (Final post and I promise to think before I hit SEND) > Actually, I take that back. It *MIGHT* be possible if you were to create > some sort of solution using VB that invokes the Access Object Model to [quoted text clipped - 11 lines] >> / Powerpoint, just Access giving me headaches. >> Thanks for the help. The Access Runtime Version is a version that does not include any design capabilities (think MS PowerPoint Viewer). I am not that familar with it nor Developer's Version of Access - which I believe you'll need to in order to deploy it. I did find this article which should get you started. http://msdn.microsoft.com/library/?url=/library/en-us/dnsmart03/html/sa03j8.asp? frame=true > Sorry, to add: > [quoted text clipped - 6 lines] >>Is it possible to override menu functions with custom codes when there is no >>database loaded in the Access window? The Access Runtime Version is a version that does not include any design capabilities (think MS PowerPoint Viewer). I am not that familar with it nor Developer's Version of Access - which I believe you'll need to in order to deploy it. I did find these articles which should get you started. http://msdn.microsoft.com/office/technologyinfo/devtools/accessextensions/defaul t.aspx http://msdn.microsoft.com/library/?url=/library/en-us/dnsmart03/html/sa03j8.asp? frame=true > Sorry, to add: > [quoted text clipped - 6 lines] >>Is it possible to override menu functions with custom codes when there is no >>database loaded in the Access window? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.