Connecting Tech Pros Worldwide Forums | Help | Site Map

Export Records to a text-file

Andre Brunner
Guest
 
Posts: n/a
#1: Nov 13 '05
Hi everybody,

I've got a table with several adresses in it and now i want to have a
button to export the records to a textfile!

So I need a Visual-Basic command to open a SaveAs-Dialog Whenever a
user presses the Export-Button I have on the formular. I have found an
example, with an CommonDialog but I'm not able to get it working
within Access!.

Is there anyone who can help me with that problem??

Thanks

André

Pieter Linden
Guest
 
Posts: n/a
#2: Nov 13 '05

re: Export Records to a text-file


AndreBrunner@gmx.de (Andre Brunner) wrote in message news:<b02c5255.0408020633.10232d3@posting.google.c om>...[color=blue]
> Hi everybody,
>
> I've got a table with several adresses in it and now i want to have a
> button to export the records to a textfile!
>
> So I need a Visual-Basic command to open a SaveAs-Dialog Whenever a
> user presses the Export-Button I have on the formular. I have found an
> example, with an CommonDialog but I'm not able to get it working
> within Access!.
>
> Is there anyone who can help me with that problem??
>
> Thanks
>
> André[/color]

How about this?
http://www.mvps.org/access/api/api0001.htm
pass the table and the filename from the above and away you go...
Closed Thread