Recent content by mohobrien

After using access daily for ten years I find that there is a property called Caption. That's embarrassing. Thanks Bob. I'll read what you suggested.

I stripped everything except a bit of a table and a query.

Shouldn't putting brackets around like this [Current Status] allow it to work? Access won't accept the brackets.

That is where I am doing this. I have done this hundreds of times before. I am wondering if STATUS or Current is a reserved word.

I can't fathom this one. I have a field called Current Status in a table. When I run a query I want to rename the field like this STATUS:Current Status No matter what I do, the field remains Current Status. I have tried putting square brackets around like this STATUS:[Current Status] but Access...

21/01/2009 7:48:06 AM Starting.... 21/01/2009 8:01:43 AM Finished Adding field Down to 13.5 minutes. Substantial improvement. Thanks Dave

I agree, I should jump out of the For Next loop once the Counter field is found, however, consistently, before change, 17 minutes removing the With-End With but keeping Rs!Counter, 20 minutes removing the With-End With and changing to rs("Counter"), 29 minutes reverting to original, 17 minutes...

I have a table with two fields. Disp_Num represents the name of a parcel of land and PPID represents a unique parcel of land. Sometimes, there are duplicate PPIDs with different Disp_Num. These would represent overlapping areas. The PPID field is sorted alphabetically. Disp_Num PPID S-140651...

I'll give that approach a try. The Fieldexists was a start at automating the whole process to do everything I'm doing in code but I messed it up and can't be bothered fixing it until I resolve the more urgent issue.

Somewhat of a problem: I have a mdb containing a number of tables, queries etc. The total size is about 40 Meg. when compacted. One of the tables is reasonably large. Only two fields, both text but only 12 in size however 400 thousand rows. Open/close/query etc no problem. About 20% bloat after...

I have a table that I'm trying to sort into different new tables or at least new fields. The original is like this: A B B C C C D E E and I'm trying to output this: A B B C C C D E E Is there a way without using vba to iterate through the table?

Thanks for the responses TylerTand and EMP. I think I have it now. http://www.access-programmers.co.uk/forums/showthread.php?t=137653

Problem solved. I hope! http://forums.esri.com/Thread.asp?c=93&f=992&t=237561

I'm not really looking for code, just a clue as to what to read up on as I have been beating my head against the wall with this one. I can do it in about three steps but I am trying to do it in one. :confused: The first table1 is like this: id Field1 Field2 Field3...

Thanks for the response. Perhaps that refers to ArcView3.x generation. I would have thought 9.2 generation would have solved the problems. I guess I can always start an instance of Access from ArcView and run the sql that way.