Software

Ask something
Question Locked

Need Hyperlink Help.. Access 97 :(

0 helpful
2 replies

by sweiss06

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am having trouble linking my table rows to a form by hyperlink. I'll give the layout to help clarify. I have a table let's say Company Jobs. The Table has Columns "Job#" "Date" and "Preformed by". I was hoping that i could create the "Job #" column in a hyperlink format. Then by clicking on this would upload the row into my form. Have been unsuccessful so far. Also am curious how i can make sure these hyperlinks are working properly when new records are created through the form. Any help on this issue would be greatly appreciated.

2 replies

by jesus h

If it is a hyperlink, Then by clicking on this, it would open your default web browser and try to connect to that web page.

You might want to change the Job#'s data type from "hyperlink" to "text" or "number".
Then add another field "ID", data type "AutoNumber".

Then use the wizard to add a "Combo Box" to the form, to switch/find Job#s.
It might look as follows,
name: Combo8
Row source: SELECT DISTINCTROW [Company Jobs].[ID], [Company Jobs].[Job#] FROM [Company Jobs];

Sub Combo8_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[ID] = " & Me![Combo8]
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub

This discussion is closed to new replies.