Tags: access, alli, asystem, client, create, database, examine, form, microsoft, mysql, oracle, report, single, sql

Create report from form?

On Database » Microsoft Access

1,436 words with 2 Comments; publish: Mon, 31 Dec 2007 00:30:00 GMT; (25093.75, « »)

Hi all

I need to create a report from a form. What I'm trying to do is create a

system where I can examine data for a single client on a form then print a

report on only that client - Any ideas??

Thank in advance

Dan

All Comments

Leave a comment...

  • 2 Comments
    • Dan Kean wrote:

      > Hi all

      > I need to create a report from a form. What I'm trying to do is

      create a

      > system where I can examine data for a single client on a form then

      print a

      > report on only that client - Any ideas??

      > Thank in advance

      > Dan

      create the report without filters and then pass the primary key of the

      client in question in the Open event of the report as a WHERE clause.

      See DoCmd.OpenReport in the help.

      #1; Mon, 31 Dec 2007 00:31:00 GMT
    • sorted many thanx

      <pietlinden.ms-access.todaysummary.com.hotmail.com> wrote in message

      news:1111449925.233540.57680.ms-access.todaysummary.com.f14g2000cwb.googlegro ups.com...

      > Dan Kean wrote:

      >> Hi all

      >>

      >> I need to create a report from a form. What I'm trying to do is

      > create a

      >> system where I can examine data for a single client on a form then

      > print a

      >> report on only that client - Any ideas??

      >>

      >> Thank in advance

      >>

      >> Dan

      > create the report without filters and then pass the primary key of the

      > client in question in the Open event of the report as a WHERE clause.

      > See DoCmd.OpenReport in the help.

      #2; Mon, 31 Dec 2007 00:32:00 GMT