This is probably a very trivial question, so I'm sure any of you could answer this one.
I'm an experienced C++ programmer with several years of experience. I have a very small amount of experience in writing Excel macros using VBA. I have no experience whatsoever with Access. All the info I can find on Access is either too basic (for total beginners) or too technical and confusing (i.e. MS reference material).
What I want to do is print a set of flash cards from an Access database. To do that I want to enumerate all the records in a particular table, extract some data from the records, print some of it on one side of the flash cards and the rest on the other side. It's very trivial; any one of you could do it in about five minutes.
But looking through the MS reference material, I can't figure out how to enumerate the records. I found an example of how to enumerate the tables in the database, but how do I enumerate the records in the table?
I've done something similar with Excel, where I enumerated the rows in a worksheet. If I remember correctly, I first enumerated the worksheets in the spreadsheet, then used the row collection property to enumerate the rows in the worksheet. I would assume that I would do something similar in Access, but I haven't been able to find a similar record collection property to enumerate the records. So what do I have to do to enumerate the records?
One further question: When I create the macro, do I have to create a form with a button to click to print the flash cards, or can I have the macro print the flash cards directly. All the VBA macros that I created for Excel would bring up a form or dialog box to do anything, so I'm not sure whether I can write a marco that will print the flash cards directly. Thank you.