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 Mike Lewis 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: *

  • Users: elac
  • Order by date
  1. elac

    internetreadfile greek or bulgarian characters

    Here is what I should get ... ?????? 91/439/??? ??? ?????????? ??? 29?? ??????? 1991 ??? ??? ????? ???????? and here is what I get ... Οδηγία αÏ?ιθ. 96/47/ΕΚ του Συμβουλίου της 23ης Ιουλίου 1996 πεÏ?ί Ï„Ï?οποποιήσεως της οδηγίας...
  2. elac

    internetreadfile greek or bulgarian characters

    Hello, I'm using 'internetreadfile' to get the source code of some html pages. The problem is that some of the pages contain bulgarian or greek characters. Internetreadfile returns funny characters and I'd like to convert them back to normal characters. Any experience on that? Thanks elac
  3. elac

    Output unicode fields to an html file

    Dear CautionMP, It's working. Great ! Thanks a lot. elac
  4. elac

    Output unicode fields to an html file

    I want to generate an html page from an access table using a VBA procedure. One of the fields contains sometimes Cyrillic characters. I can see them correctly when I consult the table with Access. When I output them to the html file (print #1, MyTable.Fields("Label")), they are converted to...
  5. elac

    Single column to matrix

    I hoped that there was a simple solution but apparently, it's not possible. My table contains on average between 100 and 200 rows. Thanks anyway for your help.
  6. elac

    Single column to matrix

    I use a single column table in my Business Objects report but as there are many rows, I'd like to transform my single column table into a multipe columns matrix. e.g. A B C D E F to A B C D E F Any idea ? Thanks in advance.
  7. elac

    EXCEL VBA INNER JOIN ORACLE

    Hello, Is it possible to write in VBA Excel a 'SELECT' statement with an INNER JOIN between a column of the excel sheet and a field of an Oracle table ? I use an ODBC connection between Excel and Oracle. A little sample code is welcome. Thanks. elac
  8. elac

    Sum in section header

    Hello, My report is made of 3 sections (Sect 1, 2 and 3). In Sect 3, there is a table with 6 columns. Column 6 is a local variable with a formula like '=if <column4> >= 20 then 1 else 0'. I've generated a Sum calculation in Column 6. When I copy/paste the Sum into Sect 2, the result is wrong...
  9. elac

    Sendkeys to close a popup window

    Of course, I could use a FTP commands file with shell in vba. If I don't find a solution to automatically close the FTP client reminder window, I will probably swith to that solution. Thanks.
  10. elac

    Sendkeys to close a popup window

    In fact, I initiate the SendKeys before calling the FTP application because the goal is to automatically answer to the popup window displayed by this application. I tried also the following code : SendKeys &quot;{ENTER}&quot;, False Msgbox &quot;Hello&quot; In this case, it works. The message...
  11. elac

    Sendkeys to close a popup window

    Hi Loomah, I tried your suggestion but it doesn't work even in interactive mode. Thanks anyway elac
  12. elac

    Sendkeys to close a popup window

    Hello, I'm using VBA in MS Access to FTP files from a server and load them into my tables. I found a free FTP client shareware (FCE) in www.marshall.soft but as soon as I open the client from vba a popup window is displayed. I tried to use SendKeys {ENTER},False to automatically close it but...
  13. elac

    WHERE operator and UserResponse function

    I try to define a new variable with the following formula : =MyMeasure Where MyDimension=UserResponse(&quot;MyDataProvider&quot;,&quot;MyPrompt&quot;) I always get a syntax error focused on 'UserResponse'. If I define another variable with formula...
  14. elac

    Inner join report from 2 data sources

    I'm using 2 datasources, one from an Excel file, the other from a DB Universe. If I link the 2 data sources with 2 common dimensions, BO will apply a full outer join. I need to produce a report with dimensions from both datasources but in an 'inner join' way. How can I do it simply ? Example...

Part and Inventory Search

Back
Top