help needed with printing individual forms

[mattijsstu]

hi

I have a problem in access. I have a table wich looks like this (has a lot more variables) :

[TABLE="width: 603"]
[TR]
[TD][/TD]
[TD]name[/TD]
[TD]age[/TD]
[TD]nationality[/TD]
[TD]phone number[/TD]
[/TR]
[TR]
[TD]client 1[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]client 2[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]client 3[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x
[/TD]
[/TR]
[/TABLE]

i then have created a form wich looks like this:

[TABLE="width: 393"]
[TR]
[TD]info about [/TD]
[TD][/TD]
[TD]date[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]client 1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD]value[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]name[/TD]
[TD]x[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]age[/TD]
[TD]x[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]nationality[/TD]
[TD]x[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]phone number[/TD]
[TD]x[/TD]
[TD][/TD]
[/TR]
[/TABLE]

I would like to be able to print this form individualy for client 1 , client 2 and so on, at the moment when i add more info it wil, when i print the form, show the first client , second client form , third client form and so on. i would like to choose wich clients form to print. I hope some one can help me! realy need the help

thanks in advance

 

[IanRyder]

Hi,

You need to look at creating Reports in Access to do this correctly. Have a look at this YouTube tutorial to start with:-

Microsoft Access 2007 Report Tutorial - YouTube

Hope that helps.

Cheers,

Ian

 

[mattijsstu]

well i already have a nice form :


i just can't figure out to make access use this form for the different clients, at the moment he makes a new form with the values of the second cliend underneath the previous form. so if i print i get the form of the previous client(row) adn the second one. if i then ad a third client i get 3 forms and so on. i only want to print the form of 1 client and that should be the one i choose. i don't know how to do this

 

[JohnH]

Is this actually related to VB.Net development? These forums is only for VB.Net support.

 

[mattijsstu]

This data base is used with my vb.net program wich calculates values and sends them to this database, then i would like to be able to print the form buth the part of printing the form is not that easy.

 

[JohnH]

Printing forms in VB.Net can be done with PrintForm component or PrintDocument class. If you're talking about Access forms that is not something that sorts under VB.Net Forums.