Posts
 
Reputation
Joined
Last Seen
Ranked #3K
Strength to Increase Rep
+4
Strength to Decrease Rep
-1
100% Quality Score
Upvotes Received
3
Posts with Upvotes
3
Upvoting Members
1
Downvotes Received
0
Posts with Downvotes
0
Downvoting Members
0
1 Commented Post
2 Endorsements
Ranked #620
Ranked #4K
~6K People Reached
Favorite Forums
Member Avatar for divakar.it

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 …

Member Avatar for divakar.it
0
233
Member Avatar for divakar.it

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 …

Member Avatar for usiegd
0
627
Member Avatar for divakar.it

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 …

Member Avatar for divakar.it
0
952
Member Avatar for jemz

Hi, Hello can you help me please how can i make a refresh button so that i will never close the program if there is update in the data to be made in other computer... example if two computers or more..have installed the program and if one computer is making …

Member Avatar for PinoyDev
0
179
Member Avatar for divakar.it

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 …

Member Avatar for divakar.it
0
1K
Member Avatar for divakar.it

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 …

Member Avatar for debasisdas
0
83
Member Avatar for divakar.it

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, …

Member Avatar for AndreRet
0
204
Member Avatar for tgifgemini

Hi everyone, I have a weired situation right here. My module was working perfectly all along. This morning I tried to run and got a run-time error: 1004 Application-defined or Object-defined error on this line of code. [code] With xlWksht.Range(Cells(ii + 1, 1), Cells(ii + 1, 5)) [/code] Below is …

Member Avatar for AndreRet
0
320
Member Avatar for divakar.it

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 …

Member Avatar for AndreRet
0
622
Member Avatar for divakar.it

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 …

Member Avatar for AndreRet
0
151
Member Avatar for divakar.it

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 …

Member Avatar for AndreRet
0
420
Member Avatar for divakar.it

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 …

Member Avatar for AndreRet
0
373
Member Avatar for divakar.it

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

Member Avatar for AndreRet
0
128
Member Avatar for divakar.it

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 …

Member Avatar for AndreRet
0
248
Member Avatar for divakar.it

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 …

Member Avatar for AndreRet
0
217
Member Avatar for divakar.it

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 …

Member Avatar for AndreRet
0
132
Member Avatar for divakar.it

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 …

Member Avatar for AndreRet
0
99