Search results for query: *

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

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

Hi, I logged into my local machine running Win2K Pro as local administrator, and tried to create a new COM+ application. But I was shown an error, titled "Catalog Error" with desc as "You do not have permission to perform the requested action. If security is enabled on the System...

Hi, I logged into my local machine running Win2K Pro as local administrator, and tried to create a new COM+ application. But I was shown an error, titled "Catalog Error" with desc as "You do not have permission to perform the requested action. If security is enabled on the System...

Hi, Understand that when I create a COM+ Application, and add in new components(dlls), the dlls will be automatically registered in the registry. Would like to find out whether deleting the COM+ Application will automatically unregister the dlls. Many thanks. Jason

Hi, Normally when we create a VB program in Visual Studio, we'll just use 'MAKE ...' in the Tool bar to create the exe/dll. But if I want to create the exe/dll outside the Visual Studio environment, say, like running a command in Windows or the Command propmt, eg. c:\MAKEVB.exe Jason.vbp. Is...

Hi, I'm trying out the LogonUser function of ADVAPI32.dll with a simple VB program, but it always return me FALSE. The following is the code: ____________________________________________________ Option Explicit Private Declare Function LogonUser Lib "Advapi32.dll" Alias...

Hi, I am new to this VB and COM+ environment, but have to take over a project that uses something like this. So, firstly I would like to have a better understanding of the "story" about VB and COM+. I've a simple sample scenario here, and appreciate it if anyone could help to rectify...