Select Names dialog hangs after large mailing
I am working with Outlook 2002 on Windows XP with a local
Exchange 2000 server running on a 2000 SBS machine.
I have a number of address books (approaching 100) under
my primary contact list. They are actual full address
books, and not groups, as they are imported from another
program as such. Each list has from 2 to 100 contacts,
and they are all enabled to be shown as email address
books, so that they appear individually in my "Select
Names" dialog when I click on TO: or CC: in a new
All of the lists come up properly when first opening
Outlook, and I am ab...Macro to lock project from viewing
I'm looking for a macro to insert into my project to automatically
password protect and lock a project from viewing instead of manually
doing the following:
-->Going into the VBA Project (view code)
-->VBA Project Properties
--> Protection Tab
-->Lock Project for Viewing
Can anyone help with this?
...dupliates name in a query
I have created a query from a table for my employee data base, the
query is dupilicating the names.
The name only exits once in the table but i can see a name that exits
3 or 4 times in the query.
On Sat, 28 Nov 2009 11:45:48 -0800 (PST), Tia <email@example.com>
>I have created a query from a table for my employee data base, the
>query is dupilicating the names.
>The name only exits once in the table but i can see a name that exits
>3 or 4 times in the query.
Please he...Change from default print changes font in Document
I need help figuring out how to change this, I have noticed that the font
and spacing of content gets messed up when printing Word 2007 documents.
I have a temporary work around by switching to my default printer then to
the printer I want to print to, to get the font back to what it originally
But is there some feature in Word I should check or something to permanently
Restarting Windows and then deleting any left-over temporary files might
help. Also, you may want to look for an updated printer driver.
Microsoft Word ...Insert Row macro not working
I have the following macro set up but it keeps hanging up on the first
' Insertrow Macro
' Macro recorded 10/6/2005 by DCTC
' Keyboard Shortcut: Ctrl+i
Dim iLastRow As Long
Dim i As Long
iLastRow = ActiveSheet.Cells(Rows.Count, "F").End(x1Up).Row
For i = iLastRow To 1 Step -1
If Cells(i, "F").Value = "Total" Then
Rows(i + 1).EntireRow.Insert
a cursory look suggests you need to change 1 to l
firstname.lastname@example.org...Graphical problems with forms in AC 2007
I have an Access application which I run both on AC 2003 and AC 2007.
It works OK on AC 2003, but on AC 2007 the forms get sometime "garbled".
Please see here:
http://www.caspit.biz/images/03062010_025718.jpg -- OK
http://www.caspit.biz/images/03062010_025833.jpg -- "Garbled"
dror at caspit dot biz
There is an extra space at the end of the second link. Here is the correct
Does anyone have a solution to bulk changes of the msExchMasterAccountSID
KB 278966 and KB 319047 contain information about disabled accounts being
unable to receive emails. There are a number of reasons that you would want a
disabled account to get mail.
Both article used to say if you have a few accounts you need to fix add SELF
with Associated External Account permission. If you many accounts you need to
change use ldifde to export a list of the accounts, modify the result file,
and then use ldifde to import the changes.
However both articles now say "For additiona...Difference between the active project and Open Project ?
"Calculation Mode Choosing Automatic specifies that a project�s
variables should be calculated automatically (as soon as a change is
made). When set to Manual, you will be forced to click the Calculate Now
button (also shown in Figure 4-60) to recalculate your project. A couple
of shortcut keys are tied to manual calculation. To recalculate all
*open projects*, press F9. To recalculate just the *active project*,
Could you tell me, what is the difference between the active project
and Open Project ?
I would like for a word document to scroll to the page with the most recent
change OR comment when it opens. Is there some VB code for this?
Not unless you write something to record something first, perhaps a
"with the most recent change"
Word does not store this information. It has no idea where the most recent
"comment when it opens"
>I would like for a word document to scroll to the page with the most recent
>change OR comment when it opens. Is there some VB cod...Microsoft Money 2007 Deluxe stops downloading from citi cards server.
From early Dec, my MOney 2007 deluxe stop downloading from Citi Card
Server afte rciti upgrade their website.
NOw it shows OFXIE12152 messge
The error code is OFXIE12152. It is server error according to MS
#define ERROR_HTTP_INVALID_SERVER_RESPONSE 12152
I contact Money and it told me it is citi problem and of course citi
is saying it is not their problem either.
The weird thing is that my wife's citi account works on the same
computer and in the same money file. The only difference is that...Changing Font in cells
I would like to know how to make a superscript number... i think i forgot how.
Assume you have the number 12345 in cell A1. Put your curser in cell A1.
You should see 12345 in the formula bar. Go to the formula bar and highlight
or select 1. Go to the standard toolbar and select Format -> Cells ->
Effects -> Superscript.
> I would like to know how to make a superscript number... i think i forgot how.
Just to add to John's reply....
This formatting will only work with text entries...How to add command bar button when DB opens in Access 2007 runtime
Have searched around but not found an explicit code example of how to do this
in code in Access 2007 ...
I have very simple Access app that I package and distribute using Access
I need to display the command bar button for "Filter By Selection" when a
Is this possible with runtime?
If so, could someone provide a code snippet I could use to display the button?
Have not had much success using VB Help or MSDN.
OK, I now have this figured out.
This helped a lot ...
http://msdn.microsoft.com/en-us/library/bb1...urgent requirement for project leader
hi partners, we are having a urgent requirement for one of our client
cmmi level5 company in hyd if u intrested Kindly mail your responses
Project Lead - JAVA / ORACLE
Through understanding and expertise in the various phases of SDLC
(Right from Requirement Analysis to Deployment).
Programming - Core Java and J2EE technologies (JSP and Servlets),
Junit testing frameworks, Scripting in languages like PERL, Database
programming (SQL, PLSQL, JDBC)
Development under environments like Eclipse/JBuilder on Unix/Linux
Design/support of hig...pleading paper not printing correctly from office 2007.
I am having an issue with printing pleading paper correctly out of offfice
Now that 2007 has been installed the pleading paper is not printing out
correctly. There is an lawfirms logo and address and phone info running
verticlally on the left hand side that looks just fine when you open it or do
a print preview yet when you actually print it, the info on the left hand
side seems to be overlapping. The logo is covering the address and phone
number. if I open the exact same document in word 2003 it looks the same but
when you print it out it comes out just fine.
any...Convert DPM 2007 Eval to Fully Licensed
I have Data Protection Manager 2007 Version 2.0.8793.0 (Evaluation Version)
installed. I purchased licenses but have been unable to register them becuase
of the "Update DPM licenses.." link is unavialable or greyed out. I have
tried installing the full version on top of the existing eval but it gives me
the you are running a newer version erro and does not give me an upgrade
option like this link says:
I have several agents installed and don't want to start over. Any
suggestions on how to convert from eval ...Macro from 2003 to 2007
I set up several macros on a number of buttons in XL2003, works fine, within
a workbook. Part of the function is to creat a copy of a couple of tabs in
another workbook, which is smaller and easier to e-mail.
However in 2007, once a macro has run, the button(s) then refer to the
macro(s) as if it was in the new workbook, when this patently is not the case.
Getting to wits end
...I want average to change as per the filter is added in the sheet
I have a Sheet in which i have 12 columns containing text Values, and 4
columns having numeric values. I have to calculate the average of the 4
columns of the numeric values. I want the average to be displayed as per I
add the filter to the 12 text values columns randomly. Can U help me out. I
am willing to send you the Sheet so you can have a better Idea.
Look up SUBTOTAL function in help
will average filtered values in A1:A100
will average filtered and hidden values (2003 onwards)
I do not want closed projects to display in the list of project in the
Project Maintenance window. I have looked and cannot find a setting that
would eliminate these projects. Does anyone have VBA code that will
eliminate these projects from the lookup window. I also need the same thing
for closed contracts.
Have you tried making "Do Not Show" for the closed contract status
The 'do not show' only work for transactions. I do not want to see them when
I ...Disable Minimize/Maximize button for Excel 2007 Application
I am trying to prevent a workbook I made from being minimized/maximized by
the user. I have command buttons to do that and I want to force them to use
the command buttons. The code below disables the min/max application buttons
in Excel 2003, but it only disables the close button in Excel 2007. It also
disables dragging to resize the application window in 2007, but that doesn't
help me. I need to disable the min/max button and it needs to work in Excel
2007. Any suggestions?
Public Declare Function FindWindow Lib "user32" Alias "FindWindowA&...Sorting a view by letter
In the view, that displays a list of orders, I click one of the letters in
I want to show only orders, where the CUSTOMER NAME begins with that
specific letter. However, my result is orders, where the SUBJECT/DESCRIPTION
begins with that letter (The view is still sorted by Customer though, just
like I've set it in the settings). I find this behaviour very strange.
Is there an easy way to deal with this problem?
...Change date format for existing sheet? (XL2K+XL2003)
Don't know if this will be the right group for this.
I have some spreadsheets that I must chart but the date formats are
not the best.
The sheet has the months like this:
April 1 to 30
May 1 to 31
June 1 to 30
July 1 to 31
August 1 to 31
September1 to 30
October 1 to 31
November1 to 30
December 1 to 31
January 1 to 31
February 1 to 28
March 1 to 31
When I will need the smallest yet most complete info so that if I
could convert the above quickly to format below, that would be best:
No...Treat Inventory item purchase for a Project through POP like drop.
Now, the item is received into inventory when the Purchase Order is received
upon-leaving it available for any other sale. An inventory adjustment is
required to actually assign the item to the project. The purchase of
inventory item for a project through POP should be treated similar to a
drop-ship purchase - not run through inventory.
Jeff Burns, CPA
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you...How to change number to text
This is a multi-part message in MIME format.
How can I change the numeric into text
to One Thousand two hundred and thirty four
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META http-equiv=3DContent-Type content=3D&q...Copy A Dialog from Project to Project
Sometimes I do this but I get all sorts of errors. I know I need to move
the .cpp & .h that go with the dialog, to the new project but I'm not sure
what the procedure is for doing this. I seem to get all sorts of errors
such as ....
enum( ID = IDD_Dialog).
Is there a magic way of importing a dialog (and it's Class) from one project
There are serious issues about the resource.h file. You can't just copy the .cpp and .h
files, because without PIECES of the resource.h file, they aren't going to be valid.
Why would you have a dialog w...Outlook 2003 Cached Exchange Mode Does Not Work with Terminal Server
I want to enable Cached Exchange Mode with Outlook 2003 on
my Windows 2003 Terminal Server and I found out the option
is grey out.
I then found out if I login on the console of Win2003
server, then I can enable the Cached Exchange Mode. The
main purpose to do so is for Junk E-Mail Filter feature in
Outlook 2003 which I found work very well.
While the Cached Exchage Mode work well on the Windows
2003 Server console, whenever I connect through Terminal
Service (Remote Desktop), the Outlook 2003 switch to on-
line mode automatically. Anybody knows anything about
this problem? Any sol...