Automate Printing of Updated Records

[AhBeng]

Hi,<br>Is there any ways to print the records automatically once any users has updated it??? If yes, pls post the instructions as detail as possible as I'm a newbiew to Access 97/2000.<br><br>-Is there anyway to convert Access2000 database to EXE instead of MDb files???<br><br><br>Thanx.

 

[famousb]

converting to an .exe file requires Access Developer (really not worth the hassle, especially if you're new to Access)<br><br>when you say you want to print records upon update, do you already have a report set up that you want to use?<br><br>if so, you could put in the AfterUpdate property of one of your fields (depending on your preference) VB to run the report.<br>simplest way to limit to the current record is to have a query that has the same record source as the form, then in your primary key field in the query put:<br><b>Forms![YourFormName]![YourPrimaryKeyName]</b><br>this will limit to just the record being dislayed.<br><br>then the VB would look something like:<br><b><br>DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70<br>Dim stDocName As String<br>&nbsp;&nbsp;&nbsp;<br>stDocName = &quot;YourReportName&quot;<br>DoCmd.OpenReport stDocName, acViewNormal, &quot;YourQueryName&quot;<br></b><br><br>the first line saves the record, the last line prints the record <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>