(Visual Basic for Applications) A subset of Visual Basic that provides a common language for customizing Microsoft applications.

learn more… | top users | synonyms

1
vote
1answer
154 views

Opening an InMemory Table and execute some SQL

I have a InMemory that gets created, what I then want to do is run INSERT, UPDATE and DELETE queries on the table. The code i have at the moment is below, I create a new InMemory table, add it to the ...
0
votes
1answer
45 views

How would I create an input mask for ArcGIS Desktop?

Someone asked me if we can create a simple input mask for geodatabase feature classes so that editing of attributes becomes easier. I am however not sure how this works with ArcGIS 10.x Is this ...
3
votes
3answers
3k views

Polyline length calculation in ArcGIS 10/VB script

I used to run this length calc on my data in ArcGIS 8 and 9, and now it don't work in ArcGIS10. Can you tell me what I have done wrong? Dim dbllength as double Dim pcurve as icurve Set Pcurve = ...
1
vote
0answers
51 views

ArcGIS macros question

How to call a UserForm appearance from a macros? (A click on a button on a panel calls a UserForm and then I work with commands that are in a userform) Solved: a stupid reason - macro and userform ...
2
votes
2answers
670 views

Why is * .tlb not visible?

I've created a Visual Studio 08 Active X - MXCommands dll for a VBA button within ArcMap 9.3.1. I'm able to load and use the .tlb on my computer; however when I try it on my test computer the .tlb ...
2
votes
0answers
64 views

Longest route of a stream in ArcGIS?

I have a shapefile with polylines representing rivers all over a region. In the attached image, there is an example of one river. The longest route is marked by the two red dots on this river, but ...
0
votes
0answers
12 views

How Do I simply display the Coordinate Info of any vector format (.Shp,.gdb,.mdb) in a textbox using VB in ARCGIS

I've made an interface using VBA Macros to show the existing coordinate system information of the input vector file in a textbox by clicking on code button. And if I defined the projection and if it ...
1
vote
0answers
45 views

Can Geomedia be automated using VBA

Can I automate Geomedia using VBA? The Geomedia training manual "Fundamentals of Geomedia Development Part 1" talks about automating using visual basic but I do not have Visual Basic.
4
votes
3answers
313 views

Where to find books or course materials to help prepare for Esri Technical Certification in ArcGIS Desktop and Developer?

Where I can find books or course materials to help prepare for Esri Technical Certification in ArcGIS Desktop and Developer?
1
vote
0answers
63 views

How to capture GPS co-ordinates from a Microsoft InfoPath form on a mobile device

We are looking for a way to capture GPS coords through the Microsoft INFOPATH form which is loaded on our Mobile Motion device. Basically, we are trying to put a VB script behind the “Get GPS Coord” ...
1
vote
2answers
136 views

VBA ArcGIS 9.3 Field Calculator: 'countif' across several fields

I have an attribute table with 15 columns that contain either a '0' or a taxonomy number. I would like a summarized column that shows the number of different species. location type1 type2 type3 ...
1
vote
0answers
52 views

How to create a startup prompt that populates definition queries on multiple feature classes

I would like to create an ArcGIS start up prompt or custom button that asks for a user's initials and then populates multiple feature class & layer definition queries. More specifically, I would ...
0
votes
0answers
22 views

Add point and update column incremental

In existing feature class we need to add point and some column value need to be updated in incremental using vba code i have some sample code please any can modify it? Private Sub ...
1
vote
1answer
150 views

Getting Coordinates from a feature with VBA

Is there a way to get the longitude and latitude coordinates from a feature class? I have some code which can select the first layer in the Table of Contents. I want to be able to get the lat./long. ...
2
votes
2answers
239 views

Display Access query in ArcMap

Hi I have an access database and have some built in queries in the database. The same data is stored in geodatabase with the spatial information. Now I want to follow this process: Access->push out ...
0
votes
0answers
110 views

VBA Code to wait until Python returns value

I have written a code in VBA, I am passing parameters to Python and creating a buffer there. After that I am passing that buffer layer and further processing in VBA again. Here is the code for ...
1
vote
1answer
172 views

remove whitespace Python code results in odd character - Field Calculator

I need to remove whitespace from the end of a string in a field in ArcMap. I tried first the VBA function RTrim, but whitespace still remained. I thought maybe the whitespaces were tabs, so I tried ...
2
votes
2answers
92 views

How to use IFeatureCursorBuffer in VBA

I tried to use IFeatureCursorBuffer to create and dissolve the buffered features.I am trying to get the solution since some days using dissolve and UnionOverlappingBuffers, but not being able to get ...
0
votes
1answer
112 views

How do I copy or edit a cell of attribute table and paste in text file?

I'm new in VBA. I want to copy one cell or optional cell in attribute table and paste in a text file. I'm using ArcGis 10.1.
2
votes
2answers
278 views

Create a Line FeatureClass from IPointCollection

I want to create a new line layer from a point layer. I store the points in an IPointCollection. I want to use that IPointCollection to create a line IFeatureClass. I know how to create a single ...
1
vote
0answers
256 views

Export topology tables to txt files using ArcObjects, generating directed graph, and finding intersections

I want to export topology tables to text files: for points: 1 id x y for lines: line id fompoint.x from point.y topoint.x topoint.y for polygons: id line id 1, line id 2... 2 arc ...
13
votes
5answers
2k views

How can I find the farthest point from a set of existing points?

I have a set of points as a shapefile and I want to find (the coordinates) of a new point which will have the longest possible distance from each of the existing points. Is that possible? If yes, is ...
2
votes
2answers
3k views

VBA to VB.NET (Visual Studio 10) Migration - ArcMap Focus

I will be migrating several VBA applications currently in ArcMap 9.3.1 to Visual Studio 10 in the near future, and wanted some feedback on the general migration steps listed below. I wanted to make ...
0
votes
1answer
48 views

Finding points in extent using VBA

Is there a way to select a point from my map's current extent? I want to use ArcObjects to tell me if there is at least one point visible in my extent. I'd like to do this entirely in VBA, and without ...
0
votes
1answer
125 views

Custom data entry in ArcGIS 10

Since VBA support is no longer supported in ArcGIS 10, what is being used out there for custom data entry forms. I'd like to develop something that is very intuitive (for non-GIS users).
2
votes
1answer
101 views

Syntax question for ArcGIS ICalculator object

This is a silly question, but I have this code snippet that I can't figure out: 'Define a calculator for NewArea field pCalculator = New Calculator With pCalculator .Cursor = pCursor ...
2
votes
3answers
126 views

Software needed to recreate VBA forms using python for Arc 10.0

I'm new to programming and need to convert VBA scripted tools for the 10.1 upgrade. I need to recreate the forms and use Python scripting. How do I do this? I need the form to function in 10 ...
3
votes
2answers
727 views

Add-in; Failure to get code to execute when toolbar button pressed

I had written several VBA routines for ArcGIS up through v9.3 and have since upgraded to 10. Since VBA will be a thing of the past in the next version, I downloaded and installed VB Express 2008 and ...
1
vote
1answer
135 views

Software program (or spreadsheet calculations) to find Borehole Deviation?

I was given a bunch of surveyed borehole data (azimuth, depth, dip, geology, etc) and am required to calculate a deviation variable. Besides querying the data and averaging the surveyed borehole ...
0
votes
1answer
133 views

Finding gaps between polygons

I am trying to build procedure for finding gaps and convert the procedure steps in to code, but i am finding some difficulty, i wonder if someone can help me with it. the steps i planned in seek of ...
0
votes
0answers
125 views

Remove unused references in ArcGIS 9.3.1 vba

Can anyone suggest me how will I find and remove unused references used in a project done in ArcGIS 9.3.1 vb6. Thanks Khaled
0
votes
0answers
148 views

What is the easiest way to calculate borehole deviation?

Does anyone know if there was a program or specific method (calculations) in order to create a deviation value based on querying specific geological and drilling variables?
1
vote
0answers
246 views

Calculating the Centroid of polygon in modelbuilder (VBA to Python) [closed]

Got an easy one, that's got me stuck. I'm moving some models that were created in 9.3.1 to work in 10. Part of the model is calculating the X coordinate of a polygon to a specified field. The code ...
1
vote
0answers
85 views

InsertFeature on a versioned layer [vba]

I am writing an application that takes data from an Excel Spreadsheet and loads it into an ArcSDE feature class. The Feature class is editable within ArcMap, but I am having trouble inserting a ...
1
vote
0answers
48 views

How do I get non modal .dll things to work in ArcGIS 9 Education edition?

I dont know if I have installed it correctly on my computer. I think I need Non-Modal Forms Support in Visual Basic DLLs? and forcing VBA to load automatically in ArcGIS 9?
1
vote
0answers
257 views

topology rules for structuring topology data to get line feature as topoparent in topology graph

i Created topology graph of a polygon feature and i copied geometry of topology edges into line feature class,and topology nodes into point feature class i created topology layer containing ...
1
vote
0answers
141 views

Quering a ArcSDE featureclass attribute table after joining

I am trying to query a ArcSDE Feature Class after joining using Iqueryfilter I have two SDE feature classes. 1) Subdivisions : which has details of subdivision and districts (parent) 2) ...
2
votes
2answers
955 views

Collapse layers in ArcMap Table of Contents using ArcObjects

Can someone offer up a Christmas present here? I'm stuck on how to collapse all layers in my ArcMap projects (9.3). I've tried a few bits of sample code, but they all seem to fail for some reason or ...
2
votes
0answers
102 views

Matching points in table to polygons

this is my first post to this forum. I hope to start participating actively. I have a table with several records (aprox 200.000), each with its own coordinates. And I need to identify the "Polygon" ...
2
votes
0answers
252 views

Rotate Selected Features ArcGIS 10 - VBA

I am attempting to loop through polygon features and rotate pairs of features by a specified angle. Pseudo logic: 1) Open up a standalone table in the map document and retrieve a unique identifier ...
2
votes
1answer
199 views

Convex Quadrilateral Polygons subdivision in equal parts using Python / OGR

Consider an irregular polygon (P) which has four vertices. I would like to subdivide P into smaller polygons as shown here http://i.stack.imgur.com/4SKhB.jpg In the old days I was using ArcGIS 9.3 ...
5
votes
1answer
1k views

How to save a layer file with a relative path

In VBA, how do you save a layer file (.lyr) with a relative path? I have some code that loads a shapefile into ArcMap but I am unsure of how I go about using this shapefile to then save a layer file ...
1
vote
0answers
56 views

Joining a In_memory table with an SDE table

I have a in memory table that gets created, and want to join it to a table from SDE. I have tried the following code. Private Sub JoinTables(sdetable As ITable, inMemoryTable As ITable, joinField As ...
1
vote
2answers
570 views

Get Number of Rows, ArcObjects (VBA 6.0)

I am sorry to bother with what may be an easy question for most of you but i am new to ArcObjects (VBA 6.0) in ArcMap (ArcGIS 10.0) and i am really struggling here. I am trying to count the number of ...
0
votes
4answers
308 views

How to solve a run-time error in Thiessen polygons command line

Well I revise my post by giving more information for my problem hoping I may get some help please. I call Procedure 2 from a loop that is within Procedure 1 (see below). The program stacks in the ...
0
votes
1answer
59 views

Vba Cons Numbers [duplicate]

I want to make a list of cons numbers(ex. 1,2,3...) in field calculator (VBA). When I am putting for example: (dim d d=[field]+1). The result is all my fields are =1. How to solve this arc map (vba). ...
3
votes
0answers
289 views

VBA Convert decimal degree to Meters button

I have 2 data frames one which has WGS data in it and the other OSGB1936. I am trying to create a button where the user can input decimal degrees (WGS) and it will zoom them to that location in ...
3
votes
2answers
558 views

MS Access and geocoding in ArcGIS

We are a small non-profit. We use a fairly complex MS Access application to track everything. We would very much like to geocode addresses in our application and display the results on a map. In ...
13
votes
2answers
2k views

How can I create weighted Thiessen polygons?

I have a point shape file and I create Thiessen (Voronoi) polygons programmatically using this scripting syntax: CreateThiessenPolygons_analysis (in_features, out_feature_class, fields_to_copy) ...
1
vote
2answers
237 views

How to define Subroutines and functions?

I am working in VBA. My error is sub and function are not defined. Here is my code: Private Sub CreateMap(cboDistrict As String) Dim mapDocument As New mapDocument If ...