473,320 Members | 1,881 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,320 software developers and data experts.

Hyperlink fields

102 64KB
I want to try something but do not know to how to go about this. I have two tables in a one to many relationship (supplier and ratings). In the ratings query the field rating date is displayed. How can I make the rating date a hyperlink field and when clicked a rating form is displayed?
Attached is an example of what I want. Thanks in advance for your help.



Attached Images
File Type: jpg suppliers.jpg (38.9 KB, 436 views)
File Type: jpg Rating.jpg (40.2 KB, 379 views)
Aug 8 '14 #1

✓ answered by Seth Schrock

Sorry, I can't open attachments at work, so I can't see your images. To do what you are wanting, you need to have a form based on your Ratings query. The query would also need to have the primary key field included. You would then have a textbox bound to the Rating Date field. In that textbox, change the Is Hyperlink property to Yes (found in the Format tab of the property sheet). You would then need to add the following code to its On_Click event.
Expand|Select|Wrap|Line Numbers
  1. DoCmd.OpenForm FormName:"yourRatingFormNameHere", _
  2.                WhereCondition:"PKFieldName = " & Me.PKFieldName
Just change the name of your form and the primary key field name to match what you have.

3 1579
Seth Schrock
2,965 Expert 2GB
Sorry, I can't open attachments at work, so I can't see your images. To do what you are wanting, you need to have a form based on your Ratings query. The query would also need to have the primary key field included. You would then have a textbox bound to the Rating Date field. In that textbox, change the Is Hyperlink property to Yes (found in the Format tab of the property sheet). You would then need to add the following code to its On_Click event.
Expand|Select|Wrap|Line Numbers
  1. DoCmd.OpenForm FormName:"yourRatingFormNameHere", _
  2.                WhereCondition:"PKFieldName = " & Me.PKFieldName
Just change the name of your form and the primary key field name to match what you have.
Aug 8 '14 #2
sc5502
102 64KB
That is great. Thank you.
Aug 8 '14 #3
Seth Schrock
2,965 Expert 2GB
Glad to be able to help.
Aug 8 '14 #4

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

Similar topics

1
by: Edgar | last post by:
I have a field which contains email addresses. I would like to be able to click the email address field and have my email program open up to send a message to that address (like you can do with...
4
by: Marco Krechting | last post by:
Hi All, Sorry but I have to create new message since it cannot find the old message to send a reply. Coming back to this hyperlink thing I will try to explain the real problem cause I think we...
3
by: Ray | last post by:
I recently upgraded from Access 97 to Access 2003 and just enter some new data into table via an input form. The form has one hyperlink field to contain a file path. In Access 2003, it appears...
2
by: Bill | last post by:
I'm having trouble making hyperlink fields or controls or labels to be active in a report. The hyperlink field is fine in the Table and in the Query but not in the Report based on the query. I...
4
by: Andreas Meffert | last post by:
Hello, How can I change the Type of a field in a table from Memo to hyperlink? I import a table from Oracle to Access 2003. After that, the field type of some hyperlink-fields is "Memo". How...
4
by: robboll | last post by:
In the part of my code that writes the variables to the table: .. .. .. mFullURL = "http://www.microsoft.com" .. .. .. With rsTblURLs
1
by: Dixie | last post by:
I wish to add some fields to an existing table in code. I am using the following code from rkc. CurrentDb.Execute ("ALTER TABLE MyTable ADD MyNewField Text 25") This works , but I need to also set...
0
by: Simon | last post by:
Dear reader, By printing a e-mail field it will be shown as: Xxxx@yyyy.nn#Mailto:xxxx@yyyy.nn#
0
by: Neozaid | last post by:
I am trying to display records from an SQL database using an ASP.Net GridView control but I would like for one of the columns to be a Hyperlink or Hyperlink fields. Im using a DataTable to get the...
0
by: james41 | last post by:
Hi, I have an access form wherein some fields are hyperlinked. On the right click menu for such fields, the options for sort are disabled. How can I enable them? do i need to modify the code...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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)...
0
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...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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...

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.