C / C++ / MFC

27-Nov-05 19:13

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

vikas amin27-Nov-05 23:27

vikas amin

27-Nov-05 23:27

What is DoCmd ?
I mean what type of object is it

Vikas Amin
Embin Technology
Bombay
vikas.amin@embin.com

Ankush Mehta27-Nov-05 23:38

27-Nov-05 23:38

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

S Douglas28-Nov-05 19:36

S Douglas

28-Nov-05 19:36

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[^]

Ankush Mehta28-Nov-05 21:34

28-Nov-05 21:34

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

S Douglas28-Nov-05 21:59

S Douglas

28-Nov-05 21:59

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[^]

Ankush Mehta28-Nov-05 22:51

28-Nov-05 22:51

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]: Cry | :((

Ankush Mehta

Problem in getting TooTip from ToolBar

S Douglas28-Nov-05 23:45

S Douglas

28-Nov-05 23:45

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[^]

rajan.msmy27-Nov-05 18:49

rajan.msmy

27-Nov-05 18:49

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"

GetProcAddress Problems :(

Bobamagoo27-Nov-05 18:01

Bobamagoo

27-Nov-05 18:01

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 />
// From the header<br />
private:<br />
    typedef Object __gc * (__cdecl *Builder)();<br />
    Builder build;<br />
    HINSTANCE library;<br />
    FARPROC holder;<br />
    Object * wompi;<br />
<br />
// From the cpp<br />
DLLoader::DLLoader()<br />
{<br />
    library = LoadLibrary(_T("LeetTrans"));<br />
    if(library != NULL)<br />
    {<br />
        /*<br />
        GetProcAddress won't assign the function to variable holder.<br />
        I don't understand why.<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 />
// From LeetTrans.cpp in the DLL<br />
Object __gc * __cdecl Build()<br />
{<br />
    LeetTrans * a = new LeetTrans();<br />
    return a;<br />
}<br />
<br />
// From LeetTrans.h in the DLL<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.

sunit527-Nov-05 18:55

sunit5

27-Nov-05 18:55

holder = GetProcAddress(library,_T("Build"));

mention the function ordinal in place of _T("Build")

Bobamagoo27-Nov-05 19:28

Bobamagoo

27-Nov-05 19:28

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. WTF | :WTF:

Gavin Taylor27-Nov-05 19:05

Gavin Taylor

27-Nov-05 19:05

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 Smile | :)

Gavin Taylor
w: http://www.gavintaylor.co.uk

Bobamagoo27-Nov-05 19:25

Bobamagoo

27-Nov-05 19:25

I enjoy the Sobe drinks myself. Big Grin | :-D

I couldn't find the 'depends.exe', but I changed the DLL code to look like this:

<br />
// Header<br />
extern "C" Object __gc * __cdecl Build();<br />
<br />
// .cpp<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. Frown | :(

Thanks for your help, especially considering your work. Good luck with your code.