Hyperlink Field Custom Formatting?

Aug 12, 2014

I have created a hyperlink field with the website urls in them.

What I am trying to achieve is to create another field to automatically convert the hyperlink field into a hyperlink that displays "Website" automatically for every record. I do not want users to type in the URL and then have to fill in another field to display it as 'Website'. Having both fields is important for reporting purposes and form use.

How may I achieve this? I have tried to use calculated field like: =Website# & [WebsiteURL], but to no avail.

View Replies


ADVERTISEMENT

Conditional Formatting Custom Colour / Color

Jun 16, 2005

Is it possible to set a custom background color for conditional formatting? Don't particuarly want to do it via code, but I suspect it might be the only way. If coding is required, can someone advise how and where to put it?

You see, I have a form with a custom background colour. In the conditional formatting criteria, all I want to change is the font color for the control, but when the critiera is set it automatically changes the background to white.

Cheers,
Christine

View 8 Replies View Related

Conditional Formatting -- Lock And Custom Color

Aug 3, 2005

Hi,

I have a continuous subform with a checkbox and a textbox. If the checkbox is checked, I would like the textbox to enable. Since using code will enable the textbox for ALL the records, I'm assuming I need to use conditional formatting.

The problem is that I'd like to set the Locked property of the textbox as well. Just disabling the textbox makes the text hard to read -- it's currently white forecolor, blue backcolor and disabling would make the forecolor grey. The conditional formatting dialog looks like it doesn't use the Locked property, so is there another way I can do it?

Along the same lines, I'd like to use a custom color for my formatting (my blue isn't a standard blue color). Is there a way to enter the numerical value for the color, rather than just pick one from the palette?

View 4 Replies View Related

Forms :: Choose Custom Colours With Conditional Formatting

Sep 6, 2013

I'm using access 2003. I've got a textbox placed ontop of an image that I want to make it seem to disappear on a conditional format.

The back color property of the textbox I want to set is "13160660". How do I choose this colour when applying conditional formatting as I only seem to be able to choose from the swatch of 40 default colours and no option to define custom colours.

View 4 Replies View Related

Modules & VBA :: Make Table - Assign Custom Formatting To Numbers

Oct 6, 2014

I am using VBA to execute a 'Make Table' (named 'DT'). One of the fields in DT (named 'Dollars') contains numbers that have 6 to 8 digits; some are positive and some are negative.

These large numbers with no commas (or parentheses when they're negative) are incredibly hard to read.

Any VBA coding that will change both the "Format" and the "Decimal Place" Field Properties on the table I make (i.e. "DT"). I want to the Format property to read (#,##0.00;(#,##0.00)) and the Decimal Place property to read "2"). This will allow me to display a number like -10326786.41 as (10,326,786.41) which is incredibly more readable.

Is it possible to do this programmatically; I've search the internet high and low and could find anything remotely useful.

View 8 Replies View Related

Modules & VBA :: Bulk Update Of Hyperlink Text To Display Not Hyperlink

May 29, 2014

i have thousands of data records with hyperlinks that are correct. Each data record shows the actual link (google.com, foxnews.com, espn.com, etc.). However, i want to change all of the records to just say "link" instead of saying espn.com, etc. How can i do this automatically without having to manually right click, edit, and changing the text to display?

View 6 Replies View Related

Hyperlink Field

Dec 5, 2007

Is there any way to have a hyperlink field in a table that has a very long path to the file show something different?

Example C:Documents and settingsMy FileOther FileThis Fileme.pdf

Woud like it to simply show "Open File"

Thanks!

Fen How

View 3 Replies View Related

Editing Hyperlink Field

Apr 6, 2006

Is there any way to edit the hyperlink field in my table, I'm thinking along the lines of an update query?

The database has thousands of records and the user has not typed any text into the 'Display Text' part of the hyperlink. This means that the stored hyperlink is double size because if no text is entered into the display text part then access uses the hyperlink string. This is a problem for me later on in the design.

I have tried a simple update query and this updates the display text as required but also loses the hyperlink itself, which I want to remain unchanged.

Any ideas?

View 1 Replies View Related

Hyperlink Field In Union Query

Mar 8, 2006

Hi,
I have a query that I build using VBA based on some user input. One of the fields I pull out is a hyperlink to particular files on our local network, so the user can click the link and open the relevant file. My problem is that if the SELECT statement contains one (or more) UNIONs the hyperlinks no longer work. The query returns all the fields but the hyperlink field is just text of the form "display_text#link_address#".
I am using MS Access 2000. The UNION statements are required so I can search for multiple keywords in various fields within the table.

An example of the SQL query I generate is:
SELECT DocRef, DocTitle, DocAbstract, DocLink, DocAuthor, DocDate FROM TechDocs
WHERE DocType IN ('TechRep', 'Misc')
AND DocAbstract LIKE ('*drug*')
UNION
SELECT DocRef, DocTitle, DocAbstract, DocLink, DocAuthor, DocDate FROM TechDocs
WHERE DocType IN ('TechRep', 'Misc')
AND DocAbstract LIKE ('*release*');

If I do the query a different way (when I am searching for phrases, not keywords) the hyperlinks work fine. As you can imagine this is very frustrating! I have read that Access 2000 has some problems with UNIONs where it has to order the individual SELECT results before the union or something, but I can't work it out. :confused:

Any help is much appreciated.

View 1 Replies View Related

Hyperlink Linked To A Field In A Table..

Dec 18, 2006

Hey guys!
I have a basic knowledge of MS Access and for some of you it might seem like a stupid question, but here's my issue:

I'm trying to create an hyperlink in a form (or a data access page) to a web page, but part of that hyperlink url will be contained in a field in a table.
For example, the link would look like that: www.[site].com where [site] is a field inside let's say Table1. So depending on the value of [site] the link will return: (URL address blocked: See forum rules) or (URL address blocked: See forum rules), etc..
I assume it might require some coding to achive the desired result which I don't know anything about
I tried to set the control source of my link to: = "www." & [Table1]![site] & ".com" but of course it doesn't work.

Thanks a lot in advance for all the help you can give me.

View 2 Replies View Related

General :: Hyperlink Based On Field Value

May 21, 2013

I have excel file with two fields:

Quote:

Model |Website
--------------------
Toyota |Press..
Honda |Press..

Website column is a function:

Code:
=+HYPERLINK("http://www."&A3&".com","Press..")

When importing to Access , the link is disappeared.

How to keep the 'Website' field value, based on 'Model' (as in Excel)?

View 2 Replies View Related

General :: Hyperlink Friendly Field In Access

Oct 10, 2012

I'm trying to create a pdf report displaying records in a columns, with each record having its own hyperlink. Rather than displaying the actual hyperlink, which is quite long, I'd like to portray a friendly_field like in Excel (Hyperlink("Link"). Hyperlinkpart doesn't seem to do this.Is there a formula I can create in a query where I can reference each individual hyperlink but show it as a "friendly_field" such as "Link"?

View 3 Replies View Related

Modules & VBA :: Display In Query Field Just The Hyperlink

Jan 20, 2015

I have a query which is a concatenated field of text and then a field from a table that has a hyperlink.

i.e 15mm predesigned mould Drw: [L:10527-123-A.pdf#L:10527-123-A.pdf#]

I want it to display in the query field as just the hyperlink

15mm predesigned mould Drw: [L:10527-123-A.pdf]

View 5 Replies View Related

Forms :: Pass Field Into Hyperlink / Button?

Mar 19, 2013

.I'm trying to pass a field ([txtUPRN]) in a form to a hyperlink or button on the form.

e.g. [URL]

I thought I could add a hyperlink and simply change the part 'jlocation = 26800' to 'jlocation = Me![txtUPRN]' but this would be too easy as it doesn't work. THe URL still opens a web page but displays no data. Do I have to be more explicit as to what I'm passing in i.e. use the full form name or am I going about this the wrong way?

View 3 Replies View Related

Modules & VBA :: Hyperlink Text In Memo Field

Apr 11, 2015

I want to create an app that works like Wikipedia. for example any word that have an explain and that's explain available in my database that word become hyperlink text with different color and so if operator click on that word open a new form and show the explain.

View 1 Replies View Related

Use Hyperlink To Open Form Based On Value In The Field?

Jun 12, 2014

I have a continuous form that lists all unapproved invoices. I would like to have a hyperlink at the end of each row that says Review and will open another form that queries the details of the unapproved invoice based on the invoice number in the current row.

View 9 Replies View Related

Generate Custom Id Field

Sep 29, 2004

Hello Again,

I have an ID field that I want a custom ID generated based on Name, Phone Number & Record Number.

Here is the code I'm currently using....

'User moved out of supplier name field
Public Sub SupplierName_LostFocus()
If Me.NewRecord = True Then 'If user adidng new supplier
SupplierNameTemp = UCase$(Left$(SupplierName, 3)) 'Store 3 characters from supplier name
End If
nd Sub

'User moved out of suppliers phone number field
Public Sub SupplierPhoneNo_LostFocus()
If Me.NewRecord Then 'If adding a new supplier
supplierPhoneNoTemp = UCase$(Right$(SupplierPhoneNo, 4)) 'Get 4 right characters of phone #
End If
End Sub

I then have a procedure which combines the two strings such as....

Private Sub GenerateSupplierId()
SupplierID=SupplierNameTemp+SupplierPhoneNoTemp
End Sub

The problem is when I check the SupplierPhoneNoTemp & the SupplierNameTemp within the GenerateSupplierID procedure. The contain no information meaning the SupplierID will have nothing as well.

However, when I check SupplierNameTemp within the Public Sub SupplierName_LostFocus() & SupplierPhoneNoTemp within Public Sub SupplierPhoneNo_LostFocus(). They both contain the proper info. It seems they loose this information when moving outside their procedures.

Does anyone know why this would happen & how I could fix this?

Thanks.

View 13 Replies View Related

Modules & VBA :: Opening Hyperlink Dependent On Field Data?

Aug 18, 2015

I am attempting to open a website hyperlink, some of the fields contain https:// and some of them dont.

Code:
Private Sub Facebookbut_Click()
Dim Hyper As String
If InStr([TEAMFacebook], "https") Then
Hyper = Me.TEAMFacebook
Else
Hyper = ("https://www.facebook.com/" & Me.TEAMFacebook)
End If
Application.FollowHyperlink Hyper
End Sub

So far this does 2 things, it doesn't open any hyperlinks at all and continues to attempt to until the program is closed from task manager. Before I had this error it would open the hyperlink twice if the field does not contain "https" and the IF statement was passed to the 2nd option.

View 14 Replies View Related

Reports :: Hyperlink In Rich Text Field On Report

Dec 3, 2014

I am generating a report that needs to have a hyperlink in part of one of the fields. Prior to saving the field to the database I do a bit of VBA coding on it and add some HTML. The result is this in the field:

"There are two ways to book with your preferred rate: <br>

1. <b><a href="http://hamptoninn.hilton.com/en/hp/reservations/index.jhtml?hotel=ABGVA&corporateCode=12345">Click Here</a></b>! <br>

2. Call us directly or at 1-800-Hampton and use your Corporate ID 12345."

It works beautifully if you paste it into a web page but in the Access report, Access applies the Bold but just ignores the hyperlink.

This is Access 2013 with MS SQL Server 2008 backend. Everything I have read suggests that this should work and is supported. Is there some trick I'm missing?

View 2 Replies View Related

Tables :: Inserting Hyperlink In Field Title On A Table?

Dec 7, 2012

Is there a way to insert a hyperlink in a field title on a table? For example, I have a field that is a check box for whether the person has taken a class. What I would like to do is insert a link in the field title for that class so I can click on it and bring up the supporting documentation in a PDF file for that class.

View 4 Replies View Related

Reports :: Hyperlink One Report To Another Based On Field Selection

Nov 29, 2013

I have a report that shows me an employee number that pulls data from the database, once that information is pulled, it shows me the results, I need to look another level down. Is there a way to put in a hyperlink to another report from the original report? example: Employee number 22 jobs worked on: 2214, 2218, 3222 From within this report, I would like to open job 2214 Is this possible?

View 2 Replies View Related

Button / Image Or Text Box To Access Hyperlink Field

Oct 15, 2013

I have a field in a Table (tblMainFile) named "File Location" which contains a hyperlink for each of the files.I have a continuous form (from a query) which displays information from the tblMainFile table.the form shows a text box (with the hyperlink) which is clickable to take them to the link location.I would like to have a button which says (GET FILE) or a different text box which simply says "Get File" as opposed to the entire hyperlink.

View 6 Replies View Related

How Do I Make A Custom Field In A Query?

Aug 27, 2007

I have a query in my database, and I have recently added new possible entries for area. My report tells me how many male chickens vs. how many female chickens I have. Now with the new entries for area, I want my breakdown to EXCLUDE any chickens that live in a specific area.

For instance:

Pen A has 15 males & 15 females.
Pen B has 12 Males & 13 Females.
Pen C has 50 males & 50 females.

Pen C is the recent addition...

Right now my report shows: 77 Males & 78 Females...

I WANT it to EXCLUDE Pen C, so it would report: 27 Males & 28 Females.

Can anyone tell me how best to do this? I figured I would add a custom field to the query that the criteria for is "Pen = C" and then on my report I would change the data source from: =Count([Chicken Query]![Male] --- and make it =Count([Chicken Query]![Male] - Count([Pen="C"]) --- or something like that.

Can anyone help me? And if so could you help with the proper code for the second part that I am adding new? I know the Count([Pen="C"]) isn't right, but until I know exactly how to add a custom field to the current query, with the critieria of Pen="C", I don't know how to write the -Count([NewField]) code, if that would even work.

Thanks!

View 2 Replies View Related

Update Query To Change Display Value Part Of Hyperlink Field

Nov 11, 2007

Given a table field that is a hyperlink type.
I need an Update Query to set all records of that table so that the Displayed Value part of the hyperlink field (not the Address part) is set to a particular value.
Any ideas how?
Thanks.

View 1 Replies View Related

Tables :: Auto Generate Hyperlink In Table Based On Field Name

Aug 29, 2014

I Have a table with 15000 entries. This table lists components we use. This table is used to generate queries/forms. I have been asked to add a hyperlink to this table to link to a drawing of the component. All the drawings are in PDF and in the same folder. I am looking for a way to automatically update the hyperlink fields all at once. The Hyperlink will be in the format of servershareddrawings12345.pdfwhere 12345 is the component name from the table.

But there are a few small problems with the component names.
1. If the component begins with a B- . The drawing name will be all the characters except when there is a second dash in the component. So if the component is B-12345-678 the drawing name will only be B-12345.
2. If The component begins with AB, The drawing will be the first 5 characters regardless of what follows, e.g. AB123.
3. Finally for all other components the full component name will be the drawing name.

Putting the naming to one side, how to go about auto generating the hyperlink. I have posted this in the table section, but maybe this should be in another section like queries or VBA.

View 2 Replies View Related

Queries :: Criteria In Query Custom Field

Dec 16, 2014

I have made a function returning True/False values. I used this function in a query and now it return value Error as well...Is there a way to set criteria to values received in that field (0/-1/#Error). I've tried putting Like 0, Like True with or without quotation mark.Also every workaround comes into play as long as it works.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved