Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Niki_S
  • Content: Threads
  • Order by date
  1. Niki_S

    How to insert excel sheet into sql server using vb 6?

    I have a excel sheet as below, And now I want to get these data into my sql server as below, When inserting data into my sql server I don't want to insert duplicates and null records. How can I do this? Thank you.
  2. Niki_S

    Error in Excel/VB6 function: "Constant expression required"

    I got this error in this highlighted line and I want to read these ranges and get data into my array. Private Sub VSFlexGrid2_DblClick() Dim oXLBook As Excel.Workbook Dim oXLSheet As Excel.Worksheet Dim Style_no As String Dim Line_no As String Dim vArray As Variant Dim Array1(D12 To H138...
  3. Niki_S

    How to merge two variables into one in VB 6?

    I have two arrays as below and I want to merge them into one. How can I do that? Dim vArray() As Variant Dim vArray1() As Variant vArray = oXLSheet.Range("E12:E140").Value vArray1 = oXLSheet.Range("U12:U140").Value cboOperation.Clear For lngRow = LBound(vArray, 1) To UBound(vArray, 1)...
  4. Niki_S

    How to read excel with a gap in vb 6?

    This is my code. SMV1 = oXLSheet.Range("H12:H138").Value cboSMV.Clear For lngRow1 = LBound(SMV1, 1) To UBound(SMV1, 1) If Not IsEmpty(SMV1(lngRow1, 1)) Then cboSMV.AddItem SMV1(lngRow1, 1) End If Next lngRow1 The format of the excel is as below, [highlight...
  5. Niki_S

    How remove duplicate values when taking data from excel to VB 6?

    My code is as below and I want to remove duplicates when taking data from excel. vArray = oXLSheet.Range("E12:E140").Value vArray1 = oXLSheet.Range("U12:U140").Value cboOperation.Clear For lngRow = LBound(vArray, 1) To UBound(vArray, 1) If Not IsEmpty(vArray(lngRow, 1)) Then...
  6. Niki_S

    How to use 2D array in vb 6?

    I want to get my excel data into a 2D array. For that I did something like this and I want to know the way of getting data to my array. Private Sub cmdExcel_Click() Dim oXLApp As Excel.Application 'Declare the object variable Dim oXLBook As Excel.Workbook Dim oXLSheet As Excel.Worksheet...
  7. Niki_S

    How to read an excel file using VB 6?

    I have an excel file as '29587643' and the location is Desktop\29587643. Now I want to do something like this. I have a textbox as txtStyle and I want to search the excel file location using my txtStyle. It means if the txtbox value is 295876438 I want to get my 29587643 excel file. And I want...
  8. Niki_S

    How to insert data into a grid by using another grid in vb 6?

    I have two grids as grid 1 and grid 2. the structure of them is as below, grid1 styleno lineno garmenttype startdate enddate 120 1 pan 2022-01-01 2022-01-05 150 1 skt 2022-03-01 2022-03-10 And what I want is when...
  9. Niki_S

    How to use a combo box to get data from SQL?

    I have a combo box as Combo1 and I want to get data from sql by using this combo box selected value. For that I did my code inside the click event in my combo box. But it is not ok and it says "method or data member not found". This is my code, Private Sub Combo1_Click() Dim sqlqueryVw As...
  10. Niki_S

    How to get data from sql into a combo box in vb6?

    I want to get data from sql server into my combo box. These are the few steps that I did and I want to know how to insert data to my combo box? Private Sub Form_Load() Call fxSETConnection(ServerType2) Dim rsreportSw As String Dim LnOD As ADODB.Recordset 'rsreportSw...
  11. Niki_S

    how to get data into a cursor from grid in foxpro?

    I have a grid as Grid1 and the columns are as below. Stylecode OrderQty ReceiveQty CD123 100 75 NHG345 125 125 JK87 500 200 Now I want to do something like this. When I'm selecting a row from my grid I want to take that row data into...
  12. Niki_S

    How to display an excel report in foxpro?

    I have a cursor as 'Absent_xl' and I want to create a excel report using this cursor data. And for this I'm using two options such as, "optexcel and optpdf'. Whe I'm selecting 'optexcel' I want to display the excel report. How can I do this? Thank you
  13. Niki_S

    How to display a message box in foxpro?

    I have already add my messagebox like this. But I want to do some changes. SELECT Absent_xl IF RECCOUNT()>0 Mesage=Messagebox("Do you want to print excel report?",32+4,"Message") IF Mesage=6 namefile= PUTFILE('Excel File:',"Name_file",'xls') IF !EMPTY('namefile') COPY TO...
  14. Niki_S

    How to get missing dates between two dates.

    I have to get missing dates from sql server and my sql server table is as below, dDate 2022-01-01 2022-01-04 2022-01-05 2022-01-06 Now I want as below, when I enter 2022-01-03 I want to get 2022-01-02 and 2022-01-03 as my final result. How can I do this in vfp9? Thank you
  15. Niki_S

    How to calculate date difference between two dates without sunday?

    I want to get date difference between two days without sunday. It is something like this, 2022 - 08 - 20 (Saturday) 2022 - 08 - 23 (Tuesday) 2022 - 08 - 24 (Wednesday) If I input 2022 - 08 - 22 as my date I want to take the difference as 1. How can I get the difference without sunday? Thank...
  16. Niki_S

    How to insert time filed into sql table?

    I have a sql field as below, timein (time (7) ) And now I want to isert data to that field using foxpro. For that I have a filed in foxpro as 'timein'. How can I arrange my foxpro field to insert time field? Thank you.
  17. Niki_S

    How to insert data into a cursor using SCAN ENDSCAN?

    Hi, I have a cursor with several designations as below, cItem ACCOUNT ASSISTANT ASSISTENT OFFICE In here if ACCOUNT ASSISTANT the results are , cFact nEmpNo cFullName SGL 1 ABC Perera SGL...
  18. Niki_S

    Data type mismatch

    I have a checkbox in my grid. When I'm going to select using the checkbox it says, Error in check2 - Value: Data type mismatch I set currentcontrol = check2 and sparse = .T. in my column. How can I fix this issue? Thank you
  19. Niki_S

    How to create a multiselect combo box?

    I have a combobox as "cboDes" and there have some designations as below, ACCOUNT ASSISTANT ASSISTENT OFFICE BOILER OPERATORS CAD ROOM ASSISTANT CANTEEN HELPER CARPENTER CLERK...
  20. Niki_S

    Create cursor and replace data to the cursor.

    I have a cursor like this and I want a varchar field. <Create Cursor Emp_Dtl(cFact C(5) Null,nEmpNo N(15,0) Null,cFullName C(60) Null,cDepartment C(50) Null,dJoin D Null,dResign D Null,Months int Null,Years int Null, Days int Null, Period c(100) Null) SELECT Emp_Dtl Append From...

Part and Inventory Search

Back
Top