VB Forum / General 2 / April 2007

does any one know what code would allow me to show the average of any
highlighted cells and display it in a message box?
thanks

Good day,
Quickbasic had a command called "Sleep" which accomplished subject
task. Is there an equivalent function or command in VB6?
Thanks,

I have a VB6 app that includes the MSCOMM32.OCX. The application is
installed from an MSI file generated by MS Visual Studio Installer. A
user has installed the app on Windows Vista, with no errors. When she
tries to execute the program however, she is getting an error 339,

Hi there  - I am having problems sending commands to a new USB printer
I am trying to send commands to the magnetic encoder of my card
printer.
The original card printer was parallel and a typical command was as

I have a project that compiles fine form the IDE, but if I try to compile
it from the command line, VB instantly gpfs without any error message.  =:-O
Do you have any idea of what might cause this behavior?
Thanks,

Another day - another wierd occurance.
I created an EXE file on the hard drive. I opened Windows Explorer and
doubleclicked the file to start the program. When I get to the point
where the Msg Box appears, (code below),  I click OK and the message

I'm looking for a way to not have to do this manually...
I have an app that we're adding a "status bar" showing the status of the
current record (unchanged, unsaved, saved) and we're checking the
modified flag in the module to do so.

I was hoping somebody could help me understand what is happening here.
I am not new to VB, but i am new to pointers.
i guess what i want to do is interprocess communication or sharing a
common memory space.

How can I evaluate which form ist the topmost ??
ChFa

I have 2 radio buttons that allow the user to select either a monthly
or yearly display by setting MonthFlag accordingly. The optMonth_click
procedure is as follows:
Private Sub optMonth_Click()

I am trying to get to grips with object indexing, and i have created
10 option buttons and 10 text boxes. The two sets of objects are set
as Index's and I am trying to work out how to create code that will
mean if option1(0) is seletected text1(0) will be enabled and the

How do I connect to sql server using visual basic using odbc? What
connection string I need to pass? I have odbc set up and I can see the
table using dataview. However when I try to write a sql query and
execute vb asks for connection string and no idea what to put in

I have a VB6 application I created.  I uses Excel for some reports (charts
and graphs etc etc)  I have a new client that uses Open Office.  Is there a
way to use VB6 to output to Open Office spreadsheet application?
Any and all assistance is appreciated.

Hello; I'm a little newbie with VB6, and I don't know if there is any
function that could give me the length of a boolean array.
I declared it this way: Dim Answers(32) As Boolean
Could anyone help me please? How could I get its length?

Working in Excel 2003
Beginner - thrown into VBA because of my new job
Attempting to create a subtotal of subtotals in a spreadsheet.
I have to subtotal payment types (MasterCard, Visa, Adjustment, Cash,