このページはEtoJ逐語翻訳フィルタによって翻訳生成されました。

翻訳前ページへ


Where you 蓄える/店 Open Office 大型のs - Open Office Tutorials - opof6marcroswhere AUTHOR'S MAIN SITE   > > > > >   TABLE OF CONTENTS for Open Office database tutorials.
MACROS section, Open Office tutorials.    Delicious Bookmark on Delicious    Recommend to StumbleUpon

Open Office Tutorials
Where 大型のs are 蓄える/店d

This page is one of several trying to help you get the most out of the splendid Open Office. They are 連合した with a larger 始める,決める concentrating on ooBase.

Remember that Open Office, 含むing ooBase, is 解放する/自由な! But don't let that fool you. And it's not new. Big organizations, 政府 and 非軍事の, are 可決する・採択するing it as their 基準 office 控訴... and saving million$, and still Getting The 職業 Done.

There's more about ooBase in the main 索引 to this 構成要素.

This page is "browser friendly". Make your browser window as wide as you want it. The text will flow nicely for you. It is easier to read in a 狭くする window. With most browsers, 圧力(をかける)ing 加える, minus or 無 while the 支配(する)/統制する 重要な (ctrl) is held 負かす/撃墜する will change the texts size. (大きくする, 減ずる, 回復する to default, それぞれ.) (This is more fully explained, and there's another tip, at my 力/強力にする Browsing page.)

Page contents © TK Boyd, Sheepdog ソフトウェア ®, 2/06-3/11.



Introduction

You can do a 広大な/多数の/重要な 取引,協定 of useful work in Open Office without ever getting 伴う/関わるd with 大型のs. But if you master 大型の programming, you can do even more.

The page you are reading 演説(する)/住所s just one tiny 詳細(に述べる) in regard to 大型のs: Where they are 蓄える/店d. It also delves into questions about where ooBase 大型のs are 蓄える/店d in the different 見解/翻訳/版s of ooBase. (A 重要な change in the 貯蔵 of 大型のs took place between ooBase 見解/翻訳/版 2 and ooBase 見解/翻訳/版 3.0, and a その上の important change occurred between 見解/翻訳/版 3.0 and 3.1 If you want to work with 大型のs and ooBase, it would 支払う/賃金 you to 昇格 to Open Office 3.1... but there are ways to 延期する the 昇格. Whether it 事柄s to your 大型の use can be understood from 構成要素 近づく the end of this essay.)


Where 大型のs live.... in general....

An Open Office 大型の can reside in at least two places, and each has its プロの/賛成のs and 反対/詐欺s.

A 大型の can 存在する in a central repository on your machine. In this 事例/患者, the 大型の will be 利用できる to any 文書 you work on 経由で Open Office, which might seem like a Good Idea.... but it will also mean that if you have some error in the 大型の, that 大型の will be 現在の across the board. But of course if you 直す/買収する,八百長をする it, you will only have to 直す/買収する,八百長をする it once. But what if the "直す/買収する,八百長をする" (in one 状況) messes up something that worked "okay" in another?

In the light of what I hope you will infer from the previous paragraph, I prefer to 蓄える/店 the 大型のs a 文書 needs in that 文書. The downside of this approach is that if I ever 工夫する a 大型の that has 幅の広い usefulness, I will have to copy to each 文書 I want to use it. I will have to 今後 updates when and as they arise. of course there is also an upside: If I move a 文書 to a different computer, it brings with it any 大型のs it needs... which doesn't happen if your 大型のs are in your central Open Office repository.

Which approach is best for you will be 影響(力)d by your 計算するing circumstances.


Where 大型のs live.... 詳細(に述べる)s....

If, from any Open Office 使用/適用 menu you 接近 道具s | 大型のs | 組織する 大型のs, you will see several choices....

(The 選択 on your machine might be わずかに different, but I would 推定する/予想する at least OpenOffice.org Basic to be 現在の.

If you select any of the 選択s, you get the same dialog, but what you see when you make use of that dialog will be filtered based on which 大型のs you 始める,決める out to "組織する". We're going to be working with the OpenOffice.org Basic 大型のs, but I believe that anyone working with different 大型の 始める,決めるs would have 類似の experiences to those I will be 述べるing.

On a computer where not much has happened in 尊敬(する)・点 of 大型のs since a pre 見解/翻訳/版 3.1 OpenOffice was 任命する/導入するd, and on which only an ooBase Open Office database is 現在/一般に open, you will see in the "大型の From" pane only "My 大型のs" and "OpenOffice.org 大型のs". In 前線 of each there will be a small square 含む/封じ込めるing a "+" or a "-", 示すing, as usual, the 存在 of a hierarchical structure, like the structure of とじ込み/提出するs in the folders on your 支援 蓄える/店. If you are using a 地位,任命する 見解/翻訳/版 3.0 見解/翻訳/版 of Open Office, you will also see a line for the open database.

The two 最高の,を越す level "コンテナs" ("MyMacros" and "OpenOffice.org 大型のs") are, I believe, 適切に referred to as "Libraries".

The first ("My 大型のs") is the 最高の,を越す level コンテナ for 大型のs created which are 利用できる to all Open Office 文書s running on the computer you are 現在/一般に using. You can 追加する modules to it. 公式文書,認める that you do not need to create a new module for each 大型の you wish to create... a 選び出す/独身 module can 含む/封じ込める 多重の 大型のs.

The second 大型の library, "OpenOffice.org 大型のs" is "read only"... you can use what's there, but not (直接/まっすぐに) change it. (Although I 嫌疑者,容疑者/疑う that at least the Open Office update 過程 (which you may invoke), or 追加する-ins (which you may 任命する/導入する) may change what is 現在の in this library.

に引き続いて those two, what you see will depend upon whether your Open Office is newer than 見解/翻訳/版 3.0

For 3.0 and 3.1 取り付け・設備s, if you have an ooWriter 文書 open, as yet unsaved, then in the dialog showing the libraries, you will have an 付加 入ること/参加(者), one 肩書を与えるd "Untitled". Yes... that's your ooWriter 文書. Any 大型のs you create within that コンテナ will be held within the ooWriter 文書. The system is やめる clever about keeping all the 指名するs straight. For instance, if you create a 大型の before you have saved the 文書, and subsequently save it, the "Untitled" 入ること/参加(者) in the 名簿(に載せる)/表(にあげる) of 利用できる libraries will have changed to fit the 指名する you gave the 文書. Whew.

For an Open Office 3.1 取り付け・設備, if you have a database open, then, as I said, there will be a line for that too. If you have a 地位,任命する 3.0 取り付け・設備, then you don't need to fool around with having the ooWriter 文書. It was only there for people with pre-3.1 取り付け・設備s, to 供給する a place to put 大型のs. Before 3.1, you couldn't 蓄える/店 them in とじ込み/提出する 持つ/拘留するing all the other parts of your database.


What about 大型のs for ooBase databases?....

I would like to save my 大型のs with the 文書 which uses them. And by "文書", I mean the database when I am working in ooBase. (... the worksheet when I'm working in ooCalc, etc.)

Before 見解/翻訳/版 3 of ooBase, there was a way save 大型のs with the form they 適用するd to. Nice... but not a perfect answer. In ooBase 見解/翻訳/版 3.0.0, the old "save it with the form" 選択 has been (疑いを)晴らすd away. The "save it with the database" 選択 appeared, hurrah, with Open Office 3.1.

恐れる not! For those who are not ready to 昇格 to 3.1, there is an answer! Here's the work-around.....

Create an ooWriter 文書, and 蓄える/店 it in the same folder as your database. Make 確かな to have that 文書 open at any time you are working with the database. You can create and 蓄える/店 大型のs in the ooWriter 文書. As long as it is open, those 大型のs will be 利用できる to any ooBase database which is open at the same time. A little "messy", but not the end of the world.

Do 昇格 to Open Office 3.1 when you can. There are always 危険s, and I probably hate "昇格s" more than most people, but I 港/避難所't (yet) had a bad experience through doing an Open Office 昇格. Each time I've done it, the system has even done a good 職業 of automatically (疑いを)晴らすing away the old 見解/翻訳/版. But do take the usual 警戒s.


That's (mostly) it!...

I hope the above was useful and will incline you to return to the main page of my Open Office tutorials, and 接近 other tutorials... or even visit my freeware and shareware "蓄える/店"!! And bring it to the attention of parents and schools, in particular.


But... P.S....

In the course of 令状ing another tutorial, I did some more work on "大型のs- where?" without remembering that I'd written the 構成要素 above essay months 以前! Sigh. There will be some overlap between what is above, and what is below. And I will someday try to come 支援する and make an elegant 合併する of the two sections which 存在する here today. But for now, I'm just "ダンピング" the new work here as a sort of 虫垂. It was done in March of 2011, a Windows XP machine, with Open Office 3.0.0

Suppose you want a particular 大型の to "解雇する/砲火/射撃" each time you open a 文書? The answer to that is in what follows...

Start by creating the 大型の that you want. A simple pop up "Hello World" message box will do to 実験(する) what follows. If you don't know how to create one, see my tutorial with introductory 構成要素 on Open Office 大型のs.

Now to put that 大型の to work...

If you 港/避難所't already done so, put a button on your worksheet. The "toggling icon" (on/off) for "edit とじ込み/提出する" on the main toolbar will be 決定的な in getting the に引き続いて working. 陳謝s for not having all of the 詳細(に述べる)s worked out yet... but you should be able to muddle through, based on the に引き続いて.

Once you have your button on the worksheet, when you have the "edit とじ込み/提出する" button in the 権利 明言する/公表する ("負かす/撃墜する"), if you 権利 click on the button, it becomes selected (drag 示すs in corners), and a pop-up menu arises, giving "支配(する)/統制する..." as one of your choices. Click it to open the 支配(する)/統制する's 所有物/資産/財産s. (A button is "a 支配(する)/統制する").

Go to the "events" tab, and on that, click on the ellipsis ("...") to the 権利 of the Mouse Button 圧力(をかける)d event.

That will open an "割り当てる 活動/戦闘" dialog, with "Mouse Button 圧力(をかける)d" selected. Click on "大型の..." (over at the 権利, below "割り当てる"). That will open the 大型の Selector... and you should see your 大型のs module, the one called "tkbUsrFuncs"... but it isn't always shown, when I look! If it isn't shown, 取り消す out until you can do 道具s | 大型のs| 組織する 大型のs... When you've done that, select "tkbUsrFuncs"... and then go 支援する, go through the steps to get to the assignment of a 大型の to "Mouse Button 圧力(をかける)d" again. 演習 負かす/撃墜する to your 大型のs module ("tkbUsrFuncs"), 最高潮の場面 "tkbSayIt", click "承認する"

Click the "edit とじ込み/提出する" button, to change it's 明言する/公表する. You'll probably be asked if you want to save your work. (Do that.) And you'll get the 警告 about 大型のs, if you have 安全 始める,決める to "medium", but in 予定 course you'll be looking at your worksheet. Try clicking your button. A message box should come up on the 審査する, 説 "Hello World".

Fancier: "On startup" calling of 手続きs from within DLLs...

井戸/弁護士席, 罰金... but let's be a little more ambitious. How about setting things up so that the message from inside the DLL arises whenever you open a particular worksheet.

A necessary, I think, evil creeps in. The code arranging for the calling of the 大型の can no longer 存在する 単独で within the 文書, I don't think. The 文書 will be trying to do the "tkbSayIt" 大型の before it has 負担d the 文書s 内部の 大型のs, I think... if you 割り当てる it to "解雇する/砲火/射撃" during the 開始 of the 文書.

The way around this Catch-22 is to 蓄える/店 the 大型の どこかよそで. I elected to 蓄える/店 it in the My 大型のs . 基準 library, in a new 大型の module I created there and called tkbPCellie2011mar because the module is 全世界の in my Open Office in the computer I call pcEllie, and I created it in March of 2011. In that 大型の module, I entered and saved....

宣言する sub SayHi lib "C:/dd50demo.dll"

sub tkbGlobalSayIt
SayHi
end sub

The 新規加入 of "全世界の" to the 指名する wasn't "necessary"... I could have had two 大型のs with the same 指名する, as they were in different places... but having two things with one 指名する can lead to programmer 混乱... never a good thing!

The とじ込み/提出する which 持つ/拘留するs your 取り付け・設備-全世界の MyMacros seems to be in an XBA とじ込み/提出する with the 指名する you gave the module. The path to this seems to start the same way as most of the paths 指定するd within...

選択s| OpenOffice. Org| Paths

... e.g.

C:\文書s and Settings\TKB\使用/適用 Data\OpenOffice.org\3\使用者\.....

From there, the path for the MyMacros seems to be...

....basic\基準

Whether that path can be 直接/まっすぐに 始める,決める is something I don't know, and wouldn't recommend fooling with! Which begs the question: How do you get two machines "in step" in 尊敬(する)・点 of what they will do when you open a 文書 that has an "Open 文書" event handler defined....?

Once a way to invoke the DLL's "SayHi" 存在するd outside the worksheet, I went 支援する to the worksheet and 遂行する/発効させるd "道具s | 大型のs| 組織する 大型のs..." yet again.

I 演習d 負かす/撃墜する to tkbGlobalSayIt, and then clicked the "割り当てる" button. That opened a dialog with three tabs. If you aren't on the "Events" tab, go there. You should see a 名簿(に載せる)/表(にあげる)....

The one you want is "Open 文書". Click the "大型の" button over at the 権利, under "割り当てる". Be sure that in the combo box at the 底(に届く), your 活動/戦闘 assignment is going to be saved in TstUserCreatedFunction.ods. (So that this only happens when you open this 文書... it seems some things ARE 負担d before the "Open 文書" event 解雇する/砲火/射撃s.)

演習 負かす/撃墜する to tkbGlobalSayIt (yes, 演習 負かす/撃墜する again... seems daft you have to say "割り当てる" twice, and have to 演習 負かす/撃墜する twice... but if you can find a faster way, more 力/強力にする to you. I couldn't!)

If when you try to 割り当てる the 大型の, the 大型の module you made, the one with TkbSayIt in it isn't in the 名簿(に載せる)/表(にあげる) of 利用できる modules, use 道具s| 大型のs| 大型の 組織者. 演習 負かす/撃墜する to your 大型のs module. Then try again to 割り当てる TkbSayIt to the form "基準" of your worksheet. I hope that you WILL, as I (usually!) do find TkbSayIt 利用できる on the second (or third) try. I believe Open Office is reliable and stable... when you 人物/姿/数字 out the "tricks". It's just that I'm still "行方不明の something" about how it ACTUALLY behaves. It is so 平易な to assume that powerful ソフトウェア can read you mind and do what YOU THINK it "ought" to do. 現実に, it tends to do what the programmers designed it to do. Sorry about that. Suck it up!

Say "承認する", "承認する", "の近くに" to tidy things up. Save your worksheet. の近くに it. Re-open it. The 手続き inside the DLL should 解雇する/砲火/射撃 as the worksheet re-opens, 迎える/歓迎するing you with the "Hello World" message box.

Useful 正確に/まさに like that? Not very. But I hope it shows you how you can arrange for 手続きs inside DLLs to 解雇する/砲火/射撃 when you are working in Open Office.


Other 資源s

I didn't understand everything I read in the に引き続いて, but it did give me ideas of things to try, and might be useful to you too, 関心ing arranging a pop-up when a worksheet opens... which entails a Catch-22 in 尊敬(する)・点 of where things are 蓄える/店d.

http://www.oooforum.org/会議/viewtopic.phtml?t=106195&最高潮の場面=dll


編集(者)の Philosophy

I dislike 'fancy' websites with more 関心 for a flashy 外見 than for good content. For a pretty picture, I can go to an art gallery. Of course, an attractive 場所/位置 WITH content deserves 賞賛する... as long as that pretty 直面する doesn't cost download time. In any 事例/患者....

I am trying to 現在の this 構成要素 in a 判型 which makes it 平易な for you to USE it. There are two 面s to that: The way it is 分裂(する) up, and the way it is 地位,任命するd. See the main 索引 to this 構成要素 for more (警察などへの)密告,告訴(状) about the way it is 分裂(する) up, and the way it is 地位,任命するd.


広告 from page's editor: Yes.. I do enjoy 収集するing these things for you... I hope they are helpful. However.. this doesn't 支払う/賃金 my 法案s!!! If you find this stuff useful, (and you run an MS-DOS or Windows PC) please visit my freeware and shareware page, download something, and 循環させる it for me? Links on your page to this page would also be 高く評価する/(相場などが)上がるd!

PLEASE >>> Click here to visit editor's Sheepdog ソフトウェア (tm) freeware, shareware pages <<< PLEASE


If you liked this ooBase tutorial, see the main 索引 for (警察などへの)密告,告訴(状) other help from the same author.

Editor's email 演説(する)/住所. Suggestions welcomed!     - - -    Want a 場所/位置 hosted, or email? I like 1&1's services.




Valid HTML 4.01 Transitional Page 実験(する)d for 同意/服従 with INDUSTRY (not MS-only) 基準s, using the 解放する/自由な, 公然と accessible validator at validator.w3.org


One last bit of advice: Be sure you know all you need to about spyware.

. . . . . P a g e . . . E n d s . . . . .