Access Database Primary Key Hyperlink

[Stargate1]

Hi,

Okay, i have been researching for 2 weeks now and i cant seem to find anyone to help me. We are using access 2010, I have a blank form that produces an ID number for the specific record when saved. then i have other forms where the ID field is hyperlinked to the original form that was entered. I now have 2 users that are unable to open the hyperlinked form. when i login as them im able to open the hyperlinked form. Below is the code we used. is there something im missing?

Private Sub ID_Click()
On Error GoTo Error_Catcher_1
DoCmd.OpenForm "NewRequestForm", , , "ID= " & Me.ID, acFormEdit

If IsNull(Sector) Then
Error_Catcher_1:
MsgBox "You may not enter a new request here."
End If
Exit Sub
End Sub
:banghead:

 

[vbaInet]

Can you expand on the issue of not being able to open the form? The form doesn't open at all in design view or the code doesn't open the form at all?

1. Are you sure the button is linked to the Click event?
2. Have you tried commenting out the error handler?

Welcome to the forum by the way.

 

[Stargate1]

Hi,

The button is linked to the "On Click" event...additionally, in the settings for that specific column of the primary key/ID number, it is set to be a hyperlink. When the link is click by these 2 users the Error_Catcher_1 in the code displays and the form will not show up at all.

We will try commenting out the Error handler and see what happens.

 

[Stargate1]

This item is resolved. We found that the issue ended up being that the user only donwloaded the microsoft viewer vs. the full microsoft package. Everything appears to be working. Thank you.

 

[vbaInet]

By Microsoft Viewer I'm guessing you meant Runtime version? If that's the case then everything should still work, although it depends how your designed the db.

At least you got it working!