Recent content by PaulCoop

rhett135 wrote: [tab]May have found a solution! Add this tag right under the <?xml> tag: [tab]<?mso-application progid="Excel.Sheet"?> Thanks, I added that to the XML Prolog Value parameter of the Oracle Report where it has the xml header. This helps a bit but unfortunately IE is still...

Hi, Currently we are upgrading our Oracle Forms 6i application from client/server model to web model. We use Oracle Reports that can output in a varity of formats. My (internal custom) requires to output a particular report in Excel (not one of the formats supported by 6i). Previously they...

I am trying to write code to alter an MS-Access database when I close a task item in Outlook 2003. I first tried to write some basic code to test the taskitem close event before doing anything more complicated involving Ms-Access. Unfortunately the help files only have an example for the close...

In the atempt to build a dynamic sql string I have run into an interesting yet annoying problem. When I append to the end of a string the concatenation symbol '||' (double pipe) PL/SQL throws an error. A single pipe is ok. Append two single pipes also throws an error. So does the use of CHR(124)...

Doing it as a called procedure is a sensible concept but by putting in a stored procedure means I need a peice of generic code or a different stored procedure for each report. If I create a table with the list of bind parameter names against the report name I in theory should be able to use a...

Is there a way to access from pl/sql, in a in-built report tigger, the report object, as displayed in the object navigator, to read off the properties of selected object without already knowing what those objects are called? (Particularly the user parameters.) What I am wanting to do is write...

After some research I found the following that is available if you have Client Access Express (R440 or later). cwblogon systemname /u userid /p password eg.: cwblogon 10.0.0.1 /u AUSER /p ROVER Yours Paul Cooper

I use MS-Access to run various queries for various reports where some of the data is stored on an AS400. I currently make use of the Client Access ODBC driver to get access to the data. As to be expected I am often asked to authenicate my access to the AS400 libraies when I run these queries...

Version: Access 2000 Platform: NT4 I have a form that has a subform on it that shows a table in datasheet view. (Please note that the source object is a table not another form) If I manually re-order the table via the right-click option menu and then close the form, even though I use the...

Thanks Chickey, but I am using a mix of access 97 and 2000 so I will have to stick to mid$'ing Paul

Talk about not seeing the wood for the trees. :) Cheers Paul

Talk about not see the wood for the trees. :) Cheers Paul

How can I get the full path of the access database that I am running? The aim of getting this path is to create dynamic linking with a table in another access database that exists in the same directory but the database is stored in different locations on different workstations. CurDir() doesn't...

The me.undo doesn't work either. Further debugging has shown that the problem is not that the CancelEvent fails but instead the Oldvalue property is not want it purports to be and in fact contains the new value. I have got round this using a global variable to store the old value. This works...

I have a combo box which contains a list of numbers (1 to 4). On selecting a smaller number I get the Beforeupdate event to count the records in a particular table with a number greater than the new selected number as these records are the ones going to be deleted in the AfterUpdate event. It...