 | |
#1
 
| |||
| |||
|
Toolbar / Ribbon -
01-29-2011
, 08:35 PM
#2
| |||
| |||
|
|
Hi NG Access Runtime 2010 I looked a lot on the internet, but did not find the answer... Can self made toolbar or ribbon be used in Access Runtime 2010...??? greeting Bjarne |
runtime, then try the ribbon example I have here:
http://www.kallal.ca/Ribbon/ribbon.htm
I also have a report sample here that should just work + run if you placed
it on a machine with runtime:
http://www.kallal.ca/msaccess/DownLoad.htm
From above, try 4th from last: Access 2007 report ribbon example (with PDF
and email
And, last one:
Access 2010 report example -
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Pleasenospam_kallal (AT) msn (DOT) com
#3
| |||
| |||
|
|
Hi NG Access Runtime 2010 I looked a lot on the internet, but did not find the answer... Can self made toolbar or ribbon be used in Access Runtime 2010...??? greeting Bjarne |
runtime, then try the ribbon example I have here:
http://www.kallal.ca/Ribbon/ribbon.htm
I also have a report sample here that should just work + run if you placed
it on a machine with runtime:
http://www.kallal.ca/msaccess/DownLoad.htm
From above, try 4th from last: Access 2007 report ribbon example (with PDF
and email
And, last one:
Access 2010 report example -
------------------------------------------------------------------------------------
thx for answer Albert
I´m new to Access 2010 - a lot have changed since Access 2003...:-(
Can you tell in short way, to get ribbon or toolbar to the runtime...???
Maybee I then better understand the code...
A lot of code - i´l try look into it...
Maybee i come back later...;-)
Bjarne
#4
| |||
| |||
|
|
I´m new to Access 2010 - a lot have changed since Access 2003...:-( Can you tell in short way, to get ribbon or toolbar to the runtime...??? Maybee I then better understand the code... |
(you could even delete the code module).
So, the ribbon definition is created and placed into a table, and then
travels with the application (including the runtime).
To create a ribbon, you thus need to first create a table in access to hold
the ribbons.
Here is a good starting point:
http://office.microsoft.com/en-us/ac...010211415.aspx
and
http://msdn.microsoft.com/en-us/library/bb187398.aspx
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Pleasenospam_kallal (AT) msn (DOT) com
#5
| |||
| |||
|
|
I´m new to Access 2010 - a lot have changed since Access 2003...:-( Can you tell in short way, to get ribbon or toolbar to the runtime...??? Maybee I then better understand the code... |
(you could even delete the code module).
So, the ribbon definition is created and placed into a table, and then
travels with the application (including the runtime).
To create a ribbon, you thus need to first create a table in access to hold
the ribbons.
Here is a good starting point:
http://office.microsoft.com/en-us/ac...010211415.aspx
and
http://msdn.microsoft.com/en-us/library/bb187398.aspx
---------------------------------------------------------------------------------------------------
Thx again...
I´ve been there...
Created the table(UsysRibbons), and put some xml code about Ribbon in...
I can´t find out how the database is told to use the table to make ribbon...
When i look in File_Options_CurrentDB no ribbons shows up there...
Thx for ur patience...
Bjarne
Bjarne
#6
| |||
| |||
|
|
Thx again... I´ve been there... Created the table(UsysRibbons), and put some xml code about Ribbon in... I can´t find out how the database is told to use the table to make ribbon... |
create the ribbons in that ribbons table.
You do have to exit + reload access (just exit your application, and then
reenter) before any new ribbon will show up in the combo box selection of
ribbons.
You can also specify a ribbon for a form or report. Simply open the
form/report in design mode. You should see a ribbon drop down in the "other"
tab of the form/report properties that lets you select from the list of
ribbons. Try downloading the sample I have here:
http://www.kallal.ca/msaccess/DownLoad.htm
grab the one:
Access 2010 report example
direct link:http://www.kallal.ca/msaccess/RibbonReportPDF2.zip
If you look at the above, note the USYSRibbons table. Take a look at how it
is setup. Then open up a report in design mode, and note the settings in the
other tab of the property sheet for that report.
Using file - options, currentDB, you should see the list of ribbons appear
in the drop down (that list comes from the USYSRibbons table). So, this
combo box setting is to specify an ribbon for the whole application as
opposed to one for each form (or report).
For each form or report, you use the property sheet in the other tab.
(however you should see the same dropdown of possible ribbon choices that
exist in the USYSRibbons table. So, take a look at the sample ribbons in the
above download to see how they are setup.
And, a great ribbon reference for access can be found here:
http://www.accessribbon.de/en/index....bon_Attributes
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Pleasenospam_kallal (AT) msn (DOT) com
#7
| |||
| |||
|
|
Thx again... I´ve been there... Created the table(UsysRibbons), and put some xml code about Ribbon in... I can´t find out how the database is told to use the table to make ribbon... |
create the ribbons in that ribbons table.
You do have to exit + reload access (just exit your application, and then
reenter) before any new ribbon will show up in the combo box selection of
ribbons.
<SNIP>
Using file - options, currentDB, you should see the list of ribbons appear
in the drop down (that list comes from the USYSRibbons table). So, this
combo box setting is to specify an ribbon for the whole application as
opposed to one for each form (or report).
For each form or report, you use the property sheet in the other tab.
(however you should see the same dropdown of possible ribbon choices that
exist in the USYSRibbons table. So, take a look at the sample ribbons in the
above download to see how they are setup.
And, a great ribbon reference for access can be found here:
http://www.accessribbon.de/en/index....bon_Attributes
--------------------------------------------------------------------------------------------------------
Hi Albert...
Thx again...
My ribbon occured now - must have been very late night yesterday...:-)
I work further with this, and will study some XML and ACCESS 2010...
Maybee i get back later...
Bjarne
#8
| |||
| |||
|
|
Thx again... I´ve been there... Created the table(UsysRibbons), and put some xml code about Ribbon in... I can´t find out how the database is told to use the table to make ribbon... |
create the ribbons in that ribbons table.
You do have to exit + reload access (just exit your application, and then
reenter) before any new ribbon will show up in the combo box selection of
ribbons.
<SNIP>
Using file - options, currentDB, you should see the list of ribbons appear
in the drop down (that list comes from the USYSRibbons table). So, this
combo box setting is to specify an ribbon for the whole application as
opposed to one for each form (or report).
For each form or report, you use the property sheet in the other tab.
(however you should see the same dropdown of possible ribbon choices that
exist in the USYSRibbons table. So, take a look at the sample ribbons in the
above download to see how they are setup.
And, a great ribbon reference for access can be found here:
http://www.accessribbon.de/en/index....bon_Attributes
--------------------------------------------------------------------------------------------------------
Maybee i get back later...
And here I am...
Are not getting all my buttons(controls) on the ribbon...
I´v put an "x" in front of controles that are missing in runtime...
My xml
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon startFromScratch="false">
<tabs>
<tab idMso="TabCreate" visible="false" />
<tab id="dbCustomTab" label="Diverse værktøjer" visible="true">
<group id="dbCustomGroup" label="EasyAdmin">
<control idMso="MailMergeGoToFirstRecord" label="Til første post"
size="large" enabled="true"/>
<control idMso="MailMergeGoToPreviousRecord" label="Til forrige post"
size="large" enabled="true"/>
<control idMso="MailMergeGoToNextRecord" label="Til næste post"
size="large" enabled="true"/>
x<control idMso="MailMergeGoToLastRecord" label="Til sidste post"
size="large" enabled="true"/>
<control idMso="GoToNewRecord" label="Indsæt ny post" size="large"
enabled="true"/>
<control idMso="FindDialog" label="Søg på et felt" size="large"
enabled="true"/>
<control idMso="Copy" label="Kopiér" size="large" enabled="true"/>
<control idMso="Paste" label="Indsæt" size="large" enabled="true"/>
<control idMso="SortDown" label="Sortér en kolonne faldende"
size="large" enabled="true"/>
x<control idMso="AdpOutputOperationsSortAscending" label="Sortér en
kolonne stigende" size="large" enabled="true"/>
x<control idMso="RecordsDeleteRecord" label="Slet en post - kan ikke
fortrydes" size="large" enabled="true"/>
<control idMso="Undo" label="Fortryd" size="large" enabled="true"/>
</group>
</tab>
</tabs>
</ribbon>
</customUI>
/My xml
Do u have a hint for this problem...???
Bjarne
#9
| |||
| |||
|
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.