I keep getting and error on start of Office x.v
I just purchased Office X.v and installed it onto my Mac. I also
removed Office Test Drive before installing the full Office X.v, but i
didn't empty my trash. So after I installed the full version i keep
getting the error "An unexpected error occurred while trying to load
Microsoft Framework X library" on all office programs. I read on
mactopia that this could be caused by "lock" identities in the
microsoft identity file, but all of mine are unlocked. When i tried
to empty my trash, it would not empty a few microsoft file because it
says they are in use. Framework ...How do I get an item's rank?
Let's say I have 10 merchants selling the same product at different prices.
How do I get a vendor's ranking?
I'd be passing the stored procedure ProductID and VendorID. And the data
comes from a table with three columns ProductID, VendorID, Price where the
Price field is smallmoney.
With RankedVendors As
(Select ProductID, VendorID, Price,
Row_Number() Over (Order By Price) As Rank
Where ProductID = <product you are looking for>)
Select ProductID, VendorID, Price, Rank
...hyperlink open in new window
How do you create a hyperlink and have it open in a new window?
David Bartosik - MS MVP
for Publisher help:
enter to win Pub 2003:
"sharin" <firstname.lastname@example.org> wrote in message
> How do you create a hyperlink and have it open in a new window?
...Button/Macro Not Working, Help!
I have a macro that pulls up Report Manager and prints out pre-define
views. The macro works fine only after I use Report Manager the firs
time. If I exit my workbook and Excel, then return to it, th
button/macro does not function. Nothing happens until I manully us
Report Manager again. Is there a bug with this or am I missin
Message posted from http://www.ExcelForum.com
Post your code.
Gord Dibben Excel MVP
On Thu, 20 May 2004 08:38:55 -0500, baston
>I have a macro that pulls up Report Manager and prints out pre...mailboxes are getting larger on Exchange Server
I ve a problem in my exchange server 2003.
* The mailboxes are getting larger and although i m delvering the mails to
*Many mailboxes shows that they r above the limit "mailbox disabled" .... i
using a quata for the mailboxes. and by browsing the mailbox i dont c any
thing in the mail box from the user's side ... the only solution is to
expand the its quota then
it returns to normale stauts
Note: I m taking backup every day "the normal backup size was 17 GB after
that its 65 GB"
*It only took one day to get to the 65...Outlook does not open all of a sudden
I have Office 2007 Business
I cannot open Outlook all of a sudden.
I get a message that The Outlook Folders cannot be opened, that the server
is not available (?).
I run Microsoft Office Diagnostic with no apparent problems,
I tried to fix , to uninstall and reinstall.
All other programs ( Excel, Word, power point, etc) are working fine.
Can anybody give me a suggestion before I get another hard disk and
What is the exact error message? Paraphrasing does not help.
Have you tried a new mail profile?
Milly Staples [MVP - Outlook]
Post all replies to the grou...Dotnet Lead Engineers opening in Pune
We are Bangalore based leading HR consulting company retained by top
IT companies like SAP Labs, TCS, i-Gate, AztecSoft, GE, Symphony
Services, HCL to hunt talent.
Excellent opening for Lead Engineers at AT CMM Level-5 & Largest IT
Company for their Pune ODC.
3) SQL Programming
4) Must have strong experience on ASP/VB script and good exposure to
5) Should have min two years experience in Classic ASP/VB script and
min one year experience on ASP.NET
6) Should be willing to work on classic ASP development
7) Good knowledge of MS Sql server, H...Opening tab-delimited files in Excel... how to stop the autoformat of dates?
I'm doing bioinformatics work in which I often download tab-delimited
files describing genomes and open them in Excel. Unfortunately, Excel
decides that genes with names like APR1 and SEP7 are actually dates,
and reformats them as such. This is a huge headache, as I often don't
notice these problems until much later.
Is there anyway to completely disable this date autoformatting? I've
searched high and low and have yet to find a solution.
P.S. I'm using Excel 2002
sa...How do I delete a text box from an Excel spreadsheet?
Rightclick on it and select cut
If the textbox is from the control toolbox toolbar, you may have to click on the
designmode icon first.
Uncle Binky wrote:
...Access ODBC problem: Excel cannot get float columns
I need some help
I'm trying to get Access external data from an Excel workbook, using
the MS Query feature.
Everything is ok except when I try to fetch some tables that ODBC
refuses to get data from. The error message tells that the MS Access
ODBC driver doesn't allow some columns to be transmited because of its
number of characters.
The most strange thing is that I can see the data from MS Query
correctly, but I caannot get it back from Excel.
After some tries, I thing it occurs only with real typed columns.
Can anybody help me?
I use Windows XP Home + Office 2000 spanish versio...Create form similar to MS Access 2000 Help
Is it possible to create a form that works similar to the Help - Index form
in Access 2000?
My StreetTable consists of the following fields: Street_ID(autonumber),
I want to be able to type the beginning letters of the street and the List
continually reduces until I see the street I need in the StreetNames window.
I would then
click on that street and the Directions would appear in the third window
Since I'm dealing with approx. 5000 streets, scrolling really isn't an
option that I want to consider.
I found that a combo ...can't get scrollbar to come up -- CScrollView
I am new to MFC and I am trying to get a simple app working with a
scrollable view. I have put in the call to SetScrollSizes in the
OnInitialUpdate method. I'm still not quite sure what sizeTotal is supposed
to do. I just gave it a value of 5 for the y for now, which I think I want
to set to the number of lines of text I have to display. And then I set y
int numLines = 5;
sizeTotal.cy = numLines;
sizeTotal.cx = 50;
In the OnDraw method, I put in code to draw my text on the view using the
device context. The text get...How do I get special symbols for correct sign?
...how to get a fixed window with caption?
which is the best way to get a window (dialog box) with captionbar but no
posibility for the user to move the window?
Try overriding the WM_WINDOWPOSCHANGING message to prevent
the move before it happens.
>which is the best way to get a window (dialog box) with
captionbar but no
>posibility for the user to move the window?
...Newbie: can't get a calculated value on the form?
I have a table with numbers and a form that shows the numbers. I have
a query that takes one of the numbers and mulitplies it. I put a text
box on the form from the query result field, but I get a "#Name" error
instead of the result. When I run the query, I get the correct
"Ed from AZ" <email@example.com> wrote in message
>I have a table with numbers and a form that shows the numbers. I have
> a query that takes one of the numbers and mulitplies it. I p...Outlook attachment problems
Our oversea office sender using Outlook Sending message (HTML) insert a
picture sending message to my office, when I have received the attachment
auto duplicate one set in the message.
I have asked the sender try remove the picture and FORWARD to my e-mail,
but the attachment sill in the message and auto duplicate one set
Out overseas office using MS SBS , user setup WG mode for outlook
I am not sure which part problems or virus effect. Please advice how to
solve out the problems ASAP.
...HELP: Excel userform version control issue
I have an excel userform that is posted on my companys intranet. The issue I
am having is, users are saving this form to their hard drive and then using
it(Instead of launching it everytime from intranet), SO basically when I
have a new version of form on intranet they still use the old version as they
have a habbit of saving it on their hard drive.
Is there a way to resove this? something like they would see a popup message
saying that "This is an older version that you are using, Please launch the
form from Intranet for newer version".
Thanks in advan...Open document from previous version
How do I open a document from a previous version of
Publisher..I have 2000?
Are you certain it is an earlier version? Do you have Norton? Disable "script
blocking" and try again.
Mary Sauer MS MVP
"Jan" <firstname.lastname@example.org> wrote in message
> How do I open a document from a previous version of
> Publisher..I have 2000?
> How do I open a document from a previous version of
> Publisher..I have 2000?
If it ...Help with
I am currently in the process of migrating exchange 2000 to exchange 2003 on
I have transfered the RUS role, offline address book role and replicated the
public folders ect. and now am beginning to move maiboxes. I noticed 3 very
repetive errors in the application event log however. I was wondering if
someone could tell me whether these messages are somthing I should be
concerned with. See them below. So far I have no user complaints about
Event ID: 9320
Description OALGen could not generate full details for some en...Help with Inbox repair tool please
I have a problem with my outlook 2000 and have been advised to use the inbox
I have opened the inbox repair tool, and I am asked to enter the folder name
or to browse and enter the location of the folder, I need to enter the
delete items folder but do not know where to find it.
Any help appreciated.
The Inbox Repair Tool works against Personal Folders Files (.PST files), not
against individual folders within the .PST file. If you don't know where
your .PST file is located, you can find it this way:
In Outlook, make sure the Folder List is visible (View | Folder...Change opening postion /Form
From my Main Form I have a control that open a smaller form overtop of main
Form, It always opens in the middle of my Main Form, can I reposition it to
open higher on my Main Form,
Thanks for any Help.....Bob
On Mon, 6 Aug 2007 11:13:29 +1200, Bob V wrote:
> From my Main Form I have a control that open a smaller form overtop of main
> Form, It always opens in the middle of my Main Form, can I reposition it to
> open higher on my Main Form,
> Thanks for any Help.....Bob
Look up the MoveSize method in VBA help.
DoCmd.MoveSize 2 *1440, 3 * 1440
will position a form 2 inch...VBA code to hide all the tables on form open
I don't want people to use a blank mdb to import my tables. I manually hide
them all. However, after running the macro to delete all records and import
from .txt, the table become unhide. I do the importation on daily basis.
I posted to macro newsgroup and asked way to hide table after importation
action macro but got no answer. Maybe it cannot be done in macro?
If so, I need VBA code to hide all the tables on form open. Thanks.
Hiding your tables won't prevent people from being able to import them into
a blank mdb. All they have to do is ensure that they've set the datab...Help; how do i change the waiting circle (in IE tab) to anything e
I am making a website and i have a lot of wait time for my server-side pages
to do their work.
The waiting circle icon gives me a headache so I would like to change that
to something else please.
I remember IE6 had a great Microsoft Flag logo that would wave while a page
would load. Could I get IE8 to use this logo?
Sorry Trozza, you can't.
"Trozza Mited" <Trozza Mited@discussions.microsoft.com> wrote in message
> I am making a website and i have a lot of wait time for my server-side
> p...emailing spreadsheet within excel
I have a user that has sent her spreadsheet as an
attachment using the Send To Function. We use Outlook.
Now, it seems as if the Send To option has lost its
settings and is now trying to set up an Internet account
instead of using the Microsoft Exchange Settings. Anyone
know how to reset the Send To settings in Excel?
...Help With Problem: Nested IF Function, Office2K v Office2003
I'm looking for some help with a nested IF worksheet function. Shown
below is a formula that I'm using in a model.
If short, what I'm trying to do is scan the data in two columns and for
any cells which meet the TRUE case in both columns, then sum the third
numbers for all cases returning TRUE-TRUE. If either cell returns a
FALSE, then enter 0.
I created the original formulas and model in Office2000 and have used
the model for more tha...