VB Forum / General 2 / September 2003

I've managed to create a string SQL query taken from a series of comboboxes,
tickboxes and textboxes, this is created when an actionbutton is pressed.
The question is, how can I display this query? I've looked at doCmd.runSQL
but this doesn't work with select queries. I can create a ...

I would like to Execute this Select Statement...
SELECT MAX(VisitorID) FROM Visitors.
Is there any way to store the result directly into a VB variable??
lngVisitorID = ???

I would like to Execute this Select Statement...
SELECT MAX(VisitorID) FROM Visitors.
Is there any way to store the result directly into a VB variable??
lngVisitorID = ???

I am developing a application in VB 6.0. I need to plot a 3D mesh of
quadrilateral and triangular polygons. I have this working OK in
wireframe. The question I have is what is the easiest way to shade the
polygons so that I can render the surface. Each polygon is defined by

to print a textbox you do printer.print text1.Text, but how to print a label
box???
Jeoren

I am trying to get the delete button to work in my browsw form, but
when I try to run it, it gives me an error "Either BOF or EOF is true,
or the current record has been deleted the operation requested by the
application requires a current record----Run time error #31"  I am not

I am trying to select records from sql server 7.0 to put into a
listbox in my vb app.  If I use my select statement in Query Analyzer
I get the records that I want, however if I use that same select
statement from vb then I don't get any records.

Scenario...
App. 1 (not mine) polls every 1 millisecond looking for a file with an .AAA
extension in a defined sub-directory.
App. 2 (my application) puts  out files into the sub-directory for 'app 1'

I have a program that when clicked i want to print 2000 papers, with the
names adress etc of customers. So it have to print every record.
How to manage it?
Jeroen

I wonder if there is I way I can designate a button (command) to be
activated using the Enter key.  Of course there is a number of buttons in my
interface, but i want one specific to be activated by the use of the Enter.
Thank you in advance

I am trying to write a specialist outlining tool, using the TreeView
control (in VB5 running on W95).
It has gone quite well so far. I have found some very useful info on
how to read and write tree structures to disk, and I've even figured

I placed a list box control on a form.
What must write at DataResource and
at DataField ?
I have write at DataResource :

VB has the possibilty of using arrays as parameters in procedures (like
public sub test( data() as string )  )
To use this parameter I do it like this :
   dim data( x ) as string

I have been writing an application that allows you to post to newsgroups
however, I have reached a brick wall because
according to http://anreg.cpe.ku.ac.th/rfc/rfc850.html you require certain
compulsory information to be sent such as

I have an VB6 application that reads data from an Excel
(97-2000) spreadsheet. But any numeric data comes in as 0.
I have found a work around by accident, which is to try to
import the spreadsheet into Access. Once any spreadsheet