You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
This is the first installment in a series of posts about Access 2007 originally made by one of our developers on the Access team on his own blog that I'm moving here for the broader audience to enjoy.
Up until this point, Access has supported command buttons with text or a picture, but never both at the same time. This has been a long standing request from users: the capability of showing both the caption and the picture. In Access 2007, you will notice a new property off of the command button called "Picture Caption Arrangement".
This property, which can be set to the following values:
You will also notice that there is a new "Alignment" property. This property allows you to position the caption and picture within the command button to the following settings (note this property can be used whether you have just a picture, just a caption, or both):
With these two new properties (which are of course also available through the OM), you will now be able to create some cool looking command buttons without any label trickery needed. Since you can now use JPEGs, PNGs and other newer image formats with Access 2007, you can create some really impressive buttons.
For example, in the snapshot below I created three buttons using Windows Vista backgrounds as the pictures. I changed the buttons' back style to transparent and played with the alignment and picture caption alignment settings:
Comments: (9) Collapse
Can one of you guys do a white paper or start a thread on minimizing the ribbon. I am not talking about the "startfromscratch" which only hides the ribbon if the ribbon is empty. We have a Ribbon custom to our app, that always shows Maximized by default and it totally messes up the screen which is designed of 1024x768 - users are missing part of the screen because the Ribbon moves the screen down and thus off the visible area unless the ribbon is in a minimized state On Application started we want to set an application option to minimize the ribbon. I do not find any documentation anyplace on doing this except on VSTO site where they are using office.commandbars to determine the height of the ribbon and then based upon the height, they are minimizing it. That code example doesn't work for Access from what I understand cause there is no VSTO add-in for Access 2007 I am looking for something such as: Application.CommandBars.minimized = true Or the equivilent code to accomplish the same thing so that upon application startup, we can set the initial state of the ribbon.
Third of Five's blog was a right gem. I wonder what he's doing now...
David: Yeah, it would be good to do that. Unfortunately there is no good programmatic way to collapse the ribbon. I wish we had this. The way customers mock it up today is by using sendkeys. Grovelli: He's gone over to work on one of the Exchange teams, a great guy, and we're really going to miss him around here.
The problem is you cant just issue sendkeys ^F1 without checking to see if the ribbon is already minimized or not. If you use sendkeys and its minimized, then it just maximizes it and thats defeating the purpose Have to check for the state of the ribbon before you can issue sendkeys. thanks to VSTO people. I was able to get resolution. Heres the code for those that might have need for it If Me.Application.CommandBars.Item("Ribbon").Height = 150 Then SendKeys "^{F1}", False
End If Biggest problem was finding the documentation on what the Item Name was in the collection. Access 2007 is seriously lacking in documentation. Hopefully you guys will not only provide a better way to minimize the ribbon then sendkeys but also work on documenting these things. Even those at utter access couldn't figure this one out and had to have someone at VSTO msdn web site document it
Thanks for the feedback on this David. The Access team doesn't actually have the ability to make any changes here, but I'll pass your comments on to the shared Office team who is responsible for the ribbon in all apps.
Hello! Good Site! Thanks you! jrynryikys
"Even those at utter access couldn't figure this one out" Actually I think we pointed you on the track you ended up using: www.utteraccess.com/.../showflat.php
The point made at utteraccess didn't resolve the issue. sendkeys was not ever a question or issue for resolution. The problem posed was how to obtain the ribbon height because issuing sendkeys without knowing the ribbon is pointless. I already knew I could use sendkeys 50% of the time. (binary is not monocular)
Also, didnt you recommend at Utter Access to use "StartFromScratch" which as pointed out in that blog will not work, and is nothing related to what I ended up using. Read above posts so you can see the code example I provide. This has nothing to do with startfromscratch
Comments: (loading) Collapse