murray83
Games Collector
- Local time
- Today, 08:02
- Joined
- Mar 31, 2017
- Messages
- 728
Hi Folks
trying to get a picture to display, pictures will be held in the DB in a gallery. If no image present then just want it to display the text like shown in attached image and also one with no image
but when i do try search for one with no image, get the ol' invalid use of null error
this is my current code
but i know i have to do something like isnull, have tried a search on google and here, but ones i found where checking if text was around, suggestions on this would help
cheers all
trying to get a picture to display, pictures will be held in the DB in a gallery. If no image present then just want it to display the text like shown in attached image and also one with no image
but when i do try search for one with no image, get the ol' invalid use of null error
this is my current code
Code:
Private Sub cmbWho_AfterUpdate()
Me.txtPlatform = DLookup("[Platform]", "[T_Data]", "[ID] = " & Me.[cmbWho]) 'inputs Platform
Me.txtYear = DLookup("[Released]", "[T_Data]", "[ID] = " & Me.[cmbWho]) 'inputs Release Year
Me.txtRegion = DLookup("[Region]", "[T_Data]", "[ID] = " & Me.[cmbWho]) 'inputs Region
Me.imgCover.Picture = DLookup("[CoverImage]", "[T_Data]", "[ID] = " & Me.[cmbWho]) 'inputs Cover of Game Selected, If One Present
but i know i have to do something like isnull, have tried a search on google and here, but ones i found where checking if text was around, suggestions on this would help
cheers all