(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
281 views

Opening InMemory Table to execute some SQL gives Runtime Error 445 - Object doesn't support this action?

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 ...
1
vote
1answer
290 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
0answers
388 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
611 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 ...
4
votes
3answers
776 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
182 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 ...
0
votes
0answers
188 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
1
vote
0answers
382 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
0answers
184 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" ...
0
votes
1answer
681 views

Finding gaps between polygons using ArcGIS Desktop? [on hold]

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 ...
2
votes
0answers
504 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 ...
1
vote
0answers
78 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 ...
2
votes
1answer
266 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 ...
1
vote
2answers
2k 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 ...
2
votes
1answer
273 views

Syntax for ArcGIS ICalculator object?

I have a code snippet that I can't figure out: 'Define a calculator for NewArea field pCalculator = New Calculator With pCalculator .Cursor = pCursor .PreExpression = "Dim ...
0
votes
1answer
76 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
612 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 ...
4
votes
2answers
1k 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 ...
1
vote
1answer
329 views

ArcGIS10 VBA requires library references

I just upgraded from ArcGIS 9.2 to 10.0, and I'm trying to create some tools using VBA. It doesn't recognize any of the ArcObjects Classes, Interfaces, or Constants unless the reference includes its ...
1
vote
0answers
44 views

Opening New mxd into existing mxd from command button on form in VBA [duplicate]

Possible Duplicate: How to define Subroutines and functions? I am programming a dialog box in VBA because Python does not have one yet!! The action that needs to occur is for an mxd to open in ...
1
vote
2answers
294 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 mapDocument....
2
votes
2answers
2k views

How do you create a button in ArcGIS and have it run code?

I'm brand new to ArcGIS and have only a year or two of programming experience. I know Java and a little C#. I have a Java app that processes geographical data. I need to have a button in ArcMap that, ...
3
votes
3answers
2k views

get layer names from a group within a group

Trying to get the layer names from a group that are inside a group. I have the code the gets the layer from a group, but not group inside group. any ideas? Dim pDoc As IMxDocument Set pDoc = ...
3
votes
1answer
497 views

Saving VBA customization to a Normal.mxt problem

I have experienced problems with saving VBA customization to a Normal.mxt document within ArcGIS 10. I have a set of VBA macros developed originally within 9.3 version of ArcGIS that reside in a ...
1
vote
1answer
272 views

How to update a value in an ArcSde table using ArcMap's VBA

First of all, I want to update a table, not a feature class (no geographical information). I tried the following Public Sub updateInSql(tableName As String, whereClause As String, field As String, ...
3
votes
0answers
390 views

Getting layers from SDE with vba

Im running arcmap 9.1. i have the code that lists feature classes in a list box from the SDE. The users select from one list box and adds it to another list box. How do i get it to show the layer name ...
-4
votes
1answer
461 views

Creating multipart polygon using ArcObjects if coordinates of each part are given? [closed]

How to create a multipart polygon if i am having the values of coordinates of each part. I am using ArcObjects in VBA or VB.NET
4
votes
1answer
435 views

Debugging Visual Basic Code Block in calculate field using ArcGIS Desktop?

From time to time, I have to use Visual Basic in Calculate Field. As the code get bigger, the more complicated is to debug it. And ArcGIS (9.3) does not help as the error messages are, in the best ...
1
vote
0answers
290 views

How to calculate column average in Arcmap using VBA [closed]

I'm really new in gis and programming... So could anyone write VBA code for counting average. For example I have 3 columns which are named as JAN, FEB, MART...Each of them have 50 values in column. ...
0
votes
2answers
1k views

How to auto populate multiple fields in attribute table?

i have Feature Class Buildings, it has many fields like this(Region_id,Region_Name,Governorate_Name,Village_id,Village_Name,Building_id,Building_Hight,Building_Area,Floor_No,...
2
votes
1answer
642 views

Using IBufferConstruction to create single and multiple buffers (VBA and ArcObjects)

I need a bit of help with using the iBufferContruction interface, my overall goal is that the user clicks on the map, a graphic is created and then buffered,at multiple distances and then stored in a ...
3
votes
1answer
488 views

Need help translating small code block from VBA to Python

I need help from someone to translate a small piece of code from VBA to Python, due to the fact that the company I am working for has upgraded from ArcGIS 9.3.1 to 10.0 and VBA is no longer supported. ...
1
vote
1answer
235 views

How do i get ArcObjects not to ignore a layer definition that has been set?

I am creating a simple text search application, where the user can enter an address search and the result appear in a listbox, which they can then select it and zoom to the address. Now the problem I ...
2
votes
1answer
1k views

How do I delete specific graphics on the map using arcobjects

I am writing a small application that allows the user to click on the map, and it will create 3 buffers (these are graphics using the IElement interface) at specified distances. What I want to do is ...
2
votes
3answers
4k views

Find polygon centroid with Python

I'm using ArcGIS 9.3 to find centroid of some polygon features. I'd like to do this in Python, but so far I can only find solutions with VBA. Can anyone provide some leads here?
1
vote
1answer
87 views

generating some random points along network

I'm having trouble with generating some random points along a network. I am trying to do it with Arcobjects in the VBA environment. I would be grateful if you could help me.
3
votes
2answers
2k views

How to overwrite a shapefile or feature class using arcobjects?

I can copy a shapefile but I want to be able to overwrite the copied shapefile to prevent multiple copies being created each time I run the program. I would also like for the saving and renaming of ...
3
votes
2answers
751 views

Adding VBA into a Python script generated by ModelBuilder

I have created a model that does a calculate field and have used VBA in the code block. But when I export it to Python, it doesn't work. Here is the VBA code: new_value = [HDATA_N_LAREF_ACTIVITY_TEXT]...
1
vote
0answers
51 views

VBA to ActiveX tool

I have several scripts that I create UIcontronButton from, but I really want to create a dll from the scripts so I dont have to copy paste scripts on every computer. How do I create arcmap tool dll?
1
vote
1answer
554 views

Running ArcMap Addin Button with VBA from MS Access form?

I am using ArcGIS Desktop 10.0. I need a way to execute an ArcGis-Addin (vb.net) from a MS-Access database form (VBA). The problem is that there is no ESRI.ArcGIS.Desktop.Addin reference in VBA and ...
0
votes
0answers
145 views

Run time error for GP objects

I have a code with toolbars, which I tried to run it in another PC, but it failed. I get a run time error "Method Addtoolbox of object IGDispatch failed". The line that the code stacks is the last one ...
0
votes
1answer
265 views

Creating a report from features that have been selected

I'm in need of some guidance, I have created an application where the users does the following workflow Enter Postcode Zoom to Postcode Create a buffer at specified distance Spatial Query to find ...
0
votes
1answer
515 views

Focus ArcMap application Window VBA

How would you focus your ArcMAP application window using VBA? I have a script that runs and selects polygons and zooms to them, but I would like ArcMap to focus and come to the front at that point. ...
1
vote
1answer
447 views

Trouble trying to zoom to graphic (ArcGIS 9.3.1, VBA)

I am writing an application where one of the things it does is create a point then creates buffer (which is a graphic) at the specific point, what I want to do is when the buffer has been created, is ...
3
votes
2answers
655 views

Zoom to Polygon in Arcmap from Access

I am attempting to Zoom from an Access record to a specific polygon in ArcMAP but I can't seem to get the function to work. The field in Access is identical to the field in arcmap. I.E. they both ...
0
votes
1answer
669 views

ArcGIS 9.3.1 VBA: Unable to loop through datasets using 'ILayerGeneralProperties' when raster catalog is present

I have a simple project which involves the use of several buttons in order to make various datasets visible depending on which category is required at the time. It works fine using the popular ...
2
votes
1answer
3k views

Creating a featureclass in memory and adding to the map error

I have the code below, which is supposed to create a new featureclass in memory then add the FC to the map, but I get a Automation error when I use the createfeatureclass method Set pFC = pFeatWS....
1
vote
0answers
239 views

Relative paths in ArcScene document are broken if opened programmatically

When I open ArcScene document with relative paths programmatically from ArcMap, all those paths are broken. The location in source tab for broken layers is set to some different path like "C:\Windows\...
2
votes
1answer
289 views

How to use ITransform2D on dimension features (arcobjects)

I am trying to move a dimension feature inside a personal geodatabase using ArcObjects VBA. I was able to move other types of features using similar code as shown below. However it is not working for ...
2
votes
0answers
520 views

Open the IGxDialog in MS Access 2010 using VBA

I hope this is the right forum for this question. I have a program in MS Access that allows users to input varius aspects related to land treatments including the spatial information (point, line, or ...