I have a datasheet subform (not sure that matters for my question) where each record has an image field. I added a double-click event so when you dbl-click on the image, it opens it in MS image viewer. If I'm "on" record 1 and I double click the image on that row, works great. If I dbl-click on the image in record 2, it still opens image 1 b/c it things I"m still on record 1. I have to select the next record then dbl-click for it to work. When I dbl-click, I'd like VBA to recognize I'm now on a different record. Thoughts? Thanks!
Double click image in data sheet -- go to current record (1 Viewer)
- Thread starter CedarTree
- Start date
nhorton79
Registered User.
- Local time
- Today, 16:51
- Joined
- Aug 17, 2015
- Messages
- 147
Is the double click event on the subform? If so, it will only work on the selected record.
I’m away from computer at the moment so can’t tell, but if there is a double click event on the actual field in the datasheet form then add the code to that event rather than the subform double click event.
Sent from my iPhone using Tapatalk
I’m away from computer at the moment so can’t tell, but if there is a double click event on the actual field in the datasheet form then add the code to that event rather than the subform double click event.
Sent from my iPhone using Tapatalk
nhorton79
Registered User.
- Local time
- Today, 16:51
- Joined
- Aug 17, 2015
- Messages
- 147
You don't want to put the code on the subform event.
You want to put this code on the field double click event on your actual subform.
Which in your case would be your image field.
See my IMG1.jpg file, showing in Design View.
Then the IMG2.jpg file contains what the form looks like in Form View.
My code on the double click event was:
This just showed (in a message box) the path of the attachment of whatever row I double-clicked on, but you would replace that with whatever code you have.
Hopefully this helps.
You want to put this code on the field double click event on your actual subform.
Which in your case would be your image field.
See my IMG1.jpg file, showing in Design View.
Then the IMG2.jpg file contains what the form looks like in Form View.
My code on the double click event was:
Code:
Private Sub Attachment_Click()
MsgBox "" & Me.Attachment
End SubThis just showed (in a message box) the path of the attachment of whatever row I double-clicked on, but you would replace that with whatever code you have.
Hopefully this helps.
Attachments
-
IMG1.jpg -
IMG2.jpg
nhorton79
Registered User.
- Local time
- Today, 16:51
- Joined
- Aug 17, 2015
- Messages
- 147
Are you able to post the code you are using on the double click event?
Everything including the Private Sub / End Sub pieces?
Possibly even a screenshot showing the form/subform.
Might just help me picture exactly what you’re trying to do and replicate it
Sent from my iPhone using Tapatalk
Everything including the Private Sub / End Sub pieces?
Possibly even a screenshot showing the form/subform.
Might just help me picture exactly what you’re trying to do and replicate it
Sent from my iPhone using Tapatalk
Here's the code...
Code:
Private Sub imgCheckBox_DblClick(Cancel As Integer)
Dim sCheckBoxPath As String, sCheckBoxFile As String
Dim sFullFileName As String
Me.imgCheckBox.Requery
sCheckBoxPath = fnCheckNullString(Me.CheckBoxImagePath)
sCheckBoxFile = fnCheckNullString(Me.CheckBoxImageFile)
If sCheckBoxPath = "" Or sCheckBoxFile = "" Then Exit Sub
sFullFileName = fnCheckBoxFileName(sCheckBoxPath, sCheckBoxFile) 'THIS JUST CREATES A PATH + FILENAME
If sFullFileName <> "" Then
Shell "RunDLL32.exe C:\Windows\System32\Shimgvw.dll,ImageView_Fullscreen " & sFullFileName
End If
End Sub
Last edited:
Here's a snip...
- So if I double-click (DC) on first image, it works
- If I select the 2nd record then DC on 2nd image it works
- If I've selected 2nd record then DC on 1st image or 3rd image, it opens the 2nd image
Attachments
-
CheckBox.JPG
nhorton79
Registered User.
- Local time
- Today, 16:51
- Joined
- Aug 17, 2015
- Messages
- 147
That looks like a continuous form anyway....
Its doesn't look like a datasheet to me although I could be mistaken.
Stacked headers and fields, with conditional formatting and images...seems like its a continuous form.
I've recreated this and have the same issue.
The reason is that even when you click an image on a continuous form, it doesn't give that record focus.
This is supposedly a known issue in Access.
After a little research, there is a workaround that I discovered on another website, which involves putting a transparent button over the image which gets focus on clicking. You then use that buttons onclick, doubleclick event
Link to website:
https://www.devhut.net/2013/10/27/m...m-not-returning-the-proper-recordprimary-key/
Also, see my attached database, where I have replicated something similar.
Just change some of the image links if they don't show on your end.
Its doesn't look like a datasheet to me although I could be mistaken.
Stacked headers and fields, with conditional formatting and images...seems like its a continuous form.
I've recreated this and have the same issue.
The reason is that even when you click an image on a continuous form, it doesn't give that record focus.
This is supposedly a known issue in Access.
After a little research, there is a workaround that I discovered on another website, which involves putting a transparent button over the image which gets focus on clicking. You then use that buttons onclick, doubleclick event
Link to website:
https://www.devhut.net/2013/10/27/m...m-not-returning-the-proper-recordprimary-key/
Also, see my attached database, where I have replicated something similar.
Just change some of the image links if they don't show on your end.
Similar threads
