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...
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...
Is there a way to access the text in the internet header of an email message as shown in the View -> Options dialog?
Once obtained, is there an easy way to extract particular fields from the header and display them in user-defined fields and hence displayable in the message list pane?
I'm...
My office has both Access 97 and Access 2000. The Database in question was developed in 97 and works fine on systems using Access 2000. I have writen a import process to import Excel 97 files that comes from an external company. The import code line is as follows:
DoCmd.TransferSpreadsheet...
I can use environ("variable") to read the values from the MS-Dos enviroment variables. The important question is there a way to write to the environment? (ie a "SET" equivalent)
Paul Cooper
You can send arguments to a form using the "Openargs" string as the last part of the Openform method:
DoCmd.OpenForm formname[, view][, filtername]_
[, wherecondition][, datamode]_
[, windowmode][, openargs]
If you wish to send more than...
I am using CreateTableDef method of CurrentDb to dynamically link a chosen table in a set of remote mdb databases. (There is one table in each of databases)
This appears to work except the linked table appears to linked exclusively. When someone else using their own copy of my database links to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.