Report Question - Please help!

[btate]

Let me see if I can verbalize what I want to do in this posting. I am a newer user to Acess.
I bulit my tables and a form to imput data into them. I have an excel sheet that many users use everyday. Each day they start with the blank excel template and fill in the blanks, save a copy under a different name, then print. Any calucations or summary reports of all the forms printed over the course of the day are then manually entered into a summary report. Obvisouly room for an Access platform to generate the reports.

What I would like to do is drop the excel template into the background of an Access report. This way the report would look the same as we see it now. I could then draw text boxes over the feilds of the excel template I wish to populate with the data from the tables.

I have not been able to get the excel file to drop into the access report design view and look the same as it does now. It is large and spans 4-5 pages (the orginal is 1 page landscaped).

I do not want to recreate this report from scratch in access and try and make it look like the current excel form. Is there anyway to make this work??

 

[quiksilver1804]

Good morning. I've never really imported excel into a report for any real purpose. 99% of the time i just design my report from scratch. I tested the idea though and when i opened up my excel sheet, i used the cursor to highlight the area that i wanted to insert into Access, copied it, and just pasted into the report. It was a clean paste. I can double click the excel sheet to edit the values as well.

Try going to page setup and turning it to landscape if you haven't already. Then remember how big the report actually is when printed (8.5 x 11, legal) and match up the report size using the rulers that run vertically/horizontally with the report. As long as you do that, i don't see why you would have any problems putting the sheet in the report and keeping it on one page.

Hope this helps..

 

[SamDeMan]

this is a new concept to me and i have not tried it yet. but i am troubled witht this idea. would you not want to create something in access like a form/report concept? entries are on forms, they don't work on reports (at least that is not what they are intended to do), you will not have the full functionality with a report.

i understand what you are going through. i had to battle the same. in a year and half i had to redesign most processess in my company. everything was excel, now most of it is in access.

good luck,

sam