Dear Friends,
A friend of mine have asked me a favor, he has started a new small bussines
to rent equipment, he wish to control the inventory and to issue renting
orders from the clients, but it is required to avoid the multiple booking of
the rented equipment, I was thinking to generate a "Orders Control" with the
standard databases generated by MS Access and do some programming
modifications in order to avoid the multiple booking. Does anyone know about
where to find an example of such database or Information system in
Internet?, it is highly desirable if that is freeware, my friend does no
have enough finantial resources to afford it.
Thanks and best regards 2 1871
"Jose Fernandez" <jf********@bel lsouth.net> wrote in message news:<yN******* ********@bignew s3.bellsouth.ne t>... Dear Friends,
A friend of mine have asked me a favor, he has started a new small bussines to rent equipment, he wish to control the inventory and to issue renting orders from the clients, but it is required to avoid the multiple booking of the rented equipment, I was thinking to generate a "Orders Control" with the standard databases generated by MS Access and do some programming modifications in order to avoid the multiple booking. Does anyone know about where to find an example of such database or Information system in Internet?, it is highly desirable if that is freeware, my friend does no have enough finantial resources to afford it.
Thanks and best regards
The first place I would look for an answer to this might be Access
Cookbook, by Ken Getz. He *might* cover this, since it's a fairly
standard scenario. Albert Kallal has written a bunch of these
databases, so he might give you some pointers. Unless you're
reasonably good at Access and VB, I think this exercise is going to be
difficult. I did one a few years ago, and for the uninitiated, it's
quite a challenge. You can create a table of time slots, but it's an
UGLY design. that means you have to write queries/code to find
conflicts etc, I think. Again, as I said, look around for Albert's
posts on the subject. Otherwise, you're in for a lot of
frustration...
HTH,
Pieter
Good suggestions, Pieter. Another company that specializes in this kind
of product is a place I used to work for. I upsized their database from
Access to SQL Server, but their Access based product is really good.
Dean Evans & Associates in Denver CO http://www.dea.com/
Their product focuses on allocating room resources, but it might work
for equipment, and it definitely addresses the double-booking issue.
--
Danny J. Lesandrini dl*********@hot mail.com http://amazecreations.com/datafast
"Pieter Linden" <pi********@hot mail.com> wrote in message news:bf******** *************** ***@posting.goo gle.com... "Jose Fernandez" <jf********@bel lsouth.net> wrote in message news:<yN******* ********@bignew s3.bellsouth.ne t>... Dear Friends,
A friend of mine have asked me a favor, he has started a new small bussines to rent equipment, he wish to control the inventory and to issue renting orders from the clients, but it is required to avoid the multiple booking of the rented equipment, I was thinking to generate a "Orders Control" with the standard databases generated by MS Access and do some programming modifications in order to avoid the multiple booking. Does anyone know about where to find an example of such database or Information system in Internet?, it is highly desirable if that is freeware, my friend does no have enough finantial resources to afford it.
Thanks and best regards
The first place I would look for an answer to this might be Access Cookbook, by Ken Getz. He *might* cover this, since it's a fairly standard scenario. Albert Kallal has written a bunch of these databases, so he might give you some pointers. Unless you're reasonably good at Access and VB, I think this exercise is going to be difficult. I did one a few years ago, and for the uninitiated, it's quite a challenge. You can create a table of time slots, but it's an UGLY design. that means you have to write queries/code to find conflicts etc, I think. Again, as I said, look around for Albert's posts on the subject. Otherwise, you're in for a lot of frustration...
HTH, Pieter This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Scott |
last post by:
Not sure if this is the right place to post this or not, but I am in the
process of trying to find a Web Hosting/Isp Billing system that is
reasonable in price and uses Access or SQL Server for a backend DB. I have
found a couple that seem to do what I want, but are using FILEMAKER for
their DB. Looking for something that will handle reoccuring billing as well
as per project billing. Keeping up with client info, etc.... Also needs to...
|
by: Sami |
last post by:
Please bear with me, and if you answer this question, please do it
step by step. I am new at Access, not at all sophisticated. I am
using Office XP. This will need to be read in Access for Office 2000.
I am creating a database to track student athletes. I have created
the following tables. The table title is to the far left, with fields
under each. The common field will be the StudentID field, which is
their student number assigned...
|
by: genc ymeri |
last post by:
Hi,
I'm really in the middle of the crossroad over here. My app recieves an XML
files and process it. This XML file contain some data and relationships
which are based on bussiness rules. My app based on these rules should make
a validation to process it or not further down......
While I'm new in the C#, I wonder what I'm suppose to use ? MSXML2 or
System.XML classes ???? Mostly I will do reading and going back and forth to
read the...
|
by: Ian Oldbury |
last post by:
Hi all,
I'm trying to use paging and also have the following placed within the
footer of the grid following on from the NumericPages information.
Page x of y
and have the "x" as a text box where the user can enter the page that they
wish to move to.
|
by: Kumar |
last post by:
Hi Folks,
I would like to develop one custom application using asp.net,C#,SQL server
for tracking all our company servers.
Most of the functionality is similar to HP Systems Insight Manager
(http://h18013.www1.hp.com/products/servers/management/hpsim/)
I would like to store as much information as we can about server.
| |
by: Stefke |
last post by:
Hi,
I want to write a little application with a textbox in which I can enter a
systems host name or ip address.
After clicking on a button Get Info, I want to display an overview of the
systems information in an rtf textbox.
Like CPU, Memory, HDD Info, Operating System, Service Pack, computer name,
Domain or workgroup name, ...
The application is meant to run in a network with +/- 250 systems, so if
|
by: nugget |
last post by:
Role-based security for an ASP/ASP.NET mixed environment
Hello:
My co-worker and I have been charged with designing role-based security
for our intranet. The technologies we have to work with are ASP and
ASP.NET. This security design must support *both* technologies.
Currently, we have a successful collection of both ASP and ASP.NET
applications with an identical look and feel; you'd only know they are
different by virtue of an ASP...
|
by: onnodb |
last post by:
Hi all,
While working on an Access UI to a MySQL database (which should be a
reasonable, low-cost, flexible interface to the DB, better than
web-based, much less costly than a full-fledged .NET app or so.... is
it?), I tried measuring the bandwith consumed by the
Access/MyODBC/MySQL link, which came out to be, er, quite high.
I fancied it would be interesting to look at the queries Access throws
at MySQL through the ODBC link, so I...
|
by: raylopez99 |
last post by:
Keywords: scope resolution, passing classes between parent and child
forms, parameter constructor method, normal constructor, default
constructor, forward reference, sharing classes between forms.
Here is a newbie mistake that I found myself doing (as a newbie), and
that even a master programmer, the guru of this forum, Jon Skeet,
missed! (He knows this I'm sure, but just didn't think this was my
problem; LOL, I am needling him)
If...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |