?
Solved

Calendar / Inventory Scheduling - General Strategy

Posted on 2003-02-26
4
Medium Priority
?
238 Views
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.
0
Comment
Question by:monahansolo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 58

Accepted Solution

by:
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.

Jim.
0
 

Author Comment

by:monahansolo
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?

Dave
0
 

Author Comment

by:monahansolo
ID: 8036165
Thanks again Jim.
0
 

Expert Comment

by:thor_61
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.
Thanks
Bill
thor_61@yahoo.com
0

Featured Post

The Orion Papers

Are you interested in becoming an AWS Certified Solutions Architect?

Discover a new interactive way of training for the exam.

Question has a verified solution.

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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
The viewer will learn how to dynamically set the form action using jQuery.
Suggested Courses

752 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