This is a Visual Basic qustion but....

[Talismanic]

This is a Visual Basic question but I was hoping that there is somebody here who can help me with it.

I can open and write to a .dat file with VB by using this code. How can I bring it back into my text boxes so that I can edit the data?

Open "c:\record.dat" For Append As #1
Write #1, txtFname, txtLname, txtAddress, _
txtCity, txtState, txtZip
Close #1

 

[simongallop]

Not having time to check this, but I would look at trying to open the .dat either on screen and linking or within a workspace, then using code to edit the data. Not much help but might point in right direction.

Simon

 

[MHM]

Hi Talismatic,

look up the help topic to the VBA-command "Open" (online-help when editing any code). There you find (German version):
Open Pfadname For Modus [Access Zugriff] [Sperre] As [#]Dateinummer [Len=Satzlänge]
...and all explanations.

Mic

 

[Talismanic]

Thank you for the help, I think I have it now.