Linking Outlook fields from the "Contact Folder" to a custom form in Outlook...
Using Exchange Server 2003/Outlook 2003, we have created a custom Help
Desk form in Outlook. We would like the ability to link specific fields
from the Contacts Folder (Example B), in a drop-down list box if
possible. We are far from knowing that something like this is even
possible. Would appreciate *any* suggestions. Thank you.
...handler for toolbar button
in Visual Studion 2003, I added a new toolbar button to the
IDR_MAINFRAME toolbar, and I need to add a handler for it in
the CFormView derived class that handles my view, how do you go about it?
> in Visual Studion 2003, I added a new toolbar button to the
> IDR_MAINFRAME toolbar, and I need to add a handler for it in
> the CFormView derived class that handles my view, how do you go about it?
There is no facility to add a handler from a toolbar button. Toolbar
buttons should only reflect what is available in a menu, this way you
don't require your client to rea...Where's the Sort by New Message option?
Not sure when the layout of the newsgroups changed but I can't seem to find the ability to sort by new message in a thread instead of sorting by just the original thread date.
That was hugely helpful as I could follow along and see what threads were still active.
If you're gonna hang around in the newsgroups (any newsgroups), you may want to
start using a newsreader.
Microsoft Outlook Express can do it for you.
Saved from a previous post:
You may want to connect to the ms newsserver directly:
If you have Outlook Express installed, try clicking on these links (or copy and
is it possible to use variable for sorting?
declare @sort varchar(10)
SET @sort='column1 DESC'
SELECT ROW_NUMBER() OVER (ORDER BY @sort)AS rowId, * FROM table
Is dynamic SQL only option?
On 15/04/2010 11:28, simon wrote:
> is it possible to use variable for sorting?
> Something like:
> declare @sort varchar(10)
> SET @sort='column1 DESC'
> SELECT ROW_NUMBER() OVER (ORDER BY @sort)AS rowId, * FROM table
> Is dynamic SQL only option?
You can use CASE to he..."An unexpected error has occurred" when sending from distribution lists
I have set up a new computer, installed Outlook 2002 on it
and migrated my files to it from the previous computer.
Now whenever I attempt to send an email addressed via one
of my distribution lists, I get an error message (An
unexpected error has occurred). I also see two Contacts
folders in the Add Address List in the Tools/options in
the address book.
I did change the location of the Outlook pst files, did I
confuse something or ?
Any ideas? Nothing in the Knowledge base helped
...Force Form to finish Loading before running Code
Sorry Folks ... Pulling my hair out here ... I have a for that loads and
after load I want it to un a query. Problem is that the query always launched
before the form has completed loading.
I have tried using the Form_Activate option as suggested in another post
amopngst a number of others
Is there an easy way to force the Form to load First
At what point do you want the query to run?
What does the query do?
Dave Hargis, Microsoft Access MVP
> Sorry Folks ... Pulling my hair out here ... I have a for that loads and
> after load ...How to sort account list?
I'm using MS Money 2004 Small Business. In the account list, my accounts
are catagorized by and in this order:
- bank accounts
- credit accounts
- investment accounts
- loans and liabilities
- asset accounts
In the above view, I cannot easily determine totals for assets and
liabilities. The following view does this.
- bank accounts
- investment accounts
- asset accounts
-loans and liabilities
How do I get the above view?
I don't use Small Business. But you can run a Net Worth report to get total
assets and ...Sharing Calendar with personal distribution list
I have been asked to find a way for our employees to be able to share their
calendars with their personal distribution lists. Is this possible?
Answered your other post
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-Properly back-up and restore your Outlook data
-Create an Office 2003 CD slipstreamed with Service Pack 1
"stahlerw" <firstname.lastname@example.org> wrote in message
>I have been asked to find a way for our employees to be able to share their
&g...Prevent user to close tabbed form
rI use the tabbed form layout in access 2007, i.e. I went to Access options
->current database and chose "Tabbed documents". One form is a startup fom
and the main menu of my application. By right-clicking on the main menu tab
the user can choose "Close" and the main menu is shut down.
How can I prevent the user from closing down the main menu form of my
On Thu, 25 Mar 2010 14:56:07 -0700, Tore <email@example.com> wrote:
I would argue that if they close it, you should close the whole
application. If we prevent the user fro...Macro filter on query
I need to run 8 append and update queries using the same date range. I
created a Form with the "Month" field as the filter and a command button to
run the macro to run the Append & Update queries for records in the month
range. I can't get the Apply Filter macro to work on the Query Date field.
Apply Filter action will not do what you seek.
Your queries must have a WHERE clause that refers in some way to the textbox
on the form where you've entered the Month value/data that you want to use
in the queries.
To assist you further, you need to post ...Row names will not move with sort
Each row in my summary table in Sheet1 is hyperlinked to a corresponding table in Sheet2 with additional details.
I need to move the rows in my summary table (Sheet1) and preserve the links to and from the details tables (Sheet2).
I found that I can move rows in Sheet1 with cut & insert and the hyperlinks are maintained. I can travel from a row in summary table (Sheet1) to details table (Sheet2) and back, even after the corresponding row (Sheet1) was moved.
But if I sort the rows in Sheet1 the links from Sheet2 back to corresponding rows in Sheet1 lead to presorted locations. Apparen...Rules and filters.txt
1) If filters.txt is really just a readme file to demo what Outlook is
doing, where are the actual entries stored in Outlook 2002 ? In a text
file, like "Junk Senders.txt" ? Or the Registry ? I can see it is the
outlfltr.dat for 2003. But where is it in Outlook 2002 ?
2) These 3 rules fall into 2 Types:
- Content: Adult Content Rule, Junk E-Mail Rule
- Exceptions: Exception List
I'm having difficulty interpreting the implementation of the "Exceptions
List" rule. If it represents the exceptions to who or what may use junk or
adult criteria, th...sorts not sorting
OK- Thanks to everyones help I now i have a list i can work with... but
there are a few problems.... the zips are all 5 digit and now i have to
sort them... the problem is, THEY WONT SORT CORRECTLY!!!!!!! The
numbers are not in order... some are but a lot are not... is there
anyway to fix this???? i need to sort them by zip code but cant seem to
get them to do it correctly.. any ideas???
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
You are going to be far better of...Cannot remove Intelligent Message Filter Ver 1 to install EX2K3-Sp2
This is a multi-part message in MIME format.
When trying to install SP2 on Exchange 2003, I got the flag that I =
needed to remove the Intelligent Message Filter before preceeding, no =
problem says I. However, on inspection there is no uninstall. On =
running setup from the Intelligent Message Filter install, in hopes to =
uninstall it from there, I get an unexpected error - code 2755, which =
probably means that it found that it was alread...import- number- sort?
I imported this data into a spread sheet- I tried to format it to number,
but when I sort it- I get :
Whats up with this?
Install the TrimAll macro, select the column and invoke
the macro from Alt+F8
Directions to install and use a macro at
I expect that you have spaces or CHAR(128) "Required Blank"
characters in you data you can check is =LEN(A1)
David...multi criteria filter
If i want to filter a single column to only show A G, J, and P ( i choose
these letters as they cant be lumped together as a range) how would i do
that in a maro or VB
Any tips appreciated
You could do it using Data|Advanced filter using a criteria range.
Record a macro when you do it once and you'll have the code.
Debra Dalgleish has some tips for working with Advanced Filter here:
Another option would be to use a helper column that contains formulas that
return true/false and then filter that column to show the ...Form elements into xml
I've been asked to write a generic function/class to scan
posted forms and generate a xml document as follow:
1. page1.aspx (or asp) posts to process.aspx
2. process.aspx calls a function that scans the form(s)
and generates a xml from elements and values(entered by
user) of the form.
I thought it might be better to ask you guys and you may
know a function or class in the framework that already
does this and put me on the right track.
Thanks for you time
...sorting macro #3
I need to sort on 8 cells in a row and on 1500+rows. I can do it one at a
time but I know there must be an easier way. Can ANYONE HELP?
C3:J3 I need these cells sorted and then down to C1532:J1532
I did create a macro to sort after I selected them but still one at a time.
Does it have to be a macro? I can edit a macro but don't really know how to
Yes, it has to be a macro. The following should do it. This macro loops
through all the entries in Column C, and in each row it sorts the values in
Columns C:J. HTH Otto
Dim rColC As Range
Dim i As...how2: show contact name and phone fields in task list
It would be useful if I could display contact name and
phone number fields in my task list. In Simple View I've
used Field Chooser to insert these columns into the
table .. but alas! the fields are blank. Can I do what I
want to do and .. how?
Any folder view shows only the data in that folder, even though Outlook lets
you think otherwise by allowing you to add fields from different types of
items in the folder. You may be able to accomplish what you want, however,
with a little custom VBA code. For an example, see
Su...Can we sort a form and also be able to enter new records.
It is possible to sort the data on a form and also be able to enter
new and edit the existing records in it.
On Tue, 15 Jan 2008 15:41:16 -0800 (PST), Rex wrote:
> It is possible to sort the data on a form and also be able to enter
> new and edit the existing records in it.
I assume you mean "Is it".
The form sort order has nothing to do with editing or adding new
records, so the answer is yes.
If you cannot edit or add new records, make sure the form's record
source, if it is a query, is updateable. Some queries are not.
O...Sorting checking register
How do i sort my check register in Money 2004 Deluxe so
that uncleared transactions appear below cleared
transactions? In Quicken i could click on the column to
provide that sort.
In microsoft.public.money, Dean wrote:
>How do i sort my check register in Money 2004 Deluxe so
>that uncleared transactions appear below cleared
>transactions? In Quicken i could click on the column to
>provide that sort.
You don't. Available choices are chosen by clicking View at the top
of the register.
...Passing a value from subform or main form to subform query
I am using MS ACCESS 2003
I have a main form and a subform that pulls up an existing case for the user
to update the information already entered. The subform is designed and opens
up in form view not in datasheet view.
The subform knows which case to pull in based on the case number on the main
The textboxes on the main form are bound fields from a query. The user
enters an ID which is how the main form query knows which record to pull and
The textboxes on the subform are bound with data from a different query (so
I have a query for each form)
The que...Supplier List and Sales Report
I am trying to build a report that lists all items for a given supplier, and
then lists sales quantities (including zeros for items not sold) within a
given timeframe. My attempts so far have allowed be to list all items for a
supplier with sales for all time, but the minute I put a timeframe for the
sales in place I lose items that have not been sold from the list.
Does anyone know where I can find such a report or have any suggestions that
would allow me to complete it?
What report did you base it off of? Detailed Sales with a filter on the
Supplier field will giv...using addrress books to sort incoming mail
I use address books to sort incoming mail.
An odd thing: depending on how the sender's name comes across, it doesn't
get caught by the filter (amd moved to the "Family Mail" Folder I have set
up. for example: my mom and dad's email (from firstname.lastname@example.org)
comes as from that address. However, in my contacts, they are listed by
their names: John and Mary Smith, with email@example.com as their
email address and John and Mary Smith as the display name.
What have I done wrong?
1. The big ONE - failed to post your version of Outlook. Rules operate at
...Manager can update membership list check box
Hi, I'm working with W2K3 and E2K3. Is there a way to setup 'Active Directory
Users and Computers' on a workstation so that the check box for 'Manager can
update membership list check box' (Distribution Group, Managed by tab)
So far I can only make that work by remoting into an Exchange server, but
that won't work for administrators, we need them to do this from their
ADUC is probably overkill for just managing distribution group
memberships. Can the manager just manage them through Outlook by selecting