I am trying to write a simple VBA program for a spreadsheet. However I
am stuck. I am learning this as I go along so that is the big problem
no doubt. I need to copy a sheet and rename. Simple eh? I copy it no
problem but cannot figure how to change the copyed name (now

How can I manipulate Datasets, such as getting a specific row based on a key
column value.  Of course, I could loop through all the rows in the entire
dataset each time I needed something, but is there an easier way?  I want to
be able to execute the equivalent of SQL statements ...

I am new to OOP and new to VB.net and have an object/Class question. I want
to create and array of objects. Each object needs to have a Property that is
and array.
Basicly here is what I have to initialize my objects

This doesn't work:
       Dim t As DateTime = DateTime.Now
       Dim a As Long = t.Ticks
       Dim t2 As DateTime = t.AddSeconds(1)

I would like to know how I can make my program to open the file I double
clicked on in a folder.
So I've associated the file with the program, but when I double click on it,
it starts the program, but the file is not opened with it.

I am using the ReportViewer to display and print work orders. I have a
ServiceTicket.rdlc which displays all of the information for one
ticket on one page. This works fine, but what I need to do is have a
report that will show all of the service tickets for a specified

My current code paints a rectangular area at the top (under the menu and
tool strip) and bottom (top of the status strip) of the main form with a
linear gradient.  The problem is that when the form is resized or maximized
for that matter, the form still displays the last areas that ...

If I use this code:
   Dim ci As New System.Globalization.CultureInfo("en-US", False)
   Dim newCi As System.Globalization.CultureInfo = CType(ci.Clone(),
System.Globalization.CultureInfo)

Hello. In project Visual Studio 2008, Visual C#, Windows Forms Application,
I have written down such code on C# without errors:
       [Flags]
       public enum WindowStyles : uint

I've already disabled of the menu but when I press <ALT>, it still can be
focusd.
How can i disable this?
Thanks

Newbie question:
I have created a custom query using the Query Builder, and it shows up
as a QueriesTableAdapter entry in the .xsd file. Now, how do I make
the results of this query available to a grid object on my form? IOW,

I've got an application that builds a URL string from user input (textboxes
etc).  I need to replace all special characters to the HTML entity thingies
(like "$" to "%24").
Is there an easy way to do this without a huge list of the String.Replace

Whats the easiest way to round numbers up.
For example,  a calculation that results in a value of 1.3 will round to 1,
and a calculation that results in 1.8 will round to 2.
My issue that I want the 1.3 to always round up to 2, as to round down to 1

i need to write a simple program that will convert wave files, from
PCM 22Khz 16 bit Stereo to PCM 8KHz 8 bit Mono.
I don't know how to use windows to do this. I tryed to check If Sound
Recorder accept command line to use it for conversion with no success.

All,
  What are your thoughts about using a learning product like AppDev's CD
tutorials to learn VB2005 / 2008?
Is it worth the money ($850 - $1,250)?