Recent content by Neera

Thanks Stew, I can import the text file or open a dialog box to read as text file and pass the value to compare in the access table. There will be several files, the users will be comparing the access table and updating. This the reason, I wanted to code using Visual Basic functions and...

Thanks for your advise. I need to open the table and update it with the text file data. If you can help please respond.

I need to open an access table using Visual basic. Then open a text file. Compare the value in the access table and update the access table. Can anyone help?? Thanks

Thanks for the tip. I really need to code the application in Visual Basic. By usign the query, it is just coding the DoCommand.OpenQuery and runs the query. It is not giving me the code to open the database, read the records, compare and then update. Please let me know if you can guide me for...

Hi, I need to code an application where there is an access table. This table will be updated based on several conditions. To update the table, a txt file will be supplied. Please help me to code: 1. OPen the database in VBA 2. Open the table and read the records. 3. Compare the data with the...

I need to run VB exe. The use wants to put it in a schedules where the input and output file will be passed as a parameter on the DOS line with run statement. For example like this: D:\>rriscrub9 [path\input table] [path\output table] Can VB run this way?????????? TimLarkin...

The processing of the file is in a click event. Now because the input/output file is passed on the command line, I would like to process the file without the user interface. In which event the code should be to process the input file and create the output file??????/

I need to run VB exe. The use wants to put it in a schedules where the input and output file will be passed as a parameter on the DOS line with run statement. For example like this: D:\>rriscrub9 [path\input table] [path\output table] Can VB run this way??????????

I need create a txt file by reading 3 tables. There is a header table, detail table, and trailer table. Each set of records should have one header, one or more detail records and one trailer. Some data items are similar for each type of record. I started coding the module but having problem...

I need to load a file which has three different record type to an access database. Need to select the documents from this file by comparing the document numbers from an table in the existing database. Can you suggest how to do in VB