Search results

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

Thank you vbaInet. As it turns out, all my code was missing was DISTINCTROW. The reason my from query strings in the vba had extra text was to support multiple Inner Joins. All works well now. I can't thank you enough!

To replicate the issue: In the frmSearch window that pops up you will see 7 controls which build a query in VBA, which in turn generates results in the subform frmsubClients. One of those 7 controls is a color drop down - this is the control where the issue is. Pick a color to search from, and...

I have uploaded a samble db. Notice how the 'color' field shows no records when searched. Again, thanks for your help.

vbaInet, I appriciate your continued help and patience. I would use the inner join method, except that when I do the subforms displaying information from the tables that were inner joined no longer display any information, even through the correct records are returned on the main form. That is...

I have come full circle in my approach, and am no closer to solving the issue. I created a temp table to hold Doc_ID returned from a search query. Then I tried to pull records from tbl_Document where the Doc_ID match. One method was using INNER JOIN. However, when I try INNER JOIN the level 2...