Search results for query: *

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

For those of you who use the search feature (which I am one ;) The reason I was getting this was that Access didn't like to have to populate my AutoNumber Field, as well as, I was trying to populate a yes/no field to a bit (0 or 1) field. I just changed the yes/no field in Access to a bit. Adam

I have an access database that is linked with sql server through ODBC. All workds fine, I can add records manually by openeing the tables and typing in data. But when I try to run an append qry, it gives me a "Didn't add 1 record due to a key violation". well, I have tried about...

I have an array of LABELS. I also have a mouselistener and I need to know how to remember which label was clicked and change the background icon for it. any ideas???? Thanks Adam

As it turns out, if you don't select any unique key feilds when it prompts you, it doesn't let you add/delete records. Thanks for your help anyway! FYI for anyone searching for an asnswer later. Adam

I have an old access database that I recently migrated over to sql 2000. I still have all of my qry/forms in access, I just linked all of the tables. Whenever I try to run a delete qry, it tells me that it "Could not delete from specified tables". Has anyone ever had this error and...