Any Way To Record Weekly Attendance

Nov 26, 2011

My next challenge/task is to create a way to record weekly attendance. I have looked at several databases available online but not that really reflect what I need. Also I am trying to do it the simpliest way possible (for now) with my limited knowledge of VBA code.

Here is what I am hoping to do. I have a form linked to a query that will select the students assigned to a faculty member in all the courses that faculty teaches. I would then like to be able to use the same form, and a second combo box, to create records in an AttendanceTable that stores the attendance for that student in that course for that week. I have created a key using StudentID-CourseID to identify each student with each of the course they are enrolled in. It is also used to relate all the involved tables.

View Replies


ADVERTISEMENT

Forms :: Attendance Form - Checking The Box For Only One Record

Apr 6, 2015

I've got an attendance form set up with check boxes for each day I want to check attendance. I have two problems with this form.

1) All the boxes start out with little squares (I want them to be blank)
2) If I try checking a box for one person, it checks all the boxes in the column (same with unchecking).

View 3 Replies View Related

Weekly Job.

Jul 22, 2005

I'm sure this must have been the subject of a thread before, but after an hour seaching my head aches.

I'm running (Access 2000 on XP Prof) a sort of planning board. The week commencing dates change automatically, as per previous postings on here.
I have a job run from a command button to then change a field representing the week the job is to be run in ie week 2 jobs to week 1, week 3 to week 2 and so on. So far so good.

I would like this job kicked off automatically once the first time the db in opened in the new week.
Any advice or pointers to appropriate thread welcome.

Ta

View 4 Replies View Related

Bi-Weekly Dates

Mar 14, 2008

I'm not really sure what to do on this one, I'd like to hear some suggestions on what everyone thinks..

I have a database where users enter information Bi-Weekly into a form. I have 2 date fields set up, one is called the RecordDate, it is the date at which the user has entered the actual data into the database. Ignore this date.

I have another date, called MainDate, which is the date that all departments need to have submitted the reports (Each department fills out these bi-weekly reports [approx 100 departments]), meaning that one complete set of 100 reports is entered every 2 weeks. Even though they are all entered at various dates within those 2 weeks, usually almost at the end of the 2 weeks, all of the reports will contain this MainDate and it will be the same for all departments every 2 weeks.

I'm looking for the easiest method to accomplish letting a user select these bi-weekly dates and making sure that the dates are correct, validation?.

Some thoughts I had
1) For instance, if typing in the bi-weekly dates, I want it so that they can only type in the dates of every 2 weeks, no other dates will be allowed.

** Best option in my opinion 2) Have a small calendar that expands when clicked right next to the MainDate field so that on the calendar you can only click on dates every 2 weeks, or have every 14 days a different color on the small box for the date. [the users seem to like the ease of using calendars, one of the reaons is is a good option in my opinion]

3) Have a dropdown? That shows the current date that is allowed to be selected based on some sort of 14 day interval cycle. (i.e. after 14 days of one cycle are up, the only option in the dropdown is to click the next MainDate, which will be exactly 14 days from that just passed.

Anyway to have this date automatically filled in after 14 since the last MainDate entry? Bi-Weekly reports are due every second Thursday.


Thanks in advance to any input you can offer
Dave

View 1 Replies View Related

Weekly Query

Mar 18, 2006

hi,

I am creating a booking system and I need to create a query for a report that will show how many bookings are made per week and the total of the bookings. I have managed to make a query that will get the number of bookings and the total, but i have no idea on how to do this for each of the weeks in a month. From this query i hope to then make a report showing 4 weeks at a time.

Any help would be great. :)

View 3 Replies View Related

Query Weekly Totals

Aug 15, 2007

On the attached jpg(s) you will see the query I'm working with. It's fairly simple except for a couple of things and those are the items I'm stuck on.

What I'm trying to do is get a representation of the amount of traffic that has come through our salescenters in the last week. Some centers had no traffic and others had multiple prospects. So when I look at the query for week 33 (this week) I would like to see all the centers even if they had zero traffic - the query should show zero.

If you look at Traffic_Query.jpg you'll see how the table is laid out. With the query I'm trying to show all of our centers for the current week even if no traffic was entered.

I may not be explaining it clearly so if you have any questions let me know.

Thanks,
Chester Campbell
Joseph Freed and Associates

View 5 Replies View Related

Weekly Summary Of Tasks

Sep 17, 2007

I am just starting to use Access and have set up many simple forms, datasheets, reports, summaries, etc. I have not worked with macros, etc. and need help for this project. I have set up a task table

F1 - DateOfCall - date - now()
F2 - Client - text
F3 - DateCompleted - date
F4 - DueDate - date
F5 - problemDescription - memo
F6 - Resolution - memo

I need to run a query and/or report every week summarizing what has been done the past week. Would also like to view previous weeks. I need help. How do I go about doing this.

View 1 Replies View Related

Difference Between Weekly Sales

Sep 11, 2011

In a table I have the sale of a department:

week SP Value UNIT
N John 100 8
N-1 John 80 6
N-2 John 120 10
N-3 John 90 9
(just the last 4 weeks and N sale professional)

I would like to have a form with

SP Value N-1 N-2 N-3 Units N-1 N-2 N-3
JOHN 100 20 -40 30 8 2 -4 1

And this go on for each SP

View 1 Replies View Related

Queries :: Save Weekly Changes To A Table

Nov 18, 2013

We import data to a table on a weekly basis. We delete the table and replace the data. Most of the data is the same. It's date's, group names, ...

Now we would like to save the weekly table and add a saved date. Then we would like a query that puts all the saved tables together and that we could filter.

For example. A team is planned to do a work on 01/01/13. The next week it has changed to 07/01/13. So the data in the table it updated but we can't track the changed date. If we had the different tables we could filter that team and so that the work was originaly planned on date x to be done on the 01/01/13, on date y it was 07/01/13....

Of course if we would save the complete table every time it would mean a lot of useless data that hasn't changed. So a better solution would be that a query could see which data has changed and it only saved those lines on that date.

View 11 Replies View Related

Attendance Dbase

Feb 12, 2007

Dear fellows
hi
I need sample access dbase records and retreive attendance of students in course
thank you for help
moheb morcoss

View 3 Replies View Related

Committee Attendance

Apr 29, 2005

I have a task of creating a database to track committee members attendance at meetings. Members can be on more than one committee. I have created tables for committees, committee population and committee members.

The meetings would take place once a month and do not need an exact date. A Yes/No would suffice for record of attendance. My question is what would be the best way to set up the table to track this since members can be on more than one committee?

I'm thinking that having a separate meeting table for each committee would be a bad idea. But haven't come up with any other ideas. Any suggestions???

Thanks :)

View 7 Replies View Related

Attendance-Query

Apr 11, 2008

Hey,

for some days i've a problem with an Access-Query and up to now i didn't succeed to find an answer, i'm not even sure if there is one.

So, how to explain my problem.
I'm trying to compile a Database for my small department to organize our computer-short-course
students (application, grades, attendance...)

And with the grades i have a problem as well as with the attendance. Up to now we are just using paper sheets for grades and attendance. So i just thought that it would be the easiest thing to create a similiar-looking form, drawing of planned Query-output-layout is attached.

The attendance should be set with a checkbox. New days are set with a small subform.
For the attendance i've this table-layout:

tblAttendance
aSID
aCID
aDate
aPresent

When a new day is set, every student gets a new record at the tblAttendance, which shall be compiled together for the later Attendance Form.

So now the big question comes, is it possible to create
a query that fits my needs (variable amount of days and students and the possibility to set my records)? It is important that i've a big sheet with all the days, students of a course
at the same time.

Any suggestions - i'm completly lost.
Thanks in advance,
protos

View 2 Replies View Related

Calculating Attendance

Mar 17, 2005

i have tblmember tblclass and tblattend

the tblattend is

member 1d
class id
date of class
Attended (check box to say or no on a form)


i need to produce a quey which will calculate % attendance after each month and after each year of each member and class

how do i do this

View 10 Replies View Related

Move GrandTotal Column To Right Of Weekly Columns

Jan 16, 2007

Below is the code that I have for a query. Currently the
GrandTotal Column appears to the left of all the Weekly Columns.
Is there a way I can have the GrandTotal column appear to
the right of all the Weekly Columns? The weekly columns
will expand or contract depending on the dates selected.



PARAMETERS [Forms]![Queries_ReportsFRM]![StartDateTxt] DateTime, [Forms]![Queries_ReportsFRM]![EndDateTxt] DateTime, [Forms]![Queries_ReportsFRM].[FaultCategory] Text ( 255 ), [Forms]![Queries_ReportsFRM].[SystemGroupProblem] Text ( 255 );
TRANSFORM Val(Nz(Sum([Totals]),0)) AS SumOfTotals
SELECT [Trends-1-3TON-WEEK].SystemGroup, [Trends-1-3TON-WEEK].FaultCategory, [Trends-1-3TON-WEEK].Problem, Sum([Trends-1-3TON-WEEK].Totals) AS GrandTotal
FROM [Trends-1-3TON-WEEK]
GROUP BY [Trends-1-3TON-WEEK].SystemGroup, [Trends-1-3TON-WEEK].FaultCategory, [Trends-1-3TON-WEEK].Problem
PIVOT [Trends-1-3TON-WEEK].YearMonthWeek;

View 1 Replies View Related

Too Many Fields - One Year Of Weekly Sales Data

Sep 6, 2007

I'm new to Access, and I've been able to figure out a way around most of the problems I've run up against, but this one has me completely stumped. I would really appreciate any help!

I need to create a query that will produce a report that will follow the sales performance data of new agents for one year. I need to have two pieces of data for each week: number of policies sold and total value of policies.

The format looks like this:

Jan1 Jan2 Jan3 Jan4 Feb1
Number 12 4 6 3 6
Value 1554 320 229 221 1824

I have been pulling weekly sales data from an external database weekly and importing it into individual tables in my Access database. I had no problem for the first 3 months, but now I am getting the error message "Too Many Fields". If I understand it right, you can have up to 255 fields in a query. I don't have anywhere near that many. What could be wrong?

Any suggestions would be greatly appreciated!

View 2 Replies View Related

Queries :: Weekly Query That Update Reports

May 16, 2014

I have made a query that was supposed to update my reports every week with new inquiries that we get.

I thought i had solved this but when i opened the report this morning, it's just showing last week's.

I have this as the criteria:Between (Date()-7-Weekday(Date(),2)+1) And (Date()-Weekday(Date(),2)+1)

It's probably wrong.

View 7 Replies View Related

Creating Weekly Report From Cumulative Totals

Mar 13, 2013

I have an excel report which I would like to run through Access to drive trend analysis and compare with other similar reports. The excel report has a cumulative spend figure each week and not the actual weekly spend numbers, the budget figure also can change depending on the actuals.

Excel report:

Week 1
Product ID
Customer
Yearly Budget
Spend

1122
Sam
100
3

1123
John
200
4

[code]...

Will I need to create a new table each week or can I link the file and it updates automatically?Can Access store the weekly data and just update it one week at a time?

View 3 Replies View Related

Sample Attendance Database?

Sep 7, 2006

I am trying to create an attendance application for my group of 6people, does anyone have or know where i can find any to look at. I don't even know where to begin.

Daily in and out. Keeping tabs of our vacation days/sick days.
I just need to know where to begin, or need a sample for ideas in creating this. I have looked high and low. Please show me/tell me if you have any or how you did it, if you have done it before. Thanks friends!

I posted this here but didn't get any response.
http://access-programmers.co.uk/forums/showthread.php?t=114099

View 6 Replies View Related

Access Attendance Register?

Jan 24, 2007

Hi,

Well I'm stumped...

I am creating a new database system for my cadet organisation, and I am in the early stages of learning how to use Access. (I am using this as a learning curve, as I need to get to grips with Access for University, there's no better way to learn than by doing.)

I want a system that stores the attendance of cadets on each night we meet, so far I have:

|Table| Cadets
CadetID - AutoNumber (PK)
FName - Text
LNAme - Text
Flight - Lookup from Flight Table

|Table|Flights
FlightID - AutoNumber (PK)
Flight - Text

|Table|Attendance
AttendanceID - AutoNumber (PK)
Attendance Type - Text

The table that actually contains the register I am unsure how to structure, it would have to contain Cadet Name/ID, the date and Attenance type, from attendance DB.

The table would be updated every Tuesday and Thursday, when we meet. I've been thinking for a while about how to do this and can't find a good solution.

As the data will be entered by a user (who won't know Access from Adam) I'd like a form that lists all the cadets in the Cadet table, as each of these will have to be registered, and then a drop down box listing the options from the Attendance table next to each cadet, doesn't have to be drop down, can be optionbutton, image....

In the final version I would like the cadets to be sorted by flight in the form, but lets not go mad yet!

Can anyone help me with this? Or am i simply being silly?

I haven't used Access for long, but have used VBA in Excel before and am a fairly experienced user; I will attempt anything but bare with me if at first I don't succeed.

Any help appreciated
Tim

View 1 Replies View Related

Attendance Data Type

Apr 19, 2007

Hello everyone, I am buiding up a database for activity school. Here first step of buiding the base, I got an attendance data type problem. i am now using "yes/no", but if i want to query about the number of student each class, is that possible?

Thank you for your help.

View 5 Replies View Related

Help! Need To Make Attendance Form!

Mar 20, 2006

I am trying to make a class attendance form, where user chooses classType
ex:"English, French" then the program shows all of the students from tblStudents that are enregistered in that class. And some how make it so that user could select on or many users in the same class and press add button which will add the students into attendance table for the current class and the current day,

**Allso what I would like to do if possible after the form above works, is to if the student has been allready added for the current day, the check box becomes un editable with appropriable comment in the comments line for that student or for examples the student registered for 12 classes, the attendance keeps track of the classes and when the student tryed to go to 13'th class the check box is uneditable and in the comments line for that student metions the reases.

View 6 Replies View Related

Sample Attendance Project?

Sep 7, 2006

I am trying to create an attendance application for my group of 6people, does anyone have or know where i can find any to look at. I don't even know where to begin.

Daily in and out. Keeping tabs of our vacation days/sick days.
I just need to know where to begin, or need a sample for ideas in creating this. I have looked high and low. Please show me/tell me if you have any or how you did it, if you have done it before. Thanks friends!

View 1 Replies View Related

Calculating Employee Overtime Worked (weekly Total)

Oct 26, 2006

Hello my beautiful worldwide friends :D
I am trying to calculate employee Overtime hours from their recorded TimeIn and TimeOut if over 7.5 hours. So anyday they work past 7.5 hours should be calculated and totalled at the end of the week. And i can't seem to figure it out, maybe my maths is bad? Maybe it's my query? The section of my report? What could i be doing wrong here, i have spent hours and im getting no where.

I have attached my report.
Can you help me figure out why my daily total shows but the weekly total is not showing?

View 9 Replies View Related

Queries :: Linking Weekly Rota System To A Date

Oct 4, 2013

I have a staff rota system that works on a rolling 4 weekly basis. I am using a table to store the shifts of a person dependent on week. I want to be able to tell access that Monday on week 1 corresponds to a certain date and then get access to figure out the rolling system based on that date.

eg Monday 21/7/13 is week 1 (7 days later it knows it is linked to week 2)

This is so if a staff member is off sick I can say they were off sick on the 24th and it will populate their timesheet with the corresponding shift without me having to input it manually. Doable?

View 1 Replies View Related

Reports :: Making Report Monthly / Yearly And Weekly

Mar 10, 2015

how to create the report monthly,year and weekly using access 2007?

View 3 Replies View Related

General :: Weekly Calendar To Show Added Records

Nov 3, 2014

I need a calendar that can go forever that shows weeks and not months and each record i add (or is added by admin form) will show up. I have a calendar attached here to show what i mean but its monthly not weekly.

Basically it needs 7 spots for employee vacation leave, 2 spots for supervisor leave and 2 spots for other leave. My current calendar will only fit the 7 employees and no1 else thus the reason i want to go weekly and not monthly, so it has more room.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved