File Attachment in 2007

[aperez54]

This is driving me nuts.

I have a table with the following fields:

MainID --> numeric ID
FileAttachment --> attachment type field.

In a new form, all I want is to show the different attachments per record.

Right now, I only have 1 record that has 3 attachments. 2 command buttons to go previous and next.

previous works fine, but the forward doesn't!

sub cmdnext_click()
fileattachment.forward
end sub

I get an error that says Can't go to next record. The form is bound to the table, with fields:

fileattachment.filedata
fileattachment.filename
fileattachment.fietype

Any ideas?

 

[randy700]

Did you use the wizard to create your button?


Randy

 

[aperez54]

No I didn't. I just dropped an attachment control on my form.

 

[aperez54]

oh but the form itself is bound to the table. I did bind each control to the appropriate fields.

 

[LisaWay]

aperez54,

I tried creating a table and form like you described. I found that if you create a textbox with the control source set to "=[FileAttachment].[filedata]", then the form displays "#Name?" in that control. Controls with "=[FileAttachment].[filename]" or "=[FileAttachment].[filetype]" as the control source work fine. I also created "GoForward" and "GoBack" buttons, and they both worked, except that I found that I needed to add "[FileAttachment].Requery" to both of their OnClick events in order to update the filename and filetype controls. Here's my code:

Private Sub GoBack_Click()
    FileAttachment.Back
    [FileAttachment].Requery
End Sub

Private Sub GoForward_Click()
    FileAttachment.Forward
    [FileAttachment].Requery
End Sub

I hope this helps!
Lisa

 

[aperez54]

Thanks Lisa!!!

I re-started fresh again, slo

http://wwwwly

and it worked!