how to make access form

[earlrainer]

hi ,

i have a table called members. it has two fields name and date of birth.
I want to make a access form which outputs the data from the table to a text file.

how can i do that.

thanks

 

[CathieB]

Create a form that uses the table called members. Then Create an append query that uses the query from the form . Create a button on the form that runs the append query and appends the information into another table which has those fields as text.

 

[starbird]

Easiest thing to do is to create a macro to output the file, and then assign the macro to a button on your form.
[tt]
[ol]
[li]Create a new macro[/li]
[li]in the Action field, select "OutputTo"[/li]
[li]In the lower pain, fill int the:[/li]
[ul]
[li]OBJECT TYPE = Table[/li]
[li]OBJECT NAME = "the name of your table"[/li]
[li]OUTPUT FORMAT = Text Files (*.txt)[/li]
[li]Other Fields are optional[/li]
[/ul]
[li]Save the macro[/li]
[li]Assign macro to a button on your form[/li]
[/ol]
[/tt]
That should do it.