Search results for query: *

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

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

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.

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

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

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

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

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