|
 Hi All,
I want to get the printout of an access table but when i open it & print it, i only get the first record printed.What may be wrong? Here are the two lines for opening & printing that i am using:
oDoCmd.OpenTable(_variant_t("recipe"),0,1);
oDoCmd.PrintOut(1,_variant_t("1"),_variant_z("1"),1L,_variant_t("1"),_variant_t("1"));
May be the problem is because whenever the table is opened its first record is already selected by default.perhaps, all the records need to be selected. How can i do that. i am using vc++ 6.0 & ms-access 2000.
Please Help. it is urgent.
Regards,
Ankush Mehta
|
|
|
|
|
What is DoCmd ?
I mean what type of object is it
Vikas Amin
Embin Technology
Bombay
vikas.amin@embin.com
|
|
|
|
|
it is used in access automation.see object model documentation for automating ms office.
hierarchical object model is used for office automation.
see msdn for details.
Regards,
Ankush Mehta
Ankush Mehta,
Dewsoft Solutions,
Mumbai
|
|
|
|
|
Ankush Mehta wrote: oDoCmd.PrintOut(1,_variant_t("1"),_variant_z("1"),1L,_variant_t("1"),_variant_t("1"));
Your arguments are wrong for the Printout command.
acPrintAll == 0
acSelection == 1
acPages == 2
BTW, there shouldn’t be any need to recast (all though I’m not completely sure about that) as all of the arguments are integers.
Good luck...
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[^]
|
|
|
|
|
sfdougl wrote: oDoCmd.PrintOut(1,_variant_t("1"),_variant_z("1"),1L,_variant_t("1"),_variant_t("1"));
Thanks, First argument must be zero(print all).But as per VBA documentation second & third arguments(from page, to page) should be omitted.This doesn't work out in VC++.Error is- error C2660: 'PrintOut' : function does not take 4 parameters.
We need to type cast since these are of type variant in vc++.
Any idea buddy 4 d solution.Can u possibly suggest me how to have the number of tables and their names in ms access database.
Thanks in anticipation,
Ankush Mehta
|
|
|
|
|
Ankush Mehta wrote: First argument must be zero(print all).
Yup that’s why I mentioned it; your first argument is 1 which is print selection, in other words the currently selected record. Change that argument to a 0.
Ankush Mehta wrote: per VBA documentation second & third arguments(from page, to page) should be omitted
Im no where near a complier to test this but if 1 is causing an error try -1.
Ankush Mehta wrote: Can u possibly suggest me how to have the number of tables and their names in ms access database.
You can query Acces for tables i.e.
SELECT MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Name) Like "Table Name"
or simply
SELECT MSysObjects.Name FROM MSysObjects
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[^]
|
|
|
|
|
How can i query that using vc++?Please suggest.
Let me restate the problem.
I want to print an entire ms access table using vc++.Unfortunately, the code works fine for vb(in which if first argument of printout is 0, there is no need for second & third argument).The same thing in vc++ is not supported, it asks for all six arguments
DoCmd.PrintOut [printrange][, pagefrom] [,pageto][, printquality][, copies][, collatecopies]:
Ankush Mehta
|
|
|
|
|
Ankush Mehta wrote: Let me restate the problem.
I want to print an entire ms access table using vc++.
Does your app have to use office automaiton?
If so have you looked at CAccessReports class[^]
Alternatively I have always wanted to use this library Report Generator[^]
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 developed a MDI Doc/View Application in MFC with Splitter windows(3 pans). Each view of pan contains item list in TreeView form. When any one of these pan had focus i couldn't get ToolTip from ToolBar. If i close the pan which contains the focus then I could get ToolTip. What could be the possible reason?
Direction regarding this is highly appreciated.
Thanks and regards,
Rajan
"I'mpossible = Impossible"
|
|
|
|
|
I've been tossing this one around for days and can't figure it out. I'm trying to dynamically load DLLs using the LoadLibrary/GetProcAddress method. I know I've loaded the library, but I can't get GetProcAddress to find the function. Here's the code.
<br />
private:<br />
typedef Object __gc * (__cdecl *Builder)();<br />
Builder build;<br />
HINSTANCE library;<br />
FARPROC holder;<br />
Object * wompi;<br />
<br />
DLLoader::DLLoader()<br />
{<br />
library = LoadLibrary(_T("LeetTrans"));<br />
if(library != NULL)<br />
{<br />
<br />
holder = GetProcAddress(library,_T("Build"));<br />
if (holder != NULL)<br />
{<br />
build = (Object __gc*(*)()) holder;<br />
wompi = build();<br />
}<br />
}<br />
}<br />
<br />
Object __gc * __cdecl Build()<br />
{<br />
LeetTrans * a = new LeetTrans();<br />
return a;<br />
}<br />
<br />
Object __gc * __cdecl Build();<br />
And finally, here's the stuff from the .DEF file in the DLL. I don't even know if I need this:
LIBRARY "LeetTrans"
EXPORTS
Build @1
I don't know what else to do. Anyone can even lead me in the right direction? Thank you in advance for any help.
|
|
|
|
|
holder = GetProcAddress(library,_T("Build"));
mention the function ordinal in place of _T("Build")
|
|
|
|
|
This could really work, but I don't know how to mention the ordinal in LPCSTR format so that GetProcAddress will understand it.
I'm SOOOOOOO close! Once I get this, I'm pretty sure the rest of the program will fall into place! Thanks to everyone for your help. Wow i've had too much caffeine. 
|
|
|
|
|
Ok for starters drop the _T macro from the GetProcAddress call, function names in libraries aren't stored in Unicode - you'll just get compiler errors when you trying moving to a Unicode build.
Next try searching under the Visual Studio folder for a file called 'depends.exe' and open the DLL using it, it will show show you a list of all the functions exported by the library. Check the function is being exported with the name you think it should be, the chances are it's not and it's got a load of giberish trailing after it. If it does you will need to declare any functions you wish to export using the extern "C" keyword, if your not sure what it does check MSDN for more details[^] but it basically tells the compiler to export the function without mangling the export name - sorry thats a really bad explanation of what it's doing but i'm just entering my 28th hour of a serious coding session and running low on coffee 
Gavin Taylor
w: http://www.gavintaylor.co.uk
|
|
|
|
|
I enjoy the Sobe drinks myself. 
I couldn't find the 'depends.exe', but I changed the DLL code to look like this:
<br />
extern "C" Object __gc * __cdecl Build();<br />
<br />
extern "C" Object __gc * __cdecl Build()<br />
{<br />
LeetTrans * a = new LeetTrans();<br />
return a;<br />
}<br />
The FARPROC variable back in the main exe is still coming up NULL. I'm using the debugger to watch it come back. It just isn't finding the Build function.  Thanks for your help, especially considering your work. Good luck with your code.
|
|
|
|
|
OK now I feel thick
Now i've just started to wake up again and noticed your trying to import / export managed code, AFAIK it isn't possible using the standard Windows API - don't hold me to that though as I'm definately no .NET expert. I *think* the only way to do it would be to create a proper .NET assembly and import them as references... again *i think* as it's the only way i've ever mixed c++ with .NET - i could be wrong though
Gavin Taylor
w: http://www.gavintaylor.co.uk
|
|
|
|
|
I have to write a dialog-based program (using MFC) which saves the position of the dialog to Window registry when user log off Window.
I've tried to save dialog's position in DestroyWindow() function but it doesn't work.
Could u tell me a way to solve this problem?
Thank in advance.
Trunghd
|
|
|
|
|
Hi,
Handle WM_CLOSE message
Bye,
Cool Ju 
Dream Ur Destiny
|
|
|
|
|
I've tried to handle WM_CLOSE message but it doesn't work, may be WM_QUERRYSESSIONEND message is better.
Many thanks for ur advice.
|
|
|
|
|
Does anyone know of any DVD/CD burning libraries that are opensource or shareware? I know of a few which cost a bit and I may eventually break down and buy them... but I'd prefer to ease the learning curve by starting with something cheap that I can play around with.
em: raddog_AT_kc.rr.com or jfe_AT_americancentury.com
Thanks!
- john ferguson, kansas city
|
|
|
|
|
Why don't you try nero API, it is free. But you and those who will use your program would need a nero installed.
|
|
|
|
|
I have a CRichEditCtrl object that contains multiple lines of data. Each line is from 1100 to 2030 characters long. For some reason the rich text control is word wrapping the line at character 1025. Can anyone suggest a way to avoid word wrapping? I do not want any wrapping at all.
Thanks in advance for your help.
|
|
|
|
|
You might check this link out:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vclib/html/vcrefcricheditctrlsetwordwrapmode.asp
I've not used this control, but you could potentially override the default wordwrap handler via the EM_SETWORDBREAKPROC message. I don't know if this would work, but perhaps by taking over the wordwrap responsibilities you could effectively disable it.
You might check here, too: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/shellcc/platform/commctls/richedit/richeditcontrols/richeditcontrolreference/richeditmessages/em_setwordbreakprocex.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/shellcc/platform/commctls/editcontrols/editcontrols.asp
best of luck.
- john
|
|
|
|
|
const type_info &t0=typeid(CWnd);
const type_info &t1=typeid(CEdit);
t0==t1;
|
|
|
|
|
Have you enabled run-time type info (/GR compiler option)? Have you #include typeinfo.h?
"You're obviously a superstar." - Christian Graus about me - 12 Feb '03
"Obviously ??? You're definitely a superstar!!!" - mYkel - 21 Jun '04
"There's not enough blatant self-congratulatory backslapping in the world today..." - HumblePie - 21 Jun '05
Within you lies the power for good - Use it!
|
|
|
|
|
I forgot to include typeinfo.h.
Thanks.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
