I am working on a desk top application and I have a few questions. I will be importing 2 text files delimited with commas to load two tables in my database.I have found code to help with this however; I still have a few questions. First, the text files will be coming from an external source. I will have to connect to that source via a phone line. I'm not sure how to do this inside a VB module. This module will run from an invisible form with an OnTimer event.

Second, the first file will reload a table each time, I know how to do this. The second file will be added on to the table it loads, I think this is appended. I am not sure how do do this.

The final piece that I am struggling with is, the background utility, as I am calling it will do maintenance to the other tables in the database based on what is loaded each night. I am comfortable using queries for reports and forms but I am not sure how do set them up in VB code. I will need to add and delete rows from tables, print reports and update individual fields in tables based on specific events.

Can anyone point me to some sample code to answer these questions.

mschwietering

>>>>> I will have to connect to that source via a phone line. I'm not sure how to do this inside a VB module<<<<<

I would search the VB forums for info on this, its unlikely that anyone has done it in Access. If you find some V. B. code you can usually use it in access with some minor modification.

>>>>> with an OnTimer event.<<<<
As a general rule it’s a good idea to avoid using the timer in access.

>>>>> I will have to connect to that source via a phone line. I'm not sure how to do this inside a VB module<<<<<

I would search the VB forums for info on this, its unlikely that anyone has done it in Access. If you find some V. B. code you can usually use it in access with some minor modification.

>>>>> with an OnTimer event.<<<<
As a general rule it’s a good idea to avoid using the timer in access.

Tony thanks for the response, why is it not a good idea to use the OnTimer event in Access. I am not using macros, I am supporting my application with VB code.