Search results

I'm actually "printing" the report straight into an email message as a pdf file using DoCmd.SendObject which apparently doesn't allow for filter criteria. But thank you for that idea. I appreciate the help.

This did the trick quite nicely, thank you. I did have to tweak it slightly because my form is actually a subform (sorry I didn't mention that in my original post). So the criteria parameter came out like this: Forms!NameOfParent!NameOfSubform.Form!NameOfFormField

I have a form that I use for entering data. One of the fields in each record is an autonumbered field called "RecordID." There is a button on the form that (on click) executes a VBA script that saves the current record and then executes a command to print a report containing the data from a...

Perfect. I did a quick lookup on LinkMasterFields and LinkChildFields. That was my error. Fixed it and all is good. Thank you for sharing your knowledge with me!

I have a parent form with three tabs for subforms. Each subform is attached to a table: · "Demographics" displays a single record. · "Appointments" displays continuous records. · "Status" displays continuous records. To enter a new record under "Appointments" or "Status", I use a...

DLookup was just what I needed. Solved the problem for me. Thanks!

Staff_ID is a lookup field that references a table with a list of staff names indexed by an ID #. There are several "charge reports"--each of which is unique to a particular staff person. So when the button is clicked, I want Access to prompt the user for the record ID#, find that record...

I have the following code that I need help modifying: Private Sub ChargeReport_Click() On Error GoTo Err_ChargeReport_Click Dim stDocName As String stDocName = "Charges_Report" DoCmd.SendObject acReport, stDocName, acFormatPDF, , , , "Charge Sheet" Exit_ChargeReport_Click...

Thank you very much! That "Query by Form" technique does the trick. I created a form for the user to input the start and end dates and a command button to execute the macro that generates the reports. I then altered the criteria line in my main query so that it pulled the data from the form...

I am a bit of a noob who needs help with a problem that I have not been able to figure out on my own. A database that I created has a main query that includes a lot of calculations of data that it pulls from a main table. The main query prompts the user for a date range with a "Between [start...