How do I print Jukebox title cards in MS Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Any suggestions on how to print Jukebox title cards in MS Access. There are
4 cards per sheet. The width for each card is 4.375 inches. There may be 7
to 30 titles on a card. I tried using the Label page setup but I couldnt
control the print for each card. HELP please.

Wanetta
 
I have no idea what Jukebox title cards are so here is only a blind idea.

Labels are probably the way to go. Printing labels involves printing the
same thing on each label. Given that, perhaps you need to have a card field
so you can specify what card to print and then build a string of all the
titles on a card for each card. Then when you print, you print to the first
label the string of titles you designated for card 1, when you print the
second label you print the string of titles you designated for card 2, etc.
You are printing the string on each label rather than individual titles. A
string of 3 titles would look like:
"Title1" & VbCrLf & "Title2" & VbCrLf & "Title3"
VbCrLf is a carriage return and line feed so you end up putting each title
on a separate line.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
The cd label could have 7 to 30 titles, how could I control keeping them
together on 1 card?
 
You need tables that look like:
TblCD
CDID
<<other descriptive fields of a CD>>

TblCDTitle
CDTitleID
CDID
CDTitle
<<Other fields related to the title>>

You identify the CD in TblCD and you identify all the titles on a specific
CD in TblCDTitle.

For your label report, you need to iterate through TblCDTitle for each CD
and build a string of all the titles for the CD. The string would look like:
"CDTitle1" & VbCrLf & "CDTitle2" & VbCrLf & "CDTitle3" ..... on out for all
the titles on the CD.

You would then print the string on a label and it would come out as:
CDTitle1
CDTitle2
CDTitle3
....
....
Down to the last title on the CD.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Thanks for your help. Below is my expected label outcome on a title sheet.

cdTiitle1 cdtitle2
titleSelection 1
titleSelection1
titleSelection2
titleSelection2
titleSelection3
titleSelection 3
...... (from 7 - 30) .....
(from 7 - 30)

cdTilte3
cdTitle4)
titleSelection1
titleSelection1
titleSelection2
titleSelection2
titleSelection3
titleSelection 3
...... (from 7 - 30) .....
(from 7 - 30)

Will the code you provided print like that? My tables are setup as you
suggested. How would the report layout look?
Thanks,
Wanetta
 
I do not know what cdTilte3 cdTitle4) is. In your report you will print two
fields:
cdTitle
a string that includes all the titles

Whatever cdTilte3 cdTitle4 is you need to do whatever to make it one value.
Perhaps you need to create a string for the cdTitle too.

<Will the code you provided print like that?> Yes

<How would the report layout look?> Exactly as you show below!

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
I just realized the example I sent you did not display the column spacing as
I typed them. The title card has 4 cards per sheet. Cd 1 and it's title
cards should be on section 1, cd 2 and it's title cards should be on section
2, cd 3 and it's titile cards should be on section 3 and cd4 and it's title
cards should be on section 4 and the 5 cd should generate a new page. Is it
clearer now. Thanks you so much for your help - Wanetta
 
My response is still the same. You create a label report and select a label
that matches the size of your card. If there isn't a label that matches, you
can cretae a custom label. Then you print two fields:
cdTitle
a string that includes all the titles

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
I found a template in Word that's close. I modified the template, but now I
don't know how to make it a page size option in Access. Can you show me how
to do that?
Thanks,
Wanetta
 
Back
Top