Run-Time Error '424' - Object Required (1 Viewer)

Julius12

New member
Local time
Today, 15:15
Joined
Jan 21, 2014
Messages
3
Hello all!
I am trying to write a code that takes a value off of a cell, which is a link, and converts it to an attachement which will be deleted after another macro. This is only so I don't have to keep attachments on the database.
Is there a better way to link pictures? I need the pictures DISPLAYED on a form.
However, I am having a lot of trouble writing code for this.


Private Sub Command54_Click()
Dim picture As String
Dim a As Integer
For a = 2 To 5
MsgBox a, vbOKOnly
Tables!["1- Site Overview"]!["Field3"] = "Hello"
MsgBox "working as fast as I can. Just a few more seconds.", vbOKOnly
Next a
End Sub


The code is getting to the point it is outputting the message "a". And then states a run-time error '424' - Object Required. Field3 is a text field.

Thanks!
 

Users who are viewing this thread

Top Bottom