VB Forum / VB Syntax / October 2004

I use VBA in MS Excel. I am trying to create files for inputting and saving
the data. The code including the open statement is as follow:
For k = 1 To NoofFiles  
 Open InFileName(k) For Input As #k

I print several text strings in a loop using printer object. After
each string is printed I send a printer.newpage.
The lines that do the work are:
       Printer.Print frm.Text1.Text       'print text.

I have this code block setup within my ASP page using VB Script as the main
language.
I want to be able to return the value of the client side VBScript back to
the main page for processing.

Apologies if this thread is in the wrong forum. Having taken the plunge to
update from VB4 to Visual Basic.NET, I'm having trouble with some syntax.
Specifically, I used to use the Keypress event to send a Tab when the Enter
key was pressed:

I am REALLY new , I have done some simple Basic and QBasic programming, but
VB is new to me.
I want to make a simple program that takes user input data, for example a
VIN Number from a Car and breaks it down into various parts.

In my errorhandling routine I want to have a standard message.
Is it possible to set the message so that the variable can be called from
anywhere and will be populated.  The message will always be the same.
At the moment I have

I want to make a date on a report look like a real date, that is, in England
we say Tuesday 26th October 2004.
Using the Format function, I can say Tuesday 26 October 2004 thus:
Label2 = "Survey Closing : " & Format((dDate), "dddd dd MMMM YYYY")

I have a question regarding referencing the ItemData property of List
and Combo boxes.
I tend to use the following code:
If cmbFoo.ItemData(cmbFoo.ListIndex) = <blah>

I want to be able to cancel the opening of a form if the recordset that the
form is based on (datagrid datasource) doesn't have any records.
In MS Access I would simply say Cancel = True.  How can I do this in VB?
Here is what I have so far but it doesn't work

I am a complete newbie so please bear with me . . .
I have only one form in my project that displays 4 datagrid control totals
based on designers that are base on paramaterised stored procedures in SQL
Server.  At the moment I have entered the values for the parameters but I

I'm writing a macro in excel to create a pivot table but i want to be able to
filter the pivot table for certain individuals and save each version as a
seperate table.
How can I incorporate SQL into the VB code so I can select certain fields

I have a stored procedure in SQL Server that requires a date parameter.
I have a 2 public variables (Date Type) that give a datefrom and a dateto.
The datefrom and dateto are derived using DateSerial.
I believe that SQL needs the dates in "mm/dd/yyyy" format but the variables

For the life of me, someone tell me how to shorten this up to a better
way....I have 13 check boxes on a form and have to scan thru them all to see
if they are checked or not and assign the value futher down....
If Check1.Value = 1 Then

how do you output the contents of listbox to a sequential file that looks
like this
John Kerry 1(800)555-9898
Bob Dilan  1(345)555-6789

I have a workbook that uses a macro to copy itself, save it to another file,
then populates sheets with formulas and such.  Everything works great until a
look up statement.
Below, I have pasted the troubling code in the macro.  The referenced sheet,