Select to view content in your preferred language

How to create a form

6868
11
08-15-2012 06:06 AM
HectorChapa
Frequent Contributor
I have an access database that we have forms that we input data that we use to address customers.
One of the question is can ArcMap have an ability to create a form maybe attach to a point layer.
Any suggestions would this be done through python.
Any help much appreciate or what are my options.
Tags (2)
0 Kudos
11 Replies
ChristopherThompson
Frequent Contributor
would this form be a duplicate of one that already exists in Access? or would it be for filling in fields that aren't in the Access DB?
0 Kudos
HectorChapa
Frequent Contributor
The form is in access database. What you mean by duplicate forms.
The reason i wanted in arcmap because we geoproccess the form into a point in the map.
In other words we have to open access database to look at the information then open arcmap and put the data as an address point thats tidious. we want to populate a form and that form because a point in the map. Any solutions.
0 Kudos
CameronWallace
Deactivated User
Definitely possible to have a "form" in ArcMap that prompts you to type in values... are you looking to add new records to a table? Or are you looking to add new points or polygons?
If you have the correct attributes/domains, and have an edit session open, the "form" is the attributes window...

IF you're looking to append data to a table, you could write a script to append a row to the table, and attach the script to a tool.

If you're not talking about doing this in Desktop, but rather in a web-application...

It really depends on you're purpose etc.
0 Kudos
ChristopherThompson
Frequent Contributor
In other words we have to open access database to look at the information then open arcmap and put the data as an address point

I'd recommend using the database as the single point for any data entry and management.  Work on a process to bring those data into GIS to create your point data against those tables instead.  The more places you have to enter and manage data, the more opportunity for error get introduced.  Access is going to have far better capabilites for creating data entry forms and quality control on the data entry process than you have within ArcMap.
0 Kudos
HectorChapa
Frequent Contributor
Here is the link to the video wat i am trying to explain.


http://www.youtube.com/watch?v=1S8KqE5u5W4&feature=youtu.be
0 Kudos
HectorChapa
Frequent Contributor
0 Kudos
HectorChapa
Frequent Contributor
Make sure to watch it in 720 and full screen
0 Kudos
Zeke
by
Honored Contributor
Well, if your data is in a personal geodatabase, that's Access right off the bat, maybe make it easier.
0 Kudos
KimOllivier
Honored Contributor
It's a very good question, and one would expect a facility to do exactly that. Link to a nice form from ArcMap  without having to redevelop the Access form.

It might be possible to call up the form from a Python script using  the COM interface, but I have not done it myself. I have opened Excel spreadsheets and Word documents. How to do this is well described in the book Python Programming on Win32 by Hammond.
http://www.amazon.com/Python-Programming-WIN32-Windows-Programmers/dp/1565926218

I expect that if you are familiar with programming in Access you will be able to call your form from a Python script running in ArcMap.
Do post a how-to if your are successful.
You will need to install the win32all module which is also needed for the Pythonwin IDE.
Here is an example opening a spreadsheet:
from win32com.client import Dispatch
xlApp = Dispatch("Excel.Application")
xlApp.Visible = 1
xlApp.Workbooks.Add()
0 Kudos