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

Report works analyze with Excel doesn't

P: n/a
Hello and Thanks in Advance for help.

I created a report that prints a line for as many time slots as
entered in a table for an agency.
ex: agency 1 get 9 slots for 8:00, 10 slots for 8:15, etc. The table
design is:
ID_Agency; dte_appt; dte_time; int_nbrOfTimeSlots

Here is the code (courtesy of this newsgroup and FredG)

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Static intMyPrint As Integer

intMyPrint = intMyPrint + 1
If intMyPrint Mod [int_nbrOfTimeSlots] = 0 Then
Me.NextRecord = True
intMyPrint = 0
Me.NextRecord = False
End If

End Sub

But, when I try to export it to Excel so the agency can enter client
names for time slots allocated I only get 1 record for each ageny per
time slot. How should I modify the above code to incorporate the
transferspreadsheet and get all time slots.

Again TIA - Liz

Aug 1 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.