Latest Contributions by markdynge

This might be too simple, but I have seen people hit the space bar for an answer to a question, (If not restricted), Is that accounted for? ... View more

seems you could not display question #2 until #1 is done,(or answered) not show question #3 til #2 is done same kind of not-null requirement for each ? like ${Q1} != '' the other is several 'and' statements Q1 not null AND Q2 not null AND,,,, have not tried this Best Wishes Mark ... View more

castle head, using a calculator 222*242*260 equals number you gave, the calculations are done on the name column of your select_one list not the label. I end up giving the name and the title columns the same value so the forms display correctly and the math works out as expected ... View more

Jackie, I have just gone thru that with 30+ users, there is a fee for each license, based upon a year's license fee. Free for public, non commercial use, as in, you can create a survey and let the public submit public info for just transaction/storage fees.(usage credits) Using it for an organization will cost you a license fee for each  additional contributor (besides the 1 license included with desktop) in the $500 us dollar range, which includes a lot of usage credits. I don't know why ESRI doesn't make this public.  ... View more

Adrian, thanks for email, I am venting, but It seems like I have to store all my data online, have a tech make an entry say 1gallon of a mixed herbicide, which contains 4 different reportable pesticides, export that via csv or excel / update my tables/ Then use Access to generate a report that breaks down all 4 different chemicals into a report that the County Ag Commissioner needs/demands – on their exact form. ArcMap-ArcGIS do not allow the data manipulations that I perform. OH, I agree that non experienced users should have no problem flipping back and forth, But I have only been using arcmap for 10-12 years or so. And its silly not to be able to display a basic table that is in access which includes “name and x and y” without exporting to csv, then importing back. We have mosquito traps that we bring mosquitoes back to the District that we count, identifiy, do lab testing, and generate reports, I will have to now export these numbers into an excel, or csv file before they can be viewed on a map, I haven’t counted the number of time I have seen in some of your (ESRI’s) magazines and communities where a phrase goes something like “ this was achieved by using ArcGis and an Access database” Hey it’s the weekend, Enjoy Mark D Systems Administrator Delta Vector Control District ... View more

Thanks Mitch for the inquiry, the fields were Text only, one field was 4 char in length the other was 10 char in length, It was a mistake (on my part) to presume what I saw was what I got, the join – based on parcels, was a 1 to many. The 3 miscalculations were just referencing a second point within the parcel which happened to be sequentially higher. ... View more

Josh, both tables are in a file geodatabase, after some more digging and eye strain, the join i used had the potential to be one-to-many, even though the table viewed in the screen shot had the one number in it, a manual field calculate brought up the 'invisible' 2nd joined item, which just happened to be 'numerically' sequential. Thanks for the reply ... View more