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 Wanet Telecoms Ltd 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: *

  • Users: WhtChoklat
  • Content: Threads
  • Order by date
  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

    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...
  7. 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...
  8. 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.
  9. 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...
  10. 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...
  11. 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