Janet Erbach
jerbach at gmail.com
Tue Mar 29 13:31:28 CDT 2011
Jim - You're right about 'F11'. I use that all the time. I'll try you're suggestion about the autoexec...thank you! Janet On Mon, Mar 28, 2011 at 6:18 PM, Jim Lawrence <accessd at shaw.ca> wrote: > Hi Janet: > > Without knowing more I would suspect that the main database window has its > x > and/or y coordinates set off the main viewing area. It is really there just > not visible. > > If you can get to create and edit a form then you also have access to the > other database objects by creating a event. Once event has been initiated > within the form, you are creating, you can then go and edit that event. > This > will expose all the other object in the MDB. (Do not quote me on this but > there is some old memory that says by pressing <F11> it will bring the main > database window into view.) > > Another thing you can do is check out what the macro autoexec does. Just go > and select the event section, in the form you have created but this time > instead of selecting an event select a macro and pick the "autoexec" macro. > Then go in and see if it is making some interest calls...turn them off if > need be. (Make sure all the tool bars are displayed etc...) > > PS: Make sure you have a backup of the anything you change. > > HTH > Jim > > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Janet Erbach > Sent: Monday, March 28, 2011 2:11 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] 'Hidden' form question & Excel 2010 question > > Jim - > > I've checked everything you mentioned - the form doesn't appear when I > display hidden and system objects, and there are no macros at all in this > 'holding tank' database. (The database is just a storage place; I use it > as a central holding point for all my custom objects and don't run any > active apps from within it.) It's as if the form falls off the face of > Access before it makes it into the database. Could this be a corruption > issue perhaps? I never thought of that until now... > > Janet > > On Mon, Mar 28, 2011 at 11:04 AM, Jim Lawrence <accessd at shaw.ca> wrote: > > > Hi Janet: > > > > If the tables are within the application they must be hidden as a > different > > named object. Check to see if all objects are being displayed (tools > > > options > view). > > > > Another trick is the move the database so far off the viewing area that > it > > is no longer visible...check as far right as possible. You can try and > > force > > the database to expose itself by attempting to link to it by running the > > link-manager etc... > > > > Check to see if there is an autoexec macro that does obscuring when the > DB > > is opened and then the Unhide command is turned off or the windows > display > > can be turned off via a API call...Anything can be done once a autoexec > > macro is run. > > > > Go into Tools > startup and make sure the option "Display Database > window" > > is checked. > > > > It is most likely one of these tricks to hide or obscure the database as > > getting too fancy with renaming can crash the system. > > > > One thing to check is if the Disable Shift Key option have been invoked > so > > just holding down the shift key when opening the DB will not allow you to > > gain access to the DB before the autoexec macro is run. There are a > number > > of little apps out there that can toggle this feature off and on. > > > > This of course is just the tip of the proverbial iceberg as there can be > > all > > sorts of protection schemes within the code to monitor changes in an > > objects > > properties. Some developers spend almost as long writing protection as > > writing the app and it can take even an experienced programmer a couple > of > > hours to remove. > > > > HTH > > > > Jim > > > > > > -----Original Message----- > > From: accessd-bounces at databaseadvisors.com > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Janet Erbach > > Sent: Monday, March 28, 2011 8:12 AM > > To: Access Developers discussion and problem solving > > Subject: [AccessD] 'Hidden' form question & Excel 2010 question > > > > Hello - > > > > I have 2 questions for you all. > > > > 1) We use a pre-packaged access application for order processing: I've > > created a number of custom forms and modules that I export to a > > 'customizations' data base and import into the main app whenever I > install > > it to a new machine. I have one form that seems to export successfully - > I > > get no error messages, anyway - but when I open up my 'customizations' > data > > base it can't be found. I've checked to see if it was somehow set to be > > hidden, and that's not the case either. I tried exporting it to a > > temporary > > data base, and it appeared there just fine. But I need it to go into > this > > 'customizations' data base, and it just won't go! What could be causing > > this? > > > > > > 2) Do any of you have any experience writing VB code for Excel 2010? A > > tech temp agency in our area is looking for someone with that kind of > > experience for a specific project; if any of you are game for that type > of > > thing, please let me know. > > > > Thank you! > > > > Janet Erbach > > IT/Office Manager > > Natural Healthy Concepts > > www.naturalhealthyconcepts.com > > 920.886.7500 * 866.505.7501 > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >