Recent content by jasontektips

Hi Sem, would you be able to add on the codes I've provided .. Sorry as I dun really know how to define explicitly .. Thanks :) Jason

Hi, I have a simple script to spool all records(data) from a table into an EXCEL file. But the header(ie. column names) gets truncated if the data field length is shorter than the column name. See below: spool d:\testtest.xls; set markup html on; set pagesize 9999; select * from my_table; set...

Hi, Thanks for the info. But still having problem with the Win98SE boot. Didn't manage to get the USB driver from the hyperlinks either. Would appreciate it if you could help to create a DOS bootup disk image that can read the external CDROM, as well as the NTFS partition if possible. Thank you...

Hi, I have a laptop installed with WinXP on the NTFS partition, with external CDROM via USB. Also, I have a Win98 boot disk in which I use Nero to burn to CD i.e. a Win98 bootup CD. I've also included some files/programs inside the CD. My intention : After inserting my Win98 bootup CD in my...

Hi, Is it possible to refresh another browser from the current browser? Eg. I have a session in browser A and after clicking a button, it'll launch browser B. After some processing in browser B, I want to refresh Browser A. Something like browser A is a Display "select" from database, and...

Hi, I've been trying real hard to install a wireless client on my Win2000 Professional labtop so as to hook on to my already-setup-and-working-fine home wireless LAN. I've purchased a ENZER SkyRoam 22Mbps PC card (model EWM122), and as instructed by the user manual, I installed the wireless...

Hi, Just a quick one ... can any kind soul help to provide the code to convert string to date, please.. I have the following string: sDay="03", sMonth="07", sYear ="2000" I want to convert this to a datevalue. Please note that I want 3rd July 2000, and not 7th March 2000. Many many thanks. JAson

Hi, Would like to find out whether it's possible to run a scanner exe command with parameter. Eg. A HP 3-in-1 printer with scanner capabilities C:\Program Files\Hewlett-Packard\hp psc 700 series\bin\Hposcv07.exe c:\mypics\me.jpg When I run the above command, it will start the scanner to...

Hi, Would like to find out whether it's possible to run a scanner exe command with parameter. Eg. A HP 3-in-1 printer with scanner capabilities C:\Program Files\Hewlett-Packard\hp psc 700 series\bin\Hposcv07.exe c:\mypics\me.jpg When I run the above command, it will start the scanner to...

Thanks guys for your advice .. Appreciate it :)

Hi, Appreciate it if anyone can advise me if I want to find out the total number of lines(of code) in my .vbp(including files like .frm, .cls etc). I suppose the manual way is to copy and paste the program(after launching VB) in a text editor that will show the total number of lines. This...

Hi Jonhwm, hey thanks :) I tried the codes and it works. I manage to launch the Acrobat Reader from the CD too. But one problem, I need user to select their CDROM drive (by using the Drive control) so as to get the full path of the acrord32.exe and the pdf file that is residing in the CD. Is...

Hi, Actually I'm trying out on a project with a simple search engine VB application that'll search in a fix pool of pdf files for some pdf files of interest, and upon clicking on the selected pdf file, the Acrobat reader application will launch with the pdf file. All these, that is the VB...

Hi, Is there a way to launch a pdf file in Acrobat Reader from a VB application? For example, I have a simple VB standalone application to search for a pool of pdf files, and upon clicking on one of the pdf files, VB will launch Acrobat Reader and the pdf file appears. Would appreciate deeply...

Hi, I tried to open a VB file(DoAuditTrail.cls) that was coded by someone else and I receive the following message. 'DoAuditTrail' cannot support MTS Transactions in this type of project. The MTSTransactionMode property has been removed. Appreciate it if someone can enlighten me on this...