I've created a db for a group working on the repairs needed after Super storm Sandy. In the db I have captured arrival and departure dates of work teams coming in to support. How I can populate an Outlook calendar from the db table?
View RepliesHi everyone,
I wanted to know if there's a way to implement a calendar in MS Access? In other words, I'd like to create a calendar that act the same way as the Outlook calendar? At first I tought about the calendar control 8.0, but we can't write anything in a square date of the calendar. So , I'm out of idea.
Thank you in advance for your suggestions!
Is it possible?
My departments wants a calendar that reminds us when a certain date is approaching.
MS Outlook has that calendar.
Can we integrate them somehow? Or do I have to write something in Access(is it even possible).
Or do I just have to look at different software out there?
I have developed an Access database which keeps track of items we have received. What I want to do is enter a date in a field and then by clicking a button that date and the name of the item gets enetered into my Outlook calendar so that it will pop up a reminder on that date.
I have no idea if/how this can be done. Any ideas or examples very much appreciated.
Hello Guys,
I'm totaly new to access and outlook applications etc..
What I'm trying to do is link an access table to my calendar in outlook. I can do it but there is one problem it is not importing all the fields. But when I do an export from outlook to access database file all the fields are there.
Can someone help me with this issue?
P.S. I'm using outlook 2003 and connecting to exchange 2002.
Thank you for all the help I can get
I am very new to VBA. I found some code that will allow me to add an appointment to my personal calendar with using access VBA and it works great. It also allows me to add an appointment to another calendar created under "My Calendars" folder.
I wanted to know how to change the code in order to add the appointment to the SHARED calendar instead.
The main folder is called "Shared Calendars" which is at the same level as the default "My Calendars" folder. Under the "Shared Calendars" folder the calendar is called "Tester".
Here is the code im using at the moment: I believe I have have to change the line of code that is in red but I don't know how.
Private Sub cmdAddAppt_Click()
On Error GoTo cmdAddAppt_Err
Dim outobj As Outlook.Application
Dim outappt As Outlook.AppointmentItem
Dim olNS As Outlook.NameSpace
[Code] ....
I have been able to successfully set up code to be able to add appointments to microsoft outlook based on data within a few forms that I have. My question is this however, how do I get access to make that appointment to a specific calendar on outlook. This calendar is a shared calendar. Currently, access is just adding the appointments to "My Calendar" and I could like it to place the appointment on "HVCalendar". a version of the code I found online is listed below:
Private Sub btnaddappttooutlook_Click()
'On Error GoTo ErrHandle
Dim olNS As Object
Dim olApptFldr As Object
' Save the Current Record
If Me.Dirty Then Me.Dirty = False
[code]...
I have linked a Shared Calendar from MS Outlook in MS Access. The fields that I need which are Appointment/Meeting Date and Time are not there, only creation date/time. Is there anyway for me to get the Appointment/Meeting Date and Time from Outlook into the table?
Windows 7
Office 2010
I have a calendar (calendar1) from which i want to populate a textbox (appt1) when i select the date on the calendar but im having problem with the code;
I tried putting it against the on updated event of the calendar as below, but not sure how far off i am:
Private Sub calendar1_Updated()
Dim myDate As NewDate
myDate = calendar1.SelectedDate
appt1.Text = myDate
End Sub
I wish to work in Access 2010 with a subset of my Outlook 2010 contacts (all desktop- no network barriers), so I am exploring the Desktop Contacts DB found in Microsoft's templates. It passes contact data back and forth using the standard macros, but I wish to add more fields from Outlook. It seems I need to find the code associated with the macro. I believe I can solve the problem using a Linked table, but am wondering if there is another solution?
Calendar synchronization is another issue. Linking gets me to the Archive Calendars, but not the Current one in Outlook which is what I want.
A client I am working for wants a calendar to interact with their database forms, I am thinking outlook would be the best bet, as a table and form to make my own in access would be overly complicated. Is there any way to embed a calendar from outlook within an access form?
View 1 Replies View RelatedGood Evening All,
I want a cheep calendar that links to queries and can input data as well as display it. It has been on my wish list for 7 or 8 years.
If anyone know how to make one or knows where to buy a cheep one I would really appreciate it.
I have been using the below code for a number of years to send reminders to Outlook and colour them red (my category colour for certain items).
I've been asked to roll out this code to all members of my dept but the category for other people assigned to the red colour is different to mine.
Is there a way to colour the item using the colour name rather than the category name?
Set OutlookApt = Outlook.CreateItem(olAppointmentItem)
With OutlookApt
.Subject = MailSubject
.start = Dte
.End = DateAdd("h", 1, Dte)
[Code] ....
I use the code below which creates an appointment in Outlook default calendar. I need to add a few lines to create the appointment to an alternative calendar in the same pst file. I need to choose between three calendars in which to create the appointment and plan to select the calendar name from a list on the form.
Dim objOutlook As Outlook.Application
Dim objAppt As Outlook.AppointmentItem
Set objOutlook = CreateObject("Outlook.Application")
Set objAppt = objOutlook.CreateItem(olAppointmentItem)
[code]....
I have a folder under the default on in outlook named ANOTHER FOLDER. All I am trying to do is add the blasted entry to this folder. At the moment though it is adding the information to the default calendar and not ANOTHER FOLDER. I'm just testing at the moment but I have tried all manner of combination but no dice.
Code:
'Error 429 occurs with GetObject if Outlook is not running.
On Error Resume Next
Set objOutlook = GetObject(, "Outlook.Application")
If Err.Number = 429 Then 'Outlook is NOT running.
[code]...
I created a call logging/work tracking type Database using SharePoint 2007 lists for the backend and Access 2013 front end for about 60 users and it has been running smoothly for around two years .
We use a shared outlook calendar and I want to be able to pull meetings & appointment information into the database from the calendar so I can assign the meetings out to specific people and keep of a record that they where given the request to attend. I was able to use the import outlook folder to create a linked table and it has lots of great information from the calendar apart from the two most important things you need in a calendar Start_time & End_Time . Is there something I'm missing in regards to these two fields? I assume I'm doing something wrong but I can't figure out what, nor did I have much luck with the Search function on here or google.
This is the list of field names it does import(everything apart from the meeting time and is it a recurring appointment)
Importance
Icon
Priority
Subject
From
Message To Me
Message CC to Me
Sender Name
CC
To
Received
Message Size
Contents
Created
Modified
Subject Prefix
Has Attachments
Normalized Subject
Object Type
Content Unread
I have been looking for a way to sync a table holding reservation dates to MS outlook calendar automatically when dates are inserted in the table.
View 2 Replies View RelatedI have started converting our Access 2003 to Access 2010 applications. In the past we have used the Calendar to pick a date to place in a textbox. I noticed that this feature will not work in Access 2010.
So I looked around and saw several references to using the calendar pick feature to a textbox...but without success.
How to have a textbox with a calendar icon next to it to populate the chosen date in the textbox?
Is there a quick and easy (or not so easy) way to use Microsoft Outlook Address Book to populate a drop down combo box? I am creating a form that needs to pull in Business Process Owners, all of which would be in our corporate address book.
View 1 Replies View RelatedHi. I have managed to create a command button on my form to send a date field on the form to Outlook as a task. I know this isn't exactly what you wanted to do, but you may be able to tailor the code to suit.
Private Sub cmdOutlookRem_Click()
Dim OutlookApp As Outlook.Application
Dim OutlookTask As Outlook.TaskItem
Set OutlookApp = CreateObject("Outlook.Application")
Set OutlookTask = OutlookApp.CreateItem(olTaskItem)
With OutlookTask
.Subject = "Contact " & Me!Forename & " " & Me!Surname & ", " & Me!CompanyName
.Body = "Company Tel No: " & Me!CoTelNo & ", " & "Direct Line: " & Me!DirectLineinCo & ", " & "Mobile: " & Me!MobileNo
.ReminderSet = True
.ReminderTime = DateAdd("n", 2, Me!DateNextContact)
'Remind 2 minutes from now.
.DueDate = DateAdd("n", 5, Me!DateNextContact)
'Due 5 minutes from now.
.StartDate = DateAdd("n", 2, Me!DateNextContact)
.ReminderPlaySound = True
.ReminderSoundFile = "C:WindowsMediaDing.wav" 'Modify path.
.Save
End With
End Sub
Hi All,
Apologies if this question has already been asked. Im a bit of a newb when it comes to Access. I was wondering if its possible to create a input form/email in Access/Outlook in which I can send to a number of people via email that populate a Access database/xls when they reply?
Extra Info:
-Users may have a different version of office that I have.
-I have office 97, 2000 and 2003.
Hope that all makes sense.
Ollie
Trying to add to my DB. Looking to be able to keep track of time worked on stock parts on a weekly basis. Would like to be able to enter time at the end of the week, by week. IE; On the week of Sept 10th 29 hours were dedicated to restocking our shelves with stock parts. Is there an easy way to accomplish a calendar setup like this, as I seem top be over complicating the issue I think. If someone could point me in the basic direction on this that would be great.
View 3 Replies View RelatedDear All:
Is there a way to implement a pop-up calendar in access so when the date is chosen, it populates a specific text field?
Any help is appreciated.
Many thanks,
Dion
I was wondering if there is a calendar tool like in VB? If so where do I go to get it. I want to be able to click a button, show the calendar tool, then enter the date that I clicked into the text box. Thanks.
View 1 Replies View RelatedCan anyone tell me if it is possible to link access to outlook so that access can send out reminders through outlook to people regarding different information??
View 1 Replies View RelatedHello,
I am running a database in Access 2000. My code for creating an Outlook message from Access was running perfectly until my company switched us to Outlook 2003. Has anyone had a similar experience? Were you able to fix it?
Thanks much,
Pat