Apache OpenOffice Community Forum

Posted: **Sun Apr 29, 2018 1:13 pm**

Hi,

I want to use the same form to edit and add new records, from diferent buttons.
I need to change the 'Only Data Entry' property of the form depending on the button that calls it.

There is a drop down for this form property in design mode, data tab, I just need to assign the value of this property when loading the form.

I have managed to position the form when opening in a new record using moveToInsertRow, but I do not want to keep access to other records from the navigation bar. Disable some buttons of this bar would serve to me.

Greetings.

Posted: **Sun Apr 29, 2018 4:05 pm**

Use a better database frontend. Base is too simple (and therefore difficult to use) for developers who want full control over the GUI elements.

Posted: **Sun Apr 29, 2018 5:30 pm**

Thanks for the advice. The licensing policy of my company does not allow me to use another development tool.
I have been using ms-acc for many years and I did not think that something so simple, such as choosing the data mode when opening a form or changing that property when opening it, would be so complicated in BASE.

Posted: **Sun Apr 29, 2018 6:43 pm**

Maybe something here would help
Macro to open form with add data only behaviour

Posted: **Sun Apr 29, 2018 6:53 pm**

The whole Base component, including all the drivers weighs 30MB. The forms are attached to office documents. There is absolutely nothing which comes even close to MS Access.

Posted: **Sun Apr 29, 2018 11:21 pm**

This seems to work on my form

Code: Select all

REM  *****  BASIC  *****

Sub ToggleAddDataOnly(oEv as object)
Dim oForm as object

oForm = oEv.Source.Model.Parent
If oForm.IgnoreResult = TRUE then
  oForm.setPropertyValue("IgnoreResult", FALSE)
else
  oForm.setPropertyValue("IgnoreResult", TRUE)
end if
oForm.reload
oForm.moveToInsertRow

End Sub

Posted: **Mon Apr 30, 2018 6:27 pm**

Thanks very much.

Now the mine also run fine, it's just what I was looking for.

Regards.

Apache OpenOffice Community Forum

[Solved] Property 'Only Data Entry' in form

[Solved] Property 'Only Data Entry' in form

Re: Property 'Only Data Entry' in form

Re: Property 'Only Data Entry' in form

Re: Property 'Only Data Entry' in form

Re: Property 'Only Data Entry' in form

Re: Property 'Only Data Entry' in form

Re: Property 'Only Data Entry' in form