VB Forum / General / August 2004

How to remove blank-lines in a ListBox?
Thanks
M A

Is there a way in VBA to list the methods corresponding to a control?  I am
wrting so VBA code to interface another application that has VBA built in
but does not have good documentation.  I am trying to find a certain method
a control calls and I do not have access to the souce ...

can i lock the CheckBox control?
i dont want to disable it because it should look "alive",
but must be locked so the users couldnt change it's value.
thanks.

Is it possible to create an API DLL in VB, or can you only create COM DLLs?
The reason that I'm interested is strictly because I have a DLL I want to
distribute as part of an Excel VBA solution at a client site, but if the DLL
has to be registered then the application has to go ...

iam having problems using preserve keyword as whenever i add more there's
always one element that iam losing. i'll put down the code here
i've a dynamic array declared in the general section as Dynarray() as string
and in the form load event iam using "Redim dynarray(0,1) just ...

Hi - hopefully this is an easy query for any experts out there!
Suppose I want to know the cust_name & order_no with invoice date > 3
days & 60 days old from the date of invoice, how do I query against
Microsoft Access table via vb6.0 shown on a data report.

I have a simple application that uses an XML file to store it's data. That
means I don't have a seperate database. In order to read the data I created a
DataSet that reads my XML file with the .ReadXml() method.
1.

A thread a few weeks ago about best practices caused me to recall some of
the worst practices I've seen.
I'd like to hear about some of the worst practices you've seen by people who
should probably be in something like human resources instead of IT.

We develop a desk top Application with VB 6.0 and DBASE III as its database.
The Application is working fine.
However, we need to use different indexes on the same table and use these
indexes throug VB on Querying the database based on the requirerement.

Hi, guys!
I have found problems on start Excel using Excel.Application. I can
instantiate de class with no problems but, when I try execute the line
cApp.Visible = True, I get a error. See the sample below:

This is probably a very simple question that I have been over-thinking and
making complicated but the situation is this
I'm making a usercontrol.
I need to access and change its position in its container.

How can I combine elements of an MDI form's menu in a right-click
popup?
The following partially works over a textbox on an MDIChild form:
Private Sub Text1_MouseUp(Button As Integer, Shift As Integer, X As

I am using the code below to create an XML file from the contents of a
recordset. The file ends up with one row with all the information (the file
seems to work fine but it is hard to read/edit). How can I get the elements
to appear on separate lines in the output file. Any pointers ...

what control can be used (vb6) as a link label?
** when the user will click on this control it should
open a Word doc.

Lets say I load a bitmap (b&w) into a picture box.
I need to convert the bitmap to bytes represending the picture.
How do I do that?
TIA