WM_QUERYENDSESSION and saving data through a worker thread
I have an application that uses a worker thread to save/load data.
I'm wondering what is the best reaction to WM_QUERYENDSESSION in my case.
I have to possible scenarios:
1. When WM_QUERYENDSESSION comes fire the thread and wait for it to end.
Only then return TRUE from WM_QUERYENDSESSION handler.
The problem is that I will get nusty dialog that my application "is not
2. When WM_QUERYENDSESSION comes fire the thread and return FALSE from the
handler. When thread is done force application to end. But this way I will
probably prevent Windows from closing,...Copying data from one chart to another
I have many graphs - all plotting on similar scales but using different
data. Is there any way I can simply copy one set of data from one graph
and paste it into another graph so that I can avoind going through all
the hassle plotting each curve again? I want to have graphs showing
different combinations of the same data and have hundreds of curves to
plot so this could be a huge timesaver...
Alan_Partridge's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29295
V...Show a date 30 days out
I have a feild that I would like to show what the date would be in 30 days
for a feild with a date in it [Sold Date].
Sold Date feild would be 1 Jan 07 so the feild would show 30 Days later 31
I did =[Sold date]+30 and it did not work
how about dateadd:
dateadd("d", 30, [Sold Date])
"KAnoe" <KAnoe@discussions.microsoft.com> wrote in message
>I have a feild that I would like to show what the date would be in 30 days
> for a feild with a date in it [Sold Date].
...Can I abbreviate one value in a data series?
I've got a chart where one value (8,300) greatly exceeds all the others. Is
there a way to abbreviate this value so the other data points show better in
One way is to break the Y axis, have a look at these examples of how to
> I've got a chart where one value (8,300) greatly exceeds all the others. Is
> there a way to abbreviate this value so the other da...How can I clear the last Data->Text to columns to formatting
I've noticed in Excel 2000 that if I paste text into various worksheets
within a workbook each paste will assume the Text->Column formatting that I
applied in the previous. How can I prevent it from happening ?
Just run another data|Text to columns against a dummy cell.
Specify delimited, but remove all the check marks from all the possible
(alternatively, you can close excel and reopen it.)
> I've noticed in Excel 2000 that if I paste text into various worksheets
> within a workbook each paste will assume the Text->Col...Close Event for the Database (?)
Is there a close event for the database?
I have forms referencing other forms, and if the user closes
Access without backing out of the forms, an error message
pops up. It would be hand to just trap that error in an "On
close" event for the entire db. Of course that might be a
horrible thing when other errors are happening on close....
...Line Chart with dates in 5 day working week only
Trying to format a chart so that only the 5 working days of the week are
displayed on the x axis. The source data only has the five days (e.g.
05/09/2005 down to 09/09/2005 and then on to 12/09/2005 down to 16/09/2005
etc etc) So I have missed out the weekend dates.
When I create the line chart however, the weekend dates appear automatically
and just show no point on the chart, therefore there is a longer line between
Fridays and Mondays!!
Hope this makes sense.
Does anyone have any ideas on how to change this? I have tried looking at
Tools-options-chart and cannot seem to turn...clear up for Event/Mutex etc.
I am using: CreateMutex() / CreateEvent() to create Event / Mutex.
After program done. How should I clear up? Using CloseHandle()? Is it
required? or it just is close automatically when handle is out of the
Handle will be out of scope when your program terminates :)
So close them with CloseHandle(...) when you are done with them.
Microsoft - MVP
"kathy" <firstname.lastname@example.org> wrote in message
>I am using: CreateMutex() / CreateEvent() to create Event / Mutex.
> After program done. How...Obtaining a hot fix for Event 9582
I have an Exchange 2000 Server standard edition (SP3 + latest roll-up)
running on Windows 2K (SP4 + latest updates). The server has 2 GB of RAM and
I do NOT have the /3GB switch in the boot.ini file. Yesterday this server
began generating memory fragmentation errors. The event log item is below:
"Event Type: Warning
Event Source: MSExchangeIS
Event Category: Performance
Event ID: 9582
Description: The virtual memory necessary to run your Exchange server is
fragmented in such a way that performance may be affected. It is highly
recommended that you restart all Exchange s...Event ID 1016 logged for sending an email
I recently emailed a co-worker (at 11:42am). I was then later shown a
security log that showed Event ID 1016 was logged at 11:42am saying that I
accessed her mailbox. I did no such thing! I've researched the
knowledgebase and found some info on this topic, but can anyone tell me how I
can definitively clear my name? Has this happened to anyone else - simply
sending an email caused 1016 to log? I realize that checking the other
person's calendar could also do this, but I don't think I did that either.
My job could be on the line. Thanks for any help you can provide. (...... I want to change a chart type ...
I have a "Line - Column" chart in my spreadsheet.
My Bars represent the month which is in a Linked Cell.
The Value of the Bars is a Dollar amount from a Linked Cell.
The Line represents a Target Dollar Value.
I would like to add a second line that would represent a count from a linked
range of cells.
Can I edit my existing chart, or do I have to create a new one? Could you
give me a few pointers?
Select and drag the new column onto the chart. In the resulting dialog
box, ensure you specify 'new series'. Once XL finishes adding the
series, if it is not the...How do I import data from lotus123 & maintain formulas/worksheets
I am trying to convert several complex Lotus 123 workbooks with formulas into
Excel 2003. How do I do this and maintain my formulas and the individual
if the lotus file is a wks version or earlier, xl should open it and let you
save it as an xl file.
if the lotus file is a 123 version or higher, you can open the file in lotus
and save it as an xl file.
if you don't have lotus, find someone who does.
> I am trying to convert several complex Lotus 123 workbooks with formulas into
> Excel 2003. How do I do this and maintai...Outlook 2007 error event id: 35
Per hour i receive about 12'000 of these errors in the event viewer on
my vista laptop. And usualy my outlook at some point just goes into
the "not responding" mode. Then I have to kill the process from the
task manager to be able to reopen outlook just to see it freeze again
after a couple of seconds.
I tried the whole stop indexing service and reinstall index service
procedure to no avail. Does anyone else have a solution to this very
email@example.com <firstname.lastname@example.org> wrote:
> Per hour i receive about 12'000 of these errors in the...obtaining data in text form from a table
I like to be able to obtain the dates in a text format from the table
Test6 4-Feb,5-Feb, 9-Feb
Do I need to do this by macros and if so, any help would be appreciated.
Care Recipient Surname 4-Feb 5-Feb 8-Feb 9-Feb
Test5 4-Feb 8-Feb
Test6 4-Feb 5-Feb 9-Feb
Vlookup should do what you want, as in:
Adjust the ranges t...Determine number of rows with data
I am using the macro below to pull some data from an external workbook.
The 2 issues I need to sort are:
1. The number of rows in the external workbook can vary. How do I amend this
code to pull all of the rows with data?
2. The number of rows in the autofill also may vary. How do I autofill only
the number of rows required? i.e the number of rows in column A that contain
'Lookup Previous Month Sales
Selection.NumberFormat = "General"
Selection.FormulaArray = _
"=S...Delete contents deletes all data and formulas
When I hit delete contents all data and formulas are deleted. How can I
delete data without deleting formulas?
You could try this
tap F5 - Special - Constants - OK
and if that selects the data you want to delete then tap the delete key
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
> When I hit delete contents all data and formulas are deleted. How can I
> delete data without deleting formulas?
First use Find...How do I change numbers to negative without re-typing?
I have a large range of data that needs to be changed to negative numbers,
Can I do this in Excel?
I a running XP64 and I as hit by a virus the other day. It affected my 32
bit browser (IE8) and ran multiple copies that tried to connect to
advertising sites. all seems clear now BUT...
the browser seems a little slow and somtimes does not connect to a site.
Eventvwr.msc has a log installed for explorer but I never see any errors
repotred. i cannot find how to set this on. Any ideas please?
On Sun, 6 Dec 2009 11:43:29 +0100, "Squeezy99"
> I a running XP64 and I as hit by a virus the othe...Add data to cell w/o loosing initial data
I would like to know if there is a way to add data to data without retyping.
For example I have a colum of 18015555555 and I want to add [rfax:(cell
#)@/fn=(phone number)] So I would like to add the brackets - copy from a
cell - @/fn= and not loose the data already in the spread sheet. Example 2.
Add [rfax:company name@fn/=(saved data here) then close bracket.
So I want to add data to cells without loosing the data already in the
cells. I have about 600 of them to do and I really don't want to do each one
Please let me know if anyone knows how to accomplish this.
Tha...Removing filters from data
I have recorded a macro to remove filters from data lasts in advance of
performing other actions.
However if the data is unfiltered the macro falls over with the message
Run time error '1004' ShowAllData method of Worksheet class failed.
I think I need some sort of if error continue code or something to check
I would be grateful if someone could point me in the right direction please.
If Activesheet.Filtermode Then ActiveSheet.ShowAllData
"Philip J Smith" wrote:
> I have re...Looking up and matching data
I have two sets of data with the same information but not in the same order
and am trying to match the data. In each data set I have 10 pools containing
100 loans. Each pool has a unique ID and each loan within the applicable
pool has an ID of 1 to 100. I need to look up the Pool ID, then look up the
loan ID so that I can extract the property type information from a third
column. The Pool ID and property type is text but the loan ID is a number.
I am struggling to put together the right combination of formulas to give
the property type for each loan within each pool. Any suggestion...invisible listbox data
I have developed software in Acces XP that is distributed to two different
locations and I have noticed some odd behaviour at one of the locations.
Sometimes the data in listboxes or combo boxes is invisible. The data IS
PRESENT because you can select and use the records as before (although you
can't see which ones you're selecting). The combo boxes are poplulated and
have the correct dropdown length for the records one would expect. The
listboxes have scroll bars where one would expect a scrollbar and
multiselcetion is possible where apropriate.
I have played around with th...create a letter with the data fron work sheet
i have a data sheet for the order.like people order staff lik
tea,coffee...etc,i ve data including date,name,department,.....etc.
when i put the data i want a letter format which picks up the data fro
the sheet then i can send it to the person who made the order as
like it the letter starts dear "......"(it could pick the name fro
also how can i create this letter? does it have to be in excel ??
help pleaseeeeeeeeeeeeeeeeeeee!!!!!!!!!!:( :( :( :
Message posted from http://www.ExcelForum.com
As answered in microsoft.public.excel and microsoft.public....excel 2007
I have data that looks something like this
account#, invoice amount
I need a way to combine all the invoice totals for each account so I
have results like this
Any suggestions on how to go about doing this? I thought I had done
something similar to this with filters
before in Excel 2003, but I can't figure out how I did it. Thanks!
You can use subtotal or a pivot table
in the pivot put the account numbers in the row field and the invoice amount
in the data, in subtotal use at each change in account numb...Moving certain data to different sheet
I need to move data that meets a certain criteria, to another sheet within a
workbook. For instance, if a column of data is for a certain ZIP code area, I
need it to automatically copy to a sheet for that city. Say, 40202 would go
to the Louisville, KY sheet. Because Louisville has multiple ZIPs, I would
need only the data that begins with 402 to go to that sheet. Lexington KY's
data, which begins with ZIP code 405, would go to its own sheet. Macro?
This can definitely not be created with a formula. I suggest that you make
use of the macros.