Forms :: How To Set MS Word Document Header And Footer Using Forms 6i

Dec 10, 2010

Now I want to use an existing MS Word file from file system (e.g d: est est1.doc) and add header & footer (e.g docname Page x of x) using Forms 6i.

View 3 Replies


ADVERTISEMENT

Forms :: Printing A Word Document

Feb 9, 2011

I have This Code working on the local form builder after starting the oc4j and run the form. but using OLE2.

but when using the Cleint_ole2 on the application to invoke an object on the client machine.

but nothing happend, while i have tested the webutil configaration and its working fine.

i use this code to print any word document without openning it. and here is the code in when_button_pressed

DECLARE
application CLIENT_OLE2.OBJ_TYPE;-- Declare a object OLE
args CLIENT_OLE2.LIST_TYPE; -- Declare List of Parameters to obj. OLE
begin
application := CLIENT_OLE2.CREATE_OBJ('WORD.Basic'); -- Start a process WordBasic
args:= CLIENT_OLE2.CREATE_ARGLIST;-- Create a list of Parameters
-- Add param. file_name with path(x. c: empmy.doc) :blk01 is my block

[Code]...

View 1 Replies View Related

Forms :: Open New Word Document And Delete It?

Mar 26, 2013

i have one word doc file name is sample.doc

i have 3 buttons in my canvas. 1st button is to open a word document.

codings:

declare
AppID PLS_INTEGER;
begin
AppID := DDE.App_Begin('D:Program FilesMicrosoft OfficeOffice12winword.exe F:DevSuiteHome_1formssamples.doc',DDE.APP_MODE_NORMAL);
end;

2nd button:

i want to delete the existing sample.doc file via forms

i dont know the codings.

View 2 Replies View Related

Forms :: Create And Format A Word Document From 6i

Oct 6, 2011

I need to generate quotation from Forms 6i. A copy fo the quotation is being uploaded. All information in the word document that are highlighted in yellow are taken from a database.

I need to create the document in the format of the uploaded file. There will be some tables also in the document.

View 1 Replies View Related

Forms :: Open Word Document / Excel / PDF From Oracle?

Mar 25, 2008

I would like to open a word document /excel sheet /pdf from oracle forms.

View 20 Replies View Related

Forms :: Open Word Document / Excel And PDF From Oracle?

Apr 29, 2010

does the path of office on the server or on the client PC?

View 1 Replies View Related

Forms :: Ole2 Data From Database To Word Document?

Apr 25, 2007

I am porting data from database to word document.Initially i am creating the table using the following

hSelection := OLE2.GET_OBJ_PROPERTY(hApplication, 'Selection');
hTables := OLE2.GET_OBJ_PROPERTY(hDocument , 'Tables' );
hRange := OLE2.GET_OBJ_PROPERTY(hSelection, 'Range');
args := OLE2.CREATE_ARGLIST;
OLE2.ADD_ARG_OBJ(args, hRange); --Range
OLE2.ADD_ARG(args, 26); --NumRows
OLE2.ADD_ARG(args, 4); --NumColumns
OLE2.ADD_ARG(args, wdWord9TableBehavior); --DefaultTableBehavior
OLE2.ADD_ARG(args, wdAutoFitContent); --AutoFitBehavior
hTable := OLE2.INVOKE_OBJ(hTables, 'Add', args);

But i want to change the columnwidth. As you see above i have 4 columns, in that first column should be double than other column.

peice of code to change th ewidth of column in word document.

View 6 Replies View Related

Forms :: Open Document Present In Shared Drive In Microsoft Word?

Feb 23, 2011

I want to open a word document which is present in a shared drive in Microsoft word from my oracle 10g form.

View 2 Replies View Related

Application Express :: Word Document / Mail Merge With Values From Reports

May 7, 2013

Using apex 4.1.1 , linux , 11gr2

Basically I have requirement to generate a Word doc (letter to a Word mail merge) from a button/navigation link pressed on Apex page which will gather data from the report and fill in values in appropriate place in Word doc.

Is this even possible with Apex with/o BI Publisher

I have Fop installed and tested , PDF works great but excel and RTF is not reading the encoding on attachment download.I am aware of new PDF feature in 4.2.2 but upgrade is just not the scope right now.

View 0 Replies View Related

Forms :: Open Application Word 2010 With Forms Developer 6.0 - Windows 7?

Apr 20, 2011

I have u na forms developer application in 6.0 that generates a Word document. This application runs successfully on Windows XP operating system. We now have PC's new operating system Windows 7 and officce 2010. My procedure reads a specific route where a template in Word which is used to generate the document. In the user's PC application that does not generate the document even shows me an error message. But when I enter my network user with the user's PC and the document genre generates me perfectly. I checked if the user has access to the server path specifies where the template encuntra wish to open and if you have them.

View 1 Replies View Related

Forms :: Secure Web.show-document() - Getting Error?

May 20, 2010

am trying to use secure call to reports from forms using the frmrwinteg.jar javabean.

when i set the implementation class of the javabean area i still have the error FRM-13008 can't find javabean with name..,but i ignore it as i read at the whitepaper downloaded from OTN. and follow all instructions add to java directory,, add to formsweb,, add parameter to basejini.htm

each time i call the report i have been asked to connect and when i run the form my username and password are written to the consol and i still can see them at the html code when call parameter form, my code is

DECLARE

rep_url varchar2(2000);

BEGIN
rep_url:='http://office_server:8889/reports/rwservlet?server=repserver10&report=d:mm-J.JSP
&desformat=htmlcss&destype=CACHE¶mform=yes&userid=';
set_custom_property('block3.userid_bean',1,'WRITE_LOGOUTPUT','true');

[code]...

and this is what is written to the consol

FrmReportsInteg1: Debugging true
FrmReportsInteg1: Adding new userid string "xx/xx@xxxxx"
FrmReportsInteg1: ADD_REPORTS_CONNECT: xx/xx@xxxxx
FrmReportsInteg1: Setting cookie path to /reports/TEST/

[code]/....

i DON'T KNOW WHERE IS THE ERROR THAT MAKE THIS NOT WORK.

View 1 Replies View Related

Forms :: Enable User To Select And Save Any Document Into Database?

Dec 6, 2012

how can i enable user to select and save any document into oracle database and later on choose to retrieve and display it.it should be like windows file open save.

View 2 Replies View Related

Forms :: Refresh Detail Lines When Header Changes?

Oct 21, 2010

My issues is when I changes the data in Header block the detail block should corresponding data immediately related to header on the detail lines.

The form is based on master detail relationship.

View 7 Replies View Related

Forms :: Design A Form With Header And Line Level?

May 23, 2011

How can we design a form with header level and line level. here i need to place a button in header section.when we press that button, line level values should be populate.

View 1 Replies View Related

Forms :: How To Store Word / Excel Documents To BLOB Column

Mar 29, 2011

My client system is WinXP.I want to store a Word/Excel document to Oracle Blob column and choosed the command named "piecewise.exe",it seems a free tool on the web, to store the document to oracle,but occausionally failed.So I need alternative which is stable and available.

View 1 Replies View Related

Forms :: Create A Form To Store Any Excel / Word Files?

Jul 1, 2011

i m using oracle 10g forms.

i want to create a form where i can store any excel / word etc files.

View 6 Replies View Related

Forms :: Generate Unique Document Numbers When More Than One User Inserting In Form At One Time

Dec 5, 2011

I have made one application form where users need to enter some data. This data is getting inserted in four tables. As in for now the data is properly getting saved and retrieved only for one user at a time. But problem arrives when more than one users are simultaneously making an entry and saving the data at one time.Same number is getting generated for the users who are saving the data at one time which should not happen.

View 4 Replies View Related

Forms :: How To Clear Line Records When F11 Is Pressed In Header Block

Sep 4, 2011

I am working in form 6i, EBS 11i. I have below requirement to achieve.

I have header data block A, line control block B. My requirement is, i know that in master detail block, if i press F11 in header block, it will clear the line block, like this, in my case if i press F11 in header data block A, i want to clear the line block B. Is there any way we can achieve this.

View 3 Replies View Related

Forms :: Provide Excel Sheet With Column Header Only In Oracle 6i

Jun 6, 2013

I want to provide excel sheet with column header only to user, with the push button of oracle forms.(i.e user suppose to get the excel sheet when he press the button on the form).

View 3 Replies View Related

Forms :: Keep Track Of Item Value Totals In Header From Items Under Each Activity

Nov 24, 2010

I have three blocks in my form , header,activity and item.One header can have many activities and one activity can have many items.I need to keep track of item value totals in header from items under each activity.

View 1 Replies View Related

Forms :: Populate Default Values In Line Level Based On Header

May 29, 2011

I have two blocks.In header 2 columns are there same columns in line how to populate default values in line level based on header?

View 1 Replies View Related

Forms :: Oracle Report Excel Output Repeated Header In Each Line?

Nov 24, 2011

After running my report I generate into the file by delimited type and then I save as it by XLS extension.The problem is each row of this excel file has header repeatedly!

View 4 Replies View Related

Forms :: User Clicks On Declaration_no From Header Table / Other Records Will Be Displayed

Jun 26, 2013

I need to populate records from a child table when the user clicks on a record in the header table..The difficulty is that the user needs to be able to edit a field from the child table and there could be 1 to many records. When the user makes a change , I don't want the 'do you want to save changes' error to appear..

the user will only be able to update field 'amt'.When the user clicks on 'declaration_no' from the header table,other records will be displayed. URL.....

View 5 Replies View Related

Forms :: Multiple Sort Options / Check Boxes On Header Block

Sep 15, 2013

I have a master detail based transaction form, i want to create three check boxes on header block, based on selection sorting must happen on detail block which has three fields, for example there are three fields item_code,item_name,item_qty, if user selects first check box then sorting will be on item_code, if he presses second then sorting should be based on item_name, likewise if he presses check box three then sorting will be based on qty, if choses two or more fields then sorting will according to that combined order.

View 4 Replies View Related

Forms :: MS Word Rich Text Format In Text Item

Apr 17, 2012

Can I use rich text item on oracle form10G with some simple features like BOLD, UNDERLINE, ITALIC and if possible one more feature like spell check.

I Google my requirement, but mostly I found win word attachment. Further more if I can save this type of data in field then how can I print in report.

View 3 Replies View Related

Client Tools :: Put Footer On A Report That Has A Title

Feb 9, 2010

I am trying to put a report footer on a report that has a title.

However, when I specify the REPFOOTER under the title specification, I get the text after every row in the report. If I put it before the TTITLE definition, I get the TTITLE text before and after the report and the REPFOOTER text after the report.

How do I get the TTITLE to appear only before the report and the REPFOOTER text to appear only after the same report?

For example, if I specify
REPFOOTER 'footer text'
TTITLE 'title text'

the above text prints the TTITLE text before and after the report. and the REPFOOTER text after the report. Is there a way to only have the TITLE text come before the report and the REPFOOTER text after?

View 1 Replies View Related

Reports & Discoverer :: Footer Layout In Main Section?

Oct 8, 2010

I have test in the main section of the layout in forms. I want to print the footer on the first page only. If I go to properties and select print object on first page, it still prints the footer in all pages. How can I force the footer on the first page only.

View 1 Replies View Related

Reports & Discoverer :: Multiple Copies Of Report With Different Footer?

Apr 10, 2012

i am using reports 6i .

i want to Print Multiple copies of report

1 - Customer copy
2- Department copy
3- Finance Copy

Setting the number of copies to 3 will print 3 copies of the report. But i want for each report , the footer should differ.

View 2 Replies View Related

Load Document / Image As Blob?

Feb 24, 2007

I have a table with a blob type field. We need to read scanned documents (doc, pdf, tif, jpg, etc.) from a specified directory and insert relevant data into a table, including the document as a blob.

View 3 Replies View Related

SQL & PL/SQL :: How To Install Excel Document Type

Feb 15, 2013

We are trying to develop one excel sheet from PL/SQL. But the requirement is that we want specific colors and fonts for specific rows and columns. For that purpose, we are using Excel Document Type. But we are getting error that Excel Document Type should be declared.How can we get rid of this error?

View 2 Replies View Related







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