- Strength to Increase Rep
- +0
- Strength to Decrease Rep
- -0
- Upvotes Received
- 3
- Posts with Upvotes
- 3
- Upvoting Members
- 1
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
17 Posted Topics
Here is my another challenge. When I pass the file name into for loop, I want to get a specific word from the file name and need to pass that as a parameter as well. For eg: When there are 5 files in a folder say Encrypted_abc_1.xml Encrypted_xyz_2.xml Encrypted_hij_3.xml Encrypted_klm_4.xml … | |
Hi, As part my developement I would like to keep all employees document stored in database table rather in folder. I dont want to store the files in folder and keep the file location in table so that get the file from the location. I tried my level best in … | |
Hi, I am tired in searching the solution in google for my issue in ADODC MoveComplete Issue: In my application I was using reference ADO 2.0 version for ADODC connection and it was working fine. Due to some other enhancement i forced to change the version from ADO 2.0 to … | |
Re: Example: DataGrid1.DataSource = Nothing 'This will clear the data Set DataGrid1.DataSource = MyRecSet1 'This will load the data DataGrid1.Refresh 'This will display the data | |
Hi, My requirement is to delete a selected row in the datagrid from SQL server. If no row is selected then nothing should happen. Below is my code [CODE] Private Sub BT_Remove_Click() On Error GoTo ErDsc: Dim MyConn As ADODB.Connection Dim MyRecSet1 As New ADODB.Recordset Set MyConn = New ADODB.Connection … | |
Hi, Please find my requirement - The Datetimepicker should display the current month - It should disable the 1st day of the month (i.e mindate should be 2nd day of the month) - It should disable all dates > current date (i.e maxdate should be current system date) So that … | |
I would like to copy and paste special values in excel using VB6 during report generation. But pastespecial is not working. Its throwing error 1004 Paste Special method worksheet failed. Below is the code. can you please advise [CODE]xlTmp.ActiveSheet.Range("H7:H23").Select xlTmp.Selection.Copy xlTmp.Sheets("Consolidation").Activate xlTmp.ActiveSheet.Cells(6, 4).Value = P(N) xlTmp.ActiveSheet.Cells(8, PS).Select xlTmp.ActiveSheet.PasteSpecial xlPasteValues, xlNone, … | |
Re: Please modify your code as below [CODE]With xlWksht.Range(xlWksht.Cells(ii + 1, 1), xlWksht.Cells(ii + 1, 5))[/CODE] This will work | |
Hello, I am getting a below error while accessing excel second time [I]run time error 1004 method sheets of object_global failed in vb6[/I] When i run the code at first time to open a excel and take a copy of the sheet, it works fine however when i run the … | |
Hi, I want to trigger a mail from VB6 code. Here the only specific requirement is, When the user click the button, it will do something and send the result in a mail using common id. Eg: There is common mail id called [email]RMG@xyz.com[/email] (Resource management Group) which will be … | |
Hi, Me again. Now the requirement is slightly changed now. Requiremetn: When I enter a employee id in a text box and click "Show calender", the code will run a query to fetch Allocation date and release date of the employee for a project and the dates between Allocation date … | |
Hi, I have a requirement that when a user click on a record in the datagrid (the record holds Emp_id and his/her project allocation date and release date), then the dates from allocation date to release date in monthview should display bold. I have written the code but i dont … | |
Hi Andreret, As per the dicussion today on my previous thread, i am creating a new thread for the function to convert the numbers on the grid to a date. I am waiting for your code. Kindly share once you done tomorrow or the day next | |
Hi, I am developing a new Application and am getting the below error Error Description: When I click the record in DataGrid, then the values should be populated from DataGrid columns to respective Text boxes. However if i click in the datagrid when there is no record then there should … | |
I am using VB 6 for my Project. There is requirement that Managers want to see blocking dates of an employee for a project. Eg: If an employee blocked for a project till Dec 2010 then the dates in a calender till Dec 2010 will be showing in a specific … | |
I am developing a application using VB 6.0. My requirement is if the user log off the application using File->Exit the below action should perform Action1 : The login status should get updated with 0 in the back end table called "Create_Login" so that next time if the user login … | |
Hi, I am currently developing a tool in VB 6.0. I am facing a problem when i generate reports in Excel format. The issue description: - When I click the 'Produce report button', the vb code will run a query and fetch the record into record set - and then … |
The End.