Search:

Type: Posts; User: meho2020

Page 1 of 2 1 2

Search: Search took 0.02 seconds.

  1. conversion from string to type double is not valid vb.net

    Dear All

    I am working in a master detail form with a primary Key connected with TenderID As Primary Key in Table "tbl_Tenders_Main" and Foreign Key in table "tbl_Tenders_Sub"

    When I input data...
  2. how to refer to control name in crystal report

    Dear All

    I'm trying to write code in crystal report Viewer and I can not refer to control in the detail Section in crystal report

    I'm using this code


    Imports...
  3. How to draw line programmatically for controls in detail section in crystal report?

    Dear All
    I want to draw line programmatically for controls in the detail section in a crystal report depending on the amount of data in 3 controls without merging these controls together, I have a...
  4. Empty radio Button Doesn't Show in the Crystal Report

    Dear All

    I have a Crystal Report with a string field (ATD) in Query (TendersCurrent) which I want to be shown as radio button , I made a formula field and added this code to it


    if...
  5. Re: External table is not in the expected format error ?

    Thanks your effort, However I found where is the problem, The code should run when the folder contains only excel files without any other files or folders, that's why it gave this error , when it...
  6. Re: External table is not in the expected format error ?

    MyCommand.Fill(DtSet, "tempTable")
  7. Re: External table is not in the expected format error ?

    The Full Code


    Private Sub GetBBSDataOLEDB()
    If FolderBrowserDialog1.ShowDialog = System.Windows.Forms.DialogResult.OK Then
    DataGridView1.Rows.Clear()
    Dim...
  8. External table is not in the expected format error ?

    Dear All

    I am working on vb.net application and I have a code which does a certain job and it is working but sometimes it gives me this error with some excel files and it is working with other...
  9. How to include .mdf inside vb.net without using SQL Express on other users machines

    Dear All

    When I Add .mdf file inside VB.net Application Under the Debug Folder and refer to it using this code


    mycon = New SqlConnection("Data Source=.;Initial Catalog=" &...
  10. How can I put a code in the print event of the detail section in crystal report?

    Dear All

    How can I put a code in the print event of the detail section in crystal report like access ?

    Thanks, Regards
  11. How to link between parent and child in visual basic 2019 form ?

    Dear All

    I want to link between Parent Form with controls and Child Form as a data grid view , I made the SQL connections, the problem is when I navigate the parent form the child form does not...
  12. Re: Data Grid Replaces the next File Data instead of copying after the first file

    Dear Paul

    Great Thanks to you, your idea worked fine, I was desperate and you made my day, Thanks, Again
  13. Re: Data Grid Replaces the next File Data instead of copying after the first file

    Dear Chris

    Which part of the code do you want me to change, the code is running and reading correctly but I am missing how to get the data of next file to be shown after the first one in the data...
  14. Re: Data Grid Replaces the next File Data instead of copying after the first file

    Dear Chris

    I took your amended code and pasted it as it is


    Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
    If FolderBrowserDialog1.ShowDialog =...
  15. Re: Data Grid Replaces the next File Data instead of copying after the first file

    Dear Chris

    Thanks your reply, However it gives the same result, I think we need something like getting the last record and paste after it , can we do this in data set?

    Thanks, Regards

    Moheb...
  16. Re: Data Grid Replaces the next File Data instead of copying after the first file

    Dear Chris

    The loop searches the Specified Folder by Browser then it opens the 1st File and copy the selected columns in the Schedule Sheet and paste it in the Data grid then it goes to the next...
  17. Re: Data Grid Replaces the next File Data instead of copying after the first file

    Dear Chris

    Thanks your reply, However your code is difficult for me , the point that my code is working and it reads the 1st file then it reads the 2nd file but the error is it is replacing the...
  18. Data Grid Replaces the next File Data instead of copying after the first file

    Dear All

    I am having a code which copies excel files data from specific folder and paste them to Data Grid view.

    The Data Grid Read all data of all files but the problem that it does not give...
  19. Re: How to Browse Files While Using OLEDB Connection in the same time

    Dear jmcilhinney

    It is the core of the system which are developing is to loop through folder and get the specific columns data from the first file then the second until we finish the files and we...
  20. Re: How to Browse Files While Using OLEDB Connection in the same time

    Dear jmcilhinney

    Thanks I used File.FullName and it gave me the first file, now How can I call Directory.GetFiles

    Regards

    Moheb Labib
  21. Re: How to Browse Files While Using OLEDB Connection in the same time

    Dear Jmcilhinney

    Thanks your reply , However when I use


    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" & File & "';Extended Properties=Excel 8.0;"

    it says Operator & is not defined for...
  22. Re: How to Browse Files While Using OLEDB Connection in the same time

    Dear Chris

    What I want is to select some columns in the first sheet and add them to the datagrid , then goes to the next file and select the same columns and add them after the last record in the...
  23. How to Browse Files While Using OLEDB Connection in the same time

    Dear All

    I am using a code to loop through excel files in a Directory using FolderBrowserDialog and it is working well but Slow, And I want to speed up the procedure by using OLEDB Connection ,...
  24. Re: Application.StartupPath is not working vb.net

    Thanks but it is not working , However I removed the

    Imports Microsoft.Office.Interop.Excel
    and it worked

    Thanks
  25. Re: Application.StartupPath is not working vb.net

    Dear ChrisE

    I found that it is working when I remove the


    Imports Microsoft.Office.Interop
    Imports Microsoft.Office.Interop.Excel

    and Keep only
  26. Re: Application.StartupPath is not working vb.net

    Thanks ChrisE But it did not change anything Still the same error
  27. Application.StartupPath is not working vb.net

    Dear All

    I used the
    Dim Path As String = Application.StartupPath & "\Main_Master_VB.xls" in vb.net Application and it worked very well but when I used it in another vb.net application with the...
  28. Standard code for connecting sql server with vb.net and record functions ?

    Dear All

    I searched the web for a standard code to link between SQL server and vb.net and record functions like insert, update and delete ... each time I find a different way of code, also in...
  29. how to remove cell value in the cell offset if the cell repeated again?

    I want to make a loop in range to zero the offset cell if the cell data is repeated next As Below:

    Col A Col B
    ...
  30. Re: Function Works in Excel Macro But Does not Work in VB.Net

    Dear All

    I Changed Variant Type to Object Type and I receive Error "Index was outside the bounds of the Array at the Code Line


    dRem = dRem + avInp(iInp, 1) + dKerf

    Thanks
  31. Re: How to copy many sheets in excel workbook to another sheet in another workbook?

    Dear Delany

    Appreciate your support in my thread

    Function Works in Excel Macro But Does not Work in VB.Net

    I am sure you can solve it.

    Thanks, Regards
  32. Re: Function Works in Excel Macro But Does not Work in VB.Net

    Dear ChrisE
    I edited the question above with full details, Hope it is clear now, Thanks
  33. Function Works in Excel Macro But Does not Work in VB.Net

    Dear All

    I have an Industrial code with function which works in VBA and I am trying to convert it to VB.net as per our management decision.

    Here is the Code and Function Code which are working...
  34. Replies
    3
    Views
    551

    Convert Syntax from VBA to VB.Net

    Dear All

    We are moving from VBA to VB.net in our company and I converted many syntaxes from VBA to VB.net except some, this is one of them but I tried as you will see below:

    BBS is the Sheet...
  35. Replies
    2
    Views
    587

    The application is in break mode error ?

    Dear All

    I receive this error while I deal with large amount of data in excel despite of the fact the program is working with the same code when I deal with a lesser amount of data in excel ?!!
    ...
  36. Re: How to copy many sheets in excel workbook to another sheet in another workbook?

    Dear Delany

    You are brilliant, Thanks a lot
  37. How to copy many sheets in excel workbook to another sheet in another workbook?

    Dear All

    I am trying to copy a specific range from many sheets in excel workbook to another sheet in another workbook

    the problem it gives the data of the last sheet only

    Here is my code:
    ...
  38. copying single sheet to a new workbook vb.net

    Dear All

    I am working on a code to copy specific sheet to a new work book in excel but the code copies all the sheets although I define the sheet by name, My code is as below:


    Private Sub...
  39. Replies
    15
    Views
    1,603

    Re: Code Syntax Conversion From VBA To VB.Net

    Dear ChrisE

    Thanks your reply, However it has the same problem (Array) VB does not accept Array alone it needs something

    Regards

    Moheb Labib
  40. Replies
    15
    Views
    1,603

    Re: Code Syntax Conversion From VBA To VB.Net

    Dear All

    The Dn is the Range contains a String which the code is searching to see, how many times it is duplicated and Count the number of Duplicates and give the count in the next column and it...
Results 1 to 40 of 61
Page 1 of 2 1 2



Click Here to Expand Forum to Full Width