On Mon, 14 Jul 2003 22:16:22 -0700, "mk sabeel"
<mk_sabeel@yahoo.co.in> wrote:
>hello sir,
>
>i am student who is doing my project using access2000
>
>my problem is as follows
>i have a text file which is quite big, it has about 500
>different feilds like
>horizontal distance = 720
>vertical distance = 840i
Is this how they're laid out in the file - fieldname, equals sign, and
value?
>i have single form which has feilds from 4 differnt feilds
>and takes record details from these 4 tables and displays
>it.
What is the Recordsource of the form? Is this one field from each
table? Is the Form updateable (I'd guess it is not)?
>i want to read the text file and input the values say 720
>and 840i as 720x840i into a particular feild of a form
>which corresponds to a feild in one of the 4 tables
>like that i would have to read from the text file and put
>differnt kind of text values in the required feilds of the
>form.
You will need VBA code to do so. Even if you could Link to a text file
like this (and to my knowledge you can't), you are limited to 255
fields - 500 is just too many. The code would need to open the text
file, step through it looking for the desired fields, and "push" the
value into the form control.

It's doable, but rather more code than I'm comfortable posting in a
newsgroup message. Look at the online help for FileOpen in the VBA
editor just to get started...


John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
[url]http://go.compuserve.com/msdevapps?loc=us&access=public[/url]