ACCESS FEED: Re: [MS_AccessPros] Properties setter for ACCDB/ACCDE/MDB/MDE

Hi Bill,

you're welcome ;) happy to help

I should have figured you would set properties, what was I thinking?!?

I am glad it works -- now we know how to get around the 2010 compatibility issues ;)

Warm Regards,
Crystal

*
   (: have an awesome day :)
*

________________________________
From: Bill Mosca

Crystal

You don't have to set any properties. When the ACCDE opens the first time after it is created, the startup form's Load event sets everything. So in essence, all that you set was changed to the way I want it in the first place. But thanks anyway. :O)

I have uploaded the 2007 version to my website.

Bill

--- Crystal <strive4peace> wrote:
>
> you're welcome, Bill :) Your Properties Setter is such a great tool, I don't want anyone to go a day without it!
>
> here is a list of what I set (to the best of my recollection):
>
> Options:
> ApplicationTitle
> DisplayForm
> OverlappingWindows
>
> I did NOT clear Use Access Special Keys ... I can if you want me to
>
> Cleared -- DisplayNavigationPane
> ShortcutMenuBar --> scutIronRptComments (I guessed on this since you had it in there)
>
> clear --> AllowFullMenus
> clear --> AllowDefaultShortcutMenus
>
> frmSetPropMain:
> MenuBar --> mnuBlank
>
>
> Warm Regards,
> Crystal
>
> *
>    (: have an awesome day :)
> *
>
>
> ________________________________
> From: Bill Mosca <wrmosca@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Friday, January 27, 2012 11:56 AM
> Subject: Re: [MS_AccessPros] Properties setter for ACCDB/ACCDE/MDB/MDE
>
> Thanks a bunch, Crystal.
>
> Bill
>
> --- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@> wrote:
> >
> > Hi Bill,
> >
> > got it! Uploaded a replacement accde (and tested it too -- works GREAT!). Also turned off everything in the options, including AutoCorrect, and added an Application Title. Let me know what else you want me to change.
> >
> > Warm Regards,
> > Crystal
> >
> > *
> >    (: have an awesome day :)
> > *
> >
> >
> >
> > ________________________________
> > From: Bill Mosca
> >
> > Crystal
> >
> > I've uploaded a database called mnuBlank_Sample.zip. Download it and import the menubar into the 2007 DB. To do that (in case others don't know how) click on Get External Data just like you would import any object. pick mnuBlank.mdb and when the objects box opens click on Options. That expands the objects box so you can see other things to import besides the usual things. Select menus and toolbars.
> >
> > Bill
> >
> > --- Crystal <strive4peace> wrote:
> > >
> > > Hi Bill,
> > >
> > > I removed reference to menu bar and uploaded the 2007 opensource version to tiles, Utilities
> > >
> > > I will be happy to get the menu bar ... but I don't know how -- thought it used to be a macro but I don't see it. It is not listed in the Import dialog box I have your opensource mdb. I can't open the 2010 version with 2007.
> > >
> > > If you can export what the menu barneeds to a file, or tell me how to see it, I will be happy to put it in before I made an ACCDE for you
> > >
> > >
> > > Warm Regards,
> > > Crystal
> > >
> > > *
> > >    (: have an awesome day :)
> > > *
> > >
> > >
> > >
> > > ________________________________
> > > From: Bill Mosca
> > >
> > > Hi Crystal
> > >
> > > That's good news. Many thanks for your help in this.
> > >
> > > mnuBlank is a blank menubar. You could try importing it from the old 2000 version. If not, just remove the reference to in in the startup form's Menu Property. There is really no need to have it with the open source version. I only needed it for the ACCDE to get rid of the File tab.
> > >
> > > The db properties are set up in the Load event. When making an ACCDE you have to make it then open the ACCDE. That sets the properties. From then on the ACCDE will open as it should, hiding the Nav pane, ribbon, context menus, etc.
> > >
> > > I'd rather not make any changes to the design. That way all versions are the same.
> > >
> > > Bill
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@> wrote:
> > > >
> > > > Hi Bill,
> > > >
> > > > it opens, yay!
> > > >
> > > > missing object: mnuBlank
> > > > if you did export it, then it has issues. I am not sure if SaveTofile still works with 2010. I tested it in the beta and it did not. I wrote a program a long time ago to store the main form and control properties so a new form could be created from them. If mnuBlank is a complicated form, I can try to find it. With all the 2010 backward issues, I need to find it sometime anyway!
> > > >
> > > > you might want to name your
> > > > startup form (frmSetPropMain) with MENU in the name so other people know which one it is. I always use UPPERCASE for main
> > > > forms, or at least part of the name, so they are easy to spot.
> > > >
> > > >
> > > > Define database properties on the form Open event of your menu so that if objects are imported, like they just were, the properties get set up ;) I have a module to work with database properties, let me know if you want me to upload it. One of the procedures is to define properties for cases just like this ;)
> > > > was it ok to put your daughter and wife on this page:
> > > >
> > > > http://www.accessmvp.com/strive4peace/SummitPics.htm
> > > >
> > > >
> > > > I hope so. If not, I'll fix it
> > > >
> > > >
> > > > If so, can I label your daughter's name? Is it ok to leave Diane labeled?
> > > >
> > > >
> > > > Warm Regards,
> > > > Crystal
> > > >
> > > > *
> > > >    (: have an awesome day :)
> > > > *
> > > >
> > > >
> > > > ________________________________
> > > > From: Bill Mosca
> > > >
> > > > Crystal
> > > >
> > > > The 2007 version is uploaded to the Utilities section. Can you check to make
> > > > sure it opens in 2007?
> > > >
> > > > Thanks a bunch, Crystal.
> > > >
> > > > Regards,
> > > >
> > > > Bill
> > > >
> > > >
> > > >
> > > > From: Crystal
> > > >
> > > >
> > > > Hi Bill,
> > > >
> > > > I just uploaded an empty 2007 database toFiles >
> > > > 1_Samples
> > > > http://tech.groups.yahoo.com/group/MS_Access_Professionals/files/1_Samples/Acces
> > > > s2007_BlankDatabase_Jan2012.zip
> > > >
> > > >
> > > > Export everything your app needs. Do NOT compact/repair it with 2010. If you
> > > > want to zip it and send it to me, I will do that for you and create an MDE too
> > > > if you like -- best to not even open it, in my opinion, with 2010. I am running
> > > > 2007.
> > > >
> > > > Warm Regards,
> > > > Crystal
> > > >
> > > > *
> > > >    (: have an awesome day :)
> > > > *
> > > >
> > > > ________________________________
> > > > From: Bill Mosca
> > > >
> > > > I was sure I used the legacy General sort, but I'll check it again.
> > > >
> > > > Regards,
> > > >
> > > > Bill
> > > >
> > > > From: John Viescas
> > > >
> > > > Bill-
> > > >
> > > > Go back and reread the link you just put up:
> > > >
> > > > http://msdn.microsoft.com/en-us/office/cc907897.aspx
> > > >
> > > > If you create a database in 2010 with the default General sort order, you cannot
> > > > open it in 2007.
> > > >
> > > > John Viescas, author
> > > > Microsoft Office Access 2010 Inside Out
> > > > Microsoft Office Access 2007 Inside Out
> > > > Building Microsoft Access Applications
> > > > Microsoft Office Access 2003 Inside Out
> > > > SQL Queries for Mere Mortals
> > > > http://www.viescas.com/
> > > > (Lahaina, HI)
> > > >
> > > > -----Original Message-----
> > > > From: Bill Mosca
> > > >
> > > > Crystal
> > > >
> > > > Thanks for the kind words. Now I just have to figure out why Duane can't open it
> > > > in 2007.
> > > >
> > > > Regards,
> > > >
> > > > Bill
> > > >
> > > > From: Crystal
> > > >
> > > >
> > > > Hi Bill,
> > > >
> > > > wonderful news! Thank you. I modified my version of your properties setter,
> > > > but I do pass the link to others who are not as savvy ...
> > > >
> > > > For those of you who have not downloaded Bill's Property Setter, YOU ARE MISSING
> > > > OUT! This is a great tool and a "must" for every toolkit
> > > > Warm Regards,
> > > > Crystal
> > > >
> > > > Microsoft MVP
> > > > remote programming and training
> > > >
> > > > Access Basics by Crystal
> > > > http://www.AccessMVP.com/strive4peace
> > > > Free 100-page book that covers essentials in Access
> > > >
> > > > *
> > > > (: have an awesome day :)
> > > > *
> > > >
> > > > ________________________________
> > > > From: Bill
> > > > Subject: [MS_AccessPros] Properties setter for ACCDB/ACCDE/MDB/MDE
> > > >
> > > > Due to popular demand, I finally got it in gear and created an open-source
> > > > Properties Setter for 2007-2010 file versions as well as older versions.
> > > >
> > > > If you spot any bugs please let me know. I didn't do a thorough testing before
> > > > uploading it to our Files>Utilities folder.
> > > >
> > > > If I can do some more testing I'll see if it's ready for my website. Of course,
> > > > that stuff is not open-source. You guys are special.
> > > >
> > > > Regards,
> > > > Bill Mosca, Founder - MS_Access_Professionals
> > > > http://www.thatlldoit.com
> > > > Microsoft Office Access MVP
> > > > https://mvp.support.microsoft.com/profile/Bill.Mosca
> > > >
> >

[Non-text portions of this message have been removed]