LOL - well that came out real nice didn't it...let's try that macro again shall
we.
sub UpdateFormName( oEvent as object )
DIM sOldTitle as string
DIM oDBFormFrame as variant
DIM offset as integer
oDBFormFrame = thisComponent.CurrentController.Frame '
oEvent.Source.Parent.Parent.CurrentController.Frame
sOldTitle = oDBFormFrame.Title
offset = InStr(sOldTitle, "(" )
if offset <> 0 then
oDBFormFrame.Title = left( sOldTitle, offset - 1 )
end if
end sub
>-----Original Message-----
>From: Drew [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, September 19, 2007 10:56 PM
>To: [email protected]
>Subject: Re: [dba-dev] OO 2.3 Base "form" view says "read-only"-- But it's
>not
>
>Hello again,
>
>Sorry I was so long on this - had to do something else first and never got to
>that backup - so I just now wrote a quick script for you.
>
>The actual Basic sub procedure is:
>
>sub UpdateFormName( oEvent as object )DIM sOldTitle as stringDIM oDBFormFrame
>as variantDIM offset as integer
> oDBFormFrame = thisComponent.CurrentController.Frame sOldTitle =
> oDBFormFrame.Title offset = InStr(sOldTitle, "(" ) if offset <> 0 then
> oDBFormFrame.Title = left( sOldTitle, offset - 1 ) end ifend sub
>
>
>How to use it. Open OO.org and from the main menu select
>Tools>Organize Macros>OpenOffice.org BasicThis opens the Basic dialog. On the
>left of the dialog box is a list titled "Macro from".
>Select My macros and expand it.
>Now you will see a basic library named "Select", expand it.
>Now you have a module inside the library named "Module1"
>Select this and click on Edit.
>
>The basic editor will open with Module1 from the Standard library loaded in it.
>
>Copy the sub procedure from above and past it into the editor after the last
>line of the
>default Main procedure.
>
>Save and close the basic editor.
>
>Now open your form in edit mode. Not for data entry in other words.
>
>Right click on the table grid control and on the context menu select "Form"
>
>The dataform control's property editor dialog opens.
>This dialog has three tabs. You want to select the tab "Events"
>
>On the Events tab you will see an event named "When loading"
>All the way to the right of the line is a small button with "..."
>Click on this and another dialog opens, "Assign action"
>Click on the button "Macro"
>
>On this dialog there are two lists "Library" and "Macro name".
>Just as before on the Library list you
>Expand My Macros, expand Standard and select Module1
>
>Now in the Macro name list there should be two items
>"Main" and "UpdateFormName"
>Select UpdateFormName and click on OK
>The Assign Action dialog is on top again, click OK
>
>Close the Property Editor dialog
>Save the form and close it.
>Save your database file.
>
>Open the form the normal way and the title should
>now be changed to only the name of the form.
>
>You can reuse this sub procedure with any forms your
>create in the future.
>
>I know that there is no explanation of why with this email..sorry.
>If you want to go over that I will be happy to do so.
>
>HTH
>
>Drew
>>-----Original Message-----
>>From: Drew [mailto:[EMAIL PROTECTED]
>>Sent: Wednesday, September 19, 2007 06:10 PM
>>To: [email protected]
>>Subject: Re: [dba-dev] OO 2.3 Base "form" view says "read-only"-- But it's
>>not
>>
>>Hi Swarup,
>>
>>ROFL - that again! ( sorry nothing to do with you, it is just a question that
>>gets asked A LOT!!! in the forum )
>>
>>That is an artifact of the decision to base the embedded Base forms on Writer
>>documents.
>>
>>That is telling you the 'document' is read only - in other words you can not
>>move the controls around or edit their properties. The data link is not read
>>only - well, unless of course it is...*smile*..in that case certain of the
>>buttons on the data navigator bar would be disabled.
>>
>>Think of it as a feature. If it is a feature you do not like, then changing
>>the title of the form, so as not to display that and perhaps to display
>>something more useful is actually quite easily done, with 3 lines of Basic. (
>>maybe it is 5 )
>>
>>I'll grab the code and put it up here - with a simple description of how to
>>use it.
>>
>>I won't be long - just have to pull it out of a backup file - long story
>>about installing Community Version of Solaris on the second hard disk of a HP
>>PC....arrrgh...that has no place here...arrrgh... Live and Learn.
>>
>>Drew
>>
>>>-----Original Message-----
>>>From: Dinbandhu [mailto:[EMAIL PROTECTED]
>>>Sent: Wednesday, September 19, 2007 05:41 PM
>>>To: [email protected]
>>>Subject: Re: [dba-dev] OO 2.3 Base "form" view says "read-only"-- But it's
>>>not
>>>
>>>Hello Drew (and others),
>>>
>>>You had recommended me to start using the "forms" view rather than the
>>>"table" view for data input and review. In OO 2.2 I had found that the
>>>forms wizard would not finish its work of creating a form, and upon
>>>reporting this on this list, was recommended to upgrade to OO 2.3. I
>>>have done so, and now the forms wizard works wonderfully.
>>>
>>>My only question at this time, is that, although the "forms" view
>>>appears to allow for data input just fine, but it states at the top of
>>>the form "read-only". Is it just an error that this appears there, or is
>>>there some significance to it?
>>>
>>>Thanks,
>>>Swarup
>>>
>>>---------------------------------------------------------------------
>>>To unsubscribe, e-mail: [EMAIL PROTECTED]
>>>For additional commands, e-mail: [EMAIL PROTECTED]
>>>
>>>
>>
>
