Date problem?

[maintt]

Today 08:21 PM
maintt

Hi all

i am creating a student attendance database for 190 students, students are allocated two hour sessions, tue to fri, and am or pm, i have created a table with the following:

StudentT

StudentID
LastName
FirstName
StartDate
ReviewDate


then i have created a query using the above and then added the dateadd expression to add a date 7 days in the future to the start date and then again 24 times ie; class1 to class 25

i then created a form using the query and the form shows all the above and when you enter a start date class 1 to 25 fills in automatically the course dates, my problem is that if a student does not attend i cannot overwrite the date field on the form, my boss wants to be able to put a new date in where the student didn't turn in and have the form recalculate the new attendance dates without having to change the query.

any help would be appreciated

maintt

 

[PNGBill]

Normally you have a Form based on a DataSource - Query in your case, and you enter a value and a number of Text Box Controls are populated.

Now your boss wants to Change one of the Populated text Box Controls and get the form to re populate ?

You would normally need to "Requery" the form when any data is changed.

You can have this as an AfterUpdate Event on the Text Box Controls so when a value is changed, the form is Requeried and the new data displayed.

But.... You will find you are not able to change a value in the Text Box Control if it is from a query that uses more then one table/query for it's record source. If so, you may need to have some of the the Forms Controls in a Sub Form with the Table in question as the data source.

 

[maintt]

thanks pngbill i will try tomorrow, only been using access for two weeks, i think my boss thinks i am an expert, and i'm not, anyway will try and if i get stuck i will let you know, many thanks for the wuick reply

maintt

 

[G37Sam]

I am confused here, you're looking for a way to record student attendance (whether or not they attend their classes?) or are you trying to distribute the 150 students in smaller classes?

 

[vbaInet]

Building an Attendance Database is way beyond the table structure I am seeing so far. You really need to rethink your structure as you would need a table for AM/PM, Attendance Codes, Academic Year Ranges, how you will deal with non attendance etc.