help me please - this is totally urgent.

[M. Jade V.]

ok fellas

this thing is really bothering me ALOT

ok... how do i show ONLY one row in the report, not ALL of them

example: i only want to show one of my student name with its details not dont want the other students details popped up on the same page after the student details....

please help me, this is extremely, EXTREMELY urgent

thank you

 

[RV]

Using quotes like "this is extremely, EXTREMELY urgent" "help me please - this is totally urgent" will not help you to get any helpfull replies.

Take into account that this forum exists by the grace of volunteers.

RV

 

[mousemat]

Mmm, another helpful answer

Jade,

How are you displaying your record on the report. are you using group headers and the like? If so, have a look in the properties section of the Group header and change the Force New Page entry.

If you are using a comand button from a form, then its just a case of using some code to print the current record from the screen based on the current record ID

Dim strDocName As String 'Sets the report to print the current record on the screen
Dim strWhere As String
strDocName = "Invoice" 'Report Title
strWhere = "[CustomerID]= " & Me!CustomerID
DoCmd.OpenReport strDocName, acPreview, , strWhere

 

[M. Jade V.]

ok guys, i do not use group headers. i will show you one screenshot. This still need to be fixed.

i want it only show one row, not all of them

 

[M. Jade V.]

if no one helps me out, my boss is going to kill me

 

[Mile-O]

if no one helps me out, my boss is going to kill me

Then he'll get a number of years in jail. Are you sure he has thought that through? You might want to sit him down and tell him why it would be wrong to kill you.

 

[Rich]

A member already came to your rescue, here's a brief synopsis,
use the WHERE clause of the OPEN REPORT method.
Both the Access help file and posts here have numerous examples that you can use to defend yourself with

 

[LLB]

Thanks Mousemat, I've been searching to find the correct syntax for getting mine to print only the current record from a form and your example was the simplest I've found and worked like a charm.

Thanks again, Lori

 

[mousemat]

Thanks Mousemat, I've been searching to find the correct syntax for getting mine to print only the current record from a form and your example was the simplest I've found and worked like a charm.

Thanks again, Lori

LLB

Always a pleasure to help someone