A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Trying to print current record



 
 
Thread Tools Display Modes
  #1  
Old May 6th, 2010, 09:39 PM posted to microsoft.public.access.reports
Victor[_7_]
external usenet poster
 
Posts: 5
Default Trying to print current record

I have a form that I created a button (that activates a macro) to print the
current record (so I thought).
Here is the action:
Report Name: DOA Record Report
View: Report
Filter Name: ------
Where Condition: [ID1]=[Forms]![App 1]![ID1]
Window Mode: Normal

ID1 is the primary key on the form
App 1 is the name of the form.

I would have just used the PRINT RECORD button that's built in, but that's
another problem (error popups).

Thanks for any assistance.


Victor
  #2  
Old May 6th, 2010, 11:17 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Trying to print current record

Victor wrote:

I have a form that I created a button (that activates a macro) to print the
current record (so I thought).
Here is the action:
Report Name: DOA Record Report
View: Report
Filter Name: ------
Where Condition: [ID1]=[Forms]![App 1]![ID1]
Window Mode: Normal

ID1 is the primary key on the form
App 1 is the name of the form.

I would have just used the PRINT RECORD button that's built in, but that's
another problem (error popups).



I seriously doubt that you want to use Report view, try
changing it to Preview.

You may have another problem somewhere else (in the report?)
thats causing whatever makes you think the report is not
doing anything.

--
Marsh
MVP [MS Access]
  #3  
Old May 7th, 2010, 02:59 AM posted to microsoft.public.access.reports
Victor[_7_]
external usenet poster
 
Posts: 5
Default Trying to print current record

Stupid Me... After putting in all the coding, I forgot to say, it prints
ALL the records (I even changed it to Print preview as you recommended). It
pops up asking for the ID1 Value.

Thanks


Marshall Barton wrote in
:

Victor wrote:

I have a form that I created a button (that activates a macro) to
print the current record (so I thought).
Here is the action:
Report Name: DOA Record Report
View: Report
Filter Name: ------
Where Condition: [ID1]=[Forms]![App 1]![ID1]
Window Mode: Normal

ID1 is the primary key on the form
App 1 is the name of the form.

I would have just used the PRINT RECORD button that's built in, but
that's another problem (error popups).



I seriously doubt that you want to use Report view, try
changing it to Preview.

You may have another problem somewhere else (in the report?)
thats causing whatever makes you think the report is not
doing anything.


  #4  
Old May 7th, 2010, 10:18 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Trying to print current record

Whatever you are prompted to enter is the thing that the
report's record source query can not find. If it was just
ID1, then either the ID1 field doesn't exist in the table OR
it was not included in the record source and a report
control is bound to the field or it is used in the report's
Sorting and Grouping list.

If you were prompted for [Forms]![App 1]![ID1] then the form
was not open when the report was opened OR the form was
open, but does not contain a control/field named ID1.
--
Marsh
MVP [MS Access]


Victor wrote:
Stupid Me... After putting in all the coding, I forgot to say, it prints
ALL the records (I even changed it to Print preview as you recommended). It
pops up asking for the ID1 Value.

Marshall Barton wrote
Victor wrote:
I have a form that I created a button (that activates a macro) to
print the current record (so I thought).
Here is the action:
Report Name: DOA Record Report
View: Report
Filter Name: ------
Where Condition: [ID1]=[Forms]![App 1]![ID1]
Window Mode: Normal

ID1 is the primary key on the form
App 1 is the name of the form.

I would have just used the PRINT RECORD button that's built in, but
that's another problem (error popups).



I seriously doubt that you want to use Report view, try
changing it to Preview.

You may have another problem somewhere else (in the report?)
thats causing whatever makes you think the report is not
doing anything.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:57 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.