Search results for query: *

I finally got around to writing something about the methodology for transposing row data to column data using plain vanilla SQL. Basically its just a reiteration of my answer to the thread below but I've also included another method for doing the same thing if you have happen to have Oracle XML...

I want to get the symbol, traded volume values and date (for eventual upload to a database) from the web page below. Is it possible using VB6. If not is there another way of doing it? http://www2.dsm.com.qa/GeneralInterface/new_streamer/new.html In order to understand recursion, you must...

I have Adobe Acrobat version 8 Professional Lets say I have a two page PDF document . On page 1 I have some text that says Goto Page 2 for instance. Is it possible using Javascript to alter that text to be a hyperlink so that when a user clicks it it will indeed take them to page 2? If anyone...

Hi, I'm using Adobe Acrobat 8 Standard to convert a large excel workbook (approx 70 individual sheets) to PDF. The workbook has a front sheet with a series of hyperlinks that take the user to one of the individual data sheets. Each individual data sheet also has one hyperlink back to the front...

Hi, first time poster on this forum. Using Adobe Acrobat v8 standard edition and excel 2003. Just now we have a single excel spreadsheet file (workbook) containing 18 separate sheets which we can and do convert to PDF format successfully. One of the sheets in our EXCEL workbook contains a list...

Hi, complete newbie from XSL perspective and would appreciate any help on the following: Given the XML below what XSL would I need to do an equivalent of the SQL SUM(quantity) group by id e.g <parts> <part><id>123<\id><quantity>200</quantity></part>...

My excel/vba sheets are all erroring with this message Run Time Error 76 Path Not found It happens when I do an application.quit from vba I created a test case with a blank worksheet and a one line macro sub test() application.quit end sub On stepping thro the macro sure enough the run...

Hi, I'm using the ADO code below to read two CSV files on my PC as if they were tables in a RDBMS. All its doing is displaying an employee name and their salary. This works a treat. My question is this, say the two CSV files were on a remote server on the internet e.g...

I want to have several cells that run the same macro when left-clicked with the mouse. The first thing the macro should do is find out the value contained in the cell (or the cells address) that was clicked which started the macro. Seems easy but I'm scratching my head over this one as the...

I'm trying to detach an attached file from a notes email using VB. I've pretty much got it coded but for some reason the embeddedobject of the doc is returning empty even though the hasembedded property is true and there is clearly an attached file to the email. Why would this happen and is...

Im using XL97 vba on NT 4 to implement a simple database based on text files. Using OLEDB text driver and everything is OK except when I try using the IN SQL keyword with certain filenames. For example ado_data.open &quot;select stock_name from stock.csv where _ stock_id in (select id...

Hi ,I'm developing an excel 97 vba app. I have hit a problem when deploying it or other machines. I now get the error message &quot; Automation Error&quot; &quot;Compile error&quot; and debugger stops on following line:- set dbcomboreg = NEW connection Sometimes the error is &quot;Invalid...

This is driving me nuts. I have developed an excel97 VBA application on a machine with vb6.0 istalled. The application creates and displays an msflexgrid programmatically. It works fine on my computer but when deployed on other users computers - which don't have VB6 installed incidentally - I...

Anyone found a way of displaying multiple lines in a controltiptext. A few people have advised using vbCRLF, CHR(10) etc ... as the record separator but these display as squares or vertical bars on my machine. Also tried using CTRL-Enter at design time and this doesn't work either. Anyone out...

Using VBA on XL97 and would like to create a multi-line controltiptext. I have tried following code but no luck. userform1.label1.controltiptext = &quot;Line 1&quot; & vbcrlf & &quot;Line2&quot; Also tried ctrl-Enter at design time and no luck. Anyone cracked this?

Hi, I have developed a VB 6 app that uses OLEDB and the MS text driver to read text files from the local hard drive by using code like:- SELECT * from C:\MYDATA\MYDATAFILE.CSV. I want to put the app onto the web. I know that you can create an IIS application using VB6 to do this. However, I also...

Why do the combo boxes on my userform have a 1 to 2 char gap between the left hand side of the box and where the text is displayed. Its set to left aligned text but still theres a gap.

We have an EXCEL 97 spreadsheet containing userforms and controls etc... which we have to deploy to clients which may be running various O/S's i.e Win98, 2000, NT4. Our only requirement will be that their system runs EXCEL97 or above. My questions is are there any utilities available which can...

Apart from setting its enable property to false does anyone know how to prevent the calendar dropping down when you click the drop down arrow on the date and time picker control?

I have a date picker field, a text field and an exit button on my userform. I have coded some validation in the exit event of the text field which works as expected except when I click on the drop down arrow of my date picker control. Although I get my validation message OK it still insists on...