VB Forum / General 2 / October 2004

Here goes:
     What do u suppose is the advantage of using Access (Office 2000)
to manipulate a SQL server database? Here's the deal: I work at a
construction supply company. about 2 years ago,,, the owner decided to

I have produced a form where a person enters a figure in text1.text click on
calculate button - answer appears in text23.text box - ALL OK THERE ...But
I have added a button called Reset - And I would like Text1.text and
Text23.text box to clear so can enter a new figure in text1 ...

I'm scrolling by Order_# where I find and display on screen the < (lesser
then) value of Order_#. Here's the syntax:
 "Select * From Orarchd Where `Order_#` < " & lngOrderNumber & " Order By
`Order_#` Desc"

That is the question. What is wrong with this sentence?
"Select 123.idunit, 123.unit, description from 123 inner join mainunits on
123.idunit = mainunits.idunit"
When I try to open those two tables in a INNER JOIN sentence, I receive the

Looking for a resource to do ADO connections within the code like I'm
used to with VB6.  I like to handle the navigation within the code and
updates.  I have several programs in VB6 that access SQL/2K and
Access/2K and would like to move them to VB.NET and ADO.NET.

Is it possible to make a VB6 application to change a computers
WORKGROUP name, share a folder eg. C:\SHARED and set attributes such
as write/read-only.
COuld you point me to any example snippets of code that show this.

I need to write a VB6 application that logs into a password-protected
web site and downloads some files from it.  Does anyone know of any
components I can use that do most of this for me?    I don't mind if
it's Visual Basic code or ASP code.

I have been offered Visual Basic 4 professional plus three programming
books for next to nothing. As this is an older version of VB, I was
wondering if it is worth my while to learn this version? What possible
problems may I encounter by using this version that other versions may ...

Anyone ever seen the "Make program.exe..." command grayed out on the file
menu in VB6?
TIA

I am new to Visual Basic and I have a problem that I cannot put my
finger on. I am working on a school project and I am getting some serial
data from a microprocessor. I have designed my "Do" loop to wait for
each data set coming in at intervals of about 1/2 a second from the

I'm scrolling by Order_# where I find and display on screen the < (lesser
then) value of Order_#. Here's the syntax:
 "Select * From Orarchd Where `Order_#` < " & lngOrderNumber & " Order By
`Order_#` Desc"

I am using the module below to play a WAV file.
Is there any way to tell when the WAV is finished playing so I can
restart it, to get it to play in a loop? Or do I have to use direct X
?

I'm looking for a good TreeView control (OCX) for VB6. Most are made for
.NET. I'd like something with the functionality of the excellent
PureComponents TreeView (which is, unfortunately, .NET only). Anyone have
any suggestions?

Hi guys,
Is there an API to grab the actual size of a font, without vertical
and horizontal spacing ?
IOW, i want to position a character's first point at exactly X and Y

when i load a textbox at runtime, then unload it en then load it again i get
an error objecy already loaded?
It realy unloads becouse it desepears from the form!!!
howcomes?