Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Calendar / Inventory Scheduling - General Strategy

Posted on 2003-02-26
Medium Priority
Last Modified: 2013-12-03
I'm building a database that is tracking inventory. This inventory is generally rented (opposed to sold, although they do a little of that) and I'd like it to track the availability of a particular piece of rental inventory at a particular point in time. So when a client calls requesting to rent 20 widgets on December 25th, I want the application to check to make sure that there are going to be 20 widgets available on that day.

I have a large part of the project done but I’m coming to this calendar part and I want to take the right direction with it. I’ve got some ideas about how to do this but without ever doing it before I’d like to ask some people who have. I know Access has a built Active X Calendar Control but I’m a little leery about diving into that without some assurance it is going to turn ugly on me (MicrosoftL).

Right now I have three general sections (about 25 tables):
1. A Customer Section – To add and edit Customers
2. An Inventory Section – To add and edit Inventory
3. A Transaction Section – To record rentals and sales
Each section is generally one tabbed form with all the details available. An added complexity is I’m using temp tables to essentially build “Save/Cancel” functionality into the application. In other words, the user edits data in a temp table and Saves it to the main table or cancels the changes (it’s removed from the temp folder and the data is reverted – moved from the main table back into the temp table).

The transaction section is where I want the calendar/availability functionality. There are four possible states for a transaction – Quote, Reservation, Invoice, Closed. I want the inventory requested to be unavailable to anyone else when the transaction becomes a reservation.

I'd also like it to have an additional graphical calendar interface that will allow the user to browse availability for particular inventory items. What I'm envisioning is a combo box at the top with all the inventory items (and maybe a text box to indicate the amount requested) and the calendar below. Where there is a lack of inventory I’m thinking the day could be red or something. It would also be nice if the user could double click on a particular day and get the detail by the hour or minute. A transaction records the rental return date and TIME so the information is there for this more detailed look.

I'm a bit of “big spender” on this question so I'd really like some good direction. I'm an intermediate developer, strong within Access and comfortable in VB. I like moonlit walks and... sorry. I hope I’ve given adequate detail in this short novel. I’m obviously available to fill in any detail.
Question by:monahansolo
  • 2
LVL 59

Accepted Solution

Jim Dettman (Microsoft MVP/ EE MVE) earned 888 total points
ID: 8025707
I did a reservation system for a campgound in the past that is just along the lines you need.

I can easily explain how to do the reservation part (drop me your e-mail and I'll send along an example with the table/query setup).

What I'm not going to be able to help with is the calendar control.  I decided to use a staright Access solution (this was written in the A2 days) as Active-X controls were not plently full.  Access in the past has had problems with a lot of Active-X controls, so I generally try to stay away from them.

 I'll be happy to forward the example and dicuss any issues with you, but I don't have any recommendations for the control.  Maybe someone else can jump in.


Author Comment

ID: 8025832
Thanks Jim.

I have no love for Active X controls either. I just know I've seen something on it. Sounds like I'll avoid it.

I'd love to see your examples. I'll drop you a line.

Any other thoughts? Anyone?


Author Comment

ID: 8036165
Thanks again Jim.

Expert Comment

ID: 8849146
I am getting ready to use access for the first time, and it sounds like the application I am building is very much the same as this one.
IT is a scheduling /reservation system for a company that primarily deals in rentals.
I was wondering if you could share your soliution with me.

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

By following these Magento e-commerce development tips, you can increase your website's conversion and profitability. Read this post for more details.
A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
The viewer will get a basic understanding of what section 508 compliance can entail, learn about skip navigation links, alt text, transcripts, and font size controls.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).
Suggested Courses

571 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