murray83
Games Collector
- Local time
- Today, 01:45
- Joined
- Mar 31, 2017
- Messages
- 736
OK i give up, iv been going round google and here looking for and at all the way to save an attachment from a table which its attached to, but most of the time there for images
and i'm not that smart on all the syntax like rs this and etc, so could some one please point me to some easy dummy guide on how to save a file, all i have is one attachment and just want it to save to default location on the c drive
so this is some pusdeo code so i know it wont work like i have written out below but this is what i would like it to do
then once that happens the attached copy of credits .htm file has been saved locally and then the form opens and the web form will show the credits
and i'm not that smart on all the syntax like rs this and etc, so could some one please point me to some easy dummy guide on how to save a file, all i have is one attachment and just want it to save to default location on the c drive
so this is some pusdeo code so i know it wont work like i have written out below but this is what i would like it to do
Code:
Private Sub cmdCredits_Click()
dim FileName As String
'code here to save the html for credits to place on the PC so the credits will scroll good !!
DoCmd.RunSQL SELECT Field1 FROM table WebAttachment
SAVE file to = "C:\Users\[Curent User]\Credits\("FileName")
Me.Visible = False
DoCmd.OpenForm "html_Credits"
End Sub
then once that happens the attached copy of credits .htm file has been saved locally and then the form opens and the web form will show the credits