Search results

Create your report then add the following code to the 'PRINT REPORT' button's on click event : Private Sub cmdPrintReport_Click() On Error GoTo Err_cmdPrintReport_Click Dim stDocName As String stDocName = "rpt_yourReportName" DoCmd.OpenReport stDocName, acPreview With...

sUser = User.UserName

HI all I have form containing some filtered records. What code do I need to put on a button to trigger a make-table query; the make-table thus containing only the current filtered records (not the entire database). The following will use the entire database: Dim stDocName As String...

Thanks guys An OpenReport on the search criteria forms OK_click did the business: Private Sub cmdOK_Click() Dim strSQL As String BuldSQLString strSQL DoCmd.OpenReport "rptMyReport", acViewPreview, , strSQL DoCmd.Close acForm...

I have a form for users to select various search criteria (name, date range, etc.) This form creates a SQL statement. What's the best way to run an exisitng report based on this SQL statement? Any thoughts appreciated.

All I did was created a mailmerge letter with the required fields like this: ------------------------------------------------- «FirstName» «LastName» «position» «CompanyName» «Address1» «Address2» «Address3» «town» «postcode» 31/03/2005 Dear «Title» «LastName» Letter body text here...

Hi Dan For the time being I've opted for the easy option. I created a form based on a table with letter heading, body text and signature fields (memo). The user clicks a 'compose letter' button and types the letter info in the fields. Another button next to the compose button prints a report...

Yeh, thanks I had seen that. Jon_k's database mailmerges the current record but I need to mailmerge the existing filtered record set - which will be more than one record depending on the users filter criteria (eg town, county, date range etc.)

Could this be used to mailmerge the current recordset rather than refer to a specific query? For example, a user on the main form filters the database on 'town' name then sends the filtered records for mailmerge? On the current setup I converted the document to a normal doc but I still get...

Hi all I have a form to display selected records (eg by town, county, etc). I need to be able to setup a mailmerge to MS Word using the existing recordset. Does anyone know if this is possible? I've spent ages searching for a suitable solution without much success (I'm using Access/Word...