Hyperlinks within Queries

[rfurelos]

Hello. I am a new user to Access and I was wondering on when a query returns results to able to click on a field and it take me to the form that I created with that specific record information?

[ItsMe]

There is a field property in the table for Hyperlink. A field with the Hyperlink property will follow the hyperlink when the field is clicked.

I recommend avoiding the hyperlink field property at the table level. I also recommend not letting users have access to queries. Instead, use forms as the graphical user interface. You can store text in a field and then convert that text into a hyperlink at the Form level.

[rfurelos]

Thank you ItsMe.... Where do you recommend to put the hyperlink and within a form would I be able to set it up as a data view? I guess I should explain what I am trying to accomplish. With in my "Main form" which provides a user with all the information on one of our vendors. With in that same form there is a button that the the user can click on which would open another form which houses Outreach information as well as who is assigned to the client, follow up date and time. I am trying to create something (report, query) that the user can run to provide them with in a specific date range of all their follow ups. Once the user runs this "report, query, whatever" they would be presented with a datasheet view with all their specific clients they have set up for follow up. Once they are in the datasheet they would be able to click on the client and it would bring them to the "Main form" of the client where they would be able to edit that specific record (client). I hope I made sense.

[ItsMe]

...Where do you recommend to put the hyperlink and within a form would I be able to set it up as a data view?...

I do not have a lot of time to address each of your questions right now. I will say this, for now, some controls on forms have the hyperlink property. A common approach is to use some very simple VBA programming to pass the literal text to method like FollowHyperlink. An event handler like a click event or a double click event of a TextBox Control (yes, even in Data Sheet View) could get the whole thing rolling.

[ItsMe]

... I guess I should explain what I am trying to accomplish....

I guess I should have took the time to understand your objective, as you defined it in post #3. I do not see any need for a hyperlink in this scenario. You could simply open an object that is within your Access DB. Some examples of objects that can retrieve data for the user are forms and queries. It is advisable to use forms exclusively as an user interface.

What you are describing is a search form with a date range. So a couple unbound textboxes with their data type set to date would be a place to start. A Dynamic Parameterized Query could retrieve the data desired and display it in your form.

If you create a query and enter dates in the criteria field (towards the bottom of the window and within the grid), you might have the beginnings of what you need. I would start with >#01/01/2015#. The next step would be to reference the unbound textbox controls in your form. These are the controls I was talking about earlier.

If you type "Forms!" (without the quotes) into the Criteria field, you will see intellisense pop up. Select the form name and then select the control name. After playing around with your query, you may have the capability to get one record as a result of your query. Maybe one record equal to the value of your unbound control within your form.

Depending on where your date fields are within your table and how you are comparing things, you may need to use the BETWEEN operator. Less than and greater than operators may not be suitable.

Here is a tutorial. Not sure what the content is. Just might give you some additional info/insight.
https://www.youtube.com/watch?v=1gp-Ph9zJ04