Forms :: Click Button And Show Calendar

Nov 4, 2011

I want a code for a button to click and calendar show. Select the date and year for enter in text field.

View 4 Replies


ADVERTISEMENT

Forms :: Opening Picture On Button Click

Oct 24, 2013

I would like to ask a very small question. what is the code that should be written to open a picture inside the button.

I have already made the button, and the trigger is when push button, what I want is when I click the button it opens a picture in this directory:

F:AmjadAmjadamjad1.jpg

the name of the picture is taken from table1 the colum serial_number

View 14 Replies View Related

Forms :: When Click On Button Fetch Only One Record?

Sep 9, 2010

i create form in which first block is non database having 2 items from_date and to_date and one button is there.when i click on button i.e when button pressed new window is open having new database block

i write code on when button pressed

HIDE_WINDOW('XX_RFQ_FIND');
SET_WINDOW_PROPERTY('XX_RFQ_FIND', visible, property_false);
SHOW_WINDOW('XX_RFQ_ACKT');
GO_ITEM('LE_NAME');
SEARCH_REQ;

[code]...

my problem is that when i click on button i fetch only one record

View 3 Replies View Related

Forms :: User Click On Radio Button To Save It On DB

May 2, 2010

i have field in DB that taken ( 1 or 2 or 3 ) am added it as text item at first and then change it to ( radio group ) contain 3 radio as :

value for first 1 = 1 , = 2 , = 3 and mapping = 1
initial value for the group = 1

but when am working with the form and commit form there is no data add in this field when am change the radio value by click on any other on ( 2 or 3 ) it's saved no problem in it ..

why this thing happen coz i need to set the first radio as default for the form .

View 1 Replies View Related

Forms :: Clear Block B Once Click FIND Button

Jul 6, 2011

I am working on form builder 6i.I have FIND widnows and MAIN window.

FIND Window: contains field1 and field2, FIND Button.

block A: Multi record data block on table t1. It contains field1,field2,field3.
block B: non datablock, it contains field4, field5.

If i enter something and click FIND button, it will populate data in Block A.If i put the cursor in any record in block A, and after that put the cursor in Block B, it will populate block B related to Block A record.For this, In Block A--> post record(block level) trigger, i am capturing values in variables.

:GLOBAL.f1:=:BlockA.field1
:GLOBAL.f2:=:BlockB.field2

In Block B--> When-New-Block-instance(Block Level)

select field3, field 4 from t2 where t1=:global.f1 and t2=:global.f2;

and populating data in block B.It's working fine.

REQUIREMENT: If i click the FIND second time, in Block B--> it's retaining previous value. I want to clear the block B once i click the FIND button. I tried to write in POST-BLOCK (Block B-->block level)

CLEAR_BLOCK('NO_VALIDATE');

But it's not working.In which trigger i have to write code to clear block.

View 3 Replies View Related

Forms :: Display All Records One By One As User Click On Next Record Button

Jul 13, 2010

I have created one tab canvased form

On first tab I am taking input (search criteria)
on that input i am trying to display all records one by one as user click on next record button....

for that i used when-tab-page-change trigger for first record display and it display correctly.but for further record what should i need to write on next_record command button so all record i can see one by one.

View 1 Replies View Related

Forms :: Inserting Multiple Selected Records Into Database When Click Button?

Jul 19, 2010

I got a form with few columns and a check_box. If the user selects n number of check boxes and click the button Save. The corresponding records should be inserted to XX_AP_CUSTOM table.

I have written the following below code in when-button-pressed trigger. With this i am able to insert only one record i.e where the current record indicator is there, even though multiple check-boxes(records) are selected.

declare

begin
IF :XXFBI_INV_QUOTE_ANAL_BLK.CHECK_BOX = 'Yes' THEN
--IF CHECKBOX_CHECKED(:XXFBI_INV_QUOTE_ANAL_BLK.CHECK_BOX) = TRUE Then
--app_insert.insert_record('WHEN-BUTTON-PRESSED');
insert into xxfbi.XXFBI_INV_QUOTE_ANAL(Item,

[code]......

I know that i have to use last_record and first_record and for loop to insert multiple selected records, but dont know how to do it.

View 5 Replies View Related

Forms :: Print Report Output To Local Printer On Button Click

Apr 19, 2007

In Sales Order Form there is a print receipt button. In current situation On Clicking the 'Print Receipt Button' it submits a XML Publisher report(PDF output) to the concurrent manager. Currently to print that report i need to go view--> requests--> view output and then print. According to my new Requirement i need to print that report directly to local printer on one simple Print receipt button click in form.

I am trying to call the printers on server using custom.pll. The report is running successfully but it is not printing output to the local printer. I need to print the report to the local printers based on responsibility. Local printers are available on apps server.

Is it possible to print the document using custom.pll? Is there any other alternative to print the report on simple button click in form.

I searched many forums but i found customizations on form level. I am trying to customize the form using custom.pll. I found many examples like URL..... but i don't think i can use these practices in custom.pll. ADD_PARAMETER & RUN_PRODUCT dont work in custom.pll. I need to complete this requirement immediately.

Environment: Apps 11.5.10.2, Forms 6i

Here is the code that i am using in my custom.pll.

if (v_form_name = 'OEXOETEL' --and v_block_name = 'LINES_SUMMARY'
and name_in('parameter.ACTIONS') = 'PAYMENT_RECEIPT' )THEN
l_organization_id := Name_In('PARAMETER.OE_ORGANIZATION_ID');
l_order_header_id := Name_In('ORDER.header_id');
select to_number(oe_sys_parameters.value ('SET_OF_BOOKS_ID')) into l_sob_id from dual;
xml_layout := FND_REQUEST.ADD_LAYOUT('XXAFP','XXAFPOEXPMTRCRTF','en','US','PDF');
[code]....

View 2 Replies View Related

Forms :: Open Form On Specific Record After Click On List Button

Dec 31, 2010

I have a list box from which the user can select a client's name, I want them to be able to press a button next to the box which will then open another form and display all the client's details. How do I attach a button to a list box? and how can I call another form to open on a specific record?

View 3 Replies View Related

Forms :: Windows Close / Click On Save Button Data Get Saved

Jun 29, 2010

i design one master detail block and one command button for saving the data....as i click on save button data get saved and after that if i want to close form then at this time it again asking me for save changes window..

View 8 Replies View Related

Forms :: Run Report Developed By Crystal Reports By Click On Button In Oracle Developer 6i?

Dec 19, 2011

I want to run a report developed by crystal reports by click on a button in oracle developer 6i.

Is it possible. If yes then how can i do this.

View 8 Replies View Related

Forms :: 6i To Show Detail Block When Button Pressed?

Aug 16, 2011

Is it possible to display the detail block (different canvas) in the master block canvas, but when finished entering data into master block and a button is pressed? And i want to use some conditions in the when-button-pressed trigger. based on that it should show different canvas.

simply speaking, my aim is to use the upper part of the screen to show master block and the lower part for a detail block from the different detail blocks based on condition checked in when-button-pressed trigger.

View 6 Replies View Related

Application Express :: Insert A Row Into Table On A Button Click?

Oct 4, 2013

i have a table say 'temp' with 4 columns as seq, name, event, id and  i have a pg with 3 text fields as name, event, id now ma issue is,if  i enter values into those 3 text fields in that page and on a button click (say create), i wanted dose values to get inserted into  'temp' table andregarding ,  'seq' column i hav created a sequence for it. so

1. how to insert values into the table by entering values in the page    

2. wat shd b done for seq column.. (shd anyth b done from apex pages or wil it automatically get values for each row entered) 

View 4 Replies View Related

Application Express :: Error In Javascript Not Fetching Value On Button Click

Nov 23, 2012

I am using APEX 4.1 to build the application. I have 2 select list region in the page where one region consist of certain values.On calling a javascript function it is able to move the value from one select region to another. After this I click on the modify button where in the value move out of the first select list region to the second will be updated in the table.

Although I could see the values are not being updates. On putting alerts after the value being fetched in the javascript function and clicking the Modify button I can see that no data is being reflected in the alert. Hence the data is not being passed from the second select list APEX item to the javascript function.

View 1 Replies View Related

Application Express :: How To Build A Button On Click Of Which Opens A List Below It

Jun 29, 2013

I have a requirement wherein onclick of button I want to open/close list/popup (which is displayed below button, just like in select list) and can select any item from list to do some action. 

View 7 Replies View Related

Application Express :: On Button Click To Fill Out Form On Same Page As Report

Jun 27, 2012

I have a report that contains a name that I want to pass in to a field in a form on a different region on the same page. My button located on the report is has its own column called ADD_LINK. Here is the button.

<button id="apexir_btn_ADD" class="apexir-button" type="button" value="Add" onclick=""><span>Add</span></button>

Once that button is clicked, I have the form region fade in. The region is called Add Tag to Employee, which has P4_ROWID, P4_EMPLOYEE_ID, and P4_TAG_ID. Once the region is displayed, I want the #NAME# to show in the P4_EMPLOYEE_ID.

I did copy this form from another page, where I had it working before. It made more sense to move it to this page for interface purposes, so maybe that tidbit will work as well.

View 15 Replies View Related

Forms :: Calendar LOV Position (x / Y) On 6i

Aug 1, 2011

I have included a calender control in my form and its working fine.Now, my problem is how can I automatically place the calender next to the text-item (for example, "block.invdate")if the push button is pressed to call a calender.

View 1 Replies View Related

Forms :: How To Make A Calendar

Mar 4, 2003

I have read the messages below about making a calendar but am still unsure of how to go about doing this. I have the STNDRD20.OLB file, but I don't know where to put it or what to do with it! What comes next?

View 20 Replies View Related

Forms :: Make Calendar In Oracle 10g

Sep 15, 2011

I want to make calendar in oracle form 10g, but i don't know make it. How to do make calendar?

View 2 Replies View Related

Forms :: How To Create Calendar In Oracle

Aug 29, 2012

I desire to create pick my date of birth from the calendar. So I have done this. I am using oracle 6i Form developer. I have not find files 'standard' and 'calendar.pll' files anywhere.

View 1 Replies View Related

Forms :: Create Calendar In Oracle?

Jan 8, 2012

How can we create a calender in oracle forms.

View 5 Replies View Related

Forms :: Calendar (Date Picker) In Form6i

Mar 9, 2011

I want to add a date picker calendar on my form on the date field. I learned that process in institute but now forget the process.. Tell me the process and share the calender and standard file.

View 4 Replies View Related

Forms :: How To Attach A Calendar To Date Item

Dec 12, 2009

I am new to the Oracle forms,i want to attach a calender to my form. I followed the below process:

--> I have attached the LOV&Record Group of the item for which the calender is attached as ENABLE_LIST_LAMP LOV which is included in the TEMPLATE.fmb
--> Set the validate from list to 'NO' in the property palette
--> Then after in the trigger KEY_LISTVAL,wrote the code

calendar.show;

while compile the form i got an error component 'SHOW' must be declared

View 6 Replies View Related

Forms :: Error In Calendar Binding And Form

Mar 21, 2011

Getting Error while running my form after including toolbar, calendar and alerts etc..I've created a library and then attached it..but unfortunately nothing special is going.. When I run my program, it first compile and then gives error. When I reach the error, there is this script..

PROCEDURE date_choosen IS
BEGIN
copy(to_char(date_lov.current_lov_date,'dd-mon-yyyy'), date_lov.date_lov_return_item);
go_item(date_lov.date_lov_return_item);
if date_lov.lov_auto_skip = TRUE then
next_item;
end if;
END;

And not moving further. I'm also attaching my this form here. I've to use the calendar on my other 45 forms.

View 3 Replies View Related

Forms :: How To Change Calendar Type (suppose To Arabic) In Oracle

Nov 21, 2011

How to change calendar type(suppose to Arabic) in oracle forms?

View 3 Replies View Related

Forms :: FRM-30047 / Cannot Resolve Item Reference CALENDAR.CONVERTED_DATETIME

Jun 13, 2013

FRM-30047: Cannot resolve item reference CALENDAR.CONVERTED_DATETIME.

LOV TIMEZONES_AND_DATETIME

View 1 Replies View Related

Forms :: Fields Not Getting Disabled In Mouse Click?

Apr 11, 2011

I am using the below code to disable forms field in fdtlblk.mdt_rqr = 'NO'

but I can go there with mouse click ( for tab and enter it is working fine ) .

but for mouse click it is not working .

if (:fdtlblk.mdt_rqr = 'NO') then
go_item('fdtlblk.section_loss');
set_item_property('FUP_RCVD_DT',enabled,property_false);

[Code]....

View 1 Replies View Related

Forms :: Details On Mouse Click Using Like Operator?

Jun 9, 2013

I want to link to blocks using description as there is no relation , for example i have two tables with one field in common called description, and i want to link this field in two tables using like operator.

create table item ( item_code varchar2(12),item_name varchar2(30));
insert into item VALUES('A','HEA160');
insert into item VALUES('B','HEA180');
create table stk (sl_item varchar2(12),sl_desc varchar2(30),sl_qty number);
insert into stk VALUES ('X','HEA160X1000',12);
insert into stk VALUES ('X','HEA160X2000',4);
insert into stk VALUES ('Y','HEA180X3000',10);

Suppose i click on item block item_desc with value on HEA160 all the items similar to that should appear in stk block like 'HEA160X1000' ,'HEA160X2000' , if i click on 'HEA180' on item then 'HEA180X3000' it should come.

View 1 Replies View Related

Forms :: Mouse Click Navigation Validation

May 6, 2013

I would like to know if with Oracle Forms Builder 11g, we can use mouse instead of TAB to validate record? And why Forms Builder use TAB or ENTER Key to validate record? I have a SAVE button, but i want to replace the TAB navigation validation by the mouse click. Is it possible?

View 6 Replies View Related

Forms :: Format Mask Allows To Click Anywhere On The Field

Oct 8, 2012

I have one NUMBER field with size 15. I have set format mask 999,999,999,999,999 on this field. This is formatting the data I am entering in that field. But the problem is if I enter a value in that field and moves to another field. And if I want to edit the previous field again I have to keep the cursor at the left end of the value.

For example I enter 3,000 in the field. If I want to edit the field again, I have to edit it from left like 1,233,000. I cannot edit it at the end(like 3,000,123).

Even I can click anywhere in that field where I have the format mask. check the screen shot in the attachment. In the red square, you can find a value with space in between.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved