access to text file

M

ms shakeel

hello sir,

Thanks in advance for the help

I filter a form which is based on 3 tables then
i get around 20 records.how do i open the filtered records
as a recordset in the VBA. plz give me the syntax.

also how do i write a text file linewise in code using the
Print statement, as what i want to achieve is that
i want to output the form to a text in such a way that the
feilds of the form appear in the text file one below the
other like-
RECORD 1
feild name feild value
feild name feild value
feild name feild value

RECORD 2
feild name feild value
feild name feild value
feild name feild value
'
'
'
RECORD 3
feild name feild value
feild name feild value
feild name feild value

i want the text file to read show the filtered records in
the above format.

so plz tell me how do i open the filtered records as a
recordset in the VBA. plz give me the syntax.also how do i
write a text file linewise in code using the Print
statement

plz tell me how do i go abt this

thank you
ms shakeel
[email protected]
 
Top