How to delete or permantly change logo in personal settings
When I was just learnng how to do publisher I created a logo and Iwant to
change it in the permanant settings for the personal information. I cannot
delete it or edit it. Also on the other 3 settings for secondary, home etc.
it does not alowany logo at all. Anyone know?
Locate the following files and delete them:
Primary Business - biz1logo.jsp
Secondary Business - biz2logo.jsp
Other Organization - Orglogo.jsp
Home/Family - Perslogo.jsp
Microsoft Publisher MVP
This posting is provided "AS IS" with no warranties, and
confers no ...count between a date range
Hi, I want to be able to count between a date range and return the value yes.
I will show you the formula I currently have:
This gives a yes if the date is greater than the date in M2 minus 365. This
however cincludes all the dates beyond M2 which isnt what I want. I want the
dates upto M2. If that makes sense? Any help would be greatly appreciated
Jacob (MVP - Excel)
> Hi, I want to be able to count be...Help with Dates
I have a table with field name "ConnectionDate".
I want to create a form with ComboBox that will show the "ConnectionDate" as
month and year only.
The value the user will choose will be a criteria for a query.
?Format(Date,"mmyyyy") would return 112007
SELECT Format(ConnectionDate,"mmyyyy") AS ConnectDate FROM SomeTable
Dave Hargis, Microsoft Access MVP
> Hi all,
> I have a table with field name "ConnectionDate".
> I want to create a form with ComboBox tha...Converting Dates from YYMMDD to MMDDYYYY
I'm looking for a format function that will convert a date in the text
format of YYMMDD to text format of MMDDYYYY.
Any help would be GREATLY appreciated!
Thanks in advance!
You can't do it using a Format function, but try:
Function SwitchDateFormat(YYMMDD As String) As String
Dim strDay As String
Dim strMonth As String
Dim strYear As String
If Len(YYMMDD) = 6 Then
strYear = Left$(YYMMDD, 2)
strMonth = Mid$(YYMMDD, 3, 2)
strDay = Right$(YYMMDD, 2)
If strYear < "30" Then
strYear = "19" & strYear
strYear =...Change cell background color based on content that results from li
This could be very simple, but I will lay the groundwork first. I have a
schedule spreadsheet that I import data to from a web based program. There
are existing filters to remove all formatting of the data and remove that
which we do not use. What remains is a non formatted sheet that other
workbooks link to so we can produce daily sheets. Now the data that is
linked on the other sheets may be for example the number 150. It appears
throughout the sheet and I would like to color any cell that contains the
number 150. The problem is I can't search for 150 because it reall...Save a Copy/Overwrite changes dialog box
All of a sudden, this dialog box pops up every time I want to save something
in Excel 2002. The box says,
"The file '<file name>' may have been changed by another user since you last
saved it. In that case, what do you want to do?
__ Save a Copy
__ Overwrite changes
even though I'm the only user that's changed anything in the past 3 years.
The shared workbook command has not been changed at all, so that can't be the
problem. The settings are the same as the ones I have at home for personal
spreadsheets that don't have this dialog box.
Than...How to change GAL from outlook
I posted this to the other group but this might be more
I'm now connected to our domain example.local. Domain
controller is W2K and has Exchange 2000 installed. I have
Outlook 2002 on my XP pro. Address book and mails are
I need change my Outlook to connect to other Exchange
(let's call it E2) outside of our domain. I have managed
to do that but Outlook shows global address book from my
domain instead of E2. I don't need to use old exchange
anymore but there are users that are still connected to
the old one so I cannot...Change the icon on Microsoft apps files?
This is a multi-part message in MIME format.
Can anyone tell me how to change the icon on a Microsoft file/shortcut =
-- for example, an excel spreadsheet or MCE recording?
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META con...how do i change or remove a signiture that is under outo text hea.
Someone please help i am using outlook 2003 and i am triyng to change a
signiture that is under auto text. to get into it i open a message push
insert then outo text then signiture. I want to change it. I have closed the
untilted message gone to tools then options then mail format then signitures
then remove all the signitures but the signiture under insert and outo text
is still there
See if this helps:
"nearly bald with frustration" <nearly bald with
email@example.com> wrote i...Changing default address book from Global to Contacts
I would like to change the Outlook 2000 default of listing
the Global Adress book from our internal network to opening
our shared business contacts when you click the "To:"
button when addressing a new email. Does anybody know how
to accomplish this? Thank you in advance.
Go to Tools > Options > Addressing Tab and choose which Contacts folder to
"Brad Streeeer" <firstname.lastname@example.org> wrote in message
> I would like to change the Outlook 2000 default of listing
&...Getting back a deleted test frame after saving the changes
My son just deleted a text frame with all his work and started a new text
frame and then when asked if he wanted to save his work he clicked yes. Is
there any way to retrieve that missing text frame when it won't allow you to
On Sat, 27 Aug 2005 16:04:01 +0100, Denise wrote
(in article <09056FDE-03FC-4988-8AB0-D1EA0896BFC7@microsoft.com>):
> My son just deleted a text frame with all his work and started a new text
> frame and then when asked if he wanted to save his work he clicked yes. Is
> there any way to retrieve that missing text frame when it won't a...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...changing entry's quickly #4
I have aproximately 5000 entries for product codes. My problem is this:
I need to get rid of the last two digits of each code quickly.
For example: I need to change 0234600 to 02346 is there a simple wa
to do this? It needs to be done in text format because of the zero a
the start of each product.
cj21's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2567
View this thread: http://www.excelforum.com/showthread.php?threadid=39095
...How to change caption on 'apply' button in a CPropertySheet-derived class?
Does anyone know how to change the caption on the 'apply' button in a
I derived a class CPlotSettingsDialog1. Here is it's OnCreate.
int CPlotSettingsDialog1::OnCreate(LPCREATESTRUCT lpCreateStruct)
if (CPropertySheet::OnCreate(lpCreateStruct) == -1)
WindowRect.bottom = WindowRect.bottom + 60;
all the code does is make the bottom of the property sheet a bit longer. It
still has the 3 default buttons.
I need to either re-caption t...columns changed to numbers instead of letters?
I noticed my excel clumns have changed from letters to numbers and
forumlas now look like =RC[-1]*R[-3]C
I was trying to make the R[-3]C static (using the $) but it errors.
In Excel Options uncheck "R1C1 Reference Style"
Gord Dibben MS Excel MVP
On Thu, 28 Oct 2010 20:25:30 -0400, Mike <email@example.com> wrote:
>I noticed my excel clumns have changed from letters to numbers and
>forumlas now look like =RC[-1]*R[-3]C
>I was trying to make the R[-3]C static (using the $) but it errors.
...send email when case notes change?
Is there any way to configure the workflow so that an email can be sent when
the notes of a case have changed?
Shan McArthur - VP, Technology
ADXSTUDIO Inc. | 200 - 1445 Park Street | Regina, SK Canada | S4N 4C5
Tel: 306.569.6502 | Toll-Free: 800.508.7811 ext. 502 | Fax: 306.569.8518
You cannot create a workflow for note.
I think the only way to achive your goal is to write a custom PostUpdate
callout for the Annotation (Note).
You could check if the note is related to the entity of type "case"
(objecttypecode) and only then send some custom e-mail.
...Double Space in notes in contacts.
Sometimes when hitting enter in a contact note field, enter double spaces
instead of single space. Anyway to get it to get it to single space when
...number changes to date ... how do I change
I am trying to do an "age" range:
Instead I get September 9, 2004
or October 19
I can't figure out how to change it.
Please help! Thank you!
Change the type to Text, and it should keep everything the way you want
it. If you don't specify a type, Excel takes a guess based on what you
Hope that helps.
Message posted from http://www.ExcelForum.com/
...No PostUpdate callout when change owner?
I have craeted an audit function but I don't get any post update
callouts when i change the owner of an entity alla other attributes
works fine. How do i get post update callout for owner change?
In the callout config file i use @all to track all attributes.
Changing the owner generates a PostAssign post callout. Just as
changing the state generates a PostState post callout. And deleting a
record generates a PostDelete post callout. etc... (BTW, you can
save a whole lot of time, and purchase an audit solution that will work
for all CRM 3.0 entities, custom fields, and cu...How to change ALL comma in a CEdit into double byte comma?
Hi, I use Visual C++ 4.2.
I've got questions here:
I have to change an application behavior here, there is a CEdit in the
application which receive user input. The change I should make is :
If there is a comma ( , ) character, I must change it into double-byte comma
( usually in Kanji / Japanese writing )
How to change those all comma characters to <space> character?
Thank you very much.
I would make sure the program is compiled to use Unicode.
Then modify the strings to contain the characters you need before adding
them to the edit controls (before call to SetWindowText()...Automatic date/time aquisition for graphs
Ok, I collect particle count data for a cleanroom which looks like th
When I use the following macro, what reference range is being employed that
makes certain decisions for the conversion? For example, when I have a date
of 1/12/46, this converts to January 12, 1946, not January 12, 2046; when I
have a date of 1/14/20, this converts to January 14, 2020, not January 14,
1920; when I have a date of 2/3//10 this converts to February 3, 2010 not
February 3, 1910??? Seems like this was only project so far into the future.
I haven't tried all numbers but once you reach that boundary it assigns the
20th century to any number there and above.
Su...Changing icon for list item
I would like to change the icon for the first column of the list
control in report view. Right now, the method I used is remove the
LVITEM at that location and reinsert at the exact same place with a
different icon. I know this is not efficient compared to directly
changing the icon. I had tried GetItem adn SetItem but even though i
specified a different icon using the index into the imagelist, it still
won't change. Could someone please enblighten me on this? thank you very
> I would like to change the icon for the first column of the list
&...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...Changing barcode type in RMS 1.3
Is there a way to change bar code type for all items all at once?
After importing to RMS 1.3 from QS200 all items show bar code type "none"
What is the best/standard type of bard codes to use.
Hi Robert, You can run the SQL Query to update it what you like: Use SO
Administrator Query option:
Update Item Set Barcodeformat=2
The above no 2 means the 2nd barcode from the list of barcode. so if you
want "codebar" you can put 4.
Please rate this.
> Is there a way to change bar code type for all items all at once?
> After imp...