Search results for query: *

I frequently use Allen Browne's “Multi-Select List Box to Filter a Report” form and code to select academic years for many of my reports. However, I would like to have side-by-side lists in my multi-select form: one for academic year and one for Department/Program. I tried adjusting the code...

Can anyone suggest a bit of code to calculate the months between an end date in one record/row and the start date in the next record/row of a record set. The following is a synopsis of the problem area in my code: Set rsA = CurrentDb.OpenRecordset("SELECT * FROM yada, yada, yada ....) Dim...

I'm trying to use the following code with a set of nested If statements ... but I'm getting "Loop without Do" error at the fifth line from the bottom: "Loop While Not rsA.EOF" I think I'm missing an End If? Can anyone help? Thanks-Colleen ------------------------------------ Option Compare...

I need to calculate consecutive years of service in part-time or full-time status. If this has been answered in another thread, please refer me to it – I’ve searched for the better part of a day and didn’t find anything relevant. For my scenario - a temporary employee may work: 2009-10 –...

I work with contracts spanning academic years. I need to create a report that shows consecutive years of service in part-time or full-time status. For example a temporary employee may work: 2009-10 – Full time 2008-09 – Full time 2007-08 – Full time 2006-07 – Part time 2005-06 – Part time...

I have a combo box on my main form that locates an employee record, then two subforms show current contract details (single form) and contract history (datasheet view). Combo box works fine. (See ComboBox Code below.) This combo box simply goes to the record of the individual typed into the...

Hi all, If this has already been answered, please refer me to previous thread. Currently using MSAccess2007/Windows XPPro I have created a form that pops-up when certain reports are opened that has a listbox listing academic years (text): Name: lstAcademicYear Multi Select: Simple Row Source...

I have the following tables: EMPLOYEE and CONTRACT – one to many – joined by Employee_Number In my database, the user screen is composed of a main Employee form - info on the left side of the user's screen, and a Contract subform – continuous form and appears on the right side of the user's...

I think I am simply overthinking this and have given myself a headache in the process, but i can't seem to find a solution to my query problem. I need a report to pull all faculty eligible for leave in 2009-10 (in a field [Eligibility_Date]) PLUS their next leave eligiblity. I have a current...

In a recent post of 11-Nov-2008, Michael Red provided the code for calculating age from "date of birth" to "date of death or current date". After finally placing the code in the correct module with the correct code for calling the function, I think I've isolated the last annoying problem...

I have created a calculated field in a query (modified from a FAQ: faq181-55) which works great, calculating from the present date as well as a date of death - but it's not in the format I desire; e.g. 9 months = 0.666666666666667 or .67. CalcAge...

In an earlier posting a similar question was asked: "asfhgwt (TechnicalUser) 14 Aug 06 10:56 -Anyone know an easy way to show the current record number on a record-filtered form -- without showing the navigation arrows? (I don't use control numbers.) Example: There are 1000 records in the...