Beautiful Report in Access -- Can I get it into VB?

[BitCounter]

I have created a fabulous report structure and it is exactly what I need...now, can I export it or somehow get it into VB without having to re-create?&nbsp;&nbsp;Any help would be much appreciated.&nbsp;&nbsp;I know this is an Access forum..just thought that somebody here might know.&nbsp;&nbsp;Very grateful <br><br>Renae

 

[elizabeth]

Sot on Tips (Click on Lightbulb icon) or Search on thread named &quot;Product Converts Access to VB&quot; in this forum for a commercial product that claims to do this. If you do purchase, please post re: your experience with this product, I've never used it.

 

[BitCounter]

Elizabeth:<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;I probably won't buy any product..this is for a school project. Thanks!<br><br>Renae

 

[DougP]

There is a way to call Access from VB<br>using Shell<br>Not to efficient but its FREE<br><br>Create a report in Access<br>Create amacro to run the report<br>Launch Access&nbsp;&nbsp;.MDBname&nbsp;&nbsp;/X macroname<br>Here's an example I use for the path <br><br>&quot;C:\Microsoft Office97\Office\MSACCESS.EXE&quot; X:\Sales\-VirtualClipboard.mdb /X VirtualOrder<br>