Recent content by digitalshepard

Thanks vbaInet. That worked well, and simple.

I have the following source data: Item Revision Start End 332 B 9/2/11 9/15/11 332 C 9/21/11 9/22/11 332 E 11/2/12 11/29/12 2A9 A 1/13/13 1/14/13 2A9 C 1/16/13 1/18/13 I'm trying to make a select query to provide the following output...

GPGeorge - I checked out Brent's post and am thoroughly amazed that this fixes the bug. Thank you very much.

jdraw, That's what I've been getting as well. It sounds like this is a verified bug for this setup. I wonder if there is a work around?

Is there anyone with a Win 7 & Access 2003 setup who can verify this issue? I've poked at it periodically and have yet to find a work around.

tt is declared in a subquery in the first monthlydata query. You have to look at the SQL to see how it works. Its an adaptation of http://www.access-programmers.co.uk/forums/showthread.php?t=213001

The sample DB I posted has been downloaded 5 times now. Has anyone tested it on Windows 7 with Access 2003 and gotten it to work? I sure haven't.

I have uploaded a sample db having the above mentioned issues. The 2 MonthlyData queries give errors in W7 but not XP. No VBA.

The error is "Option invalid or no longer set", but only with Windows 7 under Access 2003. To restate the problem, I am trying to select the bottom 13 records from a query, but there is no SELECT BOTTOM in Access. My work around was as follows: Query1: ORDER BY table.Field DESC Query2: SELECT...

As many of you are likely aware, Access has a [Select TOP] feature but does not have a [Select BOTTOM] feature. Very annoying. The work around I used had a query which sorted a field in descending order [ORDER BY table.Field DESC], and another query which used a [Select Top 10] and a [ORDER BY...

I think I'll give ChrisO's idea a shot.

Correct. If that were possible it would solve this challenge. However, the fields for the controls are linked to a table different than that of the subform, therefore that doesn't work either. The reason I would like to place controls in the form on top of a subform is to provide a logical...

Is it possible to place controls on top (in front) of subforms in Access. If so, how is this done? I have a main form and a subform. I would like to give the illusion that a FEW of the form controls are actually part of the subform, but the rest of the subform controls should appear...

Background: I have a form and 2 subforms - subform1 is a pivotchart and subform2 is a datasheet generated by a query. I would like to filter the results of the datasheet based on fieldbuttons selected in the pivotchart. Discussion: I have accomplished similar tasks using a syntax similar to...

I want to build a query using data from sheet 1 of the attachment for the purpose of building either a chart like in chart 4 of the attachment, or a pivot chart. This chart shows a running sum of items per employee for the most recent 30 days. Ideally I could make a pivot chart to filter data by...