Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Email a report using a single record
- Thread starter mlclinge
- Start date
Guest_imported
New member
- Jan 1, 1970
- 0
have you tried using the control's afterupdate event with a send object macro assigned a very specific name of afterupdate?
Guest_imported
New member
- Jan 1, 1970
- 0
In Access 97: If a user selects a record or some records on a form (whether in form view or datasheet view), then clicks File|Send..., the resulting dialog box gives them the option of sending all records or just the selected record(s).
* * *
In datasheet view, select a record by clicking on the record selector (gray block) to the left of the record. Select multiple contiguous records by clicking on the first and dragging down to the last record you want. If you want non-contiguous records, you have to make them contiguous first, somehow. (Try re-sorting, filtering, praying...)
For that matter, it's pretty much the same in form view, though it will look different. Make a record selector bar available to your user. To do this: In form design view, set the RECORD SELECTORS property of the FORM itself to Yes. If only one form is visible at a time, you'll only see one record selector; if multiple forms are visible at a time, you'll see multiple record selectors.
[I don't know of any way for the record selectors to get anywhere but the left side of the record, in the English-language version products I've used. I've never seen other language versions of any MS stuff. So the left is where you should see them, and if not -- to the best of my knowledge -- they just aren't visible.]
* * *
JUST PASSING THRU
* * *
In datasheet view, select a record by clicking on the record selector (gray block) to the left of the record. Select multiple contiguous records by clicking on the first and dragging down to the last record you want. If you want non-contiguous records, you have to make them contiguous first, somehow. (Try re-sorting, filtering, praying...)
For that matter, it's pretty much the same in form view, though it will look different. Make a record selector bar available to your user. To do this: In form design view, set the RECORD SELECTORS property of the FORM itself to Yes. If only one form is visible at a time, you'll only see one record selector; if multiple forms are visible at a time, you'll see multiple record selectors.
[I don't know of any way for the record selectors to get anywhere but the left side of the record, in the English-language version products I've used. I've never seen other language versions of any MS stuff. So the left is where you should see them, and if not -- to the best of my knowledge -- they just aren't visible.]
* * *
JUST PASSING THRU
- Status
Similar threads
- Locked
- Question
- Locked
- Question
