473,322 Members | 1,510 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Report with hyperlinks to Internet

2
I have a table with two fields:
News_head (Text)
News_URL" (Text)

I want make a report with a "News_head" fields hiperlink to internet with the News_URL data...

I don't want to show explicity in the reports the fields News_URL..

Somebody can help me?

Thank you,
Sep 11 '10 #1
4 1308
liimra
119 100+
There is a funny solution but it works.

The Url Field is called "News_URL", so you add new text field to your report (same size as for the header field) and you put right on top of the other one (You paste "News_URL" without quotes inside it - I suppose that News_URL is already in the record source of the report). Then, you change the Foreground Color to White and change the Fontsize to 1. That is it, the URL won't appear and when you click on the Header field you are actually clicking on the URL field. You might want to add
Expand|Select|Wrap|Line Numbers
  1. Me.Requery
to the On Click event as the field might disappear.


Regards,
Ali
Sep 11 '10 #2
mchao
2
Thank you, is a good idea, but I have a problem...
If I set the field "News_URL" on top in the report, I can't see the data of News_head...and if I set News_head on top, the link of News_URL behind does't work..
:-(
Sep 12 '10 #3
liimra
119 100+
Did you change the backstyle of the field to transparent? That is it and you are done.


Regards,
Ali
Sep 12 '10 #4
liimra
119 100+
Did it work?

Regards,
Ali
Sep 16 '10 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Peter | last post by:
My client has retail shops. All these shops will access retail application through Internet. So sales receipts will be generated from web/application server and send across Internet to shops. ...
1
by: CBKowitz | last post by:
I have an intermittent problem, when viewing a crystal report. This problem only happens to some users and some report formats. When they try to view the report in Microsoft Word format the...
3
by: Oscar F | last post by:
Hello, To create a excel report from ASP.NET I do the folowing steps: -Create a HTML document. -Use Response.ContentType = "application/vnd.ms-excel" Everything works fine and the excel...
8
by: jbonifacejr | last post by:
This is my first day here, so please be patient. I do not know how to search very well so the search I tried to get the answer showed me topics from the year 2000 and they really don't cover what I...
1
by: gul | last post by:
hi to every one i have to research how to design reports in the internet browser but i did not really know about it pls help me its urgent bye
6
by: Jassim Rahma | last post by:
I want to detect the internet speed using C# to show the user on what speed he's connecting to internet?
5
by: Sport Girl | last post by:
Hi again my great online assistants, just would like to say that i'm testing the script under unix , and after researches on the internet, i have realised that to resolve 500 Internal Server Error,...
10
by: Lorie0114 | last post by:
Hello, We have an issue that I do not know how to resolve. Our website has several hundred reports. There are a handful of them that are causing issues when there is no interaction for a couple...
1
by: Munna | last post by:
Hi follow this thread... might help http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1158068&SiteID=1 Best of luck ----------- Munna
1
by: =?Utf-8?B?UGF5cm9sbCBmcnVzdHJhdGVk?= | last post by:
I am on my work computer using Windows XP, I am am using Internet Explorer 7.0 also. I am on a payroll website to do my weekly payroll. I try and view my payroll before processing it so I try and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.