Message From Field in Folder
When viewing the list of my new messages, is there a way to see the
email address of the sender instead of the alias before I open it?
In the From column I see "John". When I open the email I see "John
<email@example.com>". I want to see the "firstname.lastname@example.org"
before I open it so I can tell the difference between emails from
"Microsoft Support <email@example.com>" and "Microsoft
I am currently using outlook 2002 and 2003 alternately based on my
If you ...modify fields
Hi - just started using CRM and have several questions.
1. How do I modify the COUNTRY field? I want a user to be
able to type in the name of the country and return and
display the 2-letter country abbreviation? Do I have to
build a new table for that or can I modify the country
field as it is now?
2. How do I apply or change field rules such as case-
convert, etc. for either existing fields or fields I
Thanks in advance for any assistance you can give me.
I think the existing country field is a simple text field. You cannot out
any logic behind these fields. One op...Showing Specific Data from Master Sheet to Another Sheet
I am making a bill of materials at work and have a master list I want to
access from other sheets.
The master list has all parts named and categorized, and I want to be able
to access sections (Hydraulics, Chassis, Electrical, etc.) of the master from
I have tried pivottables but I am having issues showing the data in it
Part Name Quantity Material Expense Category etc.
(accross the row)
I wish to be able to make calculations only off the selected data on each
sheet but I am having immense problems getting there.
If you can help.
Parker Jo...How can I refresh the master form from a subform?
On the After Update of the subform I am trying to refresh the Master form. I
have tried things like Docmd.requery and Me.Refresh, but not sure what I am
Can you help me with this?
>On the After Update of the subform I am trying to refresh the Master form. I
>have tried things like Docmd.requery and Me.Refresh, but not sure what I am
MVP [MS Access]
...Can't check autofilter
I have problem about filters. I can't use filters by checking in box in
Autofilter Menu (in red box in the picture) but I can use other filters
normally. I don't know how it happen but I want to use it again. Please
jatupal's Profile: http://www.citrixguide.com2235
View this thread: http://www.citrixguide.com/showthread.php?t=63821
...Query emails coming to a specific domain
We have about 5 domains on our exchange server that we receive email
from. We are in the process of not renewing one of our domains but
would like to check to see if email from that domain is still coming
through. Is there any way to do that? I tried the Message Tracking
Center with the *.domain.com but it didn't like that. It wanted a
Check SMTP logs as well.
MVP - Exchange
NEW blog location:
<firstname.lastname@example.org> wrote in message
news:...enter value based on drop down list of another field?
I have an excel 2003 spreadsheet with 3 worksheets. In sheet 1, I created a
drop down list in column A based on values in sheet 3, column A (item
number). Thisd data comes from sheet 3, where I have column A (Item #'s),
column B (Item desc)an Column C (price)
In column B of sheet 1, I have Item Descriptions and in column C I have
price. I want this to automatically fill in based on what I enter in the
column A sheet 1 and it should get the corresponding values from sheet 3
column B and C. I can make the drop down list in sheet 1 column B and C, but
some of the descriptions need ...Restrickting from field
When you create new email, you can click option and tick
It will be add FROM field and you can use address book to
pick up any name.
Are their any options or policy to restrict this function?
Using Exchange server? This should not be possible by default - someone has
changed the permissions. What version of Exchange? Follow the KB 262054 to
see where permissions might be set - and remove groups that shouldn't be
> When you create new email, you can click option and tick
> FROM field.
> It will be add FROM f...Automatic Data Entry Script OnChange Event for Date Field.
Sub: Automatic Data Entry Script OnChange Event for Date
has anyone assigned 'Today date'( new Date()) to a custom
date filed on the form - OnChange of a Picklist field, I
have the following code.
DatefiledName.value = new Date();
This assigns, currect date to the field, but then when I
save it does not like it. When I manually assign a date
it displays in the format mm/dd/yyyy, and saves
correctly, so I changed the script to:
d= new Date();
s = d.(getMonth() +1);
s += '/' + d.getDate();
s += '/' + d.getFullYear();
DatefiledName.value = s;
This also acc...Check box question 04-23-07
I have a form with a check box used to indicate if a receipt is voided or
not. What I'm trying to do is go to a new record after the checkbox is
marked. I have the following code in place and it works. Kinda. The
problem is that if I then go back and UNCHECK the check box, it sends me to a
new record again.
Here's the code:
Private Sub Check43_AfterUpdate()
If Ckeck43 = Yes Then DoCmd.GoToRecord , , acNewRec
Thanks for any help!
The following works fine for me.
If Me.Check3 = True Then DoCmd.GoToRecord , , acNewRec
If Ckeck43 = True Then DoCmd.GoToRecor...Data missing from enterprise custom task fields after migrating
We can see the enterprise task fields, but none of the data is displayed in
files migrated from Project Server 2003 to 2007. Any ideas?
What process did you follow for migration?
Gary L. Chefetz, MVP, MCT, MCTIP
"michaelj" <notreallyme.com> wrote in message
> We can see the enterprise task fields, but none of the data is displayed
> fil...Customized picklist fields are not showing up in the preview
can you please help me out in the following situation:
i have customized my crm 1.2 system in a huge manner. now all customized
picklists do not show up in the preview of e.g. opportunity. opening such a
related opportunity offers me the possibility to change the picklist field as
note: all built-in picklist fields are showing up in the preview...
Did you publish the customizations? And performed an IISReset?
After those actions your changes should be visible.
Hope this helps,
> hi,...Removing the : in the coment field
When I insert a comment to a field a colon appears. I know this is meant for
the user name to appear but I don't want that. In fact, I don't want the
colon to appear. Currently I manually delete it from each comment I
insert...is there a way to turn that feature off so I merely type in text
without having that colon appear?...I am using Excel 2000
You can use programming to insert comments with no user name. There is
sample code here:
> When I insert a comment to a field a colon appears. I know...reality check: 1GB mailboxes?
Is anyone else getting pressure to compete with GMail and offer 1GB
mailboxes to their Exchange Server 2003 users? To me, Exchange is a
messaging/collaboration platform, not a file server. The issue I'm faced
with lately is file attachments on email messages. They can be anywhere
from 20KB to 50MB (or more). Limiting the file attachment size means
finding an alternative to sending/receiving files that don't make the
cut. Since sending email with attachments is so pervasive and easy
(albeit, insecure), asking users to send/receive files another way could
result in a decrease in ...Permitting relaying to specific domain
Windows 2003, Exchange 2000 sp2.
I'm working with two e-mail domains in my exchange server, with the primary
e-mail address @yyyy.com, I can send/recieve e-mail using pop3, but I'm not
able to do the same with the second e-mail address @xxxx.com, with this
address I just can recieve e-mail, but when I try to send I recieve the
relay error 550.
Any help will be appreciated.
Create connector for that domain and in Address Space tab set "Allow
messages to be relayed to this domains".
> Windows 2003, Exchang...Extracting a word from a long text field
I have a text field (up to 200 characters) and I need to extract a specific
The text field name is "MEDICATIONS" and the word I need to extract which
might appear anywhere in the field is 'VENOFER'. The word need to be entered
in a separate field in a query.
Could any one help as to how to enter the code in the query?
In the criteria I entered Like "VENOFER" Or "Venofer"
It seems to work.
Will it cause any problems down the line? In other wrods is this an
>...Calculating Date Fields
I have a document that is filled with FormFields and users go from field to
field filling the fields for a final document. I have been reading up on
'calculated dates' but have not seen a scenario like this.
Three of my formfields are "Date1", "Date2" and "Date180." What I am trying
to figure out is how to evaluate/compare Date1 and Date2 to see which is the
earliest and then provide in Date180 the date 180 days from the earliest
date. (Unless the form is blank there will always be a Date1, but there may
not be a Date2 and if Date2 exist...Editing Password protected form fields in Word 2007
We have created a Word document with a legacy text form field. We inserted a
word date field and protected the document allowing Filling in Forms. After
protecting the document when we try going to the form field and clicking on
back space to delete the entry we get "This is not a valid selection" message
We have existing word documents in 2003 with similar form fields. We were
able to delete the entries and add new data. After converting the documents
to 2007 or create new documents in 2007 and try to delete the entries we get
the above error.
...IIF Query for Numeric Values in Text Field
I’m attempting to flag interest rate spread errors and omissions in a file
from a sales database using IIF statements I adapted from another database
(I’m a novice at this). The field I’m querying is text format and contains
both alpha and numeric values. When I test for a null value the IIF works
fine, but when I test for a numeric value I get an #ERROR.
Spread Error1: IIf(([Tbl 1 Eligible Closed Deposit Opps Appended]!Spread Is
Spread Error2: IIf(([CCC Fall 2007 Eligible Products]![IB/NIB]="NIB" And
[Tbl 1 Eligible Closed Deposit Opps Appended]!Spread<4),1,0...Enabling the "From" field in OWA
I've set up a mail-enabled public folder so a customer service group can
receive e-mail and respond to it. Most of them have Outlook 2003 and they
work just fine. A few of them are using OWA only (2000 right now, 2003
soon) and I can't figure out how to get the "From" box to show so they can
"Send As" the folder?
Is there a way to do this in OWA2000? Is there a way to do this in OWA2003?
Thanks for any help!
"Colin" <IDoNotWantToBeSpammed@foo.bar> wrote in message
news:epQDe.5434...Add Spell Icon to tool bar.
I cannot find the Spell Checker Icon in any of my pull down menus or add
buttons list. Where is it and how do I instal it on my tool bars in Outlook?
It is only available using Word as the editor in Outlook.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, Tazz asked:
| I cannot find the Spell Checker Icon in any of my pull down menus or
| add buttons list. Where is it and how do I instal it on my tool bars
| in Outlook?
...copying fields in backend
Hi Access Group.
Can somebody help me with my problem.
I have an Access backend, only with tables ;-). These tables are
updated with data written from a program which is not developed in
Access. I have no forms in the backend in which I can call dules or
What I need is that when the table "tbl_prod" has been updated with
new data, then the text value of field "tbl_prod.Article" is to be
copied into the emty field "tbl_prod.Barcode" of the updated record.
Is it possible to made this copy only in the table field setting, or
can it be done ...Look up in "Send To" field...
How do you enable the "Send To" field to do automatic lookup in your
contacts? One of our employees says his home version of Outlook (outlook
2000) will not display the selection box when you enter a name that has
mutliple contacts. I can;t be bothered looking into this non-work related
issue because it works fine here.
...In Word 2007, I want to enable tabbing between fields in my .docm
In Developer Mode, how can I set the properties of my fields to support
tabbing from one field to another in my Word form?
What kind of "fields" did you insert?
If they're form fields from the Legacy Controls button, you have to turn off
Design Mode and then protect the document for forms. Either click the
Protect Document button and go through the Restrict Formatting pain/pane, or
add the Lock command to your Quick Access Toolbar.
If they're content controls (the other buttons in the Controls group),
tabbing between controls other than a Rich Text control w...Check Schemas are correct
I have a lot of schemas to load into a schema collection. I load them in
by reading each one into a XMLTextReader from disk and add them into a
schema collection. I have a couple of issues to contend with.
1. The targetnamespace on all the schemas (except ones which define generic
types) are the same.
2. The DefaultNamespace is the same as the Targetnamespace (I think this
should be ok)
3. Some of the schemas import other sschemas containing type definitions.
How does the schema collection object handle adding a schema that imports
other schemas?? Say I have two schemas A and B which ...