3,842 Topics
![]() | |
Get difference of two text files in excel and highlighting the difference using python. eg. file1.txt alok|test1|test2|test3|test4 alok1|test2|aewer|262771|262772 Rest|t1|rang|banh|test Must|t1|rang|banh|test file2.txt alok|test11|test2|test3|test4 alok1|test2|aewer|262771|262772 Rest||rang|banh|test In excel the difference should be shouwn as below: file1.txt|alok||`test2`|test3|test4 file2.txt|alok|`test11`|test2|test3|test4 file1.txt|Rest|`t1`|rang|banh|test file2.txt|Rest||rang|banh|test `file1.txt`|`Must`|`t1`|`rang`|`banh`|`test` Basically if a record is present but with some field with different … | |
Hi group, I'm modifying a VB.net app where I need to loop through an Excel spreadsheet for data out of two column. In essence the code will need to read: For i = 2 to end of file propNo = Cells(i, 2).Value crms = Cells(i, 8).Value If crms = "Y" … | |
hi all i am looking for free window controls like dev express ,infragistic whith which i can create rich looking application in C# Any body having knowlage please revert Thank you in advance | |
Is Windows 10 step to Microsoft Cloud OS? | |
how to search a data in particular fields(ms access database) in vb6.0 using data1 control. I create a project in vb 6.0 using ms access data base and data control. I want to find a particular name from the data base table field. My code is.... If Data1.Recordset.Fields("C_Number") = Text15.Text … | |
I have a series of stand alone business computers that are not allowed to be connected to the internet but yet I have to keep up with MS updates. Downloading the Microsoft monthly Security updates on ISO is helpful, but installing them on 7 PC's , one at a time … | |
I'm updating my database using this code. only id and attendance date is updated but the time(AM_TIME_IN etc...) is not updating. What could be wrong? I'm using access and time(AM_TIME_IN etc...) datatype is shorttext Dim a As String = Now.ToShortTimeString If a.Contains("AM") Then a = "AM" Else a = "PM" … | |
Yes.....we are sort of still on Novell. However, I am new to the Active Directory world and need to create my first Active directory Forest. My test server is built, but haven't installed/initiated Active Directory services, etc. Any resources as on how to plan and create? | |
Dear all, I have created project database in msaccessdatabase. It contail  form layout as shown in image & i have attached code for reference Imports System Public Class Form1 Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load 'TODO: This line of code loads data into the … | |
hi all, i new for vb.net. i try to disable windows key function using vb.net. But by code only work on mouse click. so i need help to edit my code. This my code. Thanks, Option Strict On Imports System.Runtime.InteropServices Public Class Form1 <DllImport("user32.dll")> Private Shared Function FindWindow(className As String, … | |
Hi, I am connected to internet but my browser is not able to access any of the sites. All my chat clients and my outook is working fine but browser always displays "Page not found" error. I was reading on these forums and someone suggested running the WinSockFix utility which … | |
Hi I am running a Lotus Domino 8.5 server on Centos 5.2 x64 Linux. The installation is on a Intel server with Adaptec RAID controller 1.7Tb and the Notesdata directory is on an external Dell PowerVault MD1000 5.5Tb with RAID 5 configuration. I also have LVM2 installed. On Wednesday last … | |
I dont fully understand this issue at all, it makes no sense to me for several reasons but ill liust the main ones i have code elsewhere that works just fine and is identical in function and setup i dont think the issue is a registry key issue, this i … | |
Microsoft release surface computer, as a programmer I am wondering which operation system is more promising to study? | |
I have a website. Its IT related website last 2 months alexa ranking is good but at this time alexa ranking is not good. Tell me details how to improved in Alexa ranking in my website.... If you access my site just <link removed> | |
Hi, so i have a bit of an issue trying to select all my ms-access data in DGV with only a button, no typing in textboxes. I have been struggling with for a few days since unfortunately this isn't very popular? I can't seem to come up with anything in … | |
Usually a few times a day, but sometimes a couple of times an hour, I loose connectivity, and my wireless icon displays a yellow exclamation point. I changed my wireless card from a Broadcom to a Atheros, which improved things because the old one never reconnected by itself but the … | |
Hi everyone, I'm new here. I don't know VBA and have been tasked with a VBA project for whatever reason. We have a recurring bug wherein a report we receive has semi-fake rows, causing all kinds of hell. The current logic I am attempting to execute should run as follows: … | |
My PowerPoint has gotten buggy, the slide templates are invisible. Also, word runs slowly and seems to crash and not close files properly. I have my installation CD. When I put it in the CD drive, it brings up a window with dozens of file icons and no explanation of … | |
Are there any updates that will change the VMWare usage in the coming future? | |
Hi there, I'm still fairly new to programming. Would someone be able to explain exactly how different windows should be used in MS Visual Studio? It seems that variable sharing between different windows is problematic. So does that mean that if you are trying to do multiple things on one … | |
hello there im doing a project and need help.. how to show auto-id from ms access table 2000 into vb 6 textbox? | |
Well i want to know if there is any code for converting the date time retrived from windows system date to a unix format, :?: | |
I have an Excel sheet that I am looking to combine two columns from one sheet into a new sheet. I am including the Excel file. The columns are the B and R from the Title_Frame_Register sheet. I am trying to output to a new sheet and it what I … | |
Hi All, I work for a college and I use their systems, which I have access to a whole host of software that for Data protection reasons that cant be installed on any other computer. The issue is, I dont like using them as I dont feel very productive as … | |
So I have a problem, any help would be great. I have a new computer, like 2 weeks old. I have turned off sleep mode so I only have the shut down button and the restart one. When I shut it down, no problem, turn on no problem, its very … | |
So I have an ISO of Windows 10 x64 and I'm attempting to install it on a brand new hard drive. I start by using PowerISO to mount the image to a virtual drive then install it onto VirtualBox using my product key and all is fine so I start … | |
Hey guys. So I'm currently building an app and I'm having a bit of trouble. So I have an Excel file and it reads it and opens it fine(I imported microsoft.office.interops.excel but what I want to know is how to loop through column A and pick out the rows that … | |
Hi, I'm trying to compute a moving average of length 20. I've got a vector of structs that's read into my function and I'm using an iterator to read through as follows: int length = a; int count = 0; double sum = 0; while (itr!= priceinput.end()) { sum += … | |
Hi guys, I am trying to save the items in a listview to Access database. The listview has two columns; "Description and Price". For example, If a user adds three Items (products) in a listview and clicks a command button, I want these items to be saved in a database … |
The End.