How to write an Access program that update a text tab file created from Access query

[Geni55]

Hello, I have created a database with a query table exported as text tab to be used in another program. How can I create a program that would allow the text tab (from Access query table) to be updated every time data are entered in forms?
My text tab were created from exporting query table.

[Rabbit]

Reexport the table every time data is entered in the form. But that is a horribly inefficient way of controlling data flow. Why do you even need to do this? And what is this other program you mentioned?

[Geni55]

I am using Corvid Exsys and expert system software which can ready only text tab file. I would like this text tab file be updated anytime data are entered in the databse.

[Rabbit]

Well then you'll have to set up VBA or a macro to export it whenever the data is changed.

[Geni55]

Thank you Rabbit. That where I need help to do so. Could you please give me some help or indicate where I can get it?

[Rabbit]

If you're saying you don't know VBA or macros, there are a lot of tutorials out there that will help you get started.

If you're saying you know VBA or macros, but don't know how to implement the specific task, then we need to know a lot more detail than what you've provided. For example, we would need to know what event you want to trigger and the code you've tried and any errors that the code evoked.

[Geni55]

Thank you very much for your willing to help. I really do not know how to use VBA. I know what I would like to do, but I do not know how to do it. I need help.

[Rabbit]

This tutorial will get you started on learning VBA.

[Geni55]

I thank you for the tutorial. It has 28 lessons to learn. Please could you be more specific on the lesson that can be learned and applied to my specific question?

[Rabbit]

You'll probably want to look through at least the first 18 lessons. That will give you the basics of VBA. Once you know the basics, you'll be able to plan out how you want to trigger the code and what events you want to use. But the meat of the work will be done using the DoCmd.TransferText method. You will probably have to create a spec file for that.