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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. joshryanhr

    Email Pivot table from Access

    In the case that im not here some one else will have to run the report and send the eamail. Rather then have to train someone on how to do this it would be better to just have them click a button and everything be automated for them.
  2. joshryanhr

    Email Pivot table from Access

    i tryed that but the macro shows up blank
  3. joshryanhr

    Email Pivot table from Access

    Ok i set all microsoft office refference to get this to work, but it sends the whole workbook, all i want it to do is send the pivot table as the body.
  4. joshryanhr

    Email Pivot table from Access

    i get run time error 91 "object variable or with block variable not set
  5. joshryanhr

    Email Pivot table from Access

    I got this much so far from doing hours of searching, but now i get a error saying to set object varible. Private Sub Command13_Click() DoCmd.OpenForm "qds actions taken", acFormPivotTable, , , acFormPropertySettings, acWindowNormal DoCmd.RunCommand acCmdPivotTableExportToExcel...
  6. joshryanhr

    Email Pivot table from Access

    I have been to lots have excel and access sites for help on this. I can get it to transfer the data to a spread sheet but i can seem to find the code to export the actual pivot to a temp excel sheet and then have it email the pivot.
  7. joshryanhr

    Email Pivot table from Access

    I have thought about that, but what would be the code to have access spit it out to excel and then email it with set email addresss all from one button in access?
  8. joshryanhr

    Email Pivot table from Access

    Does anyone know how to email a pivot table from access, I have a form with a pivot table but when I try to email it the email body is just a regular table. I tryed it in reports where you can put a subform that has the pivot tabel but when i try to eamail it, it says that it cant save subforms.
  9. joshryanhr

    Pivot Table Auto Filter Help

    I am new at access. I need a pivot table that automaticly looks at Sat-Fri of last weeks data any time you open it.
  10. joshryanhr

    Update field with new vaules

    Im kinda new at this, How would the update query be set up? I also so some things about a replace function but now sure how to make it work.
  11. joshryanhr

    Update field with new vaules

    Im trying to update a old vaule with a new vaule. old=disputed new=1disputed. I have about 30000 records that need this to be changed on. Is there a way to do this without having to create a whole new table?
  12. joshryanhr

    How to Make Access Report as Body of Email

    Thinks I put the following code in and now it works. Also as a bonus if you cancle the email i dont get the error that says you have cancled and lock access up any more. Private Sub Command129_Click() Const ForReading = 1, ForWriting = 2, ForAppending = 3 Dim fs, f Dim RTFBody, strTo Dim...
  13. joshryanhr

    How to Make Access Report as Body of Email

    How do you make a report be the body of an email. I am using the following code to send it as an attachment, but I need it to be the body instead. Also I need the to and cc to generate from a field i have on a form. Private Sub Command129_Click() DoCmd.SendObject acSendReport, "Query for...

Part and Inventory Search

Back
Top