Access Booking System - Microsoft Access / VBA

PaulD

Can anyone point me in the direction of a sample Access booking
system? Trying to build a booking system were customers can book a
computer by date and timeslot, each timeslot having a limited amount
of computers.

Cheers for anyhelp, pointers given.

PaulD

Nov 12 '05 #1

Subscribe Reply

16816

MGFoster

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
When you open Access you are prompted for the name of the database you
want to open - select "Blank Database" (if in Access 97 and earlier
versions) or "New from template" (if in Access 2K or later versions) -
a dialog box will appear that has 2 tabs, "General" and "Databases, " -
select Databases. Select the template named "Resource Scheduling."
This one should do for what you want.

If you can't see the sample template dbs you will probably have to
install them - use the Access CD/files & install the Samples (you'll
have to look thru the installation selections - I forget where the
Samples checkbox is located).

MGFoster:::mgf
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP52HvYechKq OuFEgEQJGqACglE oiSXSLBFi25uuvG OehsiAZtEUAoI5O
dELDtz7jFXGKpOO htNrYV5ef
=sFTN
-----END PGP SIGNATURE-----
PaulD wrote:

Can anyone point me in the direction of a sample Access booking
system? Trying to build a booking system were customers can book a
computer by date and timeslot, each timeslot having a limited amount
of computers.

Cheers for anyhelp, pointers given.

PaulD

Nov 12 '05 #2

Pieter Linden

pa************@ hotmail.com (PaulD) wrote in message news:<ee******* *************** ****@posting.go ogle.com>...

Can anyone point me in the direction of a sample Access booking
system? Trying to build a booking system were customers can book a
computer by date and timeslot, each timeslot having a limited amount
of computers.

Cheers for anyhelp, pointers given.

PaulD

Paul,
read this post...
"Finding Free Time in Equipment Reservation and/or Compare Two
Tables". It's been discussed here many times before, so read up and
then give it a try. In a word, I think timeslots are a bad idea, but
read the post and make up your own mind.

Nov 12 '05 #3

Similar topics

1895

booking system for tourist bus, walking track

by: evski | last post by:

kia ora I am after a set of php script to administer bookings for buses and huts and coordinate customer enquiries in our small tourism business I have looked extensively but not come up with much except bughotel which seems a little bloated but along the right track An online support "ticket" type system would probably work for customer enquiries but this needs to be integrated in to the booking

PHP

18693

checking room availability for hotel booking system

by: Dave Robinson | last post by:

I was wondering if anyone could help me with a problem I'm having. I've been using Dreamweaver to create a hotel booking system for a friend of mine, using MySQL (version 4.0.21) and PHP 5. The bit I'm struggling with is checking the Room Availability based on dates that are typed into a textfield and then returning a list of the available rooms on the next page. The three tables involved in this function are: CREATE TABLE `room` (

PHP

5585

Ticket Booking System

by: thehuby | last post by:

I am prototyping a ticket booking system and just wanted to ask a few questions. 1 - What is the standard way of temporarily reserving a number of tickets throughout the purchasing process (to stop other people reserving those seats or whatever). 2 - What do you do to release these 'seats' if someone closes their browser? Is it just a cron job set for every 20 mins?

PHP

6435

Wanted: Open source php course booking system

by: samkut | last post by:

Hi, we are looking for a slim open source course booking system with the following features: * users can enroll for courses, cancel their bookings * maximum number of participants * administrator's pages: list of participants and their contact details (email, phone etc.) So far, we have found an extension to the mambo CMS

PHP

3217

Online booking system problem

by: simba | last post by:

Hello, I am currently doing a project which requires me to develop an online booking system for hotels and integrate both bed and room booking. I have the room booking working but I cant seem to get the bed booking working. I have dorm rooms with 8 beds in them and I would like to have a query(or something) which allows me to make the dorm rooms bed booked instead of room booked. Anyone any ideas on how to make this happen, anything would be...

Oracle Database

3020

Diary/Booking system question

by: shrimpeh | last post by:

Hi im currently messing around with creating a diary/booking system for a leisure centre. And im stuggling with how I can display all the data. The booking is taking the activity the customer is doing and the date and time etc. I want to display the data with each different activity having its own column and the rows having times. So that you can view a full day and see what is happening with each activity at all times of the day. Basically I...

Microsoft Access / VBA

2817

Booking System - Vacant room report

by: Peter Sutton | last post by:

Greetings all, My booking system includes 2 tables: tblRooms with the key field RoomID, and some other fields AND a tblBooked Rooms with a number of fields including RoomID and BookedDate. For a given date range, I can generate a vacant room report by generating a temporary table of all the Rooms and BookedDates using a cartesian join, and then either deleting the booked rooms, or by

Microsoft Access / VBA

1579

restaurant table booking system asp.net

by: csgraham74 | last post by:

Hi guys, i just thought id throw this one out here but i was wondering if anyone knows of where i would find an open source booking system project for asp.net ?? ive been asked by a client to develop one but heir budget is small so unless i can find one that can be tailored relatively cheaply il buy something off the shelf. if anyone knows of any good off the shelf packages for this functionality then please let me know also ??

ASP.NET

3071

Logic for booking system, day rates, etc

by: 88stevie | last post by:

Hi all, I have a system and I'm a little stuck. It's a booking system. It has rooms, etc and every room have a daily price. Then it has special daily rates when assigned. How do I calculate the total cost of a room if a daily rate exists?

PHP

9671

What is ONU?

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

General

10212

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10161

The easy way to turn off automatic updates for Windows 10/11

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,...

Windows Server

9035

AI Job Threat for Devs

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

Career Advice

7538

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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

Microsoft Access / VBA

6777

Couldn’t get equations in html when convert word .docx file to html file in C#.

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();...

C# / C Sharp

5560

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4112

transfer the data from one system to another through ip address

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

C# / C Sharp

2919

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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

General