Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS ACCESS & have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for

Converting Text To Hyperlink (possible ??)

Hi All,

I have a table with person's name, clubname, cluburl.
In a report I can show the clubname,but when I export to HTML, can this clubname
become a hyperlink to the clubURL ? (While showing the clubname..)
Anybody ideas ?

View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Converting Text To Numbers
I wondered if someone could help.

I am using the Val () Function to convert a text field to number within a query which still gives me a text output.

P.S I do not have permissions to change within table as using Access as a front end to SQL via link Tables.

View Replies !   View Related
Converting Text To Date
Hi, I have the following problem which I hope someone can help me with:

I am importing a CSV file, one of the field in which contains times in the following format: 1200 (ie this is 12:00, th text file does not contain the : separator)

I want these to be recognised as time values by access, which at the moment only treats them as text. Is there any way i can run a query on this table to convert the numbers into times? I can do it in excel using concatenate to add in the :, but access does not have this function.

Thanks in advance!

View Replies !   View Related
Converting Text To Date
Hi there,

I have a table with a field called 'dereg_date' which is formatted as text, an example is as follows:

2006-07-07 00:00:00.000

I want to be able to convert this field to a date. I have tried using a query with Cdate([dereg_date]), however it doesn't convert it and just returns #Error for all the records.

Has anyone got any ideas on this? I need this fixed fairly urgently as my superiors are getting quite impatient!

Many thanks in advance!!

View Replies !   View Related
Converting Text To Datetime
Is it possible to convert the text field that comes in this form:


to the following datetime format: MM/DD/YY 12:00:00AM

Please note that the text field contains a colon at the beginning. The number 8 represents a year (2008), the 04 represents a month (April) and the last two characters are days in the month (21). The converted field should look like:

04/21/08 12:00:00AM

Thank you.

View Replies !   View Related
Converting Hyperlinks To Text And Cleanup
My Db had an email_address field which was a hyperlink. For various reasons I had to change it to a text field. However, now every email shows as:
Is there a simple way of cleaning this up so I am only left with the email address? In other words is it possible to create an update query to remove everything between # signs (including the # signs)?

I found some vba code on the forum which extracts strings but was wondering if there is an easier way just using an update query since I'm still not too efficient with vba

View Replies !   View Related
Converting Dates Into Text From Combo Box
Dear All:

I have creadted a form with a combo box that has 3 dates in it: February 1, 2005, September 1, 2004 and June 4, 2004.

Is there a way to display in another field on the form(A text field) when one of these dates is selected from the combo box, a text field returns "DATED ON THIS FIRST DAY OF FEBRUARY TWO THOUSAND FIVE"?

I reckon this is a vb issue and any help is appreciated.

Thanking in advance


View Replies !   View Related
Converting A Null To Text In A Report
I have a date field in a form which is not compulsory.

I then pull this date field into a query to create a report.

If the date is not entered then is it possible for "Date not entered" to be written into the report automatically. I have tried playing around with nulls but have had no luck.

View Replies !   View Related
Generating Hyperlink From Text In Access
I have a table with one field set as a hyperlink. I have to generate the hyperlink according to what else is going on in the record, I do this by assembling a text string which I can write to a text field in the same record. I have no problem doing this but when I try to copy that string into the Hyperlink field I get type mismatch. Incidentally if I put two text boxes on a form and bind one to the text and one to the hyperlink field the I can 'cut and paste' it OK so how come I can't do it with Access basic?

Dim stGunlib As String
Dim stGunlib2 As String
stGunlib2 = [Stock number]
stGunlib = "" + stGunlib2 + ".jpg"
[Link] = stGunlib
[Picture] = stGunlib ([Picture] is a hyperlink field) it goes wrong here

I am using Access 2002

Thanks Dennis

View Replies !   View Related
Converting A Percentage Field From A Text File
I have a text file delimited and uploaded the information to a new Access Table. One field "MarketValue" has a number followed with a percentage (i.e. 100%, 54%, etc..), however it converts as a text column.

How can I convert the column to a TRUE percentage field representing the value originally imported.

View Replies !   View Related
Converting An Abbreviation To Full Text In A Report
In a table called Appointments and the field called Plastics we enter the initials of surgeons.
However in a report i want the initials converted to full text - in the example below the initials are HJC

The expression below doesn't work - it just returns everything in the Plastics column.

Any ideas?

Expr1: IIf(HJC([tblAppointment]![Plastics]),"Heather Cleland")

View Replies !   View Related
Automatic Transformation From Text Format To Hyperlink
Hi all,

I've made a create table which gives 2 fields which contain links to websites.
In the new table these links are in "text" format. I need to change those 2 fields from text to hyperlink in an automatic way.
Currently I've manually changed in the table the "data type" of those 2 new fields from Text to Hyperlink. In this way the hyperlinks work.

I can't do this job every day. How can I make it automatic? How I can
change automatically the formats from text to hyperlink? Do I have to
use VBA or can I avoid it?


View Replies !   View Related
Ms Access Converting Oracle's Number Field To Text
Can anybody help me ?
I've a case where ms access displays oracle's numeric field as text where msaccess is linked to oracle.The possible reason could be when we don't specify precision in declaring the filed in oracle table, default precision is 38 which ms access cannot hold. So, it(driver) converts this to text field.But this is with MSORCL32.dll(microsoft driver for oracle).Is there any other possible reason that will result this behavior?

The following are the configuration details:
1.Oracle 9i on Unix server.
2.MSAccess on Windows XP.
MSAccess holds linked data of Oracle server.

Thanks Inadvance.

View Replies !   View Related
Converting Text To Number Producing Error Data
I am using the funtion:

Clng([text field]) to convert a text field into a number so that I can link in a query. Because it is an informix database, I cannot change the underlying table format.

When I run the query, the data is showing "Error".

I tried changing the other table to text and linking but it doesn't seem to link properly because the query doesn't work.

Your advice appreciated.

View Replies !   View Related
Converting Option Box Number Results Back To Text
I have an option box 1=Yes, 2=Np 3=Unknown. the result is stored in a field in my table. When i run a query I pull up the numbers 1, 2 or 3 but to put in a report I actually want the written answers. How do i convert them back?

View Replies !   View Related
Converting Text Field To Number Without #Error In Empty Fields
I have a text field I need to convert to numbers. There are both empty and non empty fields. I then need to show the numbers like this "1.234" and a "*" in the empty fields.

I have tried to convert the fields with Cint, but I get an #Error in the empty fields.

Is there any way to solve this??

Thanks in advance..

View Replies !   View Related
Problem Converting Date Stored As Text To Data/time Format
I have a problem converting text to a real date value so I can do some calculations. I have a query that brings in data from an external data source. It appears the data is stored in the external table in text format and looks like this:

20050902 15:40:41

I have tried CDate to convert the text to a date/time format, but no luck. Any ideas?

View Replies !   View Related
Problems In Converting Date Field To Text Field
I have a strange problem of converting a date field stored as dd/mm/yyyy to a text[8] field. Example 01/06/1947 should be converted to 01061947. What is the easiest way of doing it? I tried changing it to first to ddmmyyyy and then change it to text, but it did not work.Can someone help me please?
Many thanks,

View Replies !   View Related
Converting A Text Date String To A Date For Calculations
Hi there. I'm just jumping into Access and have the following question. In my Purchase Order Table, I have a date field calcualated as text, i.e. "01/12/04". I need to convert this to a date format in my queries so I can do calculations, i.e. 01/12/04 - 01/05/04 = 7 days. Can someone help me with how to convert this text date to a date format. Sorry if this is an easy question. - AJS

View Replies !   View Related
Converting A Text Field To A Memo Field
I am in the process of changing over a text field to a memo field to generate more space (in 5 different databases :eek: ) Thanks to all the good info on several searches of this forum, I am pretty clear on how to do that.

The question is... when I convert a field that already has information in it, will I lose the current information?



View Replies !   View Related
Converting To An Exe
I have created a database but I would like it to be an exe. is this possible? if so, how???

I would like to lock the design and the code for the database. I will be holding about 2000 entries, will this be a problem?


View Replies !   View Related
Converting .MDB To .EXE
Hello Everyone,

First of all thanks alot for investing your valuable time in reading my query, I wonder if someone can kindly educate me on how to convert an access database.mdb file to an executable .exe file. Also is there a way to create an installation package to install the database to many Computers.

Thanks Again

Warm Regards,


View Replies !   View Related
Converting .mdf To .mdb
hi guys!

i just wanted to find out how do i convert an mdf to access,
please help!

Kind Regards

View Replies !   View Related
I have created a very simple code to fill automaticly an hyperlink field when a text box is updated on a form:

Me.txtHyperlink = "F:DataCPPCPP PDF" & [TxtPipeSize] & "" & [DrawingFile] & "" & [PartNumber] & ".sht" & [TxtSheetNo] & ".Rev" & [TxtRevNo] & ".pdf"

TxtHyperlink is bound to the hyperlink field, when the code is executed the Hyperlink field is filled with the right address. but I think the code just fill the text to display "parameter" of the hyperlink field and not the actual adddress.
what should I do to get the result of the function to be saved as the Hyperlink address?

View Replies !   View Related
Hyperlink Help

I am seriously confused!!! I am not a techie but feel I have a good self taught knowledge of access!

I have developed a database to hold abstracts of scientists attending a conference we are running. As some of the abstracts contain scientific symbols, we cannot input the data direct into the database as it cannot understand it.

I have received the abstracts in word format and so have put a hyperlink in the database, to the document.

However, I have run a series of queries off this database, to feed into a mail merge in word (are you following me - sorry for all the waffle). The hyperlink does not go over very well.

I wondered, is there a way that I can either:

1. Get the hyperlink to open and show the text in access, so it is displayed in the merged word document or
2. When the hyperlink is displayed in work, make it automatically open the relevent text and display it in that document.

Sorry for the waffle :rolleyes: Feel free to ask me any questions!!!!

Thanks in advance!:D

View Replies !   View Related

Copyright 2005-08, All rights reserved