Recent content by AFK1

I need to create a formula to display a specific text based on a vlue. I am trying to see if my id is 1234 then split the IDCODE and give me the fisrt value of the delimiter...here is my code... IDCODE= 1234!0009 if ID = '1234' then Local StringVar array Myval local StringVar returnValue...

I have a mathimatical vb 6.0 question. I have a program that inserts records in the system. Here is how it works. I have a MasterQty table and ChildQty table. The user can upate only the child table but keep the ChildQty always equal to MasterQty. ChildQty should not go below or above the...

How about if I want to convert a Char into Int. I have a char value '012345' that I need to insert into int Filed. I need to insert whole value without getting rid of 0.How do I do that then??

I am trying both the codes and I got errors on both codes. 1. Code 1 When I click on Print and the code goes to "Print_Labels", I get an error "By ref argumnet type mismatch" and g_strZPL is highlighted. 2. Code 2 Get error about constants on this line Declare Function...

No...Actually I though its not the array but may be its my grid.thats why i started new thread. But just now I find out that during my call to thebutton, i was erasing my array. thanks

i=0 vBookmark = (CInt(grd.selBookmarks(iRow))) sItemID=vBookMark 'check if I have rows in my Grid array If mlarrayMaxRows<> 0 Then 'Loop through rows Do While i <= mlarrayMaxRows 'check if my second array value is same as grid array. If Array(ITEM, i) = sItemID...

When I loop through my array in same application 2nd time, then it boms and gives error Subscript out of range (Error 9). I loop through array when someone clicks the grid. First time , grid click works fine. then when I click on a Button to get someother info and then click on grid again it...

I try to use.... For iRowCounter = LBound(Array) To UBound(Array) Next iRowCounter I have total of 6 rows in my array. When it get to array 6, it gives error of subscreipt out of range. I really like it, it is lees number of code and you don't need to remember how many line numbers and from...

I removed the redim part from my code and start the rowcounter at 1, and I didn't get any error. vBookmark = (CInt(grd.SelBookmarks(iRowIndex))) sItem= Array1(ITEM, vBookmark) i=1 'check if I have rows in my array If mlarrayMaxRows<> 0 Then 'Loop through rows Do While i <= mlarrayMaxRows...

The reason why I am using Redim again after loading my data is that I was getting that error(same one) and I findout in details of error to use redim. Thats why I added the redim code to my programe.

Thanks for explaing it gmmastros. I think I am not clear in what I am trying to achieve. 1. I load my array from Info. 2. Then I let the user click on grid and I capture the bookmark and match it with first Array's value and match that to second array and if the value matches I load up my...

I tried For iCounter = 0 To UBound(Array, mlarrayMaxRows) and got the same error. Why do you start x = 1, arrays start wiht 0. please help.

I am trying to populate my combo box and text boxes from array, that I already populated. I chcek if a value in an array is same as my gird Bookmark. then populate the combo box. i=0 'check if I have rows in my array If mlarrayMaxRows<> 0 Then 'Loop through rows Do While i <=...

The problem is it boms and doesn't work. It says subscript out of range.

I need to use array to store 10 elements. I am not showing them on any grid or text boxes, I need to hold the values in memory and use them when I need. Here is my code what I am doing --Arrays2 declarations( I have same declaration for Array1) Private Count As Integer Private Array2 () As...