Search results for query: *

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...

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...

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...

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...

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...

**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 =...

I have moved my data to SQL Server 2008 (Access 2003 front end) and have worked out most of the glitches involved with the move. One problem remains, hyperlinks. With Access no longer handling links, the display and functinality of my links are gone. I have managed to code around a lot of...

I am in the process of migrating my tables to SQL server 2008. I recently moved my contacts data to SQL Server. I have a contacts menu with about 13k records. The record source for this menu is simply the contacts table. (the table is actually a view filtered by client name) Common use for...

I have a database that was beginning to show signs of corruption. I am importing all of my database objects into a new DB. Importing linked table objects, approximately 100, took almost 45 minutes but it did complete. Importing queries, about 200, took about 1/2 hour and it hung on the last...

I looking for a way to have Access monitor an Outlook inbox for newly received mail and store the various properties of that email to a table. I have been able to accomplish storing this data, by manually specifying the selected email in the inbox using the Outlook.MailItem object to gather...

I have a routine that I am trying to put together. Part of it requires me to read the To: & Cc: fields of an existing Outlook (2003) email. I am by far an expert with the Outlook object model. The best I have been able to do so far is get at the name listed, vice the actual email addresses. I...

I have a query that appends a record to a notes table. The notes field in this table is set to Memo. The output to the memo field, from the query, is limited to 255 characters with the last few characters being Japanese / Kanji. The source data appears fine. I have tried the following...

Anybody know of a function / way to retrieve the name of the current domain?

I recently made use of code written by remou (thread181-1346884) that allows you to drag an email to a memo field that in turn allows you to store a copy of that email and reference a path to it. The code works great. I have been trying to find a way to reference the data in the Subject field...

Does anybody know of a way to password protect an individual outlook folder. I have seen a lot on securing your .pst but nothing on indivdual folders. Thanks!

Has anybody had any experience with converting an existing app for use with Access Services? There has been talk of deploying SharePoint 2010 here in my office. They are currently using Office 2003 and want to jump to 2010. I’m sure it will be a user nightmare for a while, but time to move on…...

Is there a way to have Windows Server 2003 notify me via email when a specific remote desktop user logs on? Thanks!

I recently moved all of the main forms in my database to popup forms and have hidden the access window. It looks great but with the caveat of loosing some right click functionality. I have been able to reconstruct most of this through VBA. There is one problem I am running into. I need to...

I am trying to find a way to open another access application from within another. (Shell?) I also need to find a way to tell the opening db which form to open and what record to go to. I cant seem to find a solid way to do this. Does anybody have any ideas on this? Thanks!

I have a continuous subform that is bound to a list box. Clicking on a issue listed in the List box returns a series of note records in the subform. Spell check will only check the currently selected record in the subform vice going through all of it's records like it normally should. I have...