VB Forum / General / January 2006

Hi, i am creating a basic retail system. i have managed to complete parts of
the system and am currently working on the "order" part of the system.
The problem is that the system should hold hold details on key customers
only. not everyone. when i actually process the order, ...

Hi friends,
            Plz  help me to save the data that is loaded in ole using
excel file to another excel file . I tried to save using binary file.
But after save , when i tried to open the new excel file a message box

Can anyone direct me to code that will mimic Vista's new collapsible
side bar

I have a DLL created in .net when I try to run a function through VB6
in single step mode, it throws an exception error. However if I compile
the VB exe and run this it works fine. It also runs fine when I run the
DLL in debug mode (editor) with the compiled VB. It appears to

I some code for Visual Basic that I can compile into an executable that will
allow me remove part of the the environment path for WinXP, Win2000, and
WinNt.
If Environment path is

Recently I noticed a question about the GMT. I cannot find it now.
vb.net code to get Coordinated Universal Time:
     Dim GMT As DateTime = DateTime.UtcNow
     Debug.WriteLine(Format(GMT, ("hh:mm:ss")))

Anybody have an idea on this one? I can open a hidden Word object from
within VB. Open a Word Document with that object and print the
document to a PDF but the PDF filename dialog shows and spoils the
whole thing.

I have an image in a PictureBox. I would like to create a list with all the
colors shown.  I was thinking reading each pixel in the picture box and
storing the list of colors I'm finding as I read. Is this the best way to
find the distinct colors that are present in the image?

The application is a VB 6 application on XP Pro, which is pulling data
from different sources and displaying it to the user. Started using a
Listbox to display the data, but without a horizontal scrollbar, longer
data could not be read.

If I have
Private Function myFunc()
On Error GoTo end
 ...

I have an image in a PictureBox. I would like to create a list of all the
colors shown in the image.  I was thinking reading each pixel in the picture
box and
storing the list of colors I'm finding as I read. Is this the best way to

Is it possible to display a MDI child form as modal?
I have a form that displays specific text, and a button is used to unload
it. Works fine, but code after the line that loads this form is executed
anyway.

I have always relied on this simple function to see if a file exists or not:
Function bFileExists(strFile As String) As Boolean
   bFileExists = Len(Dir(strFile)) > 0
End Function

Hi, I want to create a VB6 program that displays an event calendar in a
timeline view, month by month.
Rows should represent users and columns should represent dates.
Events has start date/stop date/user and should be blocked in the timeline.

Suppose I had a string which could contain any text. I want to find out if
it contains a "/" (divide) character. Suppose the string contains the
following text "DateAdd("m",3,"01/01/2000")" .
How could I parse the string to determine whether the "/" was a divide or a