Can I fade the edges of photos that I use?
I am trying to use photos in a publisher document that I want to fade the
edges of, is this possible to do with publisher?
> I am trying to use photos in a publisher document that I want to fade the
> edges of, is this possible to do with publisher?
Not really. You should use dedicated image manipulation software for
this, such as Photoshop Elements, Paint Shop Pro, or Microsoft Digital
Ed Bennett - MVP Microsoft Publisher
Are any of these programs typically come loaded on a computer?? I have
another question - ca...Can I delete my switchboard and make a new one?
I do not like my switchboard and would like to delete this one and start all over. But when I did delete it I couldn't make another one, because I couldn't delete the default. What should I do?Thanks,Dustin Just delete the form and the table that were created by the wizard, then start over.-- Rick B"Dustin" <Dustin@discussions.microsoft.com> wrote in message news:42F94A44-9352-4D02-9104-65593869B271@microsoft.com...>I do not like my switchboard and would like to delete this one and start >all> over. But when I did delete it I couldn't make another one, beca...Using different form strings to filter
Hello. Is there a way to code a query to have it use a filter string
if a form is open, or ignore it if the filter is not open?
Query Name: Query1
Form: Form1 and Form2
Query fields: Field1 and Field2
I have a string in field 1 and 2
Forms!Form1!Field1 in the first field of the query, and Forms!Form1!
Field2 in the second field. Can I also have Forms!Form2!Field1 in the
query as well? I have tried this, but a box pops up and asks for the
information from form 2 when it is not open.
> Hello. Is there a way to code a query to...Wrapping text in a cell
In a single cell, suppose I want text to appear on two lines. Viz:
How do I do that so that I specify the wrap point?
If you are typing the data into the cell use Alt-Enter between each
string to indicate where you want a line break to occur.
Case One<Alt-Enter>Case Two
Alt + Enter
Lilliabeth's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27741
View this thread: http://www.excelforum.com/showthread.php?threadid=476428
If you...Locking Formulas to Cells
I don't know if I am using the correct terminology but this is what
want to do: I have placed formulas in multiple columns that calculat
my sales numbers for a bid. The problem I am running into is that
change the bids for every person and when I clear a cell is clears th
formula from it as well. Is there a way for me to clear cells withou
deleting the formula I have placed inside it? I know that I can jus
grab the first cell in the column and drag it down to re-load th
formula in that column but I don't want to have to do that. I want th
formulas permenant and the data I enter...How do I add a hyperlink to an individual word in an Excel cell?
I am using Excel 2000 (not by choice) and I need to add a hyperlink to an
individual word within the cell, not the whole cell itself. For example in
the sentence "Click here or here to go to the appropriate web page." I want
the words "here" to each have a separate hyperlink.
Any ideas? I can manage some VBA too if necessary.
You can't do that in Excel.
You would have to use HTML or Word or some other means.
You could fake it, the entire cell would be a link, but you could
after assigning the hyperlink select another...how can I drag formulas with other cell references
cell A1 contains formula "=stdev(a2:a7)
cell a2 contains formula "=stdev(a8:a13)
Is it possible to drag the formula down so that cell a3 contains
"=stdev(a14:19) and cell a4 contains "=stdev(a20:a25) and so on for cells a5,
a6, a7 etc. etc.
It was easier to test and verify using SUM instead of stdev, but the formula is same
NOTE the formulas are in a different colu...Cell Selection?
I have a colum of numbers
What I need, is to be able to select 3. the 198's are not going to be used
in the next part of my equation. That seems simple enough, however all the
numbers could be usable (not 198) and I need to use just the first three. Any
One interp / way, using non-array formulas
Assuming source numbers in A1 down
In B1: =IF(COUNT($C$1:C1)>3,"",C1)
In D1: =IF(A1="","",IF(A1=198,"",ROW()))
Select B1:D...can i have more sender in outlook setting ?
i using win server 2003 , exchange 2003 , i using exchange client in outlook
to send & receive , but my boss have more than one mail address , can i use
another AD mail address for send out mail , i have try to add a pop3 , the
sender also is computer user
...Formulas don't work in certain cells #2
nope, the cells are formatted as numbers. I simply cannot figure thi
kalik247's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1594
View this thread: http://www.excelforum.com/showthread.php?threadid=27423
Being formatted as numbers doesn't automatically mean they are numbers.
Copy an empty cell formatted to General.
Select your range of numbers and Paste Special>Add>OK>Esc
Gord Dibben Excel MVP
On Mon, 1 Nov 2004 11:59:46 -0600, kalik247
<kalik2...IE8 can't access Microsoft Office site when all other browsers can
When trying to access the Microsoft Office page using IE8 I keep getting the
"Internet Explorer cannot display the webpage" message. If I use any other
browser (Firefox, Opera, Safari, Chrome) I have no problem accessing the
page. This happens whether running in normal or No Add-on's mode. Despite how
many people keep complaining about all the problems with IE8, neither the
MVP's or Microsoft acknowledge that they exist.
Intel E8400 Core2Duo 3.0GHz
4 GB PC2-6400 DDR2
Windows 7 Ultimate (with all the latest updates installed)
NIS 2010 (all up to date)...I can't get rid of 1 "Payment to Send' Reminder-M07
On my Home Page in the Reminder section, I have a "1 Payment to Send"
listed there. But there is NO payment to send. I"ve opened up back-up
copies as far back as May and the reminder is there, but there is no
payment that needs sending. Does anybody have an idea how I can get rid
of this Reminder?
Just removing the Reminder from Home Page doesn't do it. When you put
the Reminder back on the Home Page, the "Payment to Send" is still
there. Clicking on the link just takes me to Bill Summary page.
...MapQuest Buitton on Form
Arvin: Hope you see this post.
Mapquest must have changed their code. My Mapquest button on the form does
not work anymore. The reason is that in Canadian Postal Codes there is a
space (ie. E3A 3N7). My data is stored this way. Mapquest used to accept this
format but not anymore. How do I delete the space in the hyperlink created
from the event on click (button on Form).
Your help would be greatly appreciated again. Here is my code.
Private Sub cmdHyperlink_Click()
Dim strPath As String
If Not IsNull(Me.Postal_Code) Then
strPath = "http://www.mapquest.com/maps/" &a...is there any way I can trap for the use of navigation buttons?
Is there any way I can trap for the use of navigation buttons, such as
Next, Previous and New record?
Probably. Trap what and when?
"Stapes" <email@example.com> wrote in message
> Is there any way I can trap for the use of navigation buttons, such as
> Next, Previous and New record?
On Wed, 16 Jan 2008 05:14:20 -0800 (PST), Stapes
No. And there shouldn't be a reason for that. There are plenty of
events in...Close a form when it loses focus
Is it possible to make a form close as soon as the user clicks elsewhere on
the screen? The form in question is a trivial popup form that is best shown
in datasheet view, so I can't add a button. I know the user could close it
with the 'X' in the top-right corner, but for other reasons it would be much
better if I could force it to close as soon as they click elsewhere. I have
tried adding the following OnLostFocus event to the form, but nothing
DoCmd.Close acForm, "[frm contacts]", acSaveYes
Second question (or does this need to be in a...Forcing Input as Uppercase on User Form
can any one advise me how to amend the following code to ensure :-
(a) only two letters are input
(b) they are converted to upper case
(c) how do you centre the text in a message box header as I have use
spaces to achieve this
inputVal = TextBox1
Do Until ActiveCell = inputVal
If ActiveCell = "" Then
MsgBox ("Sorry Not Found - Please Input the first two letter
only e.g. RG ") ", vbInformation, "
Warning !! "
Excel v...how can I look into store.exe
I have an email sobig that i cant even download it on my
outlook express 6.0....
The adviced for is to locate it on the Queues in Outbound
or inbound messages on IMC, but if it is not in there the
message may be stuck up in Store.
How can I locate it and delete the massega in store.exe
they say I can use the MFCmapi but i'm a newbie how can
do this. Do I have to download the MFCMapi? what is it?
...can't change/delete bills and deposits
suddenly one day i realized that when i tried to change a
bill, i could click "ok" but nothing would happen. I
thought it was because i upgraded to 2004, so i deleted
the bills and rescheduled. about 5 of the bills will not
delete either. the error message is: "Money could not
write to your Money file. The operation could not be
performed or another application finished this task before
you. Please try again."
Now some of the newly scheduled bills will not allow me to
change the properties, i click ok but nothing happens when
i edit the series.
I have repaired ...Can't Install IBF for CRM on CRM Server
first i'm install IBF On my CRM v1.2 (it's name testcrm)
after that i'm try to install IBF for CRM on my CRM Server
but in Step "Publish Metadata" i'm type "http://testcrm:8082" and click
but it's show message box "The Information Bridge metadata service
location is not avaliable" and can't install it.
-_-' . but i can access "http://testcrm:8082/IBFWriteService.asmx" and
"http://testcrm:8081/IBFReadService.asmx". so how can i install it ?
I had the same problem - try using http://localhost:8082 for...Can Work thread get a windows class and manipulate it?
Suppose that I create a work thread when my dialog box started, then in the
thread I get the pointer to the dialog mfc class and call updateData method.
Does that work? I tried, but failed.
Is there any other way to do? thanks!!
No, it won't work, don't even waste time trying. It is almost guaranteed to fail. You do
not manipulate the windows owned by one thread from a different thread. What you do is
PostMessage requests from the worker thread to the main UI thread, usually to the window
that contains the controls.
The fact that you are using UpdateData already says you are in t...if cell in other worksheet meets criteria, then leave blank.
I have data in worksheet A for each month, for each entity. Then I have a
summary page which shows just the averages for each entity for each month.
Then I need to create a master summary page which shows just the annual
average for each entity, just one line per entity.
My Summary page shows Jan-Dec in column A. I have a formula averaging the
numbers from worksheet A. Jan-Mar is done. But the rest of the year hasn't
happened yet, so April's formula results "#DIV/0!". I have already put in
all the formulas for the year to be done with it. But I don'...Form with desktop shortcut
I created a form which displays one record. The record is chosen at random
by a query. It works fine within Access 2003. However, when I create a
shortcut to the form on my desktop and run it that way, it always gives me
the same record. How can I get the random record I'm looking for?
I'd say you're probably better off creating a macro that opens the form at
the required record. Your desktop shortcut should call this macro, rather
than the form.
Graham R Seach
Microsoft Access MVP
"CindyLu" <CindyLu@discus...Subform doesn't work once added to main form
I've been searching around looking for some help and can't find anyone
that has had quite the same problem.
I have a main form called 'Sites' and have added a subform called
'Previous Year Flows' into the main form. I do not enter data into
this subform. Instead, data on previous years is drawn through from a
table called prev yr flows into this subform. When I open the subform
on its own it draws through all the necessary data, but when it is
embedded within the main form, none of the actual data is pulled
through at all, although the linked fields, Site ID and A...Why can't I send email messages with Trial Outlook 2007?
I have a new HP laptop that came with the 60 day trial of Office'07. I
receive email but the send/reply/compose functions are grayed out. I am
certain my settings are correct. Why can't I send email?
What happens when you use the Test Account Settings? What is the exact
error message you get?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
ALWAYS post your Outlook version.
How to ask a question: http://support.microsoft.com/KB/555375
After furious head scratching, KK asked:
| I have a new HP laptop that came with the 60 day...How can I keep the header in view at all times
In Word, a header and footer s always in view when you work in th document.
However, I cannot seem to do the same in Excel - any suggestions please.
Thanks - M
Select a cell below your column header and just right of your ro
header, then goto "Window" and select Freeze Panes.
pinmaster's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=626
View this thread: http://www.excelforum.com/showthread.php?threadid=49759