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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by CWestII

  1. CWestII

    Modify Legacy (2003) Custom Menu/Toolbar in Access 2007

    Thanks! I'll probably have to do it with VBA considering this information.
  2. CWestII

    Modify Legacy (2003) Custom Menu/Toolbar in Access 2007

    No, I have not created that table. These were existing toolbars that were created when it was a 2003 application. The system automatically put them in the add-ins portion.
  3. CWestII

    Modify Legacy (2003) Custom Menu/Toolbar in Access 2007

    I have a database that was created in Access 2003. I have since switched over to Access 2007. The Menu / Toolbars show under the Add-ins Tab now. That is not a problem. I need to make changes to these custom Menus / Toolbars. In Access 2007, it is not very clear as how to perform the...
  4. CWestII

    Create a Recurring appointment in Outlook using VBA

    Does anyone have an example of how to create a recurring appointment in Outlook using VBA? I know how to create and post an appointment and set many of the attributes, but I can't seem to set the recurrence. Any help would be greatly appreciated.
  5. CWestII

    Access 2007: Prevent Users From Unhiding Db Window & Changing Settings

    Thanks for responding! I have code of this nature already in use in the system; so there is something more that I need to do.
  6. CWestII

    Access 2007: Prevent Users From Unhiding Db Window & Changing Settings

    How do I prevent Users From Unhiding Database Window and Changing Settings in Access 2007? Users with Access Professional are able to view the database window and change startup properties in the database. Most of my apps are .mde files so most of the objects cannot be modified; however, the...
  7. CWestII

    Create / Send Lotus Notes Based Email from Microsoft Access

    I need to create and send a lotus notes based email from my database. Unfortunately, I don't have Lotus notes on my machine so I don't know any of the object attributes and such. Does anyone have any code that creates a lotus notes object and then sends an email based on that? All help is...
  8. CWestII

    Parsing out the month and the year from a date

    Try this. Put this in your update query. Replace "FieldName" with the name of your field that contains your traditional dates. PostMMYYYY: Format([FieldName],"myyyy")
  9. CWestII

    Conditional Header Based on Page Overrun

    Is there a way to make a label, textbox, etc. change based on another field continuing to the next page? For instance, on the first page the label may read "Job Description". If the Job Description field continues to the next page, I want the label/textbox to read "Job Description Continued"...
  10. CWestII

    List and Description of API Calls

    Does anyone have or know where I can find a list of all the available API Calls? Along with the list, is there a description of each of the calls and a list and description of the associated parameters? Thanks in advance for any help provided!
  11. CWestII

    How To Create/Populate an Outlook Msg Created from an Outlook Template

    To all: Here is what I did: Dim olMailItem As Object Dim strTemplPath As String Dim myOlApp As Outlook.Application strTemplPath = "TemplatePath\TemplateName.oft" Set myOlApp = CreateObject("Outlook.Application") Set olMailItem = myOlApp.CreateItemFromTemplate(strTemplPath)...
  12. CWestII

    Accessing Outlook Email Templates

    MP, I figured it out so I don't need the example now. To all: Here is what I did: Dim olMailItem As Object Dim strTemplPath As String Dim myOlApp As Outlook.Application strTemplPath = "TemplatePath\TemplateName.oft" Set myOlApp = CreateObject("Outlook.Application") Set olMailItem =...
  13. CWestII

    Accessing Outlook Email Templates

    CautionMP, Thanks for the feedback. Do you have an example of how to use it? I have not used it before, so I am not familiar with what should go in the [InFolder] value. If you could provide an example of this object in context it will be very helpful and greatly appreciated. Thanks in advance!
  14. CWestII

    Accessing Outlook Email Templates

    Good Afternoon All! Let me preface this by saying that I know how to open Outlook templates via "Shell" commands And I know how to create new email objects and populate them using Outlook mail item objects from Access. What I need to know is how can I populate an Outlook template...

Part and Inventory Search

Back
Top