i have placed a custom control in my dialog box. the
control associated with it has been derived from CWnd. i
want to send a message to the dialog box when the left
mouse button clicked inside the control. the control has
implimented the OnLButtonDown.
can i use the SendMessage() inside the control's
OnLButtonDown function. if so what values are to be given
> can i use the SendMessage() inside the control's
> OnLButtonDown function.
> if so what values are to be given
> as arguments.
This highly depends on...navigation bar links
My navigation bar does not link correctly to all of the pages of my website.
I have added pages and moved them around to get them in the right order.
They do not link correctly when I preview my website. Any suggestions?
Nevermind. I got it.
> My navigation bar does not link correctly to all of the pages of my website.
> I have added pages and moved them around to get them in the right order.
> They do not link correctly when I preview my website. Any suggestions?
...Use code to stop "...contains one or more links that cannot be updated"
I sequentially open then save & close about 30 files from a list in
master spreadsheet. I am receiving the link related messag
"...contains one or more links that cannot be updated" on open of eac
file. I need this message to be stopped from displaying by usin
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
> I sequentially open then save & close about 30 files from a list in a
> master spreadsheet. I am receiving the ...Link Subform to Subform
I was wondering if someone could help:
I have an unbound form with 2 subforms. On the unbound form, i have an
unbound combo box (cmbo_name) that displays a list of names. When a name is
selected, the person's details are shown on the first subform (works
perfectly) what im having trouble doing is linking the first subform to the
other subform so when a selection is made in subform1, it's details should
appear in subform 2. Does anyone know how this can be done??
Message posted via AccessMonster.com
Hi ...Override "Send this sheet" button
I need to send a worksheet by email, but before it is sent, some validations
have to be performed. So, I need some way to override the "Send this Sheet"
"Priya" <firstname.lastname@example.org> wrote in message
> I need to send a worksheet by email, but before it is sent, some
> have to be performed. So, I need some way to override the "Send this
> button. Help.
Ok, got y...how do i link cells so that when typing in an item, the price app.
I'm trying to create a quotation template which enables me to enter in an
item in one cell and its corresponding price appear in the next cell? Is this
I have created a spreadsheet of Items and prices (of which there are going
to be over 1000) as a refernce point but am unsure how to link these for
automatic entry into the quotation.
Anyone know how to do this?
You need to build a table of the items and prices. For
example, on sheet2 in column A you list the items and in
column B you enter the corresponding price. Assume that
table...Linking worksheets (ex. =sheet1!B2)
What I want to do seems so simple but Excel is doing some
weird stuff and I'm stumped. I'm starting with two
worksheets. The first is my raw data template. The
second is my summary page, made up of simple formulas,
many of which are referencing cells from the raw data
worksheet such as(=detail!B2). This initial setup works
fine. What I want to do now is re-use the detail
worksheet to produce multiple summary pages for individual
products. My method was this:
1. Make copy of summary worksheet
2. Rename new worksheet (new worksheet has the same
formulas as original)
Hi everyone, i have a sheet named: Employee Data, but i would like t
link this to Microsoft Access so that when the details of an employe
are entered in a form at Access, it is automatically inserted int
Excel too, i should be able to delete, edit and add details o
employees, and it should take into effect at Excel.
How do i go the right way with this? Thanx, regards
Message posted from http://www.ExcelForum.com
Adn4n, open your Access database and File > Get External Data > Link. Go
through the steps and, when you're done, you'll see the little Excel icon
with the arrow n...Maintain formatting in linked chart title
I am linking an Excel chart title to a named range. Is there any way to
maintain the formatting used in the named range in the chart title?
On Tue, 15 May 2007, in microsoft.public.excel.charting,
chumley <email@example.com> said:
>I am linking an Excel chart title to a named range. Is there any way to
>maintain the formatting used in the named range in the chart title?
Not ordinarily. Someone may be able to do it using VBA.
NB Personal replies to this post will send email to firstname.lastname@example.org,
which goes to a spam folder-- please send...Pub File linked with Excel File?
I wish to transmit (Via Email or to be Downloaded) a pair of files - one
Publisher linked with data in an excel file. How may i accomplish this w/o
breaking the link?
...link with .mdb
I have created a access database and placed it on our
share drive. I have copied and pasted the URL or file
location into an email so that when someone receives it
and clicks on the URL it launches the database.
On some computers this works great - on others I get a
warning message saying I have to download the attachement
before viewing it - which defeats the purpose of the
We all have Office 2000. Is this an Outlook security
issue? I have tried changing the security setting but so
far no luck.
Nevermind - I found the answer.
http://support.micros...can not open linked table
When trying to open a linked table I get an error message that the file is
opened exclusivelyby another user. I have used this link before many times
and have knowingly done nothing to change it. I am using acces 2007 on a
vista lap top to an access 2000 database on a different computer (xp) which
uses access 2000 .
If you are certain that you are the only user, close Access and delete the
LDB file on the remote computer. If there is more than 1 user, 1 or more
have the database opened exclusively. Go to Options on each computer using
the database, and change that.
"jnacces...picture is too large and will be truncated
When copying a medium to large group of cells, the above message is received
as a popup. No error id - just the message in a popup window. Incredibly
aggrevating as I'm copying large amounts of data between spreadsheets. This
doesn't occur in Excel 2003, 2000 or 97.
Any assistance would be appreciated.
I'm just guessing but are you copying form a sheet in one workbook to a
sheet in another workbook?
Sounds like these two books are each running in their own instance of Excel.
Close down one instance and open both in a single instance of Excel.
Gord Dibben MS E...Linked Graphs
I have a workbook which contains several worksheets which are used to
calculate information for a report. The report pages are the first couple of
worksheets formatted and which contain graphs linked to data on other
worksheets within the workbook. I wish to make a stand alone version of my
report, capable of being Emailed.
I can copy the report pages to a new workbook, and then replace the formulas
with values without issue. I can then delete all the names thus removing
more references to the source workbook - however now my problems arises.
The graphs which copy across and look the same, a...How do i Change links to Relative links for linking pdf files?
Using Publisher, how do i change a link from absolute to relative.. I ahave
created an offline website as a demo CD to hand out to clients, but the
linked PDF's will only work when the CD drive of the computer is D:, how can
i make the link read from the CD no matter whats the drive directory is
When you are in the hyperlink dialog do not browse to the file to set the
link. Use the address option and enter the path you want.
David Bartosik - [MSFT MVP]
"Riggaz" <Riggaz@discussions.microso...Link from other workbook
I try to create a link which provide value, where the link path is determine
from another cell, unfortunately b8 return a string value. How to make it
evaluate to return actual value of c:\abc.xls category worksheet $a$8 value?
7 Path Def Data
8 c:\abc.xls ="'["&A8&"]category'!$A$8"
...link to SQL
Can the objects/shapes in a visio drawing link directly to a SQL 2005
I would like to have the details stored in the SQL dbase
visio 2007 professional supports datalinking using oledb/odbc and sql
"NewsReader" <Cal@offfgeigorg> wrote in message
> Can the objects/shapes in a visio drawing link directly to a SQL 2005
> I would like to have the details stored in the SQL dbase
> Carl D
...Linking SOP30200 with PM30200
How do I link in SQL SOP30200 sales invoice history information with PM30200
purchase order history information? I cannot find columns to link on and I
suppose another table will be necessary to find voucher numbers and/or doc
Is SOP60100 what you're looking for? This is where the links between SOP
documents and POP documents are stored.
Microsoft MVP - Great Plains
"richxyz" <email@example.com> wrote in message
> How do I link in SQL SOP30200 s...Link and plain text in the same cell
Question: am I able to create a cell that will ahve a link and plain text in
the same cell? Example
"Visit my site at www.me.com for todays special"
The only part I would like to link is the address.
Thanks for the help.
Excel won't allow that without a bit of cheating.
Maybe you could place a rectangle from the Drawing toolbar over the characters
for the link. Remove the border and assign the hyperlink to that rectangle.
If you format the string nicely (blue and underlined???), it may work ok.
> Questio...Cannot Send Mail
SBS2003 SP1 / Exchange SP2
The Outlook client has several email stuck in the outbox. There is no error
message, they just sit there in italics-ready state.
I've checked all the usual suspects and various solutions posted but without
success. Tomorrow I'l try turning off caching as this one was mentioned a
couple of times.
Just wondering if any one else has some ideas of this.
The Outlook client is patched to SP2.
Anything relevant in App Event log? Or in
I have a main workbook that lists all the accounts.
The accounts are each seperate workbooks. I'd like to know if I ente
information in a cell on the account workbook can that informatio
appear in a cell on the list of the main workbook.
Did that make sense?
Message posted from http://www.ExcelForum.com
if you data is in one workbook use a formula like
> I have a main workbook that lists all the accounts.
> The accounts are each seperate workbooks. I'd like to know if I
enter...How do I send a direct email?
I have a marketing list of 225 contacts selected from the main database, and
I want to send them each a personalised direct email. I have a template set
up for this, but can't figure out how to bring this together with the
marketing list to launch the campaign. The instructions I have say that I
should see 'Send direct email' in the actions menu, or see an icon on the
action bar. I have neither. Help!
As far as I remember, direct e-mail is only available in the web
client and does not appear in the Outlook client.
Also, I think it is only available in a contact ...Directory Replication links in Mixed Mode??
Directory Replication connections in Mixed Mode.
We are about halfway through a migration from Exchange 5.5 to Exchange
The Topology is basically twin hub and spoke.
In the past when migrating a site, we have kept the Directory
Replication link in place but changed the bridgehead server on each
side of it to reference the new 2000 server.
A site connector is also added at a high cost (if not already present)
to ensure that there is a direct connection between the server and
it's DirRep partner. (The high cost meaning that mail
However, we have now migrated one of the Hub sites a...Prospects and customer should be linked
Prospects and customer tables should be linked so that they you can't have
the same id for a customer and a prospect - once it is used it should be
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 suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolution...Links not linking
I have written a fairly big spreadsheet linking through the pages with SUM,
SUMIF and SUMPRODUCT formula's
What I am now finding is that when I update one page it doesn't update the
rest, even if I am only typing in a figure to the SUM function.
I have check and the calculations function is on automatic.
is there a fix or something that I could run to make sure that all the
formulas are working correctly.
Just a guess (since you already checked tools|options|calculation tab).
How about selecting all the cells (ctrl-a (twice in xl2003)) and then