I have the widescreen calendar working as well. While poking around in the code I saw the disabled double click code for each block, I have activated some blocks (ones with data) to play with, I changed the code to open a filtered (only names in that block) form with a command button to do a focused open of a form called call log. This works well but seems a little convoluted.
So here are my questions
1. Anyway of making...
rstruthers
Last Activity: Dec 28 '13, 05:58 AM
Joined: Feb 14 '12
Location:
-
ADezii
Thank You
For your time!! MUCH APPRECIATED
I made the code changes and copied calendar into DB working great!!!
I took a look at the widescreen version liked the scroll bar and the list box futures will try to code wide version to use in DB will let you know how successful I was
Again thanks for your help
RonLeave a comment:
-
ADezii
I should have given a better detail on my first post. I would like just the first and last name to populate on the appropriate date when prospect should be contacted next (last contact date + Days Before Next Contact) I created a query (NextContact) that calculates the date the contact would populate on the calendar, I also changed the code in the populate calendar section to [LastContactDate] from [LastContractDat e] this change has...Leave a comment:
-
Thank You ADezii
I will work on DB this evening and let you know tomorrow how I’m progressing
Again thanks for the quick response
RonLeave a comment:
-
MS Access Calendar Populate from query with calculated field
I'm trying to populate the ms access caledar from a query with a calculated field here s the code from the query
I’ve not had any success...Code:SELECT HPContacts.FirstName, HPContacts.LastName, HPContacts.LastContactDate+[DaysBeforeNextContact] AS [Next Contact] FROM HPContacts WHERE ((([HPContacts].[LastContactDate]+[DaysBeforeNextContact]) Is Not Null)) ORDER BY HPContacts.LastContactDate+[DaysBeforeNextContact];
No activity results to display
Leave a comment: