Highlighted

error: this operation violates your permissions configuration

Avatar

Guest

23-12-2008

Hello: I have a form with a dropdown list and 4 text fields.



The dropdown list has 3 values (Committee 1, Committee 2, and committee 3)



In access 2007 I have a database with the names of the people on each committee.



The following code is on the exit button of the dropdown list:



$sourceSet.TIMSTEST.#command.query.commandType = "text"

$sourceSet.TIMSTEST.#command.query.select.nodes.item(0).value = Concat("Select * from Tmp_Committee where Description = '", this.rawValue, "'")

$sourceSet.TIMSTEST.open()

//xfa.host.messageBox("TIMSTEST opened")



$sourceSet.TIMSTEST.close()

//xfa.host.messageBox("TIMSTEST closed")



When I open the form I automatically get the first record in the database.

When I choose another value in the dropdown I get this error:



error: this operation violates your permissions configuration



Please help.



Thank you

Replies

Highlighted

_Kirill_Krylov_

28-02-2009

Have you been able to resolve this issue. I have exactly the same when I am trying to pass any SQL statement. Please help !!!
Highlighted

pguerett

02-03-2009

When you set up the connection in the dataview you must choose the delayed open option. It is a checkbox on the bottom of the last screen on the wizard. If youdo not check this off the connection is established when the form is opened and the 1st reord is returned (by default). By delaying the open, you can set your commands (like in your script) then when you do the open then you wil get the correct record.
Highlighted

MsPatil

30-04-2009

Even after i check the Delay Open check box i get same error

xfa.sourceSet.DataConnection.#command.query.commandType

= "text"

I get same error after adding above line

any help would be appriciated

Highlighted

MsPatil

01-05-2009

i dont see target version in form properties/default....i see it under fprm property/info

8.0.1291.1.339988.308172

Highlighted

pguerett

04-05-2009

That number is the version of Designer. If you look under the File menu/Form Properties/ Defaults Tab - the 1st option is a target version of the client that you are designing for.

Paul

Highlighted

MsPatil

04-05-2009

Thank you for your response,Paul

Am attaching screen shot of my Default tab for your reference

Am designing this form to create mailing labels.

Please let me know if i can get any info about this on this forum

DefaultsTab.doc

Thank You

Highlighted