changing report headings names
I would like to give the user the option of changing the report heading
names, I can do this with the Docmd.openreport, stdocname,
acviewdesign,,,achidden and then grab the current heading and display that
heading and allow the user to change it. I then do a docmd.close acreport,
stdocname, acSaveYes, this works just fine when I test but when I compile the
program into a mde it doesn't like the it. Is there another way of doing
this? Thanks for any help.
you can write the current heading names to a table, making sure the table
holds only one record. add the table to the quer...Change of public IP for fighting spam
If I ask my dns registor to change my ip to another public ip. Is this
going to help us fight spam? Is there's a risk of not getting email?
Example old: www.company.com = 22.214.171.124
Examble new: www.company.com = 126.96.36.199
By the way, I noticed that most big companies cannot be ping anymore. Is
this advisable too?
On Thu, 20 Apr 2006 08:06:02 -0700, RickyVene
>If I ask my dns registor to change my ip to another public ip. Is this
>going to help us fight spam? Is there's a ris...How do I change a flyer (word document) into a picture?
I created a flyer and I want to change it into a picture so I can upload it
as a picture on facebook. How do I change the 2007 word document into a
This newsgroup is for Microsoft Project, a planning and scheduling application.
Questions about Microsoft Word, should be published to the Word newsgroup.
To address your question, try using File/Save As... and select type PDF. If
the document must be an image format (such as BMP, JPG, GIG, etc) you will
probably need some screen capture software such as Snag-It or the clipping
tool available with Windows Vista and later.
...Multiple Match and return header
I am trying to find a way to Match on multiple values and return the
header a row based on that. I have tried looking at combinations of
vlookup, match, and index and so far haven't been able to figure out
anything that can do what I need. I have a list of data with a
person's name in the first column, and then headers for an action they
took. Then data in each cell is then the date range they took the
action. here is an example:
Action 1 Action 2 Action 3 Action 4
John 2/3/2005 2/5/2006 5/7/2006 9/25/2006
Bob 1/3/2006 5/3/200...Hyperlink Changed
The local power company had a problem last week. The power nearly went off and
came back rapidly several times. I have a spreadsheet with a lot of hyperlinks
to other files. After the power fluctuations the hyperlinks have the wrong path
names to the files. The file names are all correct, but the path to them are
Is there a way to restore the proper path name in mass, or must I correct each
and every one? The wrong path names are all the same. Does anyone know how this
could have happened in the first place?
...why cant i change font
i select all the text in a textbox and try to apply a font. nothing happens.
that's the case with 4/5 fonts, only a few work. the same appears in both
publisher 2003 and 2007.
Are you creating a web page? Publisher will show 11 or so fonts when you are
creating web pages. To use all the fonts, on the toolbar, Format, Font, uncheck
Show only Web fonts.
If above is not the issue, are you getting an error?
Mary Sauer MVP
"ayudameconpublisher" <firstname.lastname@example.org> wrote in
message news:1BE1262A-A70B-4...Change the Default Language Setting
Is it possible to set the language to 'English (Australia)' so it will be
the default across all office applications? I keep having to change it
manually in outlook at the moment.
...Best way to change style of a table
I have a table I added via VBA like this:
set oTable = ActivePresentation.Slides("mySlide").Shapes.AddTable(...)
I then add some cells to it by:
oTable.Cell(...).Shape.TextFrame.TextRange.Text = "some text"
However, I cannot get a handle on these cells to update the font, fill, etc.
What is the best way to do this?
On Sun, 13 Dec 2009 21:01:01 -0500, Clifton Ivey <clifton ivey
> I have a table I added via VBA like this:
> set oTable = ActivePresentation.Slides("mySlide").Shapes.AddTa..."change order form"
Does anyone have a change order template that I can review?
...changing from outlook 2000 to outlook xp
i just bought a new computer and want to move all my
outlook 2000 personal folders from my old computer--to my
new computer which is running outlook xp. What's the best
way to do this?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After searching google.groups.com and finding no answer
sammy russo <email@example.com> asked:
| i just bought a new computer and want to move all my
| outlook 2000 personal folders from my old computer--to my
| new computer which is runnin...Changing formula in multiple cells or range simultaneously
I am trying to change the value in multiple cells in a
large worksheet simultaneuously. I want to identify the
range and then adjust the formula in the entire range. Is
there a way that I can highlight the range and then change
to formula in each, simultaneously? For example, if I
wanted to double the value in the entire range, how would
I do this?
You could put 2 in an empty cell.
Edit|Paste special|click on Multiply under the operation section.
Then clear out that 2.
But it really depends on what kind of change you're making. If you wanted to
ad...Changing margins on different pages in document templates.
I was wondering how you change the margins for different pages in a template.
Specifically, my firm is using a letterhead for the first page but blank
pages after that so the header and footer margins on the first page ONLY must
be larger than normal, while the following pages are fine with default
settings for the margins. How do you do this and save it as a template?
See http://sbarnhill.mvps.org/WordFAQs/Letterhead.htm, especially the "More
complex letterhead" section.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://wo...Date Changes to 01/00/00 when i enter any date.
Using XL2003, I have a problem. When i enter a date in cell, such as
08/25/10, or use the shortcut Ctrl ;, XL displays 01/00/00 in the
cell instead. I have formatted the cell as a date. What can I do to
fix this problem?
Thank you so much.
...How to change Marketing list member "All members" to "Active membe
How to change Marketing list member "All members" to "Active members" in CRM
Any help is appreciated.
I have used the following code giving object required error
* Change the default view of the Marketing List Members (Account)
if (crmForm.all.createdfromcode.DataValue == 1)
if (crmForm.FormType != 1 && crmForm.FormType != 5 && crmForm.FormType != 6)
...Better support for dynamic content within headers and footers
One of the major limitations that I find there is with Excel is the ability
to display dynamic content within headers and footers. Specifically, without
adding VBA code, there is no way to place anything in the headers/footers
except for static text, the page number, the number of pages, date (in a
standard format), time (in a standard format), file name, sheet name, and
For starters, I would like to see the following new functionality:
- The ability to specify different ways of formatting dates and times. A
good way to do this would be similar to how different formats are ...word doc lost all changes
Operating System: Mac OS X 10.6 (Snow Leopard)
I made lot's of changes to a word doc on Friday, after every few minutes I saved the document. Now that I have opened it again today, it seems to be in it's original format with absolutely no changes. <br><br>Is it possible I could have deleted the saved document rather than the original - but i renamed it with a different version! Can I back up the Mac to Friday evening so that both docs will be there? <br><br>Any other suggestions?? <br><br>Help - please!
Hi Dawn...How do I change reply to or senders address
How do I change the Reply to: email address or the sender’s address? My
infrastructure consists of:
1 – Windows 2003 AD box
1 – Exchange 2003 box
Many – Outlook 2003 email clients.
Is there a way to change the senders email address, example;
An email note that’s generated by joe in the domain test.foo.com
(firstname.lastname@example.org) can this address be changed in some setting in either
Exchange or Outlook, so that the recipient of the note sees the senders
address as email@example.com?
The Outlook clients are configured for an Exchange connection.
On Tue, 1 Mar 2005 11:03:46 -0800, HMR <HMR@discu...rule
There is a nice rule at outlook express so that messages from certain poeple are in different colors. Why there is not such rule at Outlook 2003?
There is and it's even better! See;
Tips of the month:
-Setting Permissions on a Mailbox
-Create an Office XP CD slipstreamed with Service Pack 3
"constantinos" <firstname.lastname@example.org> wrote in message
news:5B1EAC31-909A-4088-97EB-BD6A97A71EC0@microsoft.com.....Change what populates subject line when send pdf report in email
When I choose to send my POP Purchase Order Blank Form to a mail recipient
(pdf), information is populating the subject line and body of my e-mail by
default. Specifically the name of the report is populating the subject line.
Is there a way to change this? I would rather see the PO number populating
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 do not see the button, follow this
link to open the suggest...SMTP header info
How do control the info that goes into the SMTP header on Exchange 2007?
Ours is showing the internal domain name and private IP address
Received: from ex07.xxxxx.corp ([192.168.27.210])
...Outlooks "Incoming mail (POP3)" keeps changing to "local"
Hi everyone, I have a question on Outlook 2000, every few
days my account setting for the "Incoming mail (POP3)"
change from the mail server I have specified to "local"
and the mailServer then gets added to the "Account
Any ideas on why is it doing this, and can I stop it from
doing this, cause each time it does, I have to manually
change it back to original setting so I can get my mail.
This is your antivirus software, most likely (or antispam software). Outlook
doesn't do this. Check with the mfr. to see if they have an...Shared Files using Pre-compiled headers
I have a file shared by multiple projects/solutions that uses pre-compiled headers. The plan was use something like this in the shared .cpp file:
This idea could be extend for more projects. The problem is that the compiler reports "unexpected '#else'" (or #elif or #endif depending on what preprocessor directive follows the "include "stdafx"". I have tried searches on the problem, but it isn't easy to boil down into a ...Cell change on User Click
Is it possible to have a cell change to a default value when a use
clicks on it?
I have an old sheet I am working on that people put in manual "X" in t
select options. Most of the sheet uses these X's to calulate option
and such and I would rather not rewrite the entire spread.
Any help would be appreciated.
Message posted from http://www.ExcelForum.com
> *Is it possible to have a cell change to a default value when a use
> clicks on it?
> I have an old sheet I am working on that people put in manual "X" i
> to select option...Pie of Pie
I've made a Pie of Pie chart and want to change the name of the wedge that
get broken out from "other" to "Agency".
Manually you can select the data labels and then select the specific
label and edit its text.
> I've made a Pie of Pie chart and want to change the name of the wedge that
> get broken out from "other" to "Agency".
Andy Pope, Microsoft MVP - Excel
...Changing References Inadvertently
This is a multi-part message in MIME format.
A friend has an Excel workbook that contains one overall summary =
worksheet, and about 20 individual worksheets that each pull data from =
the overall summary sheet. She asked me to help troubleshoot some =
problems that she was having.
What I found was that some of the 3D references had changed. Instead of =
looking from the individual sheet to the summary worksheet in the =
current workbook, the ...