Create form in Access, use as frontend for Excel
I am planning to send a database to many users to input data (each one will
be a separate file, not a linked db). Most users do not have Microsoft Access installed on their computers, but all have Excel, so this will be an Excel file. I would like to have a User form to make data entry easy, but creating a complex User form in Excel is a lot more difficult than in Access (I don't want to write all the VBA code, and entry form is too complex for the the Data-Form function already in Excel). Is there a way that I can use Access to create a form and then import the form structure into Excel? Basically I want an Access front-end without a user having Access installed. Also, I want to do the data analysis in Excel. By the way, I have Access 2003 and Excel 2003. Thanks for the help. |
All times are GMT +1. The time now is 01:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com