Search:

Dim MyItem as ListItem

Set MyItem = Listview1.ListItems.Add
MyItem.Text = "8888"
MyItem.Key = "8888A"
SEt MyItem = Nothing

To put in a relationship you'll need to use MSHFlexGRid Control.
And a Shaper.

MSHFlexGRid Control.

Shaper

Hope that helps.

Welcome to VBForums
This Function will help you Instr
Check our string functions.

This is more of a statistics question.
I need help understanding poker odds better for a program I want to make.

52 cards. A Single player.
Chance of being dealt a pocket pair.
3/51 right?...

If Msgbox("ARe you sure you want to quit?",vbyesno+vbcritcal,"Quitting?") = vbNo then
blnCancelled = True
End if

Where blnCancelled is a public variable on your form.
Then on the...

Yes.
You could loop and add.

This is just sample Visual Basic


Dim MyRs as Recordset
Dim MyCmd as Command
Dim MyConn as Connection
Dim x&

Welcome to VBForums:

To start out with a program like that, your going to need API's (unless you use a MDI form with a child form and only hide the child).

A place you can look. Action to Make...

Ever time you use the Print#....
It'll create a new line.

You would need to say



Print #fileff, "hello" & "there"
Or
Print #fileff, "hellothere"

Yeah you need to set you objects to nothing.

Private Sub Command1_Click()
Dim MyStr As String
Dim MyArray() As String
Dim MyLoadArray() As String
Dim x&

ReDim MyArray(0 To (List1.ListCount - 1))
For x = 0 To List1.ListCount - 1...

I usually setup a Module for Globals variables.



Global t as Integer
Global t1 as Integer

Great! I'll check that out

I am curious what kind of different approach I'm going to use to program my database applications with VB.NET 2005. I'm new to .NET but pretty familiar with VB6.

Are their any good articles about...

"SELECT tblPrjImpact.impType, FORMAT(SUM(tblPrjImpact.Acres) ,'###.##'), FORMAT(SUM(tblPrjImpact.length),'###.##') FROM tblPrjImpact WHERE..." etc etc

Check out this:
http://blogs.msdn.com/danielfe/archive/2006/05/16/599054.aspx

Hello All I'm new to game development, and pretty new to C#.
I've been programming professional in VB6 for 4 years now and I want to get into game development.

Does anybody want to help make a 3D...

If you mean count elements



SELECT COUNT('MyField') as Items
FROM 'MyTable'

You could through in other fields to count items by something
For example you have a table with Fields - 'Food'...

Search this site or www.codeguru.com/forum.
I'm sure you'll find plenlty of information.

ToolTipText stays on until you move the mouse off the control with the tool tip text.

Just a simple question:
Using VB6

Basically if I just have a connection string and open a Recordset, that action has to establish a connection with the database first the open the recordset, as...

Most of my programming I've used the Lock Type adLockPessimistic.
Without really knowing what it does. I've done a little research and found out what these do. But I still have a few questions:
...

It was actually NOT BETWEEN, but I still forgetted between

Thanks I knew I was just forgetting my basics!

I'm looking for an easy way in SQL to a query similiar to this

TotalAmount <> MyOtherAmount (plus or minus a 1)

OR
WHERE NOT (TotalAmount >= MyOtherAmount - 1
AND TotalAmount <=...

A good wild idea... I haven't approached this problem like this yet... thanks again.

Any Ideas of how to get the data to "shuffle"?

Well I will continue to work with your method of it and see where that gets me!

Thanks again you have been a wonderful help!

szlamany Well I do appreciate all the time you have spent with me to help resolve this troublesome issue!

Thanks for some of your insight... explaining my problem to other people helps me...

Anyway something like this might work?

SELECT * FROM [2tb_PendingData]
WHERE InvoiceNo = ' Oneof the inovices '

Then

SELECT CASE WHEN Type = 0 THEN Price*Quanity ELSE 0 END as Labor,
CASE...

OK So we are building a temp table.
Inserting all the Data from PendingLineItems that doesn't have a realInvoiceNo.



Update @InvWork Set RealDup=(Select Sum(1) From [2tb_PendingDataLineItems]...

It says it has the same InvoiceNo....
The Second on is correct though

There are 256 rows Where realdup = 1

Put this :

listA.ItemData(listA.NewIndex)=iif(IsNull(.Fields(0).Value,"Null",.Fields(0).Value)

Try that out

HERE IS some of the results

There are 2891 rows in this query

There is 443 tickets
There are only 421 tickets with fuel

. BTW There is another group of tickets (Becuase 2 different poeple use this billing system). That...

I do have MSDE Query Analyzer.

I get 422 rows with that query

The VENDORSITemNumber will be '7101-FUEL SURCHARGEA'. That is how I know it is a fuel record

What I was doing before I had that huge SQL was having a recordset open for each lineitem.

IE. InvoiceNo = AAAAAA
LineNumberTotal = '5'


for x = 0 to line-1
Mysql = "SELECT * FROM...

Yes.

But if all the Totals Match broken up (TotalamountofInvoice, TotalLabor, TotalEquipment, totalThird, LineNumberTotal)

Then I would have 2 tickets with the same information which is not...

BTW I am attempting to do this through VB and SQL with multiple recordsets.

Fuel Total is equal to the SUM of the quanity field WHERE Type = 1. For Each invoice