Search results for query: *

The vbs is running on the server .. so I assumed this is why the window object wasn't accessible, and why some of the example I've been able to find suggest calling the js (client side) to popup the window. I'll just explain to them that you can't open a browser window on the client from code...

Thanks for your reply, tsuji. I would certainly oprefer to keep it all vbscript .. but when I tried the vbs "window.open" which you suggested, I got an error: .. This is the only reason I tried to call the js function from the vbs page script. I have seen documentation on using window.open in...

I have a vbscript running in a page where the user provides parameters to dislpay an invoice .. and the vbscript provides the invoice in various ways depending on what the user selects, one of which is to popup a window with the invoice formatted for printing. The invoice is built by the script...

HI Vijay Thanks, that gives exactly the results I'm after. I've been avoiding the "LEFT OUTER JOIN" syntax in favour of the "*=" syntax, on the recommendation of an article I read (might have been from Microsoft?) that stated that the "LEFT OUTER JOIN" syntax was...

Thanks Nikhil, but ... The "AND R.match_no IS NULL" clause is the first thing I tried .. but it fails! Instead of returning only the mismatches, it also returns records from #LHS that do have matches on #RHS .. and sets the #TMP.rhs value to NULL for all records (ie: even those that...

Hi folks .. two questions: Q1 = Any ideas on the best way to accomplish the following in only one statement? SELECT lhs = L.match_no, rhs = R.match_no INTO #TMP FROM #LHS L, #RHS R WHERE L.match_no *= R.match_no -- DROP matches DELETE FROM #TMP WHERE rhs != NULL Q2 = How does...

Hi - I'm looking for a tool to format SQL (scripts/queries/SPs) in a consistent manner. There are tools for other languages (HTML-tidy, VB-beautify, etc) .. and I wonder if anyone has come across something like this for SQL? I've heard that MS-SQL Server has a feature somewhere that does...

Hi - I'm looking for a tool to format SQL (scripts/queries/SPs) in a consistent manner. There are tools for other languages (HTML-tidy, VB-beautify, etc) .. and I wonder if anyone has come across something like this for SQL? I've heard that MS-SQL Server has a feature somewhere that does...

Thanks Chris! That seems to be exactly what i'm after. Just struggled a bit with the Recipient.Address property .. I simply wanted to use a regular "xxx@here.com" kind of address, but the Recipient object seems to want to interpret (resolve) address-book entries etc. See, the...

Hi folks Any ideas on how to use the MAPI OCXes without using a form? I need to write a DLL without any need for user-input, and it seems a bit wasteful to include a form that will never be shown, just for the sake of of an OCX or two. I'm sure I'm overlooking the obvious :o)

How does one specify, when building an InstallShield (5.5 Pro) package, that a particular file (File-A) must be installed ahead of another (File-B)? Is there a way to specify that File-B has a dependency on File-A?? Inspection of the help file yields little of value - perhaps I'm looking in...

The order in which you specify the styles is important. you should specify them in this order: A:link A:visited A:hover A:active For more details, see http://www.meyerweb.com/eric/css/link-specificity.html

Thanks folks ! I must get my head around Regular Expressions sometime. But I'll go with Sunaj's suggestion at this time. Thanks again - you're all stars :o)

I'm looking for the most generic way of "unformatting" lots of incoming data that may have a variety of different descriptors prepended or appended to the critical numerical portion, without any knowledge of the actual format to undo. For example .. Val(sX$) fails when sX$ is ...

Yes - yes - yes !!!!!!!!! You're a star, ilses .. my default printer was set to Generic, and switching over to the (previous) HP printer fixed it like magick. I set up the Generic printer some time ago, without suffering any side-effects until now .. wierd? But thank you so much for your...

I forgot to mention ... I also deleted my Normal.DOT file to see if that might help. And I am running Win98-SE on a Toshiba laptop. And it's Office 200 Premium SR-1

I have had Office-2000 Premium running quite happily for about a year now, but recently Word has lost its connection with the system Fonts. Opening Word for a new document: it shows Times New Roman as the default font; but clicking on the font dropdown listbox, shows only Roman 10cpi (not even...

Hey - I did it!! .. I wrapped the Clipboard object in a DLL, exposing only the GetText, Clear, and SetText methods. Now the following script works (: heh heh heh :) ... Set oShell = CreateObject("WScript.Shell") Set oClip = CreateObject("ClipClass.Clipboard")...

Hi folks Does anyone know how to reference the Clipboard from a *.VBS script? I want to write a script that will achieve what the following VB code does .. Shell ("Explorer.exe /n, /e, " & Clipboard.GetText) I can do the Shell-equivalent, but I'm stuck at Clipboard: Set...

Hah - I found it :)) Use the GetFileVersionInfo API, as described at http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/winui/finstlib_5a79.htm