Calender Help

[alanl]

Hi I have downloaded your Calendar Zip File posted by "RuralGuy" I hope that's OK?
Although now retired I am attempting to write a programme to run an Entertainment Agency, the business I was in.
I have a DBASE dos application that I used for many years and wanted for the hell of it to try to replicate it or similar in Access.
The calendar is great and I have adapted it to be populated with gigs for an artiste from a table holding all the gigs for all the Artistes in the agency stable.
Each record holds a Specific ID in the field named BKID and I want to double click the DAY Boxes to open the contract details for the gig on that date.
Below is the code that populates the Calendar and the data in the Day Boxes looks like this
(169) Georgian Theatre Royal Richmond £2000 + Vat PU
strDays(intTemp) = strDays(intTemp) & vbCrLf & "(" & BKID & ")" & " " & strBvname & " £" & StrBfee & Tvat & " " & strBpaycode
rst.MoveNext
Loop
' Loop through every calendar box. If there are any bookings stored
' in array strDays(r), add them to the calendar box
For r = 1 To 37
If intDays(r) <> 0 Then
intTemp = intDays(r)
Me("Day" & Trim(r)) = strDays(intTemp)
I have tried both the following lines but they only bring the same BKID to all the day boxes in any given month
[TempVars]![BKID] = strDays(intTemp) & BKID
[TempVars]![BKID] = rst!BKID

End If
Next r
End If

rst.Close
Any ideas how this can be done so that Day Boxes have BKID relating to the gig on that day which a Day Box double click could recognise?
Any help you can offer would be greatly appreciated
Regards


Alanl
Link to Calender Zip just page down to find it
https://www.accessforums.net/forms/e...help-2084.html

[RuralGuy]

Just so the record is straight, I uploaded the file but I am not one of the creators. They are listed inside of the file in the code modules.
' The majority of this code is from CyberCow on UtterAccess.com.
' Further modifications by cfields on UtterAccess.com.
' Optimizations and USA-centric date issues repaired by Doctor9
' on UtterAccess.com.
I just wanted to set the record straight. I'll still look at your situation and see what I can do.

[alanl]

Thank you I look forward to any help you can suggest
Alanl

[RuralGuy]

How about zipping up what you have and posting it here? At least we will all be working on the same mdb.

[alanl]

Hi
As suggested attached is the database I am working on.
To get it down to a attachable size I have remove quite a large amount of data, however they is still sufficient for it to work.
Alanl

[RuralGuy]

The limit on this site is 2MB for a Zip file. Compact and Repair and then Zip it and see what the size is. The uploaded file can not be compiled since it has a ton of errors.