Rectangle object in Worksheet not amenable to word indenting and Undo problems
Using the Drawing toolbar I drew a rectangle ( not a textbox) in my
I wrote many lines of text in that rectangle like below between the hyphen
lines. I note that when I move to a new line in point number 2 just after
"report will" then using space-bar doesnt move my cursor to right. Due to
that the word "start" lies just below the number "2." in the rectangle. I
want the word "start" to lie below the word "All". How do I indent lines
within the same paragraph in a rectangle? (Using Tab moves my cursor out of
the rectangl...How can I change all the figures on a worksheet by a set %, witho.
taking a guess here as your question was truncated (always best to have a
short subject and put the details in the message) - type the percentage that
you want to increase your figures by (i.e. 110% to raise them by 10%) in a
cell somewhere and copy it, then select all the cells to increase and choose
edit / paste special / multiply and click ok
hope this helps
"magsgoode" <firstname.lastname@example.org> wrote in message
...Problem after Changing the Domain Admin password
After changing the password for the domain admin users cannot log into
outlook but can open WEBMAIL. If i change the admin password back and
restart the the Exhange services everyone can once again log into their
outlook. It is Exchange 2000 on a windows 2000 server. The exchange
services are set to use the local system account. Any suggestions.
...Value Change Event
I would like to know how to make a new event that occurs when a value
in an object changes.
Can you give an example of what you mean? If by "an object" you mean a text
box or other Access control, the control has an AfterUpdate event that you
can use. For ActiveX controls, it's not quite as straight-forward.
Doug Steele, Microsoft Access MVP
(no private e-mails, please)
"Chipcom" <email@example.com> wrote in message
> I would like to know how...Queries about changing date format
I have a table that has a date in it and it also has the time. I need to get
rid of the time and leave the date. What is the best way to do this?
In a query? Just use format to return the date you want.
DateOnly: Format([YourFieldName],"short date")
Hope that helps!
"T Miller" <TMiller@discussions.microsoft.com> wrote in message
>I have a table that has a date in it and it also has the time. I need to
> rid of the time and leave the date. What is the best w...How to Change ITEM Average Cost in GP 10
How to Change ITEM Average Cost in GP 10 - while the feature disappeared from
utility --> Inventory on release 10.0???
Inventory Tile, then from the desktop Utilities->Adjust Cost
Or Microsoft Dynamics GP->Tools->Utilities->Inventory->Adjust Costs
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users
Get our Free Tips and Tricks Newsletter and check out our books at
"Mohamed Salah" wrote:
> How to Change ITEM Average Cost in GP 10 - while the feature disappeared from
> utility ...change address sender outlook 2000
I receive mails from multiple accounts in outlook, most of them using
But I can only use the exchange email address to send emails. Is there a
workaround? (I prefer freeware...)
...Could NOT change mail address after windows server 2003 sp1
Exchange Server 20003 SP1 on Server 2003 Enterprise
After upgrade to Win Server 2003 SP1 only users who are members of Local
Administrators Group (in Exchange 2003 server) can change an email address.
They can create new mail enabled users (with default addresses)
The error message is
An Exchange Server could not be found in the domain
Check if the Microsoft System Attendant service is running on the Exchange
ID no: c10308a2
Microsoft Active Directory - Exchange Extension
What errors do you see in the event logs (specifically the application log
and system log). That sounds rea...is the file exists
Is possible to know (is the file exists)
Is possible to know (If folder exists)
What I want if the code find the file or folder (display message box (the
file exists) else (the file not exists)
Check out the DIR function.
It allows you to pass the name (full path and name) of a file and if it
exists, returns just the name portion (without the path). If it doesn't
exist it returns an empty string.
It also accepts another parameter that allows you to check to see if a
Don''t forget to rate the post if it was helpful!
email address is inva...Large shared excel files
I have an excel file that I use to manage clients. I have 1067
clients. I have 8 people in my department that edit the file. I have
another 200 staff that have read only access to the file.
Most of the time the file is about 1.3 MB in size. However, on
occassion the file gets very slow and swells to about 25 mb. When I
go to "tools" "Shared Workspace" it will show everyone who is
currently signed on to edit the file. Sometimes however, it shows the
same guy on three times. When this happens, the file creates a tmp
file in the directory.
It seems to me that excel ...Stop "attachments of message have changed...do you want to save?"
How do I stop receiving this message for any message for which I have merely
opened an attachment, without making any change to it?
This greatly depends on your version of Outlook and the type of attachment.
For details see;
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins and more
Real World Questions, Real World Answers
"DaveHause" <DaveHause@discussions.microsoft.com> wrote in messag...Remove file Protection from an Excel workbook file from others
I have an older excel file created by someone who is no longer with my
company. I want to use that file as a starting point to created another
file. The file is set up as "read only". If I try to change any of the
cells, I get the message that the "cell or chart is protected and therefore
read only" and further tells me to unprotect before attempting the change.
When I got to tools/protection/Unprotect Sheet I get the request for a
password. I don't know the password as the file was created by another. I
have tried "save as", from tools making sur...file association using MFC
I am in the process of leaning VC++ MFC. I have written a
program wthat will display the complete path for the
selected file name from open dialog box. Now I would like
to associate my program to a file type.. lets say .jpeg
files. When I double click on any .jpeg files I would like
to have may program open and display the complete path.
I know it has to do something with DDE. Can somebody point
me to the right direction.
Thanks for your help
Here is the code
static char BASED_CODE szFilter =
"Image Files (*.jpeg, *.jpg, *....formula to replace cell with over 8 characters with word LAN
I hope someone will be able to help. I need a formula that can check each
cell in column "D" and if it has over 8 characters in the cell, return a
value of the word LAN in column "F". Anything with 8 or under should remain
as is. There will be up to 600 row entries in column "D".
example of col: 799Z
I'm aware that with all the talent and expertise in the group, this is small
potato's, but it is greatly appreciated.
=IF(LE...Linked Excel table
Hope someone can help me. I have weird printing problem that I can'
seem to fix! Here's the story ... I am using Windows XP and Offic
2003. I link excel tables into a word document (paste special/as link)
There is color font in the excel table. The color always appears on th
screen, but disappears when I print it to pdf or printer, *but onl
from certain PC's* Hence, the problem! I've compared the settings o
Word and Excel between the PC that can print the colored text and th
ones that cannot. To no avail. Any help would be appreciated. Thanks,
Message posted f...X and ZZ Reports
I have just upgraded a customer of mine from QuickSell to RMS and I'm having
an issue with X and ZZ reports printing on the register. The customer only
uses 1 register but has license for 2 "just in case". Receipts from
transactions print fine but x and zz reports just say "transaction complete"
on the screen and print nothing.
This is a multi-part message in MIME format.
Have you selected a X-Z report for the recei...Need to insert x number of rows in a list of data
Operating System: Mac OS X 10.6 (Snow Leopard)
Greetings, <br><br>I am trying to insert approx 10 blank rows below each line of data in a spreadsheet. (The extra rows will be used for calculations for each original row.) <br><br>I hope my explanation is sufficient; please let me know if not. <br><br>I suspect my dilemma can be fixed easily, but I have searched online for a number of hours to no avail. Under a previous version of Excel, I could have created a macro to semi-automate this, but have no idea about Excel 2008 ...Change Color Font on E-mail Signature
I want to select a line on E-mail signature to go red.
Even when I copy and past, it comes out black. Help
i dont know your version.
But if you go on your signature under
you could create a red line!
Ich habe nichts gemacht, gestern gings noch!
Bitte in den Newsgroup antworten damit jeder etwas davon hat.
"Ron" <firstname.lastname@example.org> schrieb im Newsbeitrag
> I want to select a line on E-mail signature to go red.
> ...Excell: Column Changes
The Excell program changed the Column labels from alpha characters to numbers. This makes it somewhat difficult to use formulas. Any ideas on how to changes back the numbers to alphabet characters ???
Tools|options|General Tab|Uncheck R1C1 reference style
> The Excell program changed the Column labels from alpha characters to numbers. This makes it somewhat difficult to use formulas. Any ideas on how to changes back the numbers to alphabet characters ???
Tools -- Options. On the View tab, under Settings, uncheck R1C1 style.
And...How to reopen and make changes to a closed contract
I have been reading the blog from ms dynamics team about opening and changing
a closed appointment:
I'm trying to do the same thing with a contract. the code I used is almost
I changed "Appointment" with "Contract" and the state and state Reason:
state code :
see also http://msdn2.microsoft.com/en-us/library/a...file:// links freeze or delay
I have a user with Windows XP and Internet Exp 8. Suddenly, out of the blue,
linked file locations on our internal webpages file://server/subfolder/files
containing pdf's/ instead of opening in an explorer window freeze while
opening a internet explorer 8 window for about 1 minute before then opening
the appropriate explorer window. Other users opening the same location in the
same way get a very brief internet explorer window then almost instantly the
correct explorer window...
It's a new problem on a computer where it was previously working. No new
software installs ...Comma Delimited (CSV) Files
How can I save an excel file as a comma delimited (CSV)
file, BUT still maintain a format that allows for 15-digit
credit card numbers? These usually require special cell
formatting (ie text or number) that get lost when saved as
a CSV file.
My understanding is that saving as CSV saves all formats
as "General." The result is a file that displays credit
card numbers in scientific notation (3.71528E+14)!! This
doesn't work for batch uploading to process credit cards.
What can I do to have a CSV Excel file that actually
displays 15 digits!?
If you just reformat t...I can't remove a watermark in Word 2007, suggestions?
I am having difficulty removing a watermark form a document in Word 2007.
Any suggestions would be appreciated.
Watermarks are anchored to a header. Double-click to activate the header
area; you should then be able to select and delete the watermark.
Microsoft Word MVP
"jdgesq2" <email@example.com> wrote in message
>I am having difficulty removing a watermark form a document in Word 2007.
> Any suggestions would be appreciated.
...Handle to file
What is the best way to obtain HANDLE to file we know the path ??
I am using somethink like that:
CString file = "C:\\app.exe";
handle = FindFirstFile(file,&w32fd);
I need this handle to obtain file size:
Maybe you know better way to obtain HANDLE to file and file size ??
Take a look at CreateFile()
.... Steve C
"phoenix" <firstname.lastname@example.org> wrote in message
> What is the best way to obtain HANDLE...Open a program and program file from Access VBA
OK. First off, I am wanting to know if this can even be DONE :) I am wanting to program a command button on a form to open another application and then run a file pertaining to that application based on the "part number" value in a field on a form. I know that command buttons can be programmed to open applications using the command button wizard. However, (an this is just my train of thought), can VBA take the value from the part number field, then look into a specified folder (or two) and find the file to open? Any help on this is most appreciated. Thanks :) Yes, VBA can tak...