Search results for query: *

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

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

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

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

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

Does anyone know how to determine the "File Version" information from a given file? I need to create a listing of executable components (EXEs, DLLs, OCXs) in a specific directory, indicating each one's "File Version": as in the Version tab of the Properties dialog from...