Latest Contributions by JasonTipton

ESRI is supposedly getting back to me on a very similar issue. Basically, you need to be able to access the recordset and filter it to obtain all of the records that are related to the current point. Then, basically you need a sum(volume_removed). The problem is that I do not know how to access the recordset of a related table. ... View more

Ok... can't believe nobody else has ran into this, but.... I found not to use the FieldCalculator. Just create your own updateCursor. Make sure to include from types import * Then just test by if type(c.field) is not NoneType: Then, if you want to return a Null value: c.field = None All of this where c is your updateCursor and field is the field you are testing and setting. ... View more

Ok, I still have ESRI trying to figure this one out for me, but I think I found something that will work for the time being. Just drop the dang table! I mean really, what is it going to hurt right?! When you open Studio, right click the .axf up at the top of the tree and click Command (You could just double click).  In the command window type: DROP TABLE "TableName" where "TableName" is the related table name. Then Click the Red Exclamation on the toolbar and say goodbye to that darn related table.  Now before/after this go back and make sure and delete the forms associated with the tables. I suggest before, b/c you can lock up Studio by accidentally opening the forms after the tables have been deleted. I tested this very lightly, and it seems to work. The tab actually disappears! I hope this works. ... View more

The custom forms should copy into the new .axf. When you check out, click the checkbox to pick a form. Place a copy of your current .axf somewhere for reference and choose that .axf to copy your new forms in that image. When your done, save the map and every time, you will be able to use that map w/o navigating back to that .axf as long as you keep the original .axf that the copies will be made from. All the forms will copy, but if you need to include DBf's, they will not copy, but if you need dbf's, what you can do is keep the same folder (ex DataForArcPad1) in ArcPad. Use the same map and everything and just switch out the .axf file and nothing else. All the dbf's will be in the appropriate places if they are needed. ... View more

Also, from my experience, to get SQL to load correctly, you must have the Microsoft Mobile Sync Center connected and running. ... View more

But, after that arborist was so kind to add that new subdivision with streets, how would he reflect that change back to the database? ... View more

Yes. It has a license manager ... View more

Awww... You had me so excited there for a second! I was leaving work, but I had to look up where you found that.  I never noticed the "Related Table" section under the "Forms" menu. I clicked on it, and logically, that has to be what they are talking about. There is the list of all all my related forms with checkmarks beside them. I was so happy... Then, I unchecked them all except one. And I think we all know how this story ends. . . (spoiler: it didn't do anything, and the checkboxes just reappeared the next time that I clicked "Related Table") ... View more

Yeah, you probably did something wrong. I thought there was a way to check in background layers. Why else would the give the option of ReadOnly or Editable? For the workaround (I haven't tried this on a background layer, but should work the same): Open ArcPad Studio on your computer. Open the .axf file in question. Right click the layer that you are trying to retrieve and click "Export". There you go. Now you have a shiny new shapefile. I hope it works ... View more

Ooooh. Yeah. This means that what I've been developing isn't going to work. That seems to be a very frequent feeling. ESRI, you may want to take note: Rolf is right. ComboBoxes do support .clear. The reason that I thought that they didn't is because I was trying to .clear a ComboBox inside a <TableForm> element.  Later I switched to just a normal form to build my other forms with the intention of moving them into a <TableForm> element. Of course, I did not use the .clear. Instead, I used the .ListIndex = -1. This seemed to work.... until I read Rolf's post.  I tried the .ListIndex = -1 inside a <TableForm> element. . .To my unsurprise, it does not work. Here's my code: console.print(ThisEvent.Object.Parent.Controls("Field1").ListIndex) This works. It prints the .ListIndex ThisEvent.Object.Parent.Controls("Field1").Clear or ThisEvent.Object.Parent.Controls("Field1").ListIndex = -1 These do not work. Error message: Class doesn't support Automation Source Text Unavailable If you misspell your control, ex: ThisEvent.Object.Parent.Controls("Fiel1").ListIndex = -1 Object Required Source Text Unavailable so it is a different message. Again, this DOES WORK inside a <FORM> but the SAME CODE does not work inside a <TABLEFORM>. ... View more

Yeah, I believe comboboxes do not support the .clear method. Don't you love it? I think you will need to do something like this: pCtrls("cboSICCode").ListIndex = -1 That should do the trick.  (FYI) And, I really didn't take a good look at your code, but I noticed some .Value in there. That should be logical, but it may not work right.  If you change a controlBox's value, then access the value before you have closed/reopened the form, it will still report the original value even though your eyes can see that the value has been changed. I found this out the hard way after about 2 days of trying to figure out why my code wasn't giving me the results I coded it to, so I finally tested this theory by having a comboBox with "E", and "W". If a button was pressed, it would flip "E" to "W" and vice verse. It would only flip once. It would also report in the console what the ".value" was.  The reason it would only work once was that if I started with "E", it would flip to "W". Then, when pressed again, it would report in the console that the value was still "E", even though I could see that it was really changed in the form to "W", therefore a flipped "E" remains "W" and nothing would change. BUT, when I closed the form and reopened it, the value would be correct! So, long story short, comboBox.value = x or comboBox.text = x probably should be something to avoid.  Therefore, you have to use comboBox.ListIndex to change the selection. It seems you can always say x = comboBox.value or x = comboBox.text, but not the other way. And yes, I have logged a bug. ... View more

Yeah, I believe comboboxes do not support the .clear method. Don't you love it? I think you will need to do something like this: pCtrls("cboSICCode").ListIndex = -1 That should do the trick.  (FYI) And, I really didn't take a good look at your code, but I noticed some .Value in there. That should be logical, but it may not work right.  If you change a controlBox's value, then access the value before you have closed/reopened the form, it will still report the original value even though your eyes can see that the value has been changed. I found this out the hard way after about 2 days of trying to figure out why my code wasn't giving me the results I coded it to, so I finally tested this theory by having a comboBox with "E", and "W". If a button was pressed, it would flip "E" to "W" and vice verse. It would only flip once. It would also report in the console what the ".value" was.  The reason it would only work once was that if I started with "E", it would flip to "W". Then, when pressed again, it would report in the console that the value was still "E", even though I could see that it was really changed in the form to "W", therefore a flipped "E" remains "W" and nothing would change. BUT, when I closed the form and reopened it, the value would be correct! So, long story short, comboBox.value = x or comboBox.text = x probably should be something to avoid.  Therefore, you have to use comboBox.ListIndex to change the selection. It seems you can always say x = comboBox.value or x = comboBox.text, but not the other way. And yes, I have logged a bug. ... View more

I am experiencing the same problem on my Nomad 800GL. I am upgrading from 6.0 to 6.1. Mine crashes before it even tries installing Sql. I have even tried reinstalling Windows 6.1 again and deployed each program separately, reseting the device between each install. Still, when I get to SQL Compact, it bombs. ... View more

Or how do you at least skip to a specific tableform, instead of having to scroll them all. If they were pages, you would just call Pages("page").Activate. I have no idea how to do that with TABLEFORMS. I've tried everything. ... View more