printing current record

[accdot]

I am trying to print the current record in an open form. I have a print button with the fallowing wizard generated code in the event

DoCmd.DoMenuItem acFormBar, acEditMenu, acSelectRecord, , acMenuVer70
DoCmd.PrintOut acSelection

This causes the record to print but afterwards 2 activeX buttons I use to trigger the activeX calender disappear and no longer respond to clicks.

Also, the record always prints the background image to long. Is there anyway to prevent this.

 

[hymn]

have a look at

http://support.microsoft.com/?kbid=209560

Hope this helps
Hymn

 

[tomcat21]

Try this: (If this is close to what you are asking):

Create a Macro and name it say; Print Current Record.
In the first Macro Action line select: RunCommand and in the command line select; SelectRecord.
In the second Action line select; PrintOut and in the Print Range line select; Selection.

Then in your form design, create a command Print button and in the OnClick event, select the Macro.


Thomas Bailey

http://www.reportcop.com

tomcat@reportcop.com

 

[mph1]

Suggestion --- take a look at the following.

http://www.mvps.org/access/reports/rpt0002.htm

This will tell you how to print the current record using a report. Although you can print a form, that is not what it was designed for. The report gives you much more flexibility and you only have to have on the report those objects you wish.

In addition, I would suggest using code instead of a macro. Again, there is a great deal more that can be done with code.

Good Luck!

An investment in knowledge always pays the best dividends.
by Benjamin Franklin
Autonumber Description - FAQ702-5106

 

[leadadmin]

I have a form with an "Add Record" button. We want to print the contents of the form from the current record before adding it to the table. When I write a report to print the current record and invoke it by clicking a print button, it can't find the record because it hasn't been written to the table yet. The report gets its records from the table. The form does not have a "search" or "edit" function; it is only for users to enter new info and add it to the database. Any ideas? Ideally I'd like to have one button on the form to add and print the single record.

 

[leadadmin]

Please disregard my reply...I inadvertently replied to yours instead of posting a new question. sorry!