Recent content by adamr99

Hello all- I am currently experienceing the following bug in Access xp: http://allenbrowne.com/bug-05.html Conditional formatting If you apply conditional formatting to calculated controls, you may start an endless loop where the form recalculates continually and fails to display the results...

Found the issue: http://allenbrowne.com/bug-05.html Does anyone know of any 'better' work arounds than the one given on the page? (Just don't use them). Thanks Adam

New question. Is there any reason why when I open a form in DataSheet view, the data is 'calculating' until I highlight an entire row? My CPU climbs to 100% and I can't see the values in the cells. I think that this has something do to with the conditioanl formatting.

That is what I was looking for! Thank you! :) Adam

Is there any way to change the color of an indidual cell's text in the Datasheet view of a form? For example, one of my fields must be above 48.0. So, if the text entered was 50 - I want it to be green. If the text was 30, I want it to be read. Thanks in advance! Adam

Hey, for those of you searching the archives on this. I ended up finding a solution. http://www.tech-archive.net/Archive/SQL-Server/microsoft.public.sqlserver.server/2004-04/3108.html select l.* from letters as l join ( select letter from letters group by letter having...

Any Ideas?

Yes. Basically, if the first field is duplicated in any other first field (regardless of what the other fields are) I want it in the resultset. test7, 1, 2 test7, 1, 6 YES test7, 1, 1 test7, 1, 1 YES test7, 7, 1 test7, 0, 1 YES testX, 1, 1 test4, 1, 1 NO Sorry I am so confusing.

Sorry for the multiple posts. Also, I would like to include records that are the same in only one of the two last columns. That is: test6, 1, 1 test6, 1, 000 The only thing that I care about is the first column being the same. The rest is a "don't care" condition". Thanks! Adam

SkipVought- YOU ROCK. Ok, now, my fake data was a little misleading. Is there anyway that I can include records that are EXACTLY the same as well? test5, 1, 1 test5, 1, 1 ?? Thanks! Adam

Here is the exact code that I ended up with: SELECT First(t1.test1) AS FirstOftest1, t1.test2, t1.test3 FROM Table1 AS t1, Table1 AS t2 WHERE (((t1.test2)=(t2.test2)) AND ((t1.test3)=(t2.test3))) GROUP BY t1.test2, t1.test3; Here is the result of that code: test3 1 1 test4 1 2 test4 1 3 test1...

I have the following records with 4 fields: test1, 1, 1 test1, 3, 4 test3, 1, 1 test4, 1, 2 test4, 1, 3 I would like to return: test1, 1, 1 test4, 1, 2 test4, 1, 3 test1, 3, 4 That is, I would like to get the non-distinct records ONLY non-distinct on only the first field. Note that on the...

How about that, solved my own problem. For those of us who search this forum (like me) use the onCurrent event - as indicated in: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac10/html/acevtCurrent.asp Goood Luck Adam

Sorry, I should have been more clear. I want to know if there is an event for when I cycle through the different records, not just when a change to an individual record is made. Thanks Adam

Is there an event that tells when the record changed on a form? Changed either by a mouse scroll or by clicking on the built in Access arrows at the bottom. Thanks Adam