User Profile

Collapse

Profile Sidebar

Collapse
deamond
deamond
Last Activity: Aug 2 '15, 12:44 PM
Joined: May 12 '15
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • deamond
    replied to add multiple records in one outlook reminder (from microsoft access database)
    in Access
    here's some sneak-peek of the code I wrote before :

    Code:
    Private Sub Expired_AfterUpdate()
Dim outLookApp As Outlook.Application
Dim outLookTask As Outlook.TaskItem

Set outLookApp = CreateObject("outlook.application")
Set outLookTask = outLookApp.CreateItem(olTaskItem)
countMonth = MonthName(Month(Task_Due))
countYear = Year(Task_Due)

With outLookTask
    .Subject = "Task
    ...
    See more | Go to post

      Leave a comment:

    • deamond
      replied to add multiple records in one outlook reminder (from microsoft access database)
      in Access
      @zmbd hello, thanks for your reply.
      I'm working on an access database, creating an application with reminder function. I use outlook as the reminder tools, so I put some code on Access to set outlook task reminder and it will pop up when the schedule meets its due date.
      Basically, I have a table containing these fields : Employee_Number , Employee_Name, and Task_Due.
      At first, I set one reminder for each record. But it turns out...
      See more | Go to post

        Leave a comment:

      • deamond
        started a topic add multiple records in one outlook reminder (from microsoft access database)
        in Access

        add multiple records in one outlook reminder (from microsoft access database)

        is it possible to add multiple records in one Outlook Reminder? I need to set an Outlook task reminder containing list of workers who need to extend their working contracts three months before it reach its limit date.

        This reminder will collectively pick the workers who need to extend their contracts and be appear in the 1st day of certain month (approximately three months before their contracts end).

        I was about to...
        See more | Go to post
        • deamond
          replied to automatically insert data to another table by completing checkboxes
          in Access
          thank you for your answer, jforbes.
          it's still hasn't worked for me, I guess I'm still missing something.
          Anyway, regarding to the latest code you sent yesterday, where should I put the condition whether the checkboxes is checked or not? I mean, should I just put the code just like that or add some line instead? thank you...
          See more | Go to post

            Leave a comment:

          • deamond
            started a topic automatically insert data to another table by completing checkboxes
            in Access

            automatically insert data to another table by completing checkboxes

            Hello everyone..

            I'm on my way on creating a simple Database for a company. This database contains several tables, one of the tables will record information about the training that had been completed by each employee. There are about ten sections of training that should be completed.

            Regarding to the database, I have two tables called 'Development' and 'CSA_Lisence'. 'Development' is the table that record the information...
            See more | Go to post
            • deamond
              started a topic how to create SQL Command using macros for Access Web Database?
              in Access

              how to create SQL Command using macros for Access Web Database?

              hello everyone, I'm a newbie on Access. Somebody entrusts me with a project and I found so many obstacles since I'm not familiar with Access, especially Access Web Database.
              My question is how do we create an SQL Command using Macros? I know that VBA is not compatible with Access Web Database, so I need to find a way so I could put some INSERT into command. Is there any other way other that using macros?
              Any answer and help would be...
              See more | Go to post
              No activity results to display
              Show More
              Working...