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!
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!