Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. PaulCoop

    Get IE to open XML files in Excel instead of displaying in IE

    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...
  2. PaulCoop

    Get IE to open XML files in Excel instead of displaying in IE

    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...
  3. PaulCoop

    Taskitem Close Event

    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...
  4. PaulCoop

    Double Pipe in a string problem

    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)...
  5. PaulCoop

    Accessing Oracle Report's Object Model

    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...
  6. PaulCoop

    Accessing Oracle Report's Object Model

    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...
  7. PaulCoop

    Automated Client Access Authentication

    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
  8. PaulCoop

    Automated Client Access Authentication

    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...
  9. PaulCoop

    Stopping &quot;save changes&quot; message on subforms when form closes

    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...
  10. PaulCoop

    Current Database Path

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

    Current Database Path

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

    Current Database Path

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

    Current Database Path

    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...
  14. PaulCoop

    CancelEvent fails

    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...
  15. PaulCoop

    CancelEvent fails

    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...
  16. PaulCoop

    VBA access to Internet headers in Outlook

    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...
  17. PaulCoop

    TransferSpreadsheet method in Access 97 and 2000

    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...
  18. PaulCoop

    Enviroment

    I can use environ(&quot;variable&quot;) to read the values from the MS-Dos enviroment variables. The important question is there a way to write to the environment? (ie a &quot;SET&quot; equivalent) Paul Cooper
  19. PaulCoop

    Custom Dialog Boxes---- grrrrr...

    You can send arguments to a form using the &quot;Openargs&quot; 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...
  20. PaulCoop

    Using CreateTableDef method to create shared linked tables

    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...

Part and Inventory Search

Back
Top