Link to home
Start Free TrialLog in
Avatar of qjump
qjump

asked on

HTML fields in MS Access frontend database

Hi,

We have split an MS Access database so we have forms in a new frontend MS Access 2010 database and the data in a backend SQL Server 2008 R2 database.  All works well apart from the html fields with email addresses and websites.  Both fields are stored as nvarchar(max).  The email fields are now shown as  account@bsigroup.com#mailto:account@bsigroup.com#  and websites as www.bsigroup.com#http://www.bsigroup.com#

The problem is we want to retain the Access Front End database forms but need the html fields to act as before so that users can select the field value and launch either a browser session or create a new email.

Thanks in advance
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

what is the problem? data format? what was it before? what a format do you need?
is it shown in MS access form or stored this way in sql server db?
if stored in db:

you can run update with replcE SQL Function o do sql data CLEanup

http://msdn.microsoft.com/en-us/library/ms186862(v=sql.105).aspx


just in case:
How To Connect an HTML Page to a Microsoft Access Database
http://support.microsoft.com/kb/308459
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of qjump
qjump

ASKER

Thanks for the reply.

The issue is the users need to be able to launch a browser when they select a website address from the record in the MS Access form.  They also need to be able to launch a new email message when they select the email address from the record in the MS Access form.

The secondary issue is the converted data records need tiding up using an appropriate REPLACE query as you suggested.

Thanks
Avatar of qjump

ASKER

Yes the data was recently moved to SQL Server and this problem as you rightly say is because SQL stores the data in a different format.

Im not sure what settings are needed for make the url launch correctly from the form and which vba code needs to be applied?

Thanks
this problem as you rightly say is because SQL stores the data in a different format.
Actually if you re-read the comment that is not what was stated, in fact quite the opposite.  Here is goes again (my emphasis):
I ask because SQL Server does not have a 'Hyperlink' data type, like Access does. The 'Hyperlink' datatype is just a Text field anyway, and the interface interprets it to show the link.
Avatar of qjump

ASKER

Ok, so given the interface does the interpretation what settings should be implemented for the email and website fields?

Thanks