VB Forum / General / July 2004

is it possible to stop a common dialog from being closed when the user presses Enter or clicks the 'OK'/'Open' button?

I have made a program in VB6 which displays lots of information as a
text.
I have used labels all places, which is giving me not good facilities.
can anybody tell me some control which allows me to put fancier text

I am converting a VBA MDB application into VB EXE.  Is there any documentation that would give me a dictionary of which VB methods to use for a particular VBA method?
My current problems are DoCmd.Setwarnings and DoCmd.RunSQL.  What would be the equivalent in VB?
many thanks
george

For a VB6 program I created help pages using Word and saved them as .rtf
files which I display within rich text boxes. This works great since it lets
me include bolded and coloured text etc. However, I would like to print
these help pages when the user clicks on a Print button on ...

I have been experimenting with split(). I was surprised to observe the
following result:
a=split("aaa bbb  ccc   ddd")
for i=lbound(a) to ubound(a): ?"a(" & i ") = |" & a(i) & "|": next i

Hello Friends.    Somebody knows where I can find the different sort
methods and search like quicksort, shell, binary search, etc in VB NET.
Thank you.
Gracias.

I have a checklistbox control on one of the panes of a tab-control. Whenever the user clicks a different tab then comes back, any checks in the box are erased. Can this be prevented ???  None of the other control types (that I have used anyway) lose data between tab-switches. At ...

I replaced my 20 G HDD with a 80 G HDD. I copied the partitions from
the old to the new drive with Partition Magic version 6.
<skipping a few steps>
1) After changing drives, it took 8-10 minutes to boot off the new

Can you add an animated gif to a VB 6.0 Form?
I can break it down and use the image and timer control, but that doesn't
seem like a good approach.
Is there a better way?

I need to generate a random sequence of numbers and letters that is no
longer the 8 characters.  How can I do that?
rafael

Do u know how to export a dataset or datagrid to excel spreadsheet. I
know one method but it uses COM component(through Interop), i want 100%
.net code.

What's the recommended way to handle optional arguments that are not
of type Variant?
Apparently, the IsMissing function only works for type Variant
arguments. Is that correct?

I've posted a question trice on this NG today. The post appears for a few
minutes and then it is gone. Any ideas of what is going on here?
Wayne

I have problem to impersonate a user to access the encryptd file, I hope someone can help me.
The following is the code:
     ulResult = LogonUser(username$, ".", _
        password$, LOGON32_LOGON_INTERACTIVE, _

  I have been developing a VB6 database application that
uses an Access database as its datasource.  A couple of
days ago, I accidentally deleted that database file.  The
next day, I downloaded and installed a recovery program to