Search results for query: *

TheAceMan1 .... No, actually, I need one report .... for example: for academic years selected in the AY list: 2005-06 2006-07 2007-08 .... and for the departments selected in the departments list, for example: Biology Chemistry Environmental Sciences Physics Hope this helps. Thanks a bunch...

Hi TheAceMan1 - No, the lists are not related in any way - both lists originate from tables. I have no problem going in and adjusting the SQL behind the report to get at what I need - but the select criteria form for users has to be, well, extremely user friendly. :-) Any suggestions will be...

The troublesome line: For Each varItem In .ItemsSelected

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...

Hi MajP, This worked PERFECTLY for me! You are the best. Thanks so, so much for your time. -colleen

do you ever have Jan to Dec contractsor multi year contracts starting Jan or ending in Dec" No, contracts cover a 2 semester academic year. I use generic dates (instead of fluctuating payroll dates) to track beginnings and endings of contracts. So basically contracts run: Fall => Sep-Dec...

Hi MajP, I have provided sample data for one employee and the different situations an employee may encounter. BeginDate ExpireDate Status 01-SEP-2001 31-MAY-2002 Full Time = 1 AY (academic year) 01-SEP-2002 31-MAY-2003 Full Time = 1 AY At this point, this...

Hi Ian, I'm not having much success with your code - but it's late in the day and I'm a novice at this. The code you provided would need to be the third decision-making step in a series of steps to determine if a record qualifies for inclusion in a running sum. I tried putting the code in...

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...

Thanks everyone! Fixed it - code works perfectly. 'If we are continuing with the same employee, same service type, check if semester or year If Year(dtBeginDate) <> Year(dtExpireDate) Then 'year, keep counting intCount = intCount + 1...

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...

Okay, I am a pest .... and module function runs (I set the data type for the new table/field range as date/time - instead it should have been text). HOWEVER, it runs just fine, and I get the little message at the end, but alas no data in the query table. Suggestions are welcome. Thanks again-...

Calling the function from the same query but different method: Field: Count Table: YEARSOFSERVICE Sort: (empty) Show: (checked) Criteria: CalculateService() results in an error: Data type conversion error and when I click on debug, the highlighted line of code is in the second Else...

Hi again, jesmiles, I tried calling the function from a query on a report: "ConsecutiveYrs: CalculateService([Count])" But I am receiving an error: "Wrong number of arguments used with function in query expression 'CalculateService([Count]!" Any ideas? thanks in advance- colleen

Hi jesmiles, In theory, the module is exactly what I need. I created the new table and the module as you instructed - but I can't figure out how to call CalculateService() or get it to work. I need to be able to show this in both, a form and a report. Thanks so much for your help so far! -Colleen

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...

Hi MajP, The link to your demos is no longer valid? "http://www.4shared.com/file/151793571/1124281e/DemoFAYTlistBox_and_Search.html" Will you be reposting soon? Or have you relocated the demo above? Please let me know when you find a moment. Thanks- Colleen

PERFECT! Thanks again- coleen

One more tiny problem - when searching for a name with an apostrophe in it - I get an error message: 3075 Syntax error in string in query expression 'Full_Name like'o'*';'. So, I believe I will need to do something to this line in the Class Module: strFilter = mFilterFieldName & " like '" &...