[AccessD] 'Hidden' form question & Excel 2010 question

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
>



More information about the AccessD mailing list