Access report in Autocad?

Hi,
I have a vba program linked with a ms access database file.
I have not ms access in my pc, and i want to create reports like access
reports. It is possible? if yes how can i do this?

thanks

 

Sounds like a lot of work, I've never tried it. But...Access reports consist of two parts, an unerlying query and a graphical display of the data. The query part is easy using ADO. For the display part, you might try iterating through the records and formatting the text for Word.

--
----
Ed
----
Hi,
I have a vba program linked with a ms access database file.
I have not ms access in my pc, and i want to create reports like access
reports. It is possible? if yes how can i do this?

thanks

 

On second thought, I think I would use Excel. You could start with a template spreadsheet that had some formatting applied and it would be easier to do grouping by keeping track of the size of the range.

--
----
Ed
----
Sounds like a lot of work, I've never tried it. But...Access reports consist of two parts, an unerlying query and a graphical display of the data. The query part is easy using ADO. For the display part, you might try iterating through the records and formatting the text for Word.

--
----
Ed
----
Hi,
I have a vba program linked with a ms access database file.
I have not ms access in my pc, and i want to create reports like access
reports. It is possible? if yes how can i do this?

thanks

 

Push it to a HTML file - easier than Excel.

 

do you have a code example?

 

do you have a code example?

 

yes, hang loose - its at the office

 

yes, hang loose - its at the office

Actually my example is in full vb. However, there are two ways you could
accomplish it. Here is an example that appends the HTML tags automatically
http://www.thescarms.com/vbasic/Webreport.asp which would be the longer
method. The shorter method woulld be to add a reference to the Microsoft
Data Report Designer [C:\WINDOWS\System32\msdbrpt.dll] if you have it. It
has a report.export opttion that can be set to html.

Mike

 

That web report class is pretty nice - thanx for the link!

Perion

 

Any time