Search results for query: *

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...

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 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 <=...

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...

I am using a TDBgrid. My users can select diffent rows in the grid and based on that selection I create a file.I need to send the index of the selected row and the bookmark to another sub. my code is Dim Bookmark As Variant Dim i As Integer If mMax > 0 And Grd.SelBookmarks.Count > 0 Then...

I need some help with printing a label from file. I have a code that writes to the Zebra printer. What I need is to change my code to read from file and then send that to printer to print the label. As if i need to change something I will have to change only in my file not in the program. My...

I have a tdbgrid. I need to print records from it. In the gris I have a Shipment id that will be same for some records. What I need to do is that when user clicks on Print, I want to summarize records with same Shipment id and only print taht row. For example.I have ShipmnetID Name Loc Qty...

I ahve a problem. I have two gris. I need to compare the results of both grids and make sure that they look same. Lets say that I have 25 rows on Right hand side of grid, then I should have 25 on left. Lets say I have 24 on left I need to capture that row's Id from Right and give message to...

I have a string that looks like this 123!ThisLetter!344 I need to get the letter 'ThisLetter' or in other word letter between first! and last!, because the length of the middle letter can change. Any idea of how to do that. Thanks.

I need some help here. I have two grid Parent and child. I have a column in Parent grid called total Qty. What I want to do is on the form load event and Parent grid click event, i want to populate the child grid from the values of parent grid. I need to keep in mind totlal QTY, and divide that...

Can someone help on how can I make a combo box editable. I am trying to create a combo box and I want that when user types, the combo box should automatically go to the letters typed by user and show him itms that has those letters. I know how to do this in vb.Net, but I don't know what kind of...

I am trying to write a program that can acutally go to a web page and get the reultset for me. Here is how my programme should be. Lets say that I have a part# and I need to add that to my database. I need to check if a part is valid or not. For this when I enter the part number in the textbox...

I am trying to export data from my vb form to Excel file. But I am trying to do it different. I am showing a form to user, in which I ask them which fileds they want on the excel shheet(that will be check boxes) , where they can choose as many fields as they want. Then they need to select a date...

I have a datagrid that i want to get total for a column. The column has Quantity that is of sting type(when get results back from Database).I need to sum up at the end. Also it should get refreshed if the quantity changes. I want to add an additional line to the bottom of DG to show the Total...

I need some help on writing a query that can help me to check for a particular record an dif the record exists, add 1 number to that record. Here is an example. I have two cases. Case# 1. I will get 4 Line# recors for same Pur# and same ItemID.(All fields are varchar)...