ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Create form in Access, use as frontend for Excel (https://www.excelbanter.com/excel-discussion-misc-queries/96669-create-form-access-use-frontend-excel.html)

bv111

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