UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Code Archive Item - Rollback Accdb To Mdb, Access 2003    
 
   
Access_Johnc
post Jun 27 2018, 05:22 AM
Post#1



Posts: 486
Joined: 5-July 01
From: Glasgow, Scotland


Morning,

I was looking at the Compare Text and Highlight Changes post in the Code archive by Smileycoder.

Here

Unfortunately it's a .Accdb database format and I can only open MDB files.

Could anybody do me a favour and try to roll it back to a .MDB format please. (hopefully the code is backward compatible.)

Thanks,

John
This post has been edited by Access_Johnc: Jun 27 2018, 06:21 AM
Go to the top of the page
 
isladogs
post Jun 27 2018, 06:17 AM
Post#2


UtterAccess VIP
Posts: 1,680
Joined: 4-June 18
From: Somerset, UK


The link didn't work for me
Go to the top of the page
 
Access_Johnc
post Jun 27 2018, 06:28 AM
Post#3



Posts: 486
Joined: 5-July 01
From: Glasgow, Scotland


Sorry, I posted the whole URL rather than the topic ID. confused.gif




Try again

John
Go to the top of the page
 
RJD
post Jun 27 2018, 09:40 AM
Post#4


UtterAccess VIP
Posts: 10,080
Joined: 25-October 10
From: Gulf South USA


Hi: See if this works for you - it was brought down to A2003 mdb.

Guid luck!

HTH
Joe
Attached File(s)
Attached File  TheSmileyCoder___Compare_and_highlight_A2003.zip ( 223.69K )Number of downloads: 9
 
Go to the top of the page
 
Access_Johnc
post Jun 27 2018, 09:46 AM
Post#5



Posts: 486
Joined: 5-July 01
From: Glasgow, Scotland


Many thanks.

John
Go to the top of the page
 
RJD
post Jun 27 2018, 09:48 AM
Post#6


UtterAccess VIP
Posts: 10,080
Joined: 25-October 10
From: Gulf South USA


thumbup.gif
Go to the top of the page
 
theDBguy
post Jun 27 2018, 09:50 AM
Post#7


Access Wiki and Forums Moderator
Posts: 76,378
Joined: 19-June 07
From: SunnySandyEggo


Hi John,

Please let us know if the down conversion works (without errors) so we can maybe post the mdb version in the Code Archive as well. Thanks.
Go to the top of the page
 
Access_Johnc
post Jun 27 2018, 10:01 AM
Post#8



Posts: 486
Joined: 5-July 01
From: Glasgow, Scotland


Will do.

It is throwing up some errors. I'll try to get my head around what's going on and see if I can get a working MDB.

Cheers,

John
Go to the top of the page
 
theDBguy
post Jun 27 2018, 10:34 AM
Post#9


Access Wiki and Forums Moderator
Posts: 76,378
Joined: 19-June 07
From: SunnySandyEggo


Hi John,

Thanks. When you get a working copy, we can post it in the Code Archive for others who may want a MDB version like you.

Cheers!
Go to the top of the page
 
Access_Johnc
post Jun 28 2018, 06:11 AM
Post#10



Posts: 486
Joined: 5-July 01
From: Glasgow, Scotland


Crashed and burned I'm afraid.

I hadn't noticed this section on SmileyCoders write up.

"The function is called TSCfn_CompareAndDiff and the only required parameters are the old text and the new text you wish to compare. TSCfn_CompareAndDiff will return a rich text formatted string. To display this properly you need to use a rich text control, a textbox (Access 2007+)."

....and Access 2003 doesn't have a rich text control.

I've taken the function into a clean database and can sort of get it to run in a query, by commenting out some of the code, and it shows the HTML mark-up text (i.e. not the formatted end result) but (as above) there's no way of presenting a formatted version without having a rich text control in Access 2003.

I did find a bit of Excel code that takes a mark-up string, bounces it off a browser object and brings back the formatted result but using it seemed a bit of a long way for a shortcut and limited by the number of character in the string.

The long and the short of it is that I don't have a working MDB version of SmileyCoders database to add to the code archive. Other than creating a pointer to this topic where the function exists in MDB format if anybody else wants to have a go with it.

Sorry,

John
Go to the top of the page
 
isladogs
post Jun 28 2018, 07:53 AM
Post#11


UtterAccess VIP
Posts: 1,680
Joined: 4-June 18
From: Somerset, UK


Stephen Lebans has some rich text code for MDB files at http://lebans.com/richtext.htm
I've never used it but it may do what you want.
Go to the top of the page
 
Access_Johnc
post Jun 28 2018, 08:09 AM
Post#12



Posts: 486
Joined: 5-July 01
From: Glasgow, Scotland


Yes, I came across the Lebans stuff when I was looking around. Looks like it involved downloading his own custom control and editing the registry.

Not only am I stuck with the Access 2003 version but we aren't allowed to edit the registry here either.



John
This post has been edited by Access_Johnc: Jun 28 2018, 08:09 AM
Go to the top of the page
 
JonSmith
post Jun 28 2018, 08:13 AM
Post#13


UtterAccess VIP
Posts: 4,053
Joined: 19-October 10



So thinking out loud here, but I downloaded something from the code archive today and had the opposite problem. The file was too old for Access 2003.
I think it'd be worth making sure there are .accdb versions of everything before we all move on to newer versions and no-one can convert them?

JS
Go to the top of the page
 
theDBguy
post Jun 28 2018, 09:39 AM
Post#14


Access Wiki and Forums Moderator
Posts: 76,378
Joined: 19-June 07
From: SunnySandyEggo


Hi Jon,

Not a bad idea and thanks for volunteering! wink.gif
Go to the top of the page
 
JonSmith
post Jun 28 2018, 09:42 AM
Post#15


UtterAccess VIP
Posts: 4,053
Joined: 19-October 10



QUOTE
Not a bad idea and thanks for volunteering! wink.gif


By definition I cannot though! Its already too late for me and I cannot open the old files!
Go to the top of the page
 
theDBguy
post Jun 28 2018, 09:51 AM
Post#16


Access Wiki and Forums Moderator
Posts: 76,378
Joined: 19-June 07
From: SunnySandyEggo


Hi Jon,

I was just joking but I'll bring it up to the admin group and see if we can do something about it.

Thanks for the idea again! thumbup.gif
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    14th October 2019 - 03:28 PM