Search results for query: *

Hi Pete, I followed your suggestion, but the txtTotalInsert is still doesn't changed. If I put the checkpoint in the txtTotalHeader_Change event, the system doesn't trigger the event when I enter some value in the subform. I think the on change trigger also need a refresh or explicit focus in...

The f60svrm could be run by root or the Oracle user, depend which user run the adstrtal.sh script. You can test this: stop your apps, and start it again by running adstrtal.sh from the Oracle user. If you are using adstrtal.sh and adstpall.sh, the system will loop by the file name. If you want...

Hi Pete, I have these in my forms: - txtSubtotal (in the subform), with Control Source = nz(Sum([Income_Line_Amount])) --> the total of the subform amount - txtTotalHeader (in the main form), with Control Source =[Income_Line].Form!SubTotal --> the total amount displayed in the main form -...

Hi Pete, Yes, my intention is to have a text field related to a column, and this field is programatically content the value of the txtTotal_Change. I already created one hidden text field, named txtTotal_Hidden with a column as the data source. And I put a code in AfterUpdate trigger in...

Hi Pete, How if I want to have the sum field in the main form is a column in a table? I mean, how can I save the sum into the column, since I have a function as a data source. Any idea? Thanks Irwan

Yes, I get the idea for "month from" and "month to" criterias using two month/year listboxes. Anyway, the calendar is sound very interesting. How you create that calendar? Just curious, you don't need to give the code if you mind. Regards Irwan

bandarna: when creating the data link, you should decide which query act as master query, and which one as detail query. For example your Q1 is master, and Q2 is detail. Then it will automatically create an outer join from Q1 to Q2 (but not vice versa). HTH Irwan

dpankaj: Generally you can put your summary column in the repeating frame that you would like to reset the value. It is usually the outest repeating frame. As long as the repeating frame is expand or variable vertically, it won't be a problem. HTH Irwan

InigoMontoya: I am not sure which version of Oracle Apps that you use. But generally, Oracle Apps is divided to three (or four for release 11 and above) big parts: - Oracle Database - Oracle Forms - Oracle Reports / Concurrent Manager - Oracle Web Server (Release 11 and above) The FNDLIBR is...

ychousa: There are several things you need to check: 1. After you install the database, you should have listener running as a Service. Make sure it is started, and note the Listener name. 2. You need to set SQL Net Configuration so that your Oracle client/SQL Plus can access the database via...

Hi Larry, It works perfectly in my program. Thank you so much. One thing, we don't need the parantheses when call the RowSourceType (at least on my Access :)) Thanks again Irwan

Hi Larry, I would like to know the method for month-year parameter using form. Is it possible for us to make a lookup (combo box) displaying the month-year and user just select that? And how to parse the month-year value back to date again for the query? Thanks Irwan