|
Ankush Mehta wrote: 4) if you have something to tell about it.
Here is a good quick way to dump a recordset to a excel file, then call shellexecute to print that file. Delete it it after your done.
CString str;
str.Format("SELECT * INTO [Excel 8.0;DATABASE=%s].[%s] FROM [%s]", ExcelFile, Worksheet, table);
Create an ADO Connection object to the database then call.
pConn->Execute(str.AllocSysString(), NULL, adExecuteNoRecords);
To enumerate the tables in an access database try
SELECT MSysObjects.Type, MSysObjects.Name
FROM MSysObjects
WHERE MSysObjects.Type=1;
Ankush Mehta wrote: 6)I could not manage printing a webpage with ShellExecute.My code is like this:
ShellExecute(NULL,"print",m_FileName,NULL,NULL,SW_HIDE);
Try ShellExecute("explorer.exe","print",m_FileName,NULL,NULL,SW_HIDE);
ZeePain! wrote: This seems like one of those programs that started small, grew incrementally, building internal pressure, and finally barfed all over its source code sneakers. Or something.
thedailywtf.com[^]
|
|
|
|
|
when i use the copy-paste code line given by you following error is generated.i am using VC++ 6.0.
cannot convert parameter 1 from 'char [13]' to 'struct HWND__ *'
Regards,
Ankush Mehta
|
|
|
|
|
Opps, I wasnt paying attention.
Lets see now how did I do it (FYI, Im no where near my dev computer and cant verify this at all so its based off memory, and I often have corrupt memory errors)
ShellExecute(NULL, "print", "explorer.exe", m_FileName, NULL, SW_HIDE);
Or
combine both explorer and file name
CString str = _T("explorer.exe ");
str += m_FileName;
ShellExecute(NULL, "print", str, NULL, NULL, SW_HIDE);
Hows that?
ZeePain! wrote: This seems like one of those programs that started small, grew incrementally, building internal pressure, and finally barfed all over its source code sneakers. Or something.
thedailywtf.com[^]
-- modified at 4:34 Thursday 8th December, 2005
|
|
|
|
|
No errors,
But no output also just as with the first shell execute statement i sent ...
Ankush Mehta
|
|
|
|
|
Your going to make me work arent yea? 
As I said Im not near a computer with VS installed, but I do have MS Word and VBA. This just printed the file.
ShellExecute(0, "print", "C:\workorder.html", 0, 0, 3)
One more thing, ShellExecute returns a HINSTANCE, which can be cast to an int. What is the return? Is should be a value higher than 32.
Google Cache of a website with the error return codes[^]
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/shellcc/platform/shell/reference/functions/shellexecute.asp[^]
ZeePain! wrote: This seems like one of those programs that started small, grew incrementally, building internal pressure, and finally barfed all over its source code sneakers. Or something.
thedailywtf.com[^]
-- modified at 6:22 Thursday 8th December, 2005
|
|
|
|
|
well, one last question how to typecast to int......plz answer this one sfdougl...
Ankush Mehta
|
|
|
|
|
Ankush Mehta wrote: well, one last question how to typecast to int
Sure you could do the following,
HINSTANCE hresult = ShellExecute(params)
TRACE("Result of Print %d\n", (int)hresult);
ZeePain! wrote: This seems like one of those programs that started small, grew incrementally, building internal pressure, and finally barfed all over its source code sneakers. Or something.
thedailywtf.com[^]
|
|
|
|
|
I just tested the following and it works in VS6.
HINSTANCE handle = ShellExecute(0, "print", "C:\\WorkOrder.html", NULL, NULL, SW_SHOW );
The only down side that I see here is it prompts the user with the printer settings dialog. All they have to do is click print but still...
ZeePain! wrote: This seems like one of those programs that started small, grew incrementally, building internal pressure, and finally barfed all over its source code sneakers. Or something.
thedailywtf.com[^]
-- modified at 10:00 Thursday 8th December, 2005
|
|
|
|
|
Hi,
How to open recent files from file menu in MFC application.Which method do we need to override?
|
|
|
|
|
If I understood this question then, here I say...
Just create one MenuItem in your File popup menu with this id.
you can give name something as "Recent Files"
ID_ FILE_MRU_FILE1
To know more about how it works and all, view this Microsoft link its pretty clear
http://www.microsoft.com/msj/0899/c/c0899.aspx[^]
regards,
-OP
|
|
|
|
|
right click in C drive and create a file called "hello.txt" and a folder called "New Folder". Then run this program:
BOOL ret = MoveFileWithProgress("C:\\hello.txt", "C:\\New Folder", NULL, 0, MOVEFILE_COPY_ALLOWED);
DWORD dw = GetLastError();
ret = MoveFile("C:\\hello.txt", "C:\\New Folder");
dw = GetLastError();
Both the MoveFile* calls fail with error ERROR_ALREADY_EXISTS. According to MSDN the target can be either a file or a directory. It is not clear what is going wrong, any ideas anyone?
thanks!
|
|
|
|
|
Hi,
The new file name must not already exists. This is in case of MoveFile.
When the dwflag parameter of MoveFileWithProgress is set MOVEFILE_COPY_ALLOWED it internally uses MoveFile() and DeleteFile() functions. Hence, you get the same error.
Bye,
Cool Ju 
Dream Ur Destiny
|
|
|
|
|
Never mind, I identified the problem.
If the source is a file, the target has to be a file name too, it cant be a directory. I misunderstood the MSDN doc for MoveFileWithProgress.
Btw, It is MoveFile and MoveFileEx that call MoveFileWithProgress and not the other way.
thanks!
|
|
|
|
|
Hi,
The MoveFileWithProgress function is equivalent to MoveFileEx. It doesn't get called by MoveFileEx. MoveFileWithProgess simulates CopyFile() [which i mentioned as MoveFile mistakenly] and DeleteFile when the dwflag is set to MOVEFILE_COPY_ALLOWED.
Bye,
Cool Ju
Dream Ur Destiny
|
|
|
|
|
And I use the 3D geometry model to calibrate the camera.
I need to know at least for given pairs of known corresponding scene and image points.
Four scene points I can measure, but I don't know how to determine the coordinate of four corresponding image points.
I'm using VideoOCX for to work with image porcessing in Visual C++
Can anybody help me to determine the coordinate image point (in pixel)???
Best Regard
H Anh
|
|
|
|
|
Hi,
Why can't I pick up WM_THEMECHANGED message when user change the visual style from "Windows Classic" to "Windows XP"? In the reverse direction, which is from XP style to Classic, it worked properly. Is there any special line of code needed to pick up this kind of message?
Thanks in advance.
|
|
|
|
|
That sounds weird. I know I get the message in my apps, and I don't do anything special.
--
Pictures[^] from my Japan trip.
|
|
|
|
|
I use FindWindow function in windows appl_2 to get the handle of windows appl_1. However lpWindowName cannot be use since my windows appl_1 contains version number which will change everytime I recomplie it. I used the class object name inherit "theapp" which does not work. Can anyone please tell me how to get the lpClassName from appl_1 please? Thank you.
|
|
|
|
|
The more relevant questions is WHY do you need to do this?
Because if you need HWND_1 from APPL_2, why not write HWND_1 into a memory mapped file that can be directly read from APPL_2 and then not EVER have to worry about it again. Avoiding the CHEESY FindWindow function altogether. Nuff said
I AM going to have to write an article titled FindWindow - JUST SAY NO!
|
|
|
|
|
Why not let appl_2 probe for appl_1 with window messages? Use RegisterWindowMessage() to register a unique window message which only your two apps know. A unique message name could be created using Guidgen.exe which comes with visual studio.
#define YOUR_MAGIC_COOKIE 0xdeadbeef
#define UNIQUE_NAME "AUniqueName"
#include "common.h"
UINT nMessage = RegisterWindowMessage(UNIQUE_NAME);
foreach hWnd in TopLevelWindows {
if(YOUR_MAGIC_COOKIE == SendMessage(hWnd, nMessage, 0, 0)) {
DoSomethingWithYourWindow(hWnd);
}
}
#include "common.h"
UINT nMessage = RegisterWindowMessage(UNIQUE_NAME);
switch(msg.message) {
...
case nMessage:
return YOUR_MAGIC_COOKIE;
}Please translate appl_1's message handling into your preferred toolkit's way of handling messages.
--
Pictures[^] from my Japan trip.
-- modified at 18:46 Tuesday 6th December, 2005
|
|
|
|
|
Either of your methods is better than FindWindow(). Using memory mapped file looks clean but I am not too familiar with it. RegisterWindowMessage() seems easy enough for me to pick up quick.
Thanks a million, guys!
|
|
|
|
|
Bzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzt....
foreach hWnd in TopLevelWindows { <br />
if(YOUR_MAGIC_COOKIE == SendMessage(hWnd, nMessage, 0, 0)) {
This will hang your application if the top-level window you sent a message to is not responding.
Better use the other technique, or else at LEAST use SendMessageTimeout.
|
|
|
|
|
You're right!
--
Pictures[^] from my Japan trip.
|
|
|
|
|
Another solution is to use HWND_BROADCAST and register another response message. Then collect the result in a/the message loop.
--
Pictures[^] from my Japan trip.
|
|
|
|
|
vitowong wrote: Either of your methods is better than FindWindow(). Using memory mapped file looks clean but I am not too familiar with it.
Have a look at this thread before using FindWindow api!-
PROS AND CONS of FINDWINDOW[^]
"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
cheers,
Alok Gupta
VC Forum Q&A :- I/ IV
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
