Search results for query: *

Answer to my own question. You have to specify the category by its name / string value Sub SetSelectionComplete() Dim mailMsg As MailItem For Each mailMsg In Outlook.Application.ActiveExplorer.Selection mailMsg.Categories = "Homer Simpson" mailMsg.Save Next End Sub

Based on a user selection in an Access (2010) form I am trying to change color of an Outlook email category. Working the Outlook mailItem I am trying to do the following: If Forms!frmTreeViewFull!TextFlagColor = "Red" Then currentMail.Categories = olCategoryColorRed currentMail.Save End If...

Just to follow up my thread here. Just got done upgrading to Access 2010. Problem solved.

I have recently upgraded to Access 2010. I have secured Sharepoint Access Hosting services to develop some simple Access Web Forms. The form I am working on now is a continous form. The forms displays well when published to the Sharepoint server. The form is based on a single table. When I...

Anybody?

It'd sounds like an MDAC problem. Assuming your on a 64 bit machine there is a lot listed about Win7 64 and MDAC issues. I picked this link up while doing a bit of digging around. http://social.technet.microsoft.com/Forums/fi-FI/w7itprogeneral/thread/7c20296f-6184-4c02-a616-2c6bd0bba3c9

Still trying to see if this is possible. The Microsoft Outlook View Control Reference / help file from Microsoft only exposes 12 properties. None of these properties have anything to do with the selected email in the OVC. Anybody? It would be totally cool if this was possible!

Just fishing here.... If you are trying to ODBC connect an access front end and it is a new Win 7 machine / upgrade you may have trouble connecting to your target server if network discovery is not enabled on the client machine. Try navigationg to the target server via network neighborhood...

I have code that stores / files selected outlook 2003 emails. It reads .SenderName .Subject, etc.. and stores this data in my application. I have been asked to embed the Outlook View Control into my app and create the same functionallity as listed above. I have been unable to get at the...

Default printers are installed & I'm using the office 11 object library. The database opens fine when just going to the database window (shift) so I know that it has to do my main menu. The main menu has some positioning of buttons etc. in the resize event. I suspect that this is what is...

We have just purchased a number of new computers loaded with Windows 7 Pro. With Office 2003 installed and all of the latest patches I am suddenly running into problems with Access crashing when it opens. My main menu loads, then maximizes, and the second you click on any control, Access...

MajP, works like a charm! Still could not get around "isCommandBar" & the refernce to "subFilterOrders" in the on action for the menu selection, but I can code around this. Saved me a lot of time...thanks much!!

bit hung up on "isCommandBar". Is it a seperate function in your DB?

Access 2003 I am trying to design a custom right-click reports menu for a projects page in my access database. I have multiple groupings of reports. So far with, the custom right-click menu I have created, I have only been able to create a long continous list. What I would like to do is...

I see it...so no use for VBA in my case. So is it possible in the conditional formatting of, per say, my memo field to to refer to the value in another control on the form and determine the properties settings that memo field? Or, does conditional formatting apply only to the values of the...

Hi jsteph, I just looked at that and see where that could work if I simply wanted to change background color, etc. for multiple controls. The problems is the "Enabled" property (which I need) isnt available from the form, only in VBA....

**Access 2003 I have a form that is continous. I have a combo box named NoteAuthor (row one, not visible is contactID) In the on Open of the form I use FormatCondition to lock the field with: Dim ObjToChange As FormatCondition Set ObjToChange =...

Just got done updating my DB and it worked all around. Strange how Access (2003) forces you to create a new text box to get around this.

I think that I may have solved my own problem here. If you have an existing text box with what used to be a link be a link before converting to SQL try this: If you try changing the Is Hyperlink property of the text box yes it might fix the display properties but the link still will not work...

That is what I am using right now, with a few tweaks to make it work. The problem is also display related, an address like trevorwilliams2@abc.com is now "trevorwilliams2@abc.com#trevorwilliams2@abc.com" The email actually opens with the address displayed like this. a path is now: G:\MS Office...