Page 2 - Access/VBA noob question

yeah, sorry about the mistype. this was an example given to me to "help" me get started.

Dim fField As Field

sDatabase = "filename"
Set daoDB = OpenDatabase(sDatabase)
Set daoRS = daoDB.OpenRecordset("SELECT * FROM Transactions")

daoRS.MoveFirst
While Not daoRS.EOF
'Some Function
MsgBox daoRS.Fields(0).Value
MsgBox daoRS.Fields(1).Value
MsgBox daoRS.Fields(2).Value
MsgBox daoRS.Fields(3).Value
MsgBox daoRS.Fields(4).Value
MsgBox daoRS.Fields(5).Value
MsgBox daoRS.Fields(6).Value
MsgBox daoRS.Fields(7).Value
MsgBox daoRS.Fields(8).Value
MsgBox daoRS.Fields(9).Value
MsgBox daoRS.Fields(10).Value
MsgBox daoRS.Fields(11).Value

daoRS.MoveNext
Wend


All this does is move through each value of the table through a message box. What I need to do is have each field export to text file as it is displayed in the message box. Or, just export in general, but this was given to me by one of our coders for a little help. It's not helping much, heh. Thanks for the help

Okay. Referring to the code sample I posted, what errors did you recieve when you attemtpted to run that? Once you have the connection you will be able to perform you data population.
...
Your issue is connecting to the database correct?

I actually got this to work now. I now need to print individual fields to file. I've been searching the net for weeks looking for an example of how to do this, but no luck.

Are you wanting to print to the filesystem?