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. WhtChoklat

    SaveAs in Outlook

    I have an Outlook Calendar in the All Public Folders area that is automatically updated using the information from Access Queries. I am trying to make the same calendar save itself to a website. As of right now we just have to go in and do it by hand, but there is a push to make it all...
  2. WhtChoklat

    Automating Charts in Excel

    I currently have a code that automates the creating of an Excel chart every week from an Access Query. The problem is that it is capturing the rolling data from a table, and I only want the last 12 rows to be graphed. Is there a way I can do this programmatically, so that every week it only...
  3. WhtChoklat

    Triggering an Event

    I need help!!! I need to find out how to trigger a macro on the event that a fields value is changed. If anyone can help me please post anything!!! If you know a good book about Project, please help. Ed Rich
  4. WhtChoklat

    Help with Code that Changes Value of a Custom Field

    Here is the Code I currently have. Everything works except for the SetTaskField Method. Am I even using the right method. Can someone please help me. Dim NumOfTask As Integer NumOfTask = MSProject.ActiveProject.NumberOfTasks For i = 1 To NumOfTask Dim RemainingCost As Double...
  5. WhtChoklat

    Getting the value of a field

    I need to get the value of a field so that I can run an equation against it. How would I write the VB to get the value of a field, like Baseline Cost or RemainingCost? These are both Task Fields
  6. WhtChoklat

    Custom Fieldsand VBA

    Ron, Thanks for the help. I actually have the book that you recommended right in front of me! This was most helpful in my project. Thanks, Ed
  7. WhtChoklat

    Custom Fieldsand VBA

    I was given the task of creating reports within Project. It was something that was started before I was hired. The problem is that the person who created the reports used all the Custom Fields that Project has and Management wants me to write the VBA in Project to run the code in the...
  8. WhtChoklat

    Created Complicated Chart with two axis, stacked Columns, and a line

    Oh Okay, I understand what you are saying
  9. WhtChoklat

    Created Complicated Chart with two axis, stacked Columns, and a line

    The Reason I am coding it is because I am not the end user, if I was the end user I would just use the wizard, but I was given the task of pulling info from a data dump, formating it, creating reports, and automatically creating the Charts in a clik of the button. That is the reason why I am...
  10. WhtChoklat

    Created Complicated Chart with two axis, stacked Columns, and a line

    Well, I have the data transfered into Excel, now I want to hard code a chart. I need to create two Series, one of which is stacked, and I need to create a second axis. I am not really a coder, but I have been elected to code this in VBA. I am looking for all the help I can get.
  11. WhtChoklat

    Created Complicated Chart with two axis, stacked Columns, and a line

    Here is the situation... I am currently creating an application that grabs a data dump; exports, formats, and creates a MS Access Database. It then exports the data to different Excel Worksheets and Graphs are created. I have everything working, but I can't get the graphs to reflect the data...
  12. WhtChoklat

    Export Multi-page Report into One HTML File

    I have a multi-page report that I am exporting to an HTML File. I want to make it so that instead of exporting three html files (one for each page) it will put all three pages into one HTML file. Is this possible, and could someone please help me.
  13. WhtChoklat

    exporting report as html file

    Look at the Help files. Believe it or not they explain it really well. You don't have to use one, but they just let you design the Title and so forth. But it is all in the Help files.
  14. WhtChoklat

    Send report as an HTML inside the message

    I did the same thing, what email application are you using. I tried it and my mail appliaction actually printed out all of the TAGS. I am actually using a txt to send it now. I hope this helps.
  15. WhtChoklat

    Outputing to File then emailing that file

    I am trying to email a file that I am generating from a report. The file is being created successfully, but I am getting an error when I try to read the information or email it, I am not sure where the error is occuring. Here is my coding: Dim txtTO, txtCC, txtBCC, txtSubject, txtMessage...
  16. WhtChoklat

    Reading A File and Emailing it's Contents

    I am trying to email a file that I am generating from a report. The file is being created successfully, but I am getting an error when I try to read the information or email it, I am not sure where the error is occuring. Here is my coding: Dim txtTO, txtCC, txtBCC, txtSubject, txtMessage...
  17. WhtChoklat

    Outputing to File then emailing that file

    I was just omitting it for security reasons. This is the code I came up with in the end. Thank you for your help. Dim txtTO, txtCC, txtBCC, txtSubject, txtMessage As String Dim outFile, filename, date1, path, ext As String MyDate = Date date1 = Format(MyDate, "mmm d yyyy") path =...
  18. WhtChoklat

    How to prevent opening of more than 1 Report

    I ran into the same problem recently, I found that the easiest solution was to write a macro that was linked to the second button, and when you click that second button it closes the first report. I hope this is what you were looking for.
  19. WhtChoklat

    Outputing to File then emailing that file

    I am trying to ouput to a file then email an attachment of the file and a link to the webpage it will be on. I am receiving errors when I try to output the file, the email is working good. Here is my code, could someone please help? Dim txtTO, txtCC, txtBCC, txtSubject, txtMessage As String...
  20. WhtChoklat

    Sending Email with VB

    I am in the process of automating a report for a database. Currently I am outputting the report to a word file in rtf format. I want that file to be in the body of my message and then emailed out. Can anyone help me.

Part and Inventory Search

Back
Top