![]() |
#1
|
|||
|
|||
![]()
Placing text and pictures in a WORD document.
Code:
Public Sub getBilleder(f As Form, bD As Word.Document) Dim tbl As DAO.Recordset Set tbl = CurrentDb.OpenRecordset("SELECT BILLEDE.*, BILLEDE.PersonID, BILLEDE.Sortering " & _ "FROM BILLEDE WHERE (((BILLEDE.PersonID)=" & Me.PersonID & _ ")) ORDER BY BILLEDE.Sortering;", dbOpenDynaset) With tbl .MoveFirst If .NoMatch Then Exit Sub bD.Content.InsertAfter ("Registrerede billeder: " & CrLf(2)) Do bD.Content.InsertAfter (.Fields("Billedtekst") & CrLf(1)) bD.Shapes.AddPicture (TrimFrom("Right", CurrentDb.Name, "\") & "IMG_files\" & .Fields("Sti til fil")) .MoveNext Loop Until .EOF End With Set tbl = Nothing End Sub How can I arrange the text and pictures something like this: Overall headline "Registrerede billeder: " & CrLf(2) Text for first picture: .Fields("Billedtekst") < a frame with the picture - the biggest thimbnail> Text for the second picture: .Fields("Billedtekst") < a frame with the picture - the biggest thimbnail> and so on for all pictures in the recordset |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Placing Endnotes in the Middle of a Document | lrosebush | Word | 3 | 10-24-2016 04:05 PM |
![]() |
uday.word | Word VBA | 5 | 09-11-2016 05:59 AM |
![]() |
Margaret | Excel | 4 | 07-17-2016 11:54 PM |
![]() |
thmsrox | Word VBA | 5 | 07-07-2016 05:04 AM |
![]() |
alexei_lg | Word | 1 | 02-07-2012 12:28 PM |