Newbie to VBA Reports with MS Access Database

[ftpdoo]

Hi,

As a new user to VBA excuse any terms which are wrong. I'm using MS Word 2000 to generate reports via VBA from a MS Access 2000 database.

The problem:
-----------------
I already know how to print preview and generate a report from static values stored within the VBA code.

ie: Sub Fill_Items()

Items(1, 1) = "ACM001"
Items(1, 2) = "ACME CD-ROM"
Items(1, 3) = "1"
Items(1, 4) = "80.00 $"
Items(1, 5) = "80.00 $"

Items(2, 1) = "ACM002"
Items(2, 2) = "ACME FDD"
Items(2, 3) = "1"
Items(2, 4) = "20.00 $"
Items(2, 5) = "20.00 $"

End Sub

But how do I take items from a database instead????


Thanks.. This would be a HUGE help.
Jonathan..

 

[Morpheus1981]

What r u using to connect? ADO, RDO, DAO
What do u whant to get from the Database ColumnsNames of record values?
Mail me with these answers and the explanaition again I'll do my best to help u. (fdalorzo@costarricense.com)
...

 

[ftpdoo]

Hi,

I'm using an ODBC link to a Microsoft Access database. The values that I wish to extract from the database is values stored within columns.

The two columns I wish to extract is one called:

SequenceNo (Integer) and Item (String)

Thanks,
Jonathan