Grid Planner

Posted on 2011-04-24
Medium Priority
Last Modified: 2012-05-11
I have had a look for some examples of a planning grid linked to a calendar control to show assets being booked out to incorporate into my project but cannot seem to find anything on the web. Basically I would like the grid to show when our minibus has been booked out on a weekly view. I remember having an example some time ago in Access 2000 but seem to have lost it. I'm currently working in access2002. I would appreciate some pointers or examples of how I can achieve this.

Thanks in advance
Question by:MGardner
LVL 44

Accepted Solution

Leigh Purvis earned 2000 total points
ID: 35456213
Loath though I am to go against EE guidlines and risk getting a whippin' (I ain't really skerd ;-)...
I don't know of another way to easily point you to potential examples other than by link to external site for which you'd need to be registered to perform actual downloads.
I leave that up to you.
UA Downloads

The concept of filling a mock "grid" of controls is simple enough though.
In the example page link in my profile, there's the "RecordsetBind Example" which fills in textboxes with data from a non-linear source.  That's the entire concept there really. But you'll want the headstart of an existing application I'd say.  
I have nothing I can directly offer you that isn't proprietarily owned (i.e. was paid to do :-s).

Author Closing Comment

ID: 35456341
I guessed that it would be a case of creating a calendar using text boxes. Many thanks for the link too I forgot that I had already have a login for that site and found it very useful. You have saved me a lot of trial and error.

Many, many thanks


Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question