Report & Page Print Setup

[smtazulislam]

Hello dear experts !
I have an excel file (attached) for an employee transfer letter sample that from ABC company to EFG Company. Sometime ABC 2 or 3 or 4 employees will transferred To EFG company. Before I operate on an excel.
Now I want to apply in the access,

Excel File is Arabic (Red Color change always) I explain below :
1. Date English and Arabic
2. Branch City Name.
3. Designation Title.
4. EmployeeID-EmployeeNameAr-Nationality.
Others field are same dont changed.

And also needs to transfer History all of the employee.

Page Makeup size I fixed :
LetterHead & Bottom : 3cm space,
Left & Right : 1.5cm Space

Hope any expert will help me. Thank you.

 

[smtazulislam]

Hello any questions or any update ?

 

[smtazulislam]

Thanks for your replay and good advice. I appreciate for my previous thread your good guideline and example.

Actually, you see the an excel file when I enter EmployeeID then this employee all of data insert automatically, because, formula linked DATA Worksheet.. (the top of 6 field). So, I want also same thing in the access that If i enter an employeeID then this employee all of data insert automatically what I required fields.

You see, I create report but center have blank. becoz, I dont know how to call data in the report page & this page also print 3 pages, two pages is blank print. so needs to setup perfectly.

I think I needs an expert can help me this points.
How to call my data for insert my report page, Please see my report page (rptCompany A design view) update data copy. (Red color field data want to insert)

Before I using only an excel for data collection. But I want to leave it and try to create a database.

 

[smtazulislam]

Here, anyone can help me.....