General :: Calendar Synchronization - Access 2010 To Outlook 2010
Mar 23, 2015
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.
View Replies
ADVERTISEMENT
Nov 26, 2013
I have a MS Access 2010 application when the User opens form CONTACTS Form
◦User finds single record to be used CONTACTID is identifier to be used for selection
◦User clicks button to open form frm_MAIL_MERGE
◦Frm_MAIL_MERGE has a drop down combo box that reads the folder location where the application resides and displays all .DOTM files (that is all template files) and one more combo box which contains the CONTACTID.
◦User selects single .dotm file for merge
◦Frm_MAIL_MERGE has either drop down to select CONTACTID or UNBOUND data field for user to type in CONTACTID number
◦User enters CONTACTID to be used for the mail merge
◦User selects SUBMIT
◦Application merges selected .dotm file with the information in table CONTACTS for the selected CONTACTID
◦Merged document is saved on the user Desktop as xxx.docx
View 10 Replies
View Related
Apr 4, 2013
Is it possible to have a value in an excel 2010 cell be used to update an access 2010 db?
For example, if in a spreadsheet "test" cell A2=3 then in a db "test" a column "value" is 3. However, if the value in the spreadsheet changes so does the db.
View 1 Replies
View Related
Jan 22, 2013
I have been trying to import Outlook (2010) floders into Access 2010. So far, I have only been able to import 1 folder at a time. I have also tried linking the access database to Outlook, not much luck there.What I was wanted to do was import the pst / ost file into access and then work from there.is there a way to import the Inbox and all sub-folders at one time.
View 3 Replies
View Related
Aug 6, 2013
I need to set calendar control as criteria for date in VBA query. I cannot find Calendar control in ActiveX tools in Acc 2010. Where is it?
Date picker seams like very slick and simple solution but I can see it only in database. As it might be solution to my problem, can date picker be used on a form as criteria for VBA query?
View 6 Replies
View Related
Aug 4, 2014
My company recently upgraded our MS Office from 2007 to 2010 (except for Access).
Previously, when I had Access 2007 and Outlook 2007, I had a process that generated 50+ dynamic emails from an Outlook template file (.oft).
The code would loop through a listbox and replace the template's default text to a string of text specific to the selection in the listbox by utilizing the Replace() function on the MailItem .HTMLBody.
Since the upgrade to Outlook 2010, the code is able to run, however, the Replace() function is no longer working; Instead, each email that is generated maintains the template's default text.
The only thing that is not working is the Replace() function, all other aspects of the code work fine.
I've provided a simplified version of the code below:
Dim myOlApp As Outlook.Application
Dim objMailMessage As MailItem
Dim stBody As String
Set myOlApp = Outlook.Application
Set objMailMessage = myOlApp.CreateItemFromTemplate("C:UsersDesktop emplate.oft")
[Code] .....
I've recreated the template file in Outlook 2010, thinking that the template created with Outlook 2007 would be the culprit, but to no avail.
What could have changed from Outlook 2007 to Outlook 2010 that would render my previously valid code ineffective?
Are there certain references I need to enable in both Access and Outlook to allow VBA in Access modify the content in an Outlook email?
View 12 Replies
View Related
May 22, 2012
MS Outlook contacts to MS Access database table to get in,MS Outlook contacts to an Access database?
View 12 Replies
View Related
Oct 30, 2014
I have a VBA module in my Access 2010 database that will send a report as a PDF via email to a predetermined email address. the only problem using the docmd.sendobject method is i keep getting a pop up that says "A program is trying to send an e-mail on your behalf. If this is unexpected, click Deny and verify your antivirus software is up-to-date."
I have a windows task set up at the same time each day to open this database which runs an autoexec that creates this report and using my VBA module sends the email. i want it to just send the email without any imput from me. I want automation.
Here is my code that i am using to create and send the email
"Private Sub Report_Activate()
filename = "Name of file" & Format(Me.Date_time_returned "MMDDYY") & ".pdf"
DoCmd.SetWarnings False
DoCmd.SendObject acSendReport, "Name of file", acFormatPDF, "the destination email address goes here",,, "Request completed and sent " & Format(Me.Date_time_returned, "MMDDYY"), "Subject of email goes here", False
DoCmd.SetWarnings True
End Sub"
View 4 Replies
View Related
Apr 23, 2014
I know how to create new table in Access by linking to Outlook contacts. The problem is, the default NOTES field in the Outlook contact does not show up in the linked Access table. Every Outlook Contact field shows up with the exception of that one field.
View 3 Replies
View Related
Aug 15, 2014
I am using Access 2010. I Have the 'Display Status Bar' box ticked in Application Options but the Status Bar is not being displayed.
View 8 Replies
View Related
Nov 15, 2012
Any issues with using Access 2010 to edit an mdb file..I know there are backward incompatibility issues with 2007 and 2010, but these are both accdb formats.
View 1 Replies
View Related
Oct 21, 2013
I have a Access 2010 DB. The mainform have a subform with one table alone.
I have a button who close Access when the user are finish on the mainform. Still I have the upper right corner X-button who also closing the app.
My problem is that when the user use the X-button then a dialog box appear and ask for saving the changes for the table in the subform on the main form. The user must then do the choise 'yes' , 'no' , 'Cancel'.
There is no need for this dialog box, (I take care if it's necessary earlier) but I can't get rid of it.
View 12 Replies
View Related
Apr 23, 2014
I have MS Access 2010. I cant remove password because when I open in exclusive mode, file, info, there is no decrypt password option.
View 1 Replies
View Related
Jan 25, 2013
I just upgraded to Access 2010. I was able to solve all migrational issues, but my custom ribbon is showing two File tabs, one that I created and the default access file tab. How to get rid of the default File tab or at least disable it?
View 8 Replies
View Related
Aug 27, 2014
I am Using Access 2010 Version. I have created a Database which consists of Linked Tables (from remote Server), Queries and a Form.
I am using Form to search the required Data. Every thing is working in My PC. But, when the Database file is trying to open from my colleague PC. It is not working. I mean, The Form is opening but when I click the Button nothing is happening. My Colleague is using 2007 Version of MS Access.
View 5 Replies
View Related
Jul 28, 2014
In MS Access i want to be able log jobs and be able to assign my stock to the jobs i have logged is this possible ? how to create a database to log jobs but how can i make it so when i add stock to the job it will remove it from my stock pool and assign it to the customer thus taking it out of stock.
View 3 Replies
View Related
Sep 16, 2013
When distributing a program using 2010 runtime, I find that the spell check doesn't work. Is there a spell-check .dll or is there anyway I can get a spell checker?I have several memo fields with long report-type data entry which is being keyed by mutants. Spell checking is essential to get an intelligible report.
View 1 Replies
View Related
May 1, 2013
I've been updating the look of some of my db's and am trying to access the new style colour picker per Office 2007/10.
Up to now I have been using
Private Declare Function ChooseColorAPI Lib "comdlg32.dll" Alias "ChooseColorA" (pCHOOSECOLOR As ChooseColor) As Long
which displays the pre 2007 style.
I've looked all over the web but cannot find anything relating to the current style (other than using it from the ribbon or control properties), so not sure if I should be looking for a different function or a change to the ChooseColor type values.
All db's are running 32bit access and at the moment 32bit OS but will no doubt have OS upgrades to 64bit soon.
View 2 Replies
View Related
Dec 10, 2014
I have a split database with several attachment fields that work fine.
When I try to create a new attachment field in the BE, upon opening the FE, I get the following error: "The search key was not found in any record."
I have tried several ways: first create the attachment entry in the BE, then I can't open the FE. Create it first in the FE, leave it unbound and then create it in the BE - same error.
View 1 Replies
View Related
Jul 20, 2012
I continue to get this "Enter Parameter Value" on my access and I can't figure out how to fix it. I have access 2010..
"Field1. Filename"
View 1 Replies
View Related
May 4, 2015
I have been doing an exercise to split the data from the list of the information into column A, B & C. Unfortunately the data value that i have consist of several set of data format therefore it create an issue for me to separate the information in Access 2010 easily.
eg.
Original Data Field
FLRY-B-0.75-L-GY
FLRY-4.0-V-R
VTAC-GY 19X20
COT-F2-5-DL
Actual Data To Populate Into Column A, B & C should be the following :
A
FLRY-B
FRY
VTAC-GY
COT-F2
B
0.75
4
19X20
5
C
L-GY
V-R
(No data captured for this column)
DL
View 14 Replies
View Related
Dec 9, 2012
I'm having difficulty getting my import to work... when i call on the original XML file I get too many tables... when i call on the XML file using the transform function of Access with the XSL file it gives me only two tables "body" and "tr". Body contains the value "Weather" and tr contains the value "Day".
Import the day as month/day/year into a field "Day" in access table "WeatherSFCAL"
Import the Fahrenheit temp from the high section into the field "High" in access table "WeatherSFCAL"
Import the Fahrenheit temp from the low section into the field "Low" in access table "WeatherSFCAL"
View 3 Replies
View Related
Aug 16, 2012
We have been using a shared database (on the server and it's not spilt) that was converted to MDE file and was created in Access 2003, without any issues for more than 5 years now.
Since we upgraded our office to 2010 (and access 2010) all the sudden the autonumber field starts generates a number that is about 40 to 50 records less than what is should generates. All the records for the missing 40 to 50 numbers are still there and we can search them.
The only work around is to run the database and open a new data entry form (at which time the autonumber field will generates a new number) then close the form, and we keep doing that until we reach the number that should be generated next.
View 4 Replies
View Related
Apr 17, 2013
How would I use the Access 2010 setting, 'Compact on close'?We have a back end on a server and many users with front ends on their computers. So would I set 'Compact on close' on the back end? And then it would compact when the last user logged out?
View 3 Replies
View Related
Apr 3, 2014
I am having difficulty importing a large txt file into my database, due to the first column containing a * prefix. normally i would just go through the document and delete it, but this file is quite large at over 100k records.
Is there anyway of importing this file in access 2010 and telling access to ignore the first column?
View 3 Replies
View Related
Jun 13, 2013
Why Access (2010) database is creating backup copy by itself?
View 2 Replies
View Related