Visual Basic :: Moving Items In An Array

Moving Through Items In A Listview
Am I being a complete , or what? I'm trying to move through the items in a listview, so that I can insert the entries one-by-one in to DB - ie each item in the listview represents a new record in a DB table.

Now, I would have expected (as with all things VB) this to be quite straight forward. Something along the lines:

ListView1.selecteditem.movenext

I know this a bit hopeful, but I can't believe there's no way to incrementally move through all the items.

I've been through MSDN and searched this entire forum for a similar thing but I cant find anything.

I must be missing something really obvious here!

Moving New Menu Items From One PC To Another..
Hi there. I'm using MS Word 2003 in my PC A. I'v built a new menu (e.g. Letter Template with 35 sub menu items (each item built with some macro scripts)) on the menu bar (at the right of "Help") and now I have to work with another PC B. How can I move the new menu items from PC A to PC B without having again to use the "Customise" to add all the menu items in PC B?

Cheers.

Moving Items Up And Down In A Listbox
I just solved this question that I've had for a while.

Thought I'd share the code.

http://cornempire.newezone.com/resou...e/listmove.htm

Moving Items To The End Of The List!
hi!all!
i am looking for a code to move a selected item to the end of the list box!

for example i have a list1 with items
1
2
3
i select the first item ,item 1 and then click the button!
the item should move to the end of the list and the list would look like>
2
3
1
---------------------------

Moving Menu Items
Hi folks, I found a post the other week concerning moving menu items up and down the list by clicking and dragging them to a different place (Like in IE's faves). I was wondering if anyone could find this post as I have spent the last 20 mins looking with no solution.

Any help would be much apreciated

Lucas

Moving Items In A Listbox
Hi, I have a listbox, with the following:

[case 1]
Msg "Hello"
[case2]
msg "hello"

You can place these items on another dialog.
but, I need it to look like:

[case1]
Msg "hello"
... ---->Open a new space for more Messages when you place one.
[case2]
Msg "hello 2"

This is the code I have so far, but it isnt working.

Code:
Private Sub Command1_Click()
Dim newe As Integer

newe = Newevent.EventList(Eventnum).ListCount
Newevent.EventList(Eventnum).AddItem "<Msg>: " & Text1.Text, newe
'This bit is OK, places the message.

If Newevent.EventList(Index).Text = "..." Then
Newevent.EventList(Index).List(Newevent.EventList(Index).ListIndex) = "..."
Newevent.EventList(Index).List(Newevent.EventList(Index).ListIndex) = "<Msg>: " & Text1.Text
'Only one thing to happen for a Case
'Need it so you can have more than 1 Message under
'case 1, case 2,etc... (Move every ListItem down 1?) -Chris

Dim Position
For n = Newevent.EventList(Index).ListCount To Position + 1 Step -1
Newevent.EventList(Index).List(n) = Newevent.EventList(Index).List(n - 1)
Next
Newevent.EventList(Index).List(Position) = "..."
End If
Exit Sub

Unload events
Unload Me

End Sub

Private Sub Command2_Click()
Unload Me
End Sub

Any help would be appreciated

Chris

Moving Items Together From Two Listboxes!
i have two lists!

list 1 list2

math sci
history soc
math sci
drawing fun
physics sci
biology sci
phys.eductaion fun

list1 has the subjects
list2 has the category of the subjects

now i can arrange the second list so that sci goes first then soc then fun
(i have the code for this) but the problem is that together with the category also the subject should move.

so i want them to move together when being sorted!
is there any way to keep them together!
i have done something with listindex and topindex but it is not functional for this case!

Moving Items Up And Down In A List Box...
Hey guys, I was wondering if anyone can help me on how to move items up and down a list box? Also, if I want to move an item start from the bottom to the top?

Please, help me...

Moving Items Around A List Box
hi !
I have yet another short query here..and would be grateful if anyone could help.
I got a list box with a playlist for a radio show..and to the right of it i have 2 more listboxes..one with duration of track and the other with the point in time at which the track starts in the show.
I have 2 buttons below up and down which when clicked on move the selected item up or down in the playlist accordingly along with the related times.
How do i do this ?
Also how do make sure that there is one item selected at aLL times.
any help would be great !

Harpooon

Moving Items In Listbox
im trying to get items in a list box to move up and down im not sure how to do it i dont have the first clue wot to do can anyone help with the code?

Moving Collection Items
I've never used a Collection before and I was wondering how would I go about moving an item from one index to another?

I want to display the item that has an index of 0 and then remove it form the collection at a certain interval. Then I want to move all teh other items up a spot in the collection. (1 becomes 0, 2 becomes 1, etc.)

Thanks in advance.

Edit: Also, is there a fast way to clear a collection other than looping through it all and setting the values to null?

Moving Items Between Listboxes
Hey...

Could someone please provide me with the syntax for moving items in between two listboxes (i.e. List1 and List2)?

I'm having some trouble fiddling about with it. I simple want to be able to add items from List1 to List2 (deleting the item from List1 in the process) and vice versa.

Thanking you in advance...

Moving ListBox Items
Could anyone tell me how to write a sub that allows you to click and drag an item in a listbox to a new index position within the listbox?

Ash

Moving Items In A Listbox
I have a listbox that has several items in it that i want the user to be able to move up or move down. I have two buttons, one for up the other one for down. Anyone know how to do this? Thanks!

Moving All Items From One List Box To Another
I am having problems selecting the first item in the list box. Here is the code that I have written:

Private Sub ZonesAll_Click()
Dim ZoneName As String
Dim ZoneNumber As Integer
Dim n As Integer
Dim i As Integer
n = Me.ZonesNotSelected.ListCount

'I need a line here that will select the top item in the list

For i = 0 To n - 1
Me.ZonesNotSelected.Selected
ZoneName = Me.ZonesNotSelected.Text
ZoneNumber = Me.ZonesNotSelected.ListIndex
Me.ZonesNotSelected.RemoveItem ZoneNumber
Me.ZonesSelected.AddItem ZoneName
Next i
End Sub

Thanks
SLR

Moving Items In A ListView
Hi,
I'm using a ListView to show information. I want the user to be able to click and drag one of the ListView items to move it higher or lower on the ListView. Is there any way to do this? I know that you can do it with command buttons, but is there a way to do it with the mouse?

Thanks!

Moving List Items Up And Down
This is a bit foolish question bu I forgot how to do it.
I want to move items listed in the list box up or down. How do I do it?

Kinjal

Moving Items Up/Down In List Box W/VB
There is another thread in the javascript section with almost the same title, so what I am wondering is if there is a VB version of it. The thread id is

URL

Any help would be greatly appreciated

Moving Items Between Listboxes
I'm having trouble figuring out how to move a list from one listbox to
another using a command button. The idea is to click on a command
button and all items in listbox A will move over to listbox B. I'm
able to move one item using AddItem, but I don't know how to move the
whole list.

Thank you.

Moving Items Between Listboxes
Hello,

I have a form with 2 listboxes (lstUnselected & lstSelected). I want to let the user send as many items as they have highlighted from 'lstUnselected' to 'lstSelected' with the click of a button. The items will then disappear from 'lstUnselected' and appear on 'lstSelected.'

How does this work?

Much thanks!
Ed

Moving Messages From One Sent Items Box To Another!!!
Hi All

Am desperatly trying to allow PA's to send as their bosses and there be a custom rule that moves the sent item from the PA's Sent items box to the bosses sent item box. Ideally this would be automatically and not be a forward.

I have got code to check the from feild on entry to the PA's sent item box and then forward it on to the boss but I then need to populatre the from feild so that I can run a rule at the bosses end!!!

Any help would be great.

Thanks

Nathan

Moving Items In Listbox Down
This code is supposed to move items down 1 spot within the list box with the push of a cmdbutton. I got it to move one item at a time down, but ideally it should move multiple items down at the same time. Any ideas or suggestions would be greatly appreciated. Thank you.

Private Sub cmddown_Click()
Dim Temp As String, Item As Integer

Item = lstShopping.ListIndex

If (Item > -1) And (Item < lstShopping.ListCount - 1) Then
Temp = lstShopping.List(Item)
lstShopping.RemoveItem Item
lstShopping.AddItem Temp, Item + 1
lstShopping.ListIndex = Item + 1
End If
End Sub

Archie Kantzavelos

Moving/Sizing Items On A Canvas
I'm looking for some help/info on how I can move and resize objects (image controls with handles drawn around it) on a canvas (in this case the whole form which is fullscreen); like, for example, moving shapes or textboxes around the page in Word. I've had a little luck trying to figure it out myself, but it's just not working...

Moving Items From One Datalist Box To Another {Access}
Sorry if I'm posting this to the wrong forum.
I've tried searching the site for an answer, but haven't found anything that helped me...

I've got two datalist boxes (using MS Access, if that helps), and I'm trying to figure out how to move selected items from the first box to the second box.
I know that it's probably something really incredibly easy, but I can't get it for the life of me and it's making me want to ram my head against a brick wall.
Any help you guys can give will be much appreciated.

Moving Single Items From One Folder To Another
How do I go deleting a message in my inbox, and have it show up in my Trash? I know this much of the process:

1. Delete the message (Don't need info on this)
2. Empty the listview when the user clicks on the Trash folder (Don't need info on this either)

There's a Step C, which involves retrieving the sender, subject, send date, and message text from the message, just like I did when retrieving new mail. How would I retrieve the data for just that message, and add that to the now-empty listview?

An example of what I want to do would be found inside Outlook Express. Note as it empties the listview when you change folders, and then loads the contents of the selected folder.

Sorry if this seems a little vague, but that's the best I can explain it.

Code For Moving Items Up/down List Box?
Anyone know how to move items up or down the order in a list box. Thx

Moving Items From Listboxes To Table
I want to move rows with items from listboxes to a table. Each listbox is a collumn of items, and I want all items to be moved to the database table one row at a time, and remove the rows from the listboxes when they have been added to the database. I figure I need loop function for this, but I dont have much experience with them.
I tried running the codes bellow, but I get invalid use of property or something at "kategoriliste.ListIndex = fisknummer" etc.
I also have a problem with the insert function to the database, it's giving me "missing operator in query". I tried copying an insert function from another post on this forum and changed it for my needs, but it didnt work any better.

Code:
Public Sub OppdaterIndivider()
Dim MyConn As ADODB.Connection
Set MyConn = New ADODB.Connection
Dim MyRecSet As ADODB.Recordset
Dim alder As String
Dim kjoenn As String
Dim arten As String
Dim kategori As String

For fisknummer = 0 To kategoriliste.ListCount

kategoriliste.ListIndex = fisknummer
familien.ListIndex = fisknummer
populær.ListIndex = fisknummer
kjønn.ListIndex = fisknummer
pris.ListIndex = fisknummer

kategori = kategoriliste.Text
arten = familien.Text
alder = 6
kjoenn = kjønn.Text

Set MyConn = New ADODB.Connection
MyConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:ProgrammeringAkvariespilletAkvariespillet.mdb;"
MyConn.Open
With MyConn
.BeginTrans
.Execute "INSERT INTO Individermaller (artsnavn, alder_mnd, kjønn) VALUES('" & arten & "', #" & alder & "', #" & kjoenn & "#)"
.CommitTrans
End With

Next fisknummer
kategoriliste.clear
familien.clear
populær.clear
kjønn.clear
pris.clear

End Sub
So, can you tell me why the loop and the insert functions aren't working?

Moving Multiple Listview Items Up Or Down At Once
Hi, does anybody know how to move multiple selected listview items up or down at once?

I found the subs below, but they only move one item up or down, even if I have selected multiple items.

Thanks.

vb Code:
Private Enum menmDirections MoveUp = 1 MoveDown = 2End Enum Private Sub MoveItem(ByVal penmDirection As menmDirections)Dim lvwItem As ListItemDim lvwNew As ListItemDim lvwSubItem As ListSubItemDim lngIndex As Long Set lvwItem = lstView.SelectedItem If Not (lvwItem Is Nothing) Then If penmDirection = MoveUp Then lngIndex = lvwItem.Index + 2 ElseIf penmDirection = MoveDown Then lngIndex = lvwItem.Index - 1 End If If lngIndex > 0 And lngIndex <= lstView.ListItems.Count + 1 Then Set lvwNew = lstView.ListItems.Add(lngIndex, , lvwItem.Text) For Each lvwSubItem In lvwItem.ListSubItems lvwNew.ListSubItems.Add , lvwSubItem.Key, lvwSubItem.Text, lvwSubItem.ReportIcon, lvwSubItem.ToolTipText Next lvwSubItem lvwNew.Selected = True Set lvwNew = Nothing lstView.ListItems.Remove lvwItem.Index End If Set lvwItem = Nothing End IfEnd Sub

vb Code:
Private Sub MoveUp(lv As ListView) Dim itm As ListItem, itmNew As ListItem, i As Long If lv.SelectedItem.Index > 1 Then Set itm = lv.SelectedItem Set itmNew = lv.ListItems.Add(itm.Index - 1, , itm.Text, itm.Icon, itm.SmallIcon) For i = 1 To itm.ListSubItems.Count With itm.ListSubItems(i) Call itmNew.ListSubItems.Add(, .Key, .Text, .ReportIcon, .ToolTipText) End With Next lv.ListItems.Remove itm.Index itmNew.Selected = True lv.SetFocus End IfEnd Sub Private Sub MoveDown(lv As ListView) Dim itm As ListItem, itmNew As ListItem, i As Long If lv.SelectedItem.Index < lv.ListItems.Count Then Set itm = lv.SelectedItem Set itmNew = lv.ListItems.Add(itm.Index + 2, , itm.Text, itm.Icon, itm.SmallIcon) For i = 1 To itm.ListSubItems.Count With itm.ListSubItems(i) Call itmNew.ListSubItems.Add(, .Key, .Text, .ReportIcon, .ToolTipText) End With Next lv.ListItems.Remove itm.Index itmNew.Selected = True lv.SetFocus End IfEnd Sub

Listview Report Moving Items Up && Down
Hi everyone ,

I know how to move the first column field up and down in a listview report.

But now i have 10 columns and the user wants to select a row and puts it one down (if its not already at the bottom) or one up (if its not already at the top).

thx

Moving Listbox Items W/ Mouse
does anyone know how to shift listbox items around with the mouse? a good example would be winamp's playlist. the code i came up with works fine...if you move your mouse slowly. if you go fast, it'll pretty much mess up the order because the cursor jumps around when you move your mouse too quickly.

Dim HotItem1 As Integer

Private Sub List1_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
If Button = 1 Then
If HotItem1 <> List1.ListIndex Then
If HotItem1 > -1 Then
a = List1.List(HotItem1)
b = List1
List1.List(List1.ListIndex) = a
List1.List(HotItem1) = b
End If
HotItem1 = List1.ListIndex
List1_Click
End If
Else
HotItem1 = -1
End If

End Sub

Moving Items Between Listboxes (RESOLVED)
Hi, all

I am trying to do simple moving items between Listoxes I have a lbxAll that is populated with all items and lbxSelected that is to contain the selected items. I need a functionality that user will be able to select more than one item and at the push of a button these items will be transfered to the other listbox and removed from lbxAll

This is my code

Code:

'# to loop over all irems
        Dim i As Integer
        For i = 0 To lbxAll.Items.Count - 1
            '# if current item is selected copy it to lbxSelected
            If lbxAll.GetSelected(i) = True Then
                lbxSelected.Items.Add(lbxAll.Items.Item(i))
            End If
        Next

        Dim j As Integer
        For j = lbxAll.Items.Count - 1 To 0 Step -1
            '# if current item is selected copy it to lbxSelected
            If lbxAll.GetSelected(j) = True Then
                lbxSelected.Items.Remove(lbxSelected.Items.Item(j))
            End If
        Next

The first loop works OK items are copied into lbxSelected But I am always getting error when a Item is to be removed I think this is because once the item has been removed the whole index of lbxAll will change... But Is there any way of doing this?

--------------------------------------------------------------------------------

<Signature>

     That boy is our last hope.......................................

     No there is another !

</Signature>

Edited by - pajer on 9/13/2004 4:33:57 AM

Outlook Macro- Moving Items Into Folders
hi - Im trying to get mail from specific addresses to go into appropriate folders, but my code only sorts mail for one address and not the other. What can you see that Im not seeing?

Code:
Sub Sort()

'Dim Variables

' Initialise Outlook App
Dim objOutlook As New Outlook.Application
' Initialise name space
Dim objOutlookNameSpace As NameSpace
' Initialise folders
Dim fldInbox As MAPIFolder
Dim fldOS As MAPIFolder
Dim fldSM As MAPIFolder

Dim fldPersonal As MAPIFolder
' Others
Dim lNumEmailsInInbox As Long
Dim MyMail As Items

' Set the name space to MAPI
Set objOutlookNameSpace = objOutlook.GetNamespace("MAPI")

' Set the pointer to the inbox
Set fldInbox = objOutlookNameSpace.GetDefaultFolder(olFolderInbox)

' Set the pointer to the Test folder (a folder within the inbox)
Set fldOS = fldInbox.Folders("ACM Business").Folders("01 Overstock IN")
Set fldSM = fldInbox.Folders("ACM Business").Folders("02 SkyMall IN")
' How many emails in the inbox?
lNumEmailsInInbox = fldInbox.Items.Count

' Display it on a form
MsgBox ("There are " & CStr(lNumEmailsInInbox) & " messages in your Inbox")

' Initialise Mail items
Dim MyMailItem As Outlook.MailItem
Set MyMail = fldInbox.Items

' If there are any mail items in inbox
If lNumEmailsInInbox > 0 Then

' Loop through each mail in the inbox and move it to the appropriate folder
For Each MyMailItem In MyMail
If MyMailItem.SenderEmailAddress = "overstock-orders@vcommerce.com" Then

'MsgBox ("Moving " + CStr(MyMailItem))
With MyMailItem
.Move fldOS
End With
ElseIf MyMailItem.SenderEmailAddress = "updates@Skymall.com" Then

With MyMailItem
.Move fldSM
End With
End If
Next MyMailItem
Else
Call MsgBox("No emails in inbox to move", vbAbortRetryIgnore, "Warning")
End If

End Sub
Any help would be appreciated
Thanks a lot guys.

Moving Big Array Into Small Array?
I have an array that stores the numbers 0,1,1,1,2,2,3..etc.
I need to create a new array that will store each number once.
So my new array needs to store the numbers 0, 1,2,3. I need to search my "big" array for duplicates.
[code]
bigIndex=1
smallIndex=1
prevValue=0

'to get starting values
smallarray(smallIndex)=bigarray(bigIndex)
prevValue=bigarray(bigIndex)
smallIndex=2

'search bigarray starting at second element
for bigIndex = 2 to arraylen

Moving To The Next Array?
Hi All,

I am still new to VB, so I need a little help please. I am trying to move to the next array in the below code. i know its very simple, but once the "clickbutton" check has been completed for varArray(0) , how do i move to varArray(1)?

Any help would be grateful.

Thanks.

Dim varArray(0 To 1) As Variant

varArray(0) = "http://www.bbc.co.uk"
varArray(1) = "http://www.vbforum..com"

GoToPage (varArray(0))

ClickButton ""
If ClickButton = True Then
WriteToLog "button found"

End If
End Sub

Moving Array Up One
Hello,

I need to take an array of up at 15 (so 0 - 15) and in a loop move each cell of the array up one. Each cell has text so it goes in a circle.

So basically move 0 to cell 1, cell 1 to cell 2, ect...

I've tried it like this:

VB Code:
Dim i As Integer Dim j As Integer For i = 0 To 15 j = j + 1 If j = 16 Then j = 1 End If intarray(i) = intarray(j) Next i

but this does not work because there are repeats of the same cell..

Moving The Elements In An Array Up Or Down A Step
i just got a blackout sorta, can't come up with a single line of code that would help me.

what i want to do is to move elements up or down in an array

exemple

original list:
1
2
3
4
5
6
7
8
9
10

and what i want it to look like when im done:

10
1
2
3
4
5
6
7
8
9

or

2
3
4
5
6
7
8
9
10
1

hope you guys get it, coz right now im a bit lost

Question On Moving Array Data....
Hi, I'm trying to write a program that can move all array elements up to the upperbound.

Let me explain in detail:

Lets say I input this data into an array with 5 elements.(the below isn't supposed to look like code its just kind of a diagram)

'array1(0)' is 100
'array1(1)' is 50
'array1(2)' is 75
'array1(3)' is 25
'array1(4)' is 500

now lets say I remove the data so it looks like this:

'array1(0)' is 100
'array1(1)' is ___
'array1(2)' is 75
'array1(3)' is ___
'array1(4)' is 500

Notice how array elements 1 and 3 are now blank. My problem is I'm trying to figure out a way I can implement a button that when pressed will move the remaining elements up top so it will look like this:

'array1(0)' is 100
'array1(1)' is 75
'array1(2)' is 500
'array1(3)' is ___
'array1(4)' is ___

How would I go about doing this? I know I have to make some kind of for loop that checks each element, but I'm confused on how to move them. Can anybody help me out? Thanks.

Moving Control Array Data
HI Friends,

I have one command button,one text box, and one control array which having 25 indexes.My question is How to move one line to another line data in control array means(if i entered 5 strings each string having five character.

How to move line one string to line two,linetwodata to linethree,line three to linefour,linefour to linefive.if i enter new string in textbox.then lineone move to linetwo so on ..

My code is

Option Explicit
Dim labelindex As Integer
Dim Lineonedata As String
Dim linetwodata As String
Dim linethreedata As String
Dim linefourdata As String
Dim linefivedata As String

Private Sub Form_Load()
labelindex = 0
End Sub

Private Sub Command2_Click()

Dim i, j As Integer

For i = 0 To 4
Label2.Item(i + labelindex).Caption = Mid(TxtYourtext.Text, i + 1, 1)
Next i

labelindex = labelindex + 5

Lineonedata = Label2.Item(0).Caption & Label2.Item(1).Caption & Label2.Item(2).Caption _
& Label2.Item(3).Caption & Label2.Item(4).Caption

linetwodata = Label2.Item(5).Caption & Label2.Item(6).Caption & Label2.Item(7).Caption _
& Label2.Item(8).Caption & Label2.Item(9).Caption

linethreedata = Label2.Item(10).Caption & Label2.Item(11).Caption & Label2.Item(12).Caption _
& Label2.Item(13).Caption & Label2.Item(14).Caption

linefourdata = Label2.Item(15).Caption & Label2.Item(16).Caption & Label2.Item(17).Caption _
& Label2.Item(18).Caption & Label2.Item(19).Caption

linefivedata = Label2.Item(20).Caption & Label2.Item(21).Caption & Label2.Item(22).Caption _
& Label2.Item(23).Caption & Label2.Item(24).Caption

If labelindex = 25 Then

For j = 0 To 24
Label2.Item(j).Caption = ""
TxtYourtext.SetFocus
TxtYourtext.Text = ""
Next j
labelindex = 0
End If

Label2.Item(5).Caption = Mid(Lineonedata, 1, 1)
Label2.Item(6).Caption = Mid(Lineonedata, 2, 1)
Label2.Item(7).Caption = Mid(Lineonedata, 3, 1)
Label2.Item(8).Caption = Mid(Lineonedata, 4, 1)
Label2.Item(9).Caption = Mid(Lineonedata, 5, 1)

Label2.Item(15).Caption = Mid(linetwodata, 1, 1)
Label2.Item(16).Caption = Mid(linetwodata, 2, 1)
Label2.Item(17).Caption = Mid(linetwodata, 3, 1)
Label2.Item(18).Caption = Mid(linetwodata, 4, 1)
Label2.Item(19).Caption = Mid(linetwodata, 5, 1)

Label2.Item(20).Caption = Mid(linethreedata, 1, 1)
Label2.Item(21).Caption = Mid(linethreedata, 2, 1)
Label2.Item(22).Caption = Mid(linethreedata, 3, 1)
Label2.Item(23).Caption = Mid(linethreedata, 4, 1)
Label2.Item(24).Caption = Mid(linethreedata, 5, 1)

Label2.Item(20).Caption = Mid(linefourdata, 1, 1)
Label2.Item(21).Caption = Mid(linefourdata, 2, 1)
Label2.Item(22).Caption = Mid(linefourdata, 3, 1)
Label2.Item(23).Caption = Mid(linefourdata, 4, 1)
Label2.Item(24).Caption = Mid(linefourdata, 5, 1)

End Sub

PLease help Me

Thanks

Moving Items Between Listboxes Using "instr, Right And Left" Functions
Pls help........
I need help using instr, right , and left functions.
I got 3 list boxes, 1 called lstProduct, 1 called lstPrice and 1 called lstTrolley.
When I dbl click on any item in Product or Price it moves the selected item and corresponding price to the Trolley listbox.
What I need to do is , when I dbl click a selection in the Trolley listbox, I need it to seperate the text and move it back into their appropriate listboxes, e.g. "Apples 1.20".
I am new to VB programming so any help with coding would be greatly appreciated.
Thx......

No Of Array Items
Hello, all,

I need to count the number of array items in a text file, so far I have:

Const MyFile As String = "c:windowsdesktop est.txt"

Open MyFile For Input As #1

Dim MyFileString() As String
Dim MyFileLength As Long
Dim i, j As Integer

MyFileString = Split(Input$(LOF(1), 1), "~~")

Close #1

Now, How do I count how many array items I have? ie, the i value if I have to know the upper limit of i for myfilestring(i)? Thanks a lot.

Items In An Array
I wonder why the following code only considers the last item in the array but misses out the others...What am I missing?

Thanks

If Len(Trim(txtInput2.Text)) <> 0 Then
retString2 = Split(txtInput2.Text, " ")

If cboChoice4.Text = "Keyword" And cboChoice3.Text = "any of these" Then

For i = 0 To UBound(retString2)
SQL1 = " Keywords = '" & retString2(i) & "' or"

Next

SQL1 = Left$(SQL1, Len(SQL1) - 2)
End If

Array Items
Dilemma...

I want to let instances of a class have direct access to an array... so they can change the items within an array one at a time easily... is this possible... I tried the code below, but I am not allowed to have 2 get and 2 let property procedures.... any solutions?

I want it so that users can do this:
frmMain.beta(1) = "Blah"

and ALSO this:
frmMain.beta = anotherArray

Option Explicit
Private mvarBetaArray() As String

'so user can retreive entire array
Public Property Get beta() As String()
beta = mvarBetaArray
End Property

'so user can retreive items in the array
Public Property Get beta(i As Integer) As String()
beta = mvarBetaArray(i)
End Property

Public Property Let beta(newBeta() As String)
mvarBetaArray = newBeta
End Property

Public Property Let beta(newValue As String, i As Integer)
mvarBetaArray(i) = newValue
End Property

cheers...

Moving Arround A Control Array Of Txt Boxes
hi could any body tell me how i can use the arrow keys to move between txtboxes in a control array i have 41 txtboxes in the form of 7 columns by 6 rows.

the code i came up with as an idea was:

Code:
Dim iLoc As Integer
txtPuz(Index) = iLoc
If KeyCode = vbKeyUp Then
If iLoc > 6 Then
iLoc = iLoc - 7
txtPuz(iLoc).SetFocus
End If
End If

If KeyCode = vbKeyDown Then
If iLoc < 35 Then
iLoc = iLoc + 7
txtPuz(iLoc).SetFocus
End If
End If

It didnt work properly when set to the forms keydown event. so what code would be best and where would i put the code?

Thanks

Array Moving Tonext Object When Not Suppose To
Can someone please look at this code. For some reason my do while loop is checking the next record when it is not suppose to. Coudl someone look at this and see fi this code is correct or if I need to change somethign in one of the functions.

Thanks,

Ryan

Private Sub cmdRegister_Click()
'Checks the Classes form for valid data. If the data is valid the Register
'button will add up the total hours along with activating the CLear button

Dim i As Integer
Dim blnerror As Boolean
Dim inttotal As Integer

i = 0
blnerror = False

Do While i < txtCourse1.Count And blnerror = False
'Call validation then increment i
If IsCourseHoursValid(txtCourse1(i).Text, txtHours1(i).Text) = True Then
blnerror = False
If IsCourseHoursValid(txtCourse1(i).Text, txtHours1(i).Text) = False Then
blnerror = True
ElseIf IsCourseValid(txtCourse1(i).Text) = False Then
Call TextBox_Error(txtCourse1(i), "Course name must be 2 to 4 characters")
blnerror = True
ElseIf IsCreditValid(txtCourse1(i).Text) = False Then
Call TextBox_Error(txtCourse1(i), "The Course is not defined")
blnerror = True
ElseIf IsHoursValid(txtHours1(i).Text) = False Then
Call TextBox_Error(txtHours1(i), "Course Credit Hours are between 1 and 3 hours")
blnerror = True
End If
End If
i = i + 1
Loop

If blnerror = False Then
'Total Hours
For i = 0 To txtCourse1.Count - 1
If txtHours1(i).Text <> "" Then
inttotal = inttotal + txtHours1(i).Text
End If
Next i
If inttotal = 0 Then
MsgBox " You must enter at least one course."
lblHours.Caption = 0
Else
lblHours.Caption = inttotal
End If
Else
'Clear Label
lblHours.Caption = ""
End If

'Enables Clear button
If cmdClear.Enabled = False Then
cmdClear.Enabled = True
End If

End Sub

Adding Items To An Array
Code:
For x = 0 To (File1.ListCount - 1)
If Left(File1.List(x), 2) = "ep" Then
MyArray(x) = File1.List(x)
End If
Next

The items get added correctly here...but I don't like the way it is working. Lets say this thing doesn't write something to the array until x = 4. Then MyArray(0 - 3) are useless. Can I somehow get rid of all the empty array spots, or is there a way to just add an item to the end of an array rather than a specified position?

Filtering Items In An Array
Hiya

I want to search an array for certain information if I find this information I want to put code in to say don't show thes items. I've started but i'm stuck with filtering the cars I don't want to show

Private Sub cboVehicle_GotFocus()

'Check the age against the car
Dim bolCheck As Boolean
bolCheck = True
intAge = lblShowAge.Caption
If intAge < 21 And recDetails(Index).strLicense = "Over 21 Years Old" Then
bolCheck = True 'If true, don't load these cars into combobox
'?????? need to somehow flag these cars out
Else
bolCheck = False
End If
If bolCheck = False Then 'if false load all cars into combobox
For Index = 0 To UBound(recDetails)
cboVehicle.AddItem (recDetails(Index).strMake) 'populate combo box with available cars
Next
End If

End Sub

Cheers if anyone can help out

Moving Items In An Array

G'day I have a numeric array (20,7).The user is allowed to delete one line (1 to 20).If the used deletes line 7, I need to move all items 8 to 20 down 1 and zero number 20 so I don't have a blank line in position 7Is there an easier way to do it rather than a for/next loopPeter.

G'day

I have a numeric array (20,7).

The user is allowed to delete one line (1 to 20).

If the used deletes line 7, I need to move all items 8 to 20 down 1 and zero number 20 so I don't have a blank line in position 7

Is there an easier way to do it rather than a for/next loop

Peter.