Reports Need Some Help

[Margah]

Hello All,

Is there a way to use a form that was created in Excel in access. What I am trying to do is Create a Report that will fill in the fields of the form that was created in excel. ( Need to try and keep the layout of the form created in excel.


thanks for any info i can get on this.


Margah

 

[Trendsetter]

I would say the easy answer is NO!

You need to have somewhere to store the input data as well as build a new form based on the required layout.

It is easy to emulate the layout of an Excel form and there is far more power and flexibility in Access for database purposes than that available in Excel.

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk

 

[Margah]

Ok.

Is there a place on the beb or somewhere to find some information on how to do a form layout in access. i know how to collect the information but the report itself needs to be in a certain layout.

Thanks

 

[Trendsetter]

If you send me a screen shot of what you want as a layout I will do a .avi that will start you off in the use of Access and the formatting methods.

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk