topic Re: Create form in ArcMap or Sql... Old access form in Data Management Questions https://community.esri.com/t5/data-management-questions/create-form-in-arcmap-or-sql-old-access-form/m-p/180925#M10208 <HTML><HEAD></HEAD><BODY><P>Yes this is exactly what I am looking for! I will take a shot at it and see if I can get it configured</P></BODY></HTML> Tue, 26 Apr 2016 20:15:49 GMT BenDrury 2016-04-26T20:15:49Z Create form in ArcMap or Sql... Old access form https://community.esri.com/t5/data-management-questions/create-form-in-arcmap-or-sql-old-access-form/m-p/180921#M10204 <HTML><HEAD></HEAD><BODY><P>Report wizard or Sql forms? We have an old database in access that we transfered into out sde database, but my boss likes the old forms we created in access to create a book for him to have to look at. The data is billboard data. We have about 126 total in the city. I am looking to recreate this form from access into a different workflow. Create report in ArcMap or is it possible to create a form in slq directly from this data-set?</P><P></P><P>It is a pain to go from GIS back to access to have all the data updated, want to reduce the redundancy </P><P></P><P>If this can be done in ArcMap can you point me in the right direction for getting started. </P><P></P><P>Example of what we currently have built from access</P><P></P><P> <A href="http://www.cookeville-tn.gov/uploads/planning/MiscFiles/BB067-Revised043013.pdf">http://www.cookeville-tn.gov/uploads/planning/MiscFiles/BB067-Revised043013.pdf</A></P></BODY></HTML> Tue, 26 Apr 2016 19:57:09 GMT https://community.esri.com/t5/data-management-questions/create-form-in-arcmap-or-sql-old-access-form/m-p/180921#M10204 BenDrury 2016-04-26T19:57:09Z Re: Create form in ArcMap or Sql... Old access form https://community.esri.com/t5/data-management-questions/create-form-in-arcmap-or-sql-old-access-form/m-p/180922#M10205 <HTML><HEAD></HEAD><BODY><P>I've done some reports similar to this with <A href="http://desktop.arcgis.com/en/arcmap/10.3/map/page-layouts/creating-data-driven-pages.htm" title="http://desktop.arcgis.com/en/arcmap/10.3/map/page-layouts/creating-data-driven-pages.htm">Creating Data Driven Pages—Help | ArcGIS for Desktop</A> and <A href="http://desktop.arcgis.com/en/arcmap/10.3/map/page-layouts/using-dynamic-text-with-data-driven-pages.htm" title="http://desktop.arcgis.com/en/arcmap/10.3/map/page-layouts/using-dynamic-text-with-data-driven-pages.htm">Using dynamic text with Data Driven Pages—Help | ArcGIS for Desktop</A> . You'll have to do the map and the report separately </P></BODY></HTML> Tue, 26 Apr 2016 20:04:06 GMT https://community.esri.com/t5/data-management-questions/create-form-in-arcmap-or-sql-old-access-form/m-p/180922#M10205 WesMiller 2016-04-26T20:04:06Z Re: Create form in ArcMap or Sql... Old access form https://community.esri.com/t5/data-management-questions/create-form-in-arcmap-or-sql-old-access-form/m-p/180923#M10206 <HTML><HEAD></HEAD><BODY><P>Yes I know they will have to be done separately but as long as they are pulling from the sde database that is fine. The problem is having to update 2 data sources all the time to get these reports, when we done us the access database for anything other than the report. Thanks for the advice</P></BODY></HTML> Tue, 26 Apr 2016 20:06:57 GMT https://community.esri.com/t5/data-management-questions/create-form-in-arcmap-or-sql-old-access-form/m-p/180923#M10206 BenDrury 2016-04-26T20:06:57Z Re: Create form in ArcMap or Sql... Old access form https://community.esri.com/t5/data-management-questions/create-form-in-arcmap-or-sql-old-access-form/m-p/180924#M10207 <HTML><HEAD></HEAD><BODY><P>Just so you understand. I'm pulling all my data from server and creating my report with ArcMap that has all the data and a picture</P></BODY></HTML> Tue, 26 Apr 2016 20:13:16 GMT https://community.esri.com/t5/data-management-questions/create-form-in-arcmap-or-sql-old-access-form/m-p/180924#M10207 WesMiller 2016-04-26T20:13:16Z Re: Create form in ArcMap or Sql... Old access form https://community.esri.com/t5/data-management-questions/create-form-in-arcmap-or-sql-old-access-form/m-p/180925#M10208 <HTML><HEAD></HEAD><BODY><P>Yes this is exactly what I am looking for! I will take a shot at it and see if I can get it configured</P></BODY></HTML> Tue, 26 Apr 2016 20:15:49 GMT https://community.esri.com/t5/data-management-questions/create-form-in-arcmap-or-sql-old-access-form/m-p/180925#M10208 BenDrury 2016-04-26T20:15:49Z Re: Create form in ArcMap or Sql... Old access form https://community.esri.com/t5/data-management-questions/create-form-in-arcmap-or-sql-old-access-form/m-p/180926#M10209 <HTML><HEAD></HEAD><BODY><P>How did you get the photo to pull in from the attachment?</P></BODY></HTML> Tue, 26 Apr 2016 20:17:43 GMT https://community.esri.com/t5/data-management-questions/create-form-in-arcmap-or-sql-old-access-form/m-p/180926#M10209 BenDrury 2016-04-26T20:17:43Z Re: Create form in ArcMap or Sql... Old access form https://community.esri.com/t5/data-management-questions/create-form-in-arcmap-or-sql-old-access-form/m-p/180927#M10210 <HTML><HEAD></HEAD><BODY><P>See this link <SPAN style="color: #1f497d;"><A href="http://support.esri.com/ja/knowledgebase/techarticles/detail/42153">http://support.esri.com/ja/knowledgebase/techarticles/detail/42153</A></SPAN></P></BODY></HTML> Tue, 26 Apr 2016 20:31:09 GMT https://community.esri.com/t5/data-management-questions/create-form-in-arcmap-or-sql-old-access-form/m-p/180927#M10210 WesMiller 2016-04-26T20:31:09Z