Search results

Hi Brian, I need to highlight the details exactly as it will save on my users time in identifying the exact changes that the customer has sent.. The details may run into a multiple number of lines thus making it difficult for my user to understand what exactly has changed.. Now I have modified...

Hi, I have now modified my code to compare each word.. however while highlighting it does some vague behaviour.. it does not highlight some parts of the text or highlights is wrongly.. can you tell me what am i missing in this code. Private Sub CompareText1() Dim txtold() As String, txtnew()...

Not the entire line.. but maybe the word or the character as red.. as this will give my user more precision on what has changed between the old and the new values

Yes absolutely right.. and I want to compare the string line by line by extracting it using instr.. but I am not able to get the logic ahead of it for highlighting..

you are right Brian and thats the precise reason I want to modify my code to compare line by line.. so that atleast the next line will not turn red but am not able to find a logic codewise to achieve this..

Hi Michael, Thank you for your inputs.. I replaced the line in the code as per your suggestion.. however the output still remains the same.. e.g: Textbox 1: This is first line. This is second line.. Textbox 2: This. is first line. This is...

Hi, I am not using a normal text box instead I have used "Microsoft InkEdit Control" to do the highlighting part.. The highlight is working fine but its just that instead of the whole text box i want to compare the two text boxes line by line.. and highlight the differences in each line.. It is...

Hi, I have a code to compare contents of two text boxes and highlight the differences which is working fine but due to this even if one character has changed the entire text after the change is highlighted in red color. what I want to do is to change this code to compare text line by line to...

Hi, tried creating a SQL Pass-through query.. However it asks me for a DSN while executing it.. On providing the DSN I get an error "Invalid Object Name: " <name of my local Access table> Not sure if what I did is correct.. :banghead::confused: Regards, Mahie

Hi dear, Before coming to this stage I did try writing a SP in SQL to OPENROWSET & OPENdatasource to get the data from Access & update into a table pre-created in SQL DB. but with that am getting another error which says " Cannot initialize the data source object of OLE DB provider...

Hi all, I am trying to transfer data from .mdb file to SQL server.. I tried linking the table using ODBC but I am not able to access it to insert records.. I created a DSN-Less connection and am able to connect to the SQL database.. however am getting error while I try to xfer the data...

Hi friends.... Need some urgent help with a functionality that have been breaking my head on since past 2 days.. :banghead: I have a front end (.adp) and my backend is in SQL Server 2008 but along with this have a local temp access table (.accdb/.mdb) which will store my data temporarily...