can anybody pls help

[samicole246 via AccessMonster.com]

hi
having problems regarding a repot..can i do this?when i click the add new
record command button the report page will begin to a new page..?so that if i
print (or click "print report")it will only print the record i enter for that
particular report..
can i do that?

 

[Duane Hookom]

If I understand correctly that you want to open a report filtered to the
current record, read this http://www.mvps.org/access/reports/rpt0002.htm.

 

[samicole246 via AccessMonster.com]

If I understand correctly that you want to open a report filtered to the
current record, read this http://www.mvps.org/access/reports/rpt0002.htm.

hi
having problems regarding a repot..can i do this?when i click the add new

[quoted text clipped - 4 lines]

particular report..
can i do that?

can you teach me about whereconditioning?how should i put it on the code
sheet?to specify my record

 

[samicole246 via AccessMonster.com]

If I understand correctly that you want to open a report filtered to the
current record, read this http://www.mvps.org/access/reports/rpt0002.htm.

hi
having problems regarding a repot..can i do this?when i click the add new

[quoted text clipped - 4 lines]

particular report..
can i do that?

whats a runId control that used in the example?should i change the strDocName,
acPreview, strWhere im sorry for these questions im just a begginer on using
access..thanks byt the way..

 

[Duane Hookom]

You need to replace RunID with your primary key field name . Also, replace
"rptSomeReport" with your report name.

If you can't figure this out, come back with your report name as well as
your primary key field and its data type.

--
Duane Hookom
MS Access MVP

If I understand correctly that you want to open a report filtered to the
current record, read this http://www.mvps.org/access/reports/rpt0002.htm.

hi
having problems regarding a repot..can i do this?when i click the add
new

[quoted text clipped - 4 lines]

particular report..
can i do that?

whats a runId control that used in the example?should i change the
strDocName,
acPreview, strWhere im sorry for these questions im just a begginer on
using
access..thanks byt the way..

 

[samicole246 via AccessMonster.com]

You need to replace RunID with your primary key field name . Also, replace
"rptSomeReport" with your report name.

If you can't figure this out, come back with your report name as well as
your primary key field and its data type.
[quoted text clipped - 11 lines]

using
access..thanks byt the way..

hi there thanks for the advice..but one more thing when i do what you have
told me to do the "enter parameter value"just pop up..whats that for?thanks
again..appreciate your concern

 

[Duane Hookom]

"enter parameter value" suggests your form or report doesn't contain a
control or field of the name you have attempted to use. This would be a
typical error message if you had code like:

Dim strWhere as String
strWhere ="[LastNmae]=""" & Me.LastName & """"
DoCmd.OpenReport "rptEmployees", acPreview, , strWhere

The above code would error because my report has a field [LastName], not
[LastNmae].

--
Duane Hookom
MS Access MVP

You need to replace RunID with your primary key field name . Also, replace
"rptSomeReport" with your report name.

If you can't figure this out, come back with your report name as well as
your primary key field and its data type.

If I understand correctly that you want to open a report filtered to the
current record, read this
http://www.mvps.org/access/reports/rpt0002.htm.

[quoted text clipped - 11 lines]

using
access..thanks byt the way..

hi there thanks for the advice..but one more thing when i do what you have
told me to do the "enter parameter value"just pop up..whats that
for?thanks
again..appreciate your concern

 

[samicole246 via AccessMonster.com]

"enter parameter value" suggests your form or report doesn't contain a
control or field of the name you have attempted to use. This would be a
typical error message if you had code like:

Dim strWhere as String
strWhere ="[LastNmae]=""" & Me.LastName & """"
DoCmd.OpenReport "rptEmployees", acPreview, , strWhere

The above code would error because my report has a field [LastName], not
[LastNmae].
[quoted text clipped - 12 lines]

for?thanks
again..appreciate your concern

thanks again..now it works..thanks thanks