VB Forum / General / March 2007

I have a stored procedure with Order By as:
   CASE WHEN CAST((Left(dbo.[Partial].PartialNumber, 2)) AS int)<50 then
             CAST(1 AS varchar)+(dbo.[Partial].PartialNumber)
   else

Is there an API to return msgbox button captions that will be displayed
according to user's language settings. I'm not looking to change the
captions but to be able to do something like this -
sCancel = "Cancel" ' in user's language

I have a listbox setup with vbTabs and four pieces of information and I want
to keep the 5 newest records and delete the rest. Here is the information in
the listbox:
 72 66.1 103 3/22/07

I am struggling with the concept of using Properties to input viariables for
processing by the Class vs inputting them as Method Arguments.
With Public Properties I can manipulate the data coming in to my Private
variables and I would like to  "call" a Public Property in a ...

Okay, I know that Vista does not like the User saving INI or data files to
the Program Files directory (although it seems to handle both fine through
virtualization, I am told). So, what if I placed my app in a /different/
directory? Like c:\MyApp? Do the same rules apply? Would it ...

I'm Trying to make a program with vb2005express that  connect to any
Microsft SQL data base and  show it's table. I'm having some problems
can anyone help me?
Omar Abid

I made a program that stay as a icon in the System Tray, and I want to
maximize it when someone try to execute a new instance of the program.
   Is it possible?
Thanks

I've written code that uses a thread to read a 70K line CSV file one line at
a time, however, after about 9 to 10 thousand lines into the file I get a
StackOverflowException while the thread tries to update a counter.
I'm sure I'm doing this correctly but if anyone can tell me ...

I've been using VB5 every since it came out.  I picked up a copy of
VB6 on eBay.  When I loaded my first program into it, it was riddled
with "User-defined type not defined" errors.  The errors seemed to all
be associated with beginning Sub statements, but I didn't see a common

I want to export the db recordset to a text file like the following
format,
--------col1--------- ------col2----- -----col3------
9999999999999aaaaaaaaaaa33333333

I cannot figure out how size my form correctly, under any Windows Border
/ Caption Bar / Menu Bar configuration.  By my understanding,
ScaleHeight / -Width is the client area from the "inner" top-left corner
below the Caption and Menu Bars, to the bottom-right corner inside the

Here is my problem. From my code, i want to open an excel file.I don't
want to use an Excel object to do that. My problem is that when I use
the API function ShellExecute, it starts the excel with the file but
in a different workbook every time. I want to have the same behavior

In spite of the fact that Microsoft abandoned this ad campaign on
December 13, 1996 I thought it was especially appropriate when
considering the following:
http://www.forbes.com/security/2007/02/10/microsoft-vista-drm-tech-security-cz_b
s_0212vista.html

G'day folks,
I have a small ToolWindow form aside my main form, displaying Chr(0 -
255) (a character map).  When a user clicks on a character, I want it
pasted to the field with the active focus on the main form.

Here is my problem. I am not able to set a manual pagebreak property in
excel using VB.
I have Excel 2003 and VB 6.0 with 11.0 excel object library.
I have reduced the columnwidth to 2.5