One of my biggest complaints with Access of old was the inflexibility of publishing and multi-user sharing online (via the web). Earlier versions of Microsoft Access used a ‘static’ web view known as Pages and to get to any level of interaction required some programming and scripting skills.
With Access 2010 combined with SharePoint 2010 services this now provides that missing ‘automated’ link. The video demonstrates what can be done using a simple business process of an online calendar system but using your imagination and head for the skies!
This video is only a demonstration and doesn’t show you how to build and implement and Access database over the web – that’s going to take considerably more than seven minutes but at least you now know the power of Microsoft Access (2010).
Please feel free to contact me for more information.
Tags: Microsoft Access 2010
Well put, sir, well put. I’ll cretaliny make note of that.
Hi, love the calendar display part of the video. how do i learn to do that? i’ve been an access developer for about 10 years now. thanks, greg
Hi Greg,
As the video explains (but not shown in the video), you place textboxes on a form spread-out across a monthly arrangement where each textbox control source points to a day value in the table back-end. The way I would approach this is to have a table with the following fields: year, month and day (as separate) so it will be easier to set criteria by the day and not have to use date based split functions linked to another table with a unique ID showing one or more narratives as stored for a date.
Using VBA code (or data macros) in the form; applying the filtering by month to populate each text box passing the month and year values into the query and refreshing the screen.
It takes some thought to plan and design but it’s easily achievable. There are many ways to approach this and welcome anyone else approach.
Thanks, Ben
Hi Ben,
I am looking to build a calendar based database in 2010 and came across this awesome video. Where do I start. Thanks
I’m new in the access..
I’m making a databass for my business however, I’m stucked with the calendar control. (making for monthly view, weekly view, and daily view… with appointments…)almost rest of databases are done or doing to finish…but the main is calendar…
Is there any help I can get?
Hi,
To have an appointment/calendar feature, you will need to build the controls bound to a table in a form like with any interface. There may be templates available from Microsoft (haven’t checked myself as I would build my own).
The calendar control was replaced with the data picker control in Access 2007/2010 and is now longer really used.
In your email you sent to me where you mention “I saw the calendar in this web for access”, do you have an image or link so that I can see this too?
I can then advise on the approach to building this form once I know what the web form looks like.
Thanks
Ben
I need to create an access “2010” vacation calander. All the data (name, date, hours) already exist. Already created query as well with month, week, day fields. Can you please pass along some advise to me to create the calenar. Thank you.
First of all, you need to decide if this is going to be on the web or desktop.
Second, your knowledge of form designs with either macros or VBA code is important and if you are completely new, you will need to either invest in a book, video tutorials or an eBook. My eBook: https://accessdatabasetutorial.com/ebooks/how-to-build-access-database-forms-ebook/
To create a form to show for example a month view, the form will need to be bound to a query by month (and year), grouped together by day (has this been done)?
Again, my eBook on queries maybe needed here: https://accessdatabasetutorial.com/ebooks/how-to-build-access-database-queries-ebook/
On the form, each text box (as shaped for a day box) will be coded and bound to a single day.
Code will need to be added in various places including the navigation between months and if you add, edit or delete appointments (on refresh).
Additional forms to pop-up to create or edit appointments will improve the user’s navigation and experience and is bound to different sources (where applicable).
It would take too long to step you through this here and I don’t know the level of Access you have to start from.
Finally, if using the web approach (version 2007 onwards), macros will be allowed (including data trigger macros) and not VBA code (it’s a security risk).
Please email me with more detail on how far you have reached and more detail on the end result to [email protected]
My eBook bundle includes the main 6 eBooks that may be of help: https://accessdatabasetutorial.com/ebook-bundle-offer/