Custom Ribbon and Reports
I'm very new to Access 2007, and I'm trying to create a custom Ribbon.
Currently, I basically have the code for the sample in the USysRibbons table
<tab id="dbCustomTab" label="A Custom Tab" visible="true">
<group id="dbCustomGroup" label="Reports">
</c...Excel 2007 Ribbon Limitations
I have to admit when I first started using the ribbon I struggles with
it, but recognised it "should" make my life easier as it does put the
most frequent features first.
The problem is, Microsoft have removed half the functionality and made
just a pain in the butt
Simple things like removing a border format is now no longer a single
Even adding a left border is now two clicks, one to get a list of
border options from the Home-borders icon, the second to pick the left
border. So I added the left, right, top and bottom border command to
the Quick access toolbar so now at lea...No Ribbon
I am using office 2007 and in Outlook and Access I dont see the ribbon nor do
i have the Customize Quick Access Toolbar button. confused...
Word, Excel and others are good. please help me out.
by the way it displays the toolbars like standard, advanced, web and outlook
The Ribbon was not implemented in the main views of Outlook 2007. Open a
Contact Record. Do you see the Ribbon now?
"Yama" <Yama@discussions.microsoft.com> wrote in message
>I am using office 2007 and in Outlook an...IE8 and Chinese on screen keyboard
I have IE8 in Vista Home 64bit. I installed Chinese input language, on
screen keyboard didnt show up when I click it. I have no problem with IE7 or
Ne Ho Jay,
Is the keyboard input in your tasks list?
It may just be hidden behind the IE Window or you may be in Full Screen IE
mode (F11 to toggle).
"Jay/Dallas Texas" <Jay/Dallas Texas@discussions.microsoft.com> wrote in
> I have IE8 in Vista Home 64bit. I installed Chinese input language, on
> screen keyboard didn...Screen wrapping issue
On certain tabs within files with macros and protection, my cursor
wraps around the sheet. In other words, if it's in cell A1 and I hit
the left arrow, it moves to cell IV1 (in excel 2003). Is there a way
of turning this off? Thank you.
...Ribbon toggle button issues
I have two custom toggle buttons on the ribbon and they work sometimes but it
is very clunky. When I first open the file the ribbon works.
But it seems sometimes if I switch to another file and/or do some other
tasks, then go to use either toggle, I get "Object variable or with block
variable not set". If I close and reopen the ribbon file again it works again
--- for awhile.
The error is on this line: gRibbonUI1.InvalidateControl ("rxTB1")
I think the variable gRibbonUI1 which is set to "ribbon" is falling out of
scope (gRibbonUI1 is declared ...Program-Wide Web Font Problem?
I'm new to this Google Group but I've been finding lots of fixes here
and they're great. So, I ran into a weird problem that I thought I
might throw out to the group.
Here's my problem. If you go to CRM through the web client, and go to
a Contact, and then click Send Email there is a way that the app will
change your font style and size AUTOMATICALLY. I have tried this on
multiple computers (both servers and client machines) and the issue
exists on everyone I have tried.
If I could post a screenshot of the problem I would. But I'll give you
the next best thing. ...full screen
is there a way to get XL to start in full screen without having to use the
Application.WindowState = xlMaximized
"Tree*Rat" <firstname.lastname@example.org> wrote in message
> is there a way to get XL to start in full screen without having to use the
...one side mail traffic
got 2 exch2k3 servers in the same site
traffic from B->A goes great but traffic from A->B got stuck on qeue
plus get error event 7002 on server A related to xexch50 error
this is smtp log from server A
this is not cut this it how it ends!!!
192.168.1.2, OutboundConnectionResponse, 7/30/2005, 0:27:38, SMTPSVC1,
MAINSRV, -, 328, 0, 119, 0, 0, -, -, 220 capsrv.domain.local Microsoft ESMTP
MAIL Service, Version: 6.0.3790.211 ready at Sat, 30 Jul 2005 00:27:38 +0000
192.168.1.2, OutboundConnectionCommand, 7/30/2005, 0:27:38, SMTPSVC1,
MAINSRV, -, 328, 0, 4, 0, 0, EHLO, -, ...mask/hide private appointments on screen
I don't want collegues to see the content of my private appointments in outlook. How do I do that.
I can recall having been able to do so in an earlier version of outlook, but somehow I can't find it in version 2000
At the lower right hand corner of the appointment there is a Private
check box. Check that and make sure your delegates and folders
permissions granted to other people don't include rights to see
[MVP - Outlook]
Author: Absolute Beginners Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended R...Transposing addresses
I have a s/sheet with 1,000 addresses, all in column A, most over 4 lines,
some over 5.
Is there an 'easy' way of converting each of these address blocks into a
single row, with each line in it's own column?
(I ultimately need to use these addresses in a Word mailmerge).
Thanks for any help ... !
I would do this via Word.
Copy all the cells to Word. Change table to text. Use Edit, Replace to
replace manual line break with tab character. Copy everything to Excel. If
you provide headings the list should be suitable for Word mail merge.
> I have a...How can I paste a wide table from Excel into Quark?
With an old version of Excel I had no problem copying wide tables from Excel
into Quark and then reducing them if necessary to fit the margins. Now I have
New Microsoft Excel Worksheet and when I copy and paste a wide table, the
right-hand columns do not appear in Quark. Please help.
Maybe try my webtablemaker at
It will convert your table to a html web page. From there, you could maybe
import it into Quark if it has webpage import?
"Tom Ireland" wrote:
> With an old version of Excel I had no problem copying wide tables from...Screen Resolution Sizing
Well as you can see that my question is about changing the screen
resolution, and i know a lot of people are against the idea of
changing peoples Settings. and all the knock on effects it causing
with other applications.
I've done some searching, and i ain't been able to find any real
about 98% of the users that use the database use the screen resolution
of 1024x768 so when i built the database i optimized the forms to
work on the resolution ( I have an awful lot of forms)
the other 2% use the 800x600 as a resolution, which when they open the
database the ...The Lighter Side of DST
I was thinking of other ways to get through the new DST rules
Become Amish - we live near an Amish community. I guess they must think
we're all fools for letting machines and the time of day get the best of us -
Write your appointments down in a Daytimers type calendar. The paper and ink
are "DST compliant".
Place large amounts of food in every meeting/board room. If your users get
there at the wrong time or the wrong room, they'll still have a reason to be
Convince the CEO to do a study on the effectiveness of meetings, by
cancelling all of them for the ...Autoshapes
Is it possible to draw an Autoshape (say a rectangle) in a
worksheet at a particular place on a screen. That is, to
position it on screen using coord's rather than 'by
It doesn't mater what shape, as they are part of a shapes collection which
you can address.
Here is an example
.Left = 500
.Top = 555
where shpBob is the shape name, whiich you can set.
... looking out across Poole Harbour to the Purbecks
(remove nothere from th...Minimized Ribbon on load
Is there a way to disable the menu and minimized the ribbon when opening the
...Can not Transpose with out destroying my formulas
I would like to know how to transpose the layout of a speadsheet from rows to columns with out destroyin my spread sheet...
When ever I do this I lose the equations I have entered.. for some reason the refereces tdo not folllow the trransposition...
Assuming your source range is in A1:A26 (ie a 26R x 1C grid)
Select say B1:AA1 (target range)
(note: the target range selected must be the "converse"
of the source 26R x 1C grid, i.e. a 1R x 26C grid)
Put in the formula bar: =TRANSPOSE(A1:A26)
Array-enter the formula, viz.:
Hold down CTRL + SHIFT, press ENTER
(instea...Ribbon in Excel 2007: positioning buttons using box controls
I'm trying to position 5 buttons in a group:
2 vertically on the left, 2 vertically on the right, and one below.
The code below places the last button on the far right and I'm
wondering what I can do to fix this. I realise that I can set the
boxStyle to horizontal and rearrange the buttons, but I'm trying to
keep them grouped in a logical fashion as above. If all else fails, I
will revert to this, but I would have thought there'd be a solution.
Any suggestions appreciated.
Thanks in advance
I forgot to post my code:
<gr...Screen Font Smoothing
I working on an App where I need to ensure that the screen font smoothing type is Standard and NOT ClearType. To do this I'm using this block of code
SPIF_UPDATEINIFILE | SPIF_SENDCHANGE)
SPIF_UPDATEINIFILE | SPIF_SENDCHANGE);
In order for me to use the constants SPI_SETFONTSMOOTHINGTYPE and FE_FONTSMOOTHINGSTANDARD WinUser.h specifies ...Help! Blue screen ! Windows XP only run in safe Mode !
WindowsXP SP2 cannot run in normal mode ,
It become blue screen after a minute or later,
Now It can only run in Safe Mode !
I get some Dump files and blue screen viewer (file attached) ,
Can anyone help !
*(Sorry for my poor English !)*
|Filename: Dump.rar |
--------------------------------------------...How to transpose in excel file
Hi I would like to make a transpose like this?
House Defect How much
#1 Broken Sinks 1000
#1 Bad Paint 2000
#1 Bad Lighting 1000
#2 Broken Sinks 0
#2 Bad Paint 2000
#2 Bad Lighting 100
and Transpose into
House Broken Sinks Bad Paint Bad Lighting
#1 1000 2000 1000
#2 0 2000 100
A Pivot Table will do that and more.
Set House as row field, Defect as column field and How much as data.
HTH. Best wishes Harald
"vilfood" <vilfood@d...Booklet, printing both sides of paper
I think I have the booklet setup somewhat correct.
I have 8 pages listed at the bottom. Page is 4.25 by 11.
I type what I want in each page, and print it, but where a page should be on
the back, the back is blank. I see the 8 pages, and they print all on one
side, I am using the full 8.5, a page is 4.25, face to face (Hope that isn't
Page 1 is the front (or cover page) page 2 should be on the other side of
that , but is page 4 when printed.
It must be a set up problem?
For an eight page booklet it will take two sheets of paper. First sheet will
have pag...How To: Ribbons
Hi, I want to create a custom ribbon menu but load it from code when the
database starts (Autoexec), e.g. the ribbon menu is temporary in that I
DON'T/CAN'T use the 'USysRibbons' table (ADP and all that, tables are stored
in Oracle), so after I've connected to the Oracle server and created a
recordset to the menu ribbon table that stores my XML, I then load my menu
ribbons by using the code,
While not rs.EOF
Application.LoadCustomUI rs!MENU_RIBBON_NAME, rs!MENU_RIBBON_XML
So the question, what is the code that will hide the curre...Ribbon vs traditional Menu......
Hi, I want to change the ribbon menu format back to the traditional menu
format.... can this be done and if so, how?
Learn Ribbon side by side using old office classic menu from
Free Exshail Classic Menu for Excel-2007
"Nichelle" <Nichelle@discussions.microsoft.com> wrote in message
> Hi, I want to change the ribbon menu format bac...