Search:
Type: Posts; User: meho2020
Search:
Search took 0.06 seconds.
-
Dear jmcilhinney
Thanks your reply, Regards
Moheb Labib
-
Dear All
I have a vb.net application connected to access database which is inside the Application Under the debug Folder , when I add this database as existing item it copies it to another path ?...
-
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...
-
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...
-
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...
-
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...
-
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...
-
MyCommand.Fill(DtSet, "tempTable")
-
The Full Code
Private Sub GetBBSDataOLEDB()
If FolderBrowserDialog1.ShowDialog = System.Windows.Forms.DialogResult.OK Then
DataGridView1.Rows.Clear()
Dim...
-
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...
-
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=" &...
-
Dear All
How can I put a code in the print event of the detail section in crystal report like access ?
Thanks, Regards
-
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...
-
Dear Paul
Great Thanks to you, your idea worked fine, I was desperate and you made my day, Thanks, Again
-
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...
-
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 =...
-
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...
-
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...
-
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...
-
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...
-
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...
-
Dear jmcilhinney
Thanks I used File.FullName and it gave me the first file, now How can I call Directory.GetFiles
Regards
Moheb Labib
-
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...
-
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...
-
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 ,...
-
Thanks but it is not working , However I removed the
Imports Microsoft.Office.Interop.Excel
and it worked
Thanks
-
Dear ChrisE
I found that it is working when I remove the
Imports Microsoft.Office.Interop
Imports Microsoft.Office.Interop.Excel
and Keep only
-
Thanks ChrisE But it did not change anything Still the same error
-
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...
-
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...
-
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
...
-
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
-
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
-
Dear ChrisE
I edited the question above with full details, Hope it is clear now, Thanks
-
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...
-
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...
-
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 ?!!
...
-
Dear Delany
You are brilliant, Thanks a lot
-
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:
...
-
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...
|
Click Here to Expand Forum to Full Width
|