I have not written a VB program that needs a report generated. So far the programs I have written in VB are to update/add records. Please let me know if there is a book about reading a database then generating a report. If someone could guide me or has an example program I could look at so I will be familiar on how to code or go about this project.

Thanks,
Judy

How are you planning on printing the report? Crystal Reports? Access? A different third party tool? Generating your own?

I was planning on generating my own. I heard that I could pass it off into a Word Document but I will start with just the basic if this will be simpler. I am planning to do incorporate Crystal Report later on as soon as I know the basic report generation code.

Thanks,
Judy

I do not think that there is such a thing like "basic report generation code".
I feel that it is more like emptying your database and giving a meaningfull structure to the data gathered from the database.

I usually generate the reports directly to word using VBA but basically it is just looping throug recordsets or datasets and structuring the information so the user knows what it means and presenting it in a readable and printable medium. (Could be a RichTextBox, word, excel ,...)

How do you it through VBA? Is it totally different from VB? Is there a book I can read to do this?


I usually generate the reports directly to word using VBA but basically it is just looping throug recordsets or datasets and structuring the information so the user knows what it means and presenting it in a readable and printable medium. (Could be a RichTextBox, word, excel ,...)

VBA is not that different from Visual Basic. I just use it in a Visual basic project.

Basically is VBA a set objects and commands by which you can manipulate word or excel or different appliations.

For example:

First Select the Reference 'Microsoft Word 10.0 Object Library' (are the version you have)

Then in you visual basic project you can do the following

Dim woApp as Word.application
Dim woDoc as word.document
Dim woFont as word.font
Dim woSel as word.Selection

Set woApp = CreateObject("Word.Application")
woApp.Visible = true

set woDoc = woApp.Documents.Add("")

set woSel = woApp.Selection
set woFont = woSel.Font

'now you can use the woSel object to type text and the woFont object to format the font.

woFont.Bold = 1
woFont.Size = 14
woSel.typeText "Some text here"
woFont.Reset

'You can mix this VBA code with normal Visual Basic Code.
'So you can use recordsets and loops

Do until rsDb.EOF

  woSel.TypeText rsDb.Fields("SomeField") & vbCrLf

  rsDb.movenext

loop




I hope this gives you a strart.

There are books that you can buy but when you search google for +vba +word you will be able to find some examples.

Greetz

Tom

Thanks for the suggestion Tom. This will give me a place to start.