Search results

Hi folks I have an unbound form that contains three graph objects - Graph1, Graph2 Graph3. Each graph serves as a dashboard report and is linked to individual queries, each containing a field called 'Academic Year'. I would be grateful for pointers on how I can set the form up so that the...

Hi Arnelgp Thanks for your support. The test database creates the email messages but does not send direct. Can this be automated so they are sent without my intervention?

Many thanks for all assistance, and apologies for duplicate posts.

Hi all In trying to resolve this issue, I found a similar example on here relating to Payslips. The exact functionality I am after is the same as this. Only instead of emailing Payslips to staff, I wish to email attendance reports to schools. I downloaded a working dbase and have tried...

Hi all I manage an apprenticeship programme for a college. Students attend from multiple Local Authority areas, multiple schools per LA area. We require to report attendance by school after each day of the course. Currently this is particularly time consuming because attendance is marked by...

Hi folks I have a college information system that manages two-year courses. At present we have three blocks running 15-17, 16-18 and 17-19. I have an Autoexec Menu with buttons where users select buttons to administer data. One of these buttons is called 'Enrols'. This opens up a form...

Folks I work for a college. I'm looking to get my workplace to develop a Web Form that can submit Applications from their website directly to an Access database. Website is controlled by someone in Marketing and I'm being told that this isn't possible, which I know to be bollocks as I've used...

Thanks Pbaldy! I'll get to work on this over the weekend and try it out. Fozi

Hi all I work in a college and have developed an attendance management report. Within this is a breakdown of students attendance from particular schools which we then circulate to each school via email. Currently it is a very cumbersome process eg: User runs the report per school Save...

Thanks reycan. As usual with these things, one step forward etc. That worked a treat so long as there's only one month between start and end date. On a rare occasion long term sick stakk can be off on dates spanning three months. Is there a way to 'loop' the check returning values identified...

Thanks but not quite what I'm after. Essentially all periods of sickness are recorded by two dates [Start_Date] and [End_Date]. I need to do two things from here. 1. Extract the weekend days from the range 2. From the remaining days, identify how many fell into each month. Eg: Joe off...

Thanks Recyan I follow the logic but no sure how to factor in the 'working days' part into the formulae. Fozi

Brilliant. I had to make a couple of adjustments to the code but essentially that's worked well. Only one issue. We only work Mon-Fri, so I need to exclude weekend days. Once again grateful for your assistance. Fozi

Captures both calendar and working days. So from a 12 day range I want to automatically identify the days for each month. Thanks for your reply.

Working on an absence database. Start Date and End dates are recorded. From this I then calculate the number of days absent. However when reporting I need to display absent days per month. So if Joe is off from 27/07/12 thru to 04/08/12 I need it to show x days in July and y days in...

:confused: Folks I'm working on a Travel and Expenses system and trying to come up with a solution to the following. Company has three bases. Company policy dictates that if departing from home to work at a location not your base, then you should clain the smallest distance between either...

Folks I've been asked to identify an alternative reporting tool instead of Crystal Reports for that staff can gain access to more immediate and user friendly informaiton. the plan is to link this back to a SQL database and user could then choose the informaiton they wish to access and the...

Sorry for the confusion. The parent form contains Project Details. What I want is a subform that captures ongoing corresspondence. I know this is pretty straightforward by inserting the subform within the Parent form and linking by Project reference. However to save space on the form I...

I have a form on my system. I know how to include a subform on this and I also know how to use a button to open a form. What I want to know is how do you go about using a button to open a subform. Previous attempts to do this do not insert the common data to the subform control and and such...

Thanks Stopher for you reply. Would this resolve the issue of forms and reports etc mysteriously disappearing? Frank