export to file

[miletjs]

how can i export to text tab delimited file a table from MS Access?

[André]

Hi,

Call the database and retreive a recordset.
When you have the recordset do a for each field in rs.fields loop and put a tabulator between fields, then when you get the next record you need to add a chr(13) for enter and next record.

Does this make sense? I'm ill today and maybe delirious!!!

André

[miletjs]

hi

your ill but youre surfing the net!!!...NET ADDICT!!!

ha ha ha just kidding...

anyway, ill tr it. thanks for replying.

P.S.

do you know how to put a hot key to a graphical command button. I wont be able to use the ampersand cos i didnt put any caption on the command button. i put picture instead (but i need to have a hotkey for it)

thanks

[mlewis]

set the form's keypreview property to true, then test for the hotkey in the forms KeyUp/KeyPress event.