how can i print access report

hi all.

How can i print access report using vb code without opening access database window. i need the vb code to show the access report in the preview mode. please give me the respective code..

saj

Never did, but try referencing the Microsoft Access Object Library in your VB project, declare the access object and

Code:

---

objAccess.DoCmd.OpenReport rptName

---

Thank u for the reply,,i can able to take print out.

but my doubt,

1. Is it possible to print access report without opening the ms access database (client dont want see the access database to be open)

2. How can i print the system date in the format Month day year ( eg: October 15, 2008) in access report.

saj

Quote:

---

Originally Posted by sajankk

1. Is it possible to print access report without opening the ms access database (client dont want see the access database to be open) using vb code

---

No. In order to do anything with an Access report, the database has to be opened.

2. Yes, open your report and add a label to it. Then in the controlsource property format the Date() function as you desire.

1. You do have to open the Access database and the system does need Access installed. You can do it hidden too so the user doesnt see.

Duplicate Threads Merged

One topic, one thread, one section please.

Thank you. :)

Quote:

---

Originally Posted by RobDog888

2. Yes, open your report and add a label to it. Then in the controlsource property format the Date() function as you desire.

1. You do have to open the Access database and the system does need Access installed. You can do it hidden too so the user doesnt see.

---

thank u rob...

how can i hide and open database through vb code. can u explain please

saj

can anybody will help me in this matter. otherwise i have to go for crystal report.

Access Object

Quote:

---

Originally Posted by jggtz

Access Object

---

what u mean by access object