473,320 Members | 1,695 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Roster web application

Hi all,

I am about to create a web application using asp and vbs to build an online
roster for a department of 25 people. The roster covers some 10 shifts a
day, 7 days a week always starting on a Sunday. I will be using an access
database file to hold the information. At this this stage I will hold all
the data for each week based on the date that the week starts.

I am looking for ideas on how to dynamically give the user the option to
choose any given week in any given year, always starting on a sunday. Could
this be created on the fly or would it be easier creating a database table
holding the dates for Sunday for a year or 2 ?

Once a week is chosen a check on the database will determine if that weeks
roster has been created or not. If not a user with the correct permissions
can then create it.

The rosters are currently written out by hand. It is a labourious task which
must have certain numbers of staff working each shift for a given day. By
creating a web application automating the checking process and making the
roster available online and by email will make life easier for all staff
involved.

Any help, much appreciated.

Cheers, Bill.

Jun 28 '06 #1
1 1776

Blinky wrote:
Hi all,

I am about to create a web application using asp and vbs to build an online
roster for a department of 25 people. The roster covers some 10 shifts a
day, 7 days a week always starting on a Sunday. I will be using an access
database file to hold the information. At this this stage I will hold all
the data for each week based on the date that the week starts.

I am looking for ideas on how to dynamically give the user the option to
choose any given week in any given year, always starting on a sunday. Could
this be created on the fly or would it be easier creating a database table
holding the dates for Sunday for a year or 2 ?

Once a week is chosen a check on the database will determine if that weeks
roster has been created or not. If not a user with the correct permissions
can then create it.

You should look at the DatePart function

<%
Response.Write DatePart("ww", Now)
%>

--
Mike Brind

Jun 28 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: J. Baute | last post by:
I'm caching data in the Application object to speed up certain pages on a website The main reason is that the retrieval of this data takes quite a while (a few seconds) and fetching the same data...
3
by: Amit Dedhia | last post by:
Hi I am developing a Dot net application (involving image processing) on a uni processor. It works well on my machine. I then take all my code on a multi processor, build and run the application...
1
by: Mark Reed | last post by:
Hi all, The background to this problem is that I have been asked to create a Db that monitors holidays within the warehouse. What the users wish to do is to type in a colleague number (unique) and...
6
by: orekin | last post by:
Hi There I have been trying to come to grips with Application.Run(), Application.Exit() and the Message Pump and I would really appreciate some feedback on the following questions .. There are...
0
by: Mark | last post by:
Hi, I have been asked to create a roster application for a local company. Rather then reinventing the wheel, does anyone know of some .NET open source roster software. I have looked at...
1
by: robert d via AccessMonster.com | last post by:
I'm trying to determine who is linked to the backend. I'm using the Microsoft code on the Jet User Roster that uses ado to develop a list. The front end and backend are secured. This code is to...
20
by: Peter Oliphant | last post by:
How does one launch multiple forms in an application? Using Photoshop as an example, this application seems to be composed of many 'disjoint' forms. Yet, they all seem somewhat 'active' in...
6
by: Josef Brunner | last post by:
Hi, I published my application (VS 2005) and am now trying to install it when I get this error message. It worked before...even on a different machine. Here is the detailed description: ...
6
by: rdemyan via AccessMonster.com | last post by:
I've implemented the Jet Roster code for determining how many users are logged into the backend file. There are many code examples and I've copied them. Also, I've checked at least 20 times...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.