By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,480 Members | 2,192 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,480 IT Pros & Developers. It's quick & easy.

Tiling pictures in a report

P: n/a
Hi

I've got a load of pictures stored in my db, and want to print them in
a report. I can't figure out how to tile them four by five (for
instance) in a report, only in a single column.

Any hint appreciated.

K
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a

"demo" <kr******@bommelibom.com> wrote in message
news:23*************************@posting.google.co m...
Hi

I've got a load of pictures stored in my db, and want to print them in
a report. I can't figure out how to tile them four by five (for
instance) in a report, only in a single column.

Any hint appreciated.

K


In the design of the report, select File>Page Setup and look at the columns
tab. If this doesn't make it obvious what to do, run the label wizard which
creates multi-column reports for you.
Nov 13 '05 #2

P: n/a
For photos uploaded to the server, I set up a report with 25 image controls,
25 labels for the id number of the person, and 25 labels for the person's
name, all name photo1, id1, name1, etc. Tthe photo name, person's id, and
person's name are stored in UploadedPhotoTable. After uploading 25 photos,
the report is opened, which contains the following (ADO) code:

Private Sub Report_Open(Cancel As Integer)
Set cnxn = CurrentProject.Connection
Set rs = New ADODB.Recordset
Dim i As Integer
i = 1
With rs
.Open "UploadedPhotoTable", cnxn, adOpenKeyset, adLockOptimistic,
adCmdTableDirect
Do While Not .EOF
Me("photo" & i).Picture = "C:\odis\uploaded\" & .Fields(0)
Me("id" & i).Caption = .Fields(0)
Me("name" & i).Caption = .Fields(1)
.MoveNext
i = i + 1
If i > 25 Then Exit Do
Loop
.Close
End With
End Sub
Darryl Kerkeslager

"demo" <kr******@bommelibom.com> wrote:
I've got a load of pictures stored in my db, and want to print them in
a report. I can't figure out how to tile them four by five (for
instance) in a report, only in a single column.

Nov 13 '05 #3

P: n/a
"Eric Schittlipz" <er**@schittlipz.com> wrote in message news:<cl**********@titan.btinternet.com>...
"demo" <kr******@bommelibom.com> wrote in message
news:23*************************@posting.google.co m...
Hi

I've got a load of pictures stored in my db, and want to print them in
a report. I can't figure out how to tile them four by five (for
instance) in a report, only in a single column.

Any hint appreciated.

K


In the design of the report, select File>Page Setup and look at the columns
tab. If this doesn't make it obvious what to do, run the label wizard which
creates multi-column reports for you.


That made it obvious, hoped it wouldn't be harder...

Thanks
K
Nov 13 '05 #4

P: n/a
"Eric Schittlipz" <er**@schittlipz.com> wrote in message news:<cl**********@titan.btinternet.com>...
"demo" <kr******@bommelibom.com> wrote in message
news:23*************************@posting.google.co m...
Hi

I've got a load of pictures stored in my db, and want to print them in
a report. I can't figure out how to tile them four by five (for
instance) in a report, only in a single column.

Any hint appreciated.

K


In the design of the report, select File>Page Setup and look at the columns
tab. If this doesn't make it obvious what to do, run the label wizard which
creates multi-column reports for you.


That made it obvious, hoped it wouldn't be harder...

Thanks
K
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.