OraFAQ Forum: Forms » Frm-41009 function key not allowed ,press ctrl+k for list of valid values when press F11

Home » Developer & Programmer » Forms » Frm-41009 function key not allowed ,press ctrl+k for list of valid values when press F11

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Frm-41009 function key not allowed ,press ctrl+k for list of valid values when press F11 [message #553105]

Tue, 01 May 2012 23:26

thanhtram254
Messages: 9
Registered: April 2012
Location: Viet Nam

Junior Member

Hi everyone!
i create form,when i press F11, it displays this error:Frm-41009 function key not allowed ,press ctrl+k for list of valid values.And i can't enter value into fields to query records.
What is this error and how can i solve this error?
thank for all your reply.

Report message to a moderator

Re: Frm-41009 function key not allowed ,press ctrl+k for list of valid values when press F11 [message #553124 is a reply to message #553105]

Wed, 02 May 2012 01:22

Littlefoot
Messages: 21824
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

So you can't enter query mode?

Is a current block "data block"? Is its "Query allowed" property set to "Yes"? Does that block contain any item whose "Query allowed" property is set to "Yes"?

Is there any other information you'd like to share?

Report message to a moderator

Re: Frm-41009 function key not allowed ,press ctrl+k for list of valid values when press F11 [message #553129 is a reply to message #553124]

Wed, 02 May 2012 01:34

thanhtram254
Messages: 9
Registered: April 2012
Location: Viet Nam

Junior Member

I have 2 data blocks,header and detail."Query allowed" properties of data blocks and items are "yes". When execute query by Ctrl+F11,it doesn't have any problem but when I press F11,it has error

Report message to a moderator

Re: Frm-41009 function key not allowed ,press ctrl+k for list of valid values when press F11 [message #553130 is a reply to message #553129]

Wed, 02 May 2012 01:48

Littlefoot
Messages: 21824
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

When you pressed <Ctrl + K>, did you see what is <F11> key mapped to? Maybe its function is different from what you think.

Report message to a moderator

Re: Frm-41009 function key not allowed ,press ctrl+k for list of valid values when press F11 [message #553131 is a reply to message #553130]

Wed, 02 May 2012 01:52

thanhtram254
Messages: 9
Registered: April 2012
Location: Viet Nam

Junior Member

when i press Ctrl + K,F11 mapped to "Enter query" function.

Report message to a moderator

Re: Frm-41009 function key not allowed ,press ctrl+k for list of valid values when press F11 [message #553132 is a reply to message #553131]

Wed, 02 May 2012 01:58

Littlefoot
Messages: 21824
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Did you create a KEY-ENTQRY trigger? If so, what does it do?

Report message to a moderator

Re: Frm-41009 function key not allowed ,press ctrl+k for list of valid values when press F11 [message #553134 is a reply to message #553132]

Wed, 02 May 2012 02:11

thanhtram254
Messages: 9
Registered: April 2012
Location: Viet Nam

Junior Member

before i used this trigger to assign value of database item for a temporary item. but now,i don't use it. I have deleted it.

Report message to a moderator

Re: Frm-41009 function key not allowed ,press ctrl+k for list of valid values when press F11 [message #553136 is a reply to message #553134]

Wed, 02 May 2012 02:16

Littlefoot
Messages: 21824
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

When did you delete it? A few moments ago, or several days ago? Did you - in the meantime - recompile the form ("All" - <Ctrl + Shift + K>)?

Report message to a moderator

Re: Frm-41009 function key not allowed ,press ctrl+k for list of valid values when press F11 [message #553137 is a reply to message #553136]

Wed, 02 May 2012 02:22

thanhtram254
Messages: 9
Registered: April 2012
Location: Viet Nam

Junior Member

I deleted it several day,about a week.And I recompile the form a lot of times.

Report message to a moderator

Re: Frm-41009 function key not allowed ,press ctrl+k for list of valid values when press F11 [message #553355 is a reply to message #553134]

Thu, 03 May 2012 13:26

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

thanhtram254 wrote on Wed, 02 May 2012 03:11

before i used this trigger to assign value of database item for a temporary item. but now,i don't use it. I have deleted it.

Did you really delete it or did you change the trigger body to NULL; which would of course change the functionality of it.
Also, do you have a KEY-ENTQRY on the item, block or form level?

Report message to a moderator