mark processed

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Mark as processed

Mark as processed

resolvedResolved · Urgent Priority · Version 2016

Marco has attended:
Access Introduction course
Access Intermediate course

Mark as processed

Good day,

I have a tblDeductions, where I would like to record some deductions made to staff hours. We have a time sheet number (not relevant in Access) from which we deduct a certain amount of hours for a particular course as set in the tblCourse.
So far, I have it all working, however I'm struggling to figure out how I mark a deduction done tick box if that staff member (StaffID) has been deducted the full amount of hours. I have a Update query that totals up all the deductions made for a particular staff member, and the idea is that the update query ticks all the boxes to mark Deduction done. This part is not working and I'm struggling to figure out the best way to do this.
On the form where deductions are recorded, the cbo box to select a staff member should only show the staff members who have not yet fully deducted the course. Once selected, a different txt box should shor the remaining hours to be deducted.
This is the first time I'm using this forum, How would I go about uploading what I have so far?

I look forward to some much needed help.
Thank you in advance.

Marco

RE: Mark as processed

Hi Marco,

Thank you for the forum question.


You can send what you have done to:

admin@stl-training.co.uk


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

RE: Mark as processed

Hi Marco,

Happy New Year.

I am sorry about the late answer but I have been away on holiday.

I have been looking at your database and I have been creating a couple of queries which I hope will help you in the right direction. If you have a look at the TestQuery. It is a Update Query which will tick the two check boxes if there is hours to deduct. I have also created a query (TestQuery 2) which will select all records where the full number of hours are not deducted.

I have had huge problems creating a form which only will show staff where the remaining hours should be shown. I have some time Wednesday and hopefully I can get it right.

The database is attached with the queries I have created.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Attached files...

CIEHDeductions v1.03.accdb

RE: Mark as processed

Hi Jens,

Thank you for helping us out with this. Can I just ask, how or where can I find the attachment you have uploaded?

Regards,
Marco

RE: Mark as processed

HI Jens,

I have managed to download the db. Thank you for this. We have booked ourselves onto a Access training course on the 26th Jan. I hope you are the tutor for this training. If this is the case, then it might be better if I can talk to you about this then. I look forward to hear from you.

Regards,
Marco

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

RE: Mark as processed

Hi Marco,

Yes I will be the trainer on the course.

I will have some ideas ready for you on the day and we can talk about it in one of the breaks.



Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

RE: Mark as processed

Thank you Jens.

We ate big fans of yours.

Marco


 

Access tip:

Undo Entries In Records

To Undo any entries or changes in records:

Hit the ESC key once for the current field

And ESC twice for current record

View all Access hints and tips


Server loaded in 0.08 secs.