AfxHookWindowCreate fails and createEx returns getlasterror value as Zero and does not give a meaningful return error value
My application crashes after running for a long time, when analyze the
cause, i found that CreateEx is causing the problem. In this
AfxHookWindowCreate is failing. when i tried to get the error code for
the createEx, it returns getlasterror value as Zero and does not give a
meaningful return error value.
Can any one please tell why AfxHookWindowCreate can fail..The window
iam creating is a child window and having attributes as
Note: It fails after running for a long time. Not in the first atempt
>My application crashes after running for a long time, when ...Help
Hope someone can see the error of my way. I have a workbook saves as a
template. Each week I receive a new excel file (data dump) from payroll
timesheets of all the employee's hours charged to the different job codes
and projects they worked on for the week. With this file open, I run the
below macro. I only use two colunms, job numbers and hours from the
original file. I copy the two columns, then open the template, paste the
data into the newly created file, input the week ending date in a cell (that
cell is referenced in the chart title), then do a save, then ask for it to
calculat...How to assign datalabels to a scatter chart, obtaining the labels.
How to assign data labels to the points of an xy scatter diagram (excell
2003)? The labels are to be fetched from a column in the data sheet, but not
from one of the columns containing the x- and y-values. This should be
possible. How can I do this?
Thanks in advance.
You can use Rob Bovey's XY Chart Labeler to add labels. It's a free
add-in that you can download from his web site:
Jos Koot wrote:
> How to assign data labels to the points of an xy scatter diagram (excell
> 2003)? The labels are to be fetched from a col...office v. x updates 10.1.6 and or 10.1.9
I was trying to update my office x with the update 10.1.6 and it would
allow me to start the update, but then when it was installing the
visual basic libraries, it would stop and give me the error "error
creating folder" "1008:9,-43 file not found". In addition, when I tried
to use the 10.1.9 update, it said that I do not have any qualifying
products on my computer. I know that I have office v. x installed,
because update 10.1.6 recognized it. I think that this is a folder
permission issue, but I do not know which folders I need to change. If
at worst, I would like to get e...Simple
I am writing a very basic proc to return a list of court types. The
developers have requested that I include a bit that can toggle whether
or not I include the 'All' option in the result set. I have this at
CREATE PROC dbo.CourtJurisdiction_lst @show_all_option BIT = 1
SELECT long_name, court_type_id FROM
SELECT 'All' AS long_name, -1 as Court_Type_id, 0 as OrderId
1 as orderId
ORDER BY a.orderId, a.long_name
Based on the @show_all_option bit, is ...Problem with .NET Security Settings
I have a problem with security-settings in a .NET Application.
The application has a strong name and is full trusted ("Trust an
assembly" - Full Trust),
..NET Security is set "Local Intranet - medium trust".
The application ist installed on a network-drive.
Working-Directory and Configuration-Files are also on different
The application uses intensively XSLT and XML.
The following XSL-Transformation-process fails (without errors !):
Base-Document XML X is stored on network-folder A.
Transformation-Stylesheet XSL Z is stored on Networkfolder B
...pivot chart mystery fields
I've been given the task to reverse engineer an excel pivot chart that
an ex-employee created. When i look at the data source it pulls in all
the fields from a particular table from an access database. However,
once it gets to Step 3, and i select Layout, all of a sudden there are
these extra fields that have appeared from no where!
The data in these extra fields is used as grouping for the pivot chart.
There is nothing in the query telling it to create extra fields, it just
pulls everything from the table.
When i told the chart to list all formulas (thinking they might be
calcu...Change setting for mailing attachments
I'm running GP 7.5 and Acrobat 5.0 Distiller. When I send to Mail Recipient
as PDF, it works fine, and attaches a pdf to a new mail message, however,
Acrobat ALWAYS opens. I've turned off all imaginable settings in acrobat and
even changed the default pdf file association with acrobat 7 reader and
still, whatever that file association is linked to, GP will run acrobat and
show a preview. Any thoughts?
...Publisher: set up an 11 X 17 tabloid with facing pages
I'm trying to create a tabloid which is 11" tall and 17" wide (folded in
half--with facing pages). Please help me set it up.
This based on Publisher 2000 but it should get you there.
set the paper size to 11"x17"
Special fold dot
Verify the page size is 8.5"x11" (after Landscape is selected)
Next it will ask you if you want groups of 4 pages, yes.
This should get you going.
"newsletterlori" <firstname.lastname@example.org...VBA error: Unable to set the Values property of the Series class
Excel 2003 SP1
Trying to create a chart using VBA. The following two subs are edited a bit
after being created by the macro recorder.
The send sub errs on this line:
ActiveChart.SeriesCollection(2).Values = "=Sheet1!R12C3:R22C3"
With the error:
Run-time error '1004':
Unable to set the Values property of the Series class
Column 3 is just a series of numbers. Strangely, the first
ActiveChart.SeriesCollection(1).Values line works OK, but then the 2nd
I can't figure it out...
' area_chart Macro
Range("A1:C72"...Adding a value to blank cells
I have a spreadsheet with a number of blank cells in a column, I want to fill
these cells with a another cell value from a different column, the value
will need to change every time a non blank cell is reached, as will the data
to be put in to the next section of blank cells. I can send a small sample of
data if required.
for each CELL in selection
if CELL.Text="" then
field bit is with true or false and consequently to post a popup in
var champ_bloque = crmForm.all.new_bloque.Value;
if (champ_bloque == True)
This code does not seem to be good. However I checked in the base the
valeure is well in True when I put yes in the field bit.
Would somebody have an idea?
var champ_bloque = crmForm.all.new_bloque;
alert("bloqued");...Rotating Stock Charts in Excel
Operating System: Mac OS X 10.5 (Leopard)
I have read the threads on rotating Excel charts and realise that Stock charts cannot be rotated there. But I must rotate and put side by side 4 such charts (High-Low-Close). I cannot rotate them in Word or Powerpoint - the rotate function is disabled. I can rotate them and appose them very well in Appleworks but then I lose a lot of definition in the chart and the text. Any solution either in Microsoft or Appleworks <br>
> Version: 2008 Operating...Can't Include more than one data range in chart
Operating System: Mac OS X 10.4 (Tiger)
Whenever I try to add a second data range to a chart, I see the following message: <br><br>"The Chart Data Range is too complex to be displayed. If a new Data Range is selected, it will replace all of the series in the Series Panel." <br><br>This happens with any data set on every type of chart; even a simple series of 10 numbers in a plain line graph. <br><br>Any ideas?
...Setting DCB parameters in MFC app?
I have a VC6 SP5 MFC app that provides serial communications. I need to be
able to set my DCB struct so that it is configured to communicate with a
device that uses hardware flow control and also says that it needs RTS/CTS
Do you know what values in the DCB I need to set in order to accomplish
Set the fRtsControl in DCB to RTS_CONTROL_ENABLE. You can use the
WaitCommEvent function to wait for serial events (CTS is one of them) or you
can call GetCommModemStatus to find out if CTS is on.
"Microsoft" <email@example.com> wrote in message
news:e...plot schedule-type data in graph, date and times as x & y axes
want to plot schedule-type data on graph x axis is 30 days of month and 3
rooms per day; y axis is hour of day from 6am to 8pm in 15min increments,
want to plot for say, the 3rd of the month in room 1: 7am-8:15, 10:30-11:15,
1145-1400, 1415-1530, 1600-1730, then other times for room 2, for each day
of the month, several rooms per day. Is this impossible- if impossible in
Excel, then is there another program that can do this??Thanx!
What I came up with is this:
Format column as time "13:30"
Column B starting at cell B2
Enter "06:00" without the ""...Find a cell(date) that corresponds to a particular maximum value
I've got some temperature values on B5:I34 and I used the MAX functio
to find the maximum temperature in that range. The maximum value is a
cell F5. The date column is on cells A5:A34. My question is how can
retrieve the date corresponding to that particular maximum value
similar to minimum value?
Appreciate any help.
Message posted from http://www.ExcelForum.com
Assuming *no ties* in the max and min temperatures in B5:I34
Using 2 empty cols, say cols J and K
Put in J5: =MAX(B5:I5)
Put in K5: =MIN(B5:I5)
Select J5:K5 and copy down to K34
Put ...stop entry of data that causes a negative value from a formula
Excel 2002. I tried to use "Validation" on the "Data" menu but that only
works on entered data. I have a formula in a cell and if the answer becomes
a negative number I want it to stop the user and "force" them to fix it. I
used an IF condition but that only displays a message.
Maybe you could fix the formula yourself:
if the cell had to be non-negative.
Or you could put the message in that same cell...
=if(yourformula<0,"Please fix cells x, y, z",yourformula)
That might be enough to make it so that they can't advanc...Assign value to variable
Several people have helped me get to the stage where I've got the
following formulae working:
Range("B6").Formula = "=max(h1:h300)"
Range("B8").Formula = "=ROW(OFFSET(A1,COUNTA(A:A)-1,0))"
next question is for my 3 formulae, how do i set a variable to equal
each of those values for writing to a sequential text file?
rroach's Profile...CE Fonts in MS Office X (Mac)
I am often using all the aplications within the MS Office X (latest
version) in the Czech language (CE fonts). Everything works fine
except when I type a smal "i" and a "space" key afterwards. The small
"i" turns stubbornly into a capital "I" every time.
Any cure for this small but annoying problem ?
Please respond by e-mail : firstname.lastname@example.org
The controls you are seeking are in Word. From the Tools menu choose
AutoCorrect. You can control the setting for capitalization and correct
things as you type.
All respo...4 field in legend of line chart
I have a Line chart in Access.i want to have 4 field in legend of chart.but
access don't let to me to do it.
While in design view of the chart, you can adjust the size of the legend. If
this doesn't help, you need to provide more significant information about
your chart, what you tried, and your results.
MS Access MVP
"afshin" <email@example.com> wrote in message
> I have a Line chart in Access.i want to have 4 field in legend of
> acce...Formula to make Negative Values Positive & Positive Values Negative?
I would like to know if there is any way to have a formula/function that
takes a value from another cell (I know how to do that part) and then
makes the number negative if the original is positive - or else makes
the number positive if the original is negative. Any ideas?
mustard's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=20017
View this thread: http://www.excelforum.com/showthread.php?threadid=470855
Just multiply it by -1
...Setting Outlook 2000 AutoArchive longer than 60 days
Is there a way to do this? It is very tedious to do every folder at a
time so I want to be able to set the AutoArchive setting to 365 days.
Is there somewhere in the registry or is there a group policy that
could be used to set this at the server?
This is on Outlook 2000.
Archive is an Outlook function, so there is no server setting for it.
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"sprouty" <firstname.lastname@example.org> wrote in message
> Is there a way to do ...Retiring Asset with Non-Zero Net Book Value
I have recently started handling Fixed Assets and I have some doubts
about the retiring assets
in GP, When an asset is retired and has not been fully depreciated,
the net book value is calculated as cost basis less LTD depreciation.
Can anybody explain the underlying accounting concept for keeping the
net book value. When an asset is retired, it means this asset has no
value for the company. Isn=92t it so ?
Is there any way in GP to make net value zero when it is retired ?
...Display line chart in customize reports
How do I display a line chart in viewing charts? The line and Pie options
are greyed out.
Wayne wrote in <89D9F87A-E7F0-4EDC-883B-EE4AB1818B18@microsoft.com>:
>How do I display a line chart in viewing charts? The line and Pie
>options are greyed out.
If the option's greyed out, you're out of options. :-)
* Look at the other reports. Maybe one of them offers what you want.
* Export the data to a spreadsheet. You can do anything you want there.
If you'll tell us what you're trying to accomplish, maybe someone can
offer you some alternati...