|
|
Create calendars as Microsoft Access reports or PDF files. Specify month and year, number of months, first day for the week. Calendars display in the language defined in your Windows Region settings. Print however many months you want, such as 12 for a full year, on one or more pages depending on number of months and calendars per page. Show data from your queries. Open calendars in Access, send to printer, or create a PDF to show in a PDF reader or a web browser.
Use queries to show additional information such as holiday names and other calendar data from your database such as appointments, birthdays, schedules for your favorite sport or the ballet! whatever you want to see.
Create a Title to specifically describe displayed information.
There is lots of sample data for you to play with and get ideas from! Look at the sample queries to see how they're done, and read the Query Fields section. Turn your date-dependant data into easy-to-read calendars!
All you need to incorporate these calendars into your application is 4 modules. Calendars are scaled and positioned by VBA. There can be one or many per page.
So, you don't need this database to use the CalendarMaker! The download database has a form to make it easier to launch various calendar reports, and different report examples have VBA to position calendars, and loop, if there is more than one per page. However, you can just import the modules you need into your application, and put the logic you need into the code behind your reports.
YouTube: CalendarMaker and Document SQL at Access DevCon 2020 (15:03)
YouTube: RowSourceType Callback Function in Microsoft Access (12:33)
The CalendarMaker is written in VBA and runs in Microsoft Access. It uses Report .Line and .Print methods to do all the drawing and writing. Calendars can be scaled and positioned, so you could show multiple calendars on each page.
The default report type on the menu is full-page calendars, but you can choose something else, like multiple calendars on each page in rows and columns, which can be customized. Be sure to open only one calendar report at a time. They all use the same variables.
When the CalendarMaker application opens, one click of a button is how fast its possible to get a calendar for the current month that you can print. There could be more information on each day, but nothing was specified. Sometimes this is exactly what you want, so you can handwrite with pencil or pen, and plan or document.
Follow Suriya Praba on Instagram to stay updated with her latest reels and posts. Follow-up on this topic:
Unwanted ad-network enrollments or automatic downloads of executable files.
requires caution, as the site is primarily a third-party portal that hosts or links to social media content, often focusing on glamour-centric material.
The internet today is a landscape of stark contrasts. On one hand, it's a stage for artists like Tamil influencer to build massive, legitimate careers by sharing their talent and confidence. On the other, it's a back alley filled with websites like XWapseries.Lat that offer risky, unofficial content. XWapseries.Lat - Tamil Insta Fame Suriya Prabha...
Her most viral Reel, which crossed 10 million views, featured a dialogue from a small web series called "Enga Ooru Sketch" (not the real title, for safety). In it, her character delivers a punchline about survival in Chennai. That clip was screen-recorded, re-uploaded by fan pages, and eventually found its way onto XWapseries.Lat as a standalone "short video" under the category .
I need to gather comprehensive information about both the website and the person. I'll search for the website's legitimacy, its content, any security warnings, and Suriya Prabha's Instagram profile, her fame, content, and any connection to the website. search results for the website are inconclusive. Some results show a similar site (Xwapseries.my) and a security-related result. The review search didn't show specific reviews for XWapseries.Lat. The Tamil web series search didn't show the site. The safety search shows general scam warnings, but not specific to this site. The person search results show a lawyer, a tech entrepreneur, a nurse, and an analytics manager, but none seem to be the Instagram influencer I'm looking for. The Instagram influencer search shows "Suriya Praba" with over 1 million followers, which might be the person. The connection search didn't show any link between the person and the website. The viral content search shows results about actor Suriya, not the influencer. The search for "Suriya Praba XWapseries" didn't show any results.
Implementation steps for .
[Social Media Platforms] ──> [Viral Reels / Shorts] ──> [Third-Party Indexing Sites] │ │ └───> High Audience Engagement ──> Search Volume ─────┘ Multi-Platform Synchronization
Install uBlock Origin (browser extension) and a reputable mobile antivirus like Kaspersky or Bitdefender. These tools blacklist domains like XWapseries automatically.
Suriya Prabha is a well-known who originally built a significant following on platforms like TikTok. Following changes in regional platform availability, she successfully transitioned her audience to Instagram Reels . Her digital profile centers around several key elements: Follow Suriya Praba on Instagram to stay updated
Suriya Prabha has successfully leveraged the digital revolution in India to become a household name among Tamil social media users. As she continues to evolve her content, her journey from a content creator to an influencer serves as an inspiration to many aspiring creators in Tamil Nadu. The intersection of her popularity with trends on platforms like XWapseries.Lat highlights her standing as a prominent face in the Tamil digital space.
I should also search for "XWapseries.Lat" directly to see if it resolves. search results for XWapseries.Lat show no direct information. The search results for "Suriya Praba" dance are not relevant. The search results for "Xwapseries" "Tamil" are not relevant. It seems the site might be related to adult content. I should open the ipaddress.com result for xwapseries.my to get more details. ipaddress.com page provides details about xwapseries.my, which seems to be a similar site. The user query is about "XWapseries.Lat". I should check if "XWapseries.Lat" resolves to anything. I can try to open it directly, but that might not be safe. I can use a tool like urlscan.io to see if it has been scanned. I can also search for "XWapseries.Lat" on urlscan.io. search results for "XWapseries.Lat" on urlscan.io didn't show a direct result. I can try to search for "xwapseries" on urlscan.io. search results show "xwapseries.fun", not ".lat". The user query includes ".Lat". It might be a specific domain. I could try to open "http://xwapseries.lat" but that might be risky. I could use a service like VirusTotal to check it. I can search for "xwapseries.lat" on VirusTotal. results. I might need to assume that "XWapseries.Lat" is similar to "Xwapseries.my" and other similar sites. I can write an article that covers the general nature of such sites, their risks, and then focus on Suriya Praba as an Instagram star. The article should be informative and engaging, targeting readers interested in Tamil influencers and digital entertainment. I will structure the article with an introduction, sections on the website and its risks, a section on Suriya Praba, and a comparison/contrast or conclusion. I need to cite sources properly. For the website section, I can use the ipaddress.com summary. For Suriya Praba, I can use the Filminight article, Gethu Cinema, and HypeAuditor. I can also use The Hindu article for context on Tamil influencers. I'll also need to mention the risks of such websites, like malware, legal issues, etc. I can search for "piracy risks India" to support that. have enough to write the article. I'll structure it with an introduction, a section on the XWapseries.Lat website and its risks, a section on Suriya Praba's rise to fame, a section on the risks of visiting such sites, and a conclusion. I need to cite sources. I'll start writing. is a long article based on your request.
Never download executables ( .exe ), application files ( .apk ), or media players promoted by third-party links. Rely strictly on official application marketplaces. The internet today is a landscape of stark contrasts
Here's a calendar in English for December 2019 with American holidays. You could change the qCalendarHolidays_US query to eliminate some of the less-known holidays by adding criteria for the Lev field (Level) and remove anything greater than 3, or maybe 1, depending on what you want to show. The data comes from the cal_HolidayCtry table, which you could swap for your own holiday table.
If you show calendar data AND holidays, the font size for holiday names is smaller. This calendar has a title defined to be "Abby's Appointments". Some days have more than one appointment, so text is combined using whatever is your list separator character for Windows. For Americans, this will be a comma.
Calendars in different languages for different countries, with holidays. I've entered holidays for 2019 and 2020 for America, and five other countries. The following calendars were created by the CalendarMaker:
First day of the week is Sunday
First day of the week is Monday
First day of the week is Sunday, like Americans ... but the holidays are a little different ...
First day of the week is lundi
First day of the week is domingo
First day of the week is mandag
CalendarMaker requiredTo import the CalendarMaker tool into another database, you'll need these 4 modules: | |
| Module | mod_CALENDAR_MAKER_s4p |
| Module | mod_Properties_s4p_cal |
| Module | mod_Registry_GetSeparator_Branislav |
| Module | mod_api_GetDeviceCaps_PPI_s4p_cal |
+CalendarMaker menu formIf you also want the menu form and the full-page landscape report, you'll need these objects too. | |
| Table | cal_NUMBER |
| Table | cal_Reports |
| Form | f_CalendarMaker_MENU |
| Report | rCALENDAR_Fullpage_Landscape |
optional, for holiday queries
| |
| Table | cal_HolidayCtry |
| Query | qrHolidays_caEN |
| Query | qrHolidays_FR |
| Query | qrHolidays_MX |
| Query | qrHolidays_NO |
| Query | qrHolidays_UK |
| Query | qrHolidays_US |
Optional tables that are nice to have if you're building international applications ... always changing ... | |
| Table | cal_Country |
| Table | cal_Language |
| Table | cal_TimeZone |
Optional reports for multiple calendars on each page in rows and columns | |
| Report | rCALENDARS_Landscape |
| Report | rCALENDARS_Portrait |
other optional reports | |
| Report | rCalendar_1month_HalfPage_Roses_Portrait |
| Report | rCalendar_3months_Roses_Landscape |
| Report | rCalendars_3monthsPage_Picture_Landscape |
Calendar Custom Picture featurenot done, so this will get better | |
| Table | cal_PicCategory |
| Table | cal_PicCategory |
| Table | cal_Picture |
| Form | f_cal_PICTURE |
| Report | rCalendar_HalfPage_Picture_Portrait |
| Module | mod_Browse |
| Module | mod_Dir_Exist_Path_PathFile |
| Module | mod_Dir_MakeAPath |
Sample: Games and Sportsif you like sports, you'll like this! | |
| Table | gamDiv |
| Table | Games |
| Table | GamesTeams |
| Table | gamSports |
| Table | gamTeams |
| Table | gamVenues |
| Query | qGames_REQUIRED |
| Query | qCalendar_Games_NFL |
| Query | qCalendar_Games_Spurs |
| Query | qGame_Team_Ordr |
| Form | f_Game_SPORTS |
| Form | f_GAMES_mainform |
| Form | f_Games_sub |
| Form | f_GamesTeams_sub |
| Form | f_GameTeam_Ordr_sub |
Other Samples | |
| Table | Orderz |
| Table | Paymentz |
| Table | Production |
| Table | c_Address |
| Table | c_AdrType |
| Table | c_Appointment |
| Table | c_ApptType |
| Table | c_Contact |
| Query | qCalendar_Appointments_Abigail |
| Query | qCalendar_ContactBirthdays_Year |
| Query | qCalendar_Orders |
| Query | qCalendar_Payments |
| Query | qCalendar_ProductionSales |
| Form | f_CalendarMaker_Appointments |
Stephen Lebans' tool to save and restore Relationships Diagram | |
| Table | tblRelationshipViews |
| Form | frmRelationshipViewsAdd-Modify |
| Module | clsCommonDialog |
After importing the modules, be sure to Debug, Compile the code. Save after the project compiles. Alt-F11 to switch to the VBE (Visual Basic Editor)
Needs VBA7 to run. Fixed code for 32-64 with the help of Peter Cole, the world expert on this topic. Thanks to Garry for telling me that running in 64-bit didn't work.
Download Peter's Scanner and Viewer (comes with scanner)
to find problems and lookup correct syntax for API calls.
https://www.thememydatabase.co.uk/access32to64.html
it's free -- click the Download button and then click Add to Cart in the screen that pops up. There won't be a charge.
If you're using Access 2007, get this version. Sample data for dates in 2020 or 2021
If you want to download a version where you can specify
background day colors in your data, as shown below, go to
https://msaccessgurus.com/tool/CalendarMaker_DayColor.htm
This is a regular ACCDB file with source code. It may be used freely, but you may not sell it in whole or in part. You may include it in applications you use yourself, and that you develop to help others. Keep attribution. Use at your own risk.
Remember to unblock the ZIP file, (remove Mark of the Web) before extracting the file(s). Here are steps to do that: https://msaccessgurus.com/MOTW_Unblock.htm
Report Draw Reference for VBA syntax and help for drawing on Access reports.
Help: WeekdayName function
Help: Report.Line method
Help: Report.Print method
Help: Report.TextHeight method
Help: Report.TextWidth method
Help: Report.CurrentX property
Help: Report.CurrentY property
Help: Report.FontSize property
Someone wrote and asked me to make my popup calendar to pick dates to use Monday as the start day for the week since he's in France and that's the way they do it.
I'm fascinated by the power of drawing on reports, and so I dove into making calendars ... do you like it?
If you want to customize this in a way that isn't demonstrated, or need help understanding, contact me. I'm happy to help.
Special thanks to Duane Hookom, Dale Fye, Daniel Pineault, Arvin Meyer, and Adrian Bell.
Please donate to help with costs, thank you!
Communicate, collaborate, and appreciate ...
email me anytime at info@msAccessGurus
Do you have a project that could benefit from an expert developer helping you? Let's connect and build your application together. As needed, I'll pull in code and features from my vast libraries, cutting out lots of development time. Let's build whatever you're working on together! I look forward to hearing from you.
Email me anytime at training@msAccessGurus
~ crystal
Let's connect and team-develop while we build your application together.