<div>
Well if it could be done in VBA it would be good. Can use VB.Net though
</div>


Well if it could be done in VBA it would be good. Can use VB.Net though

<div>
Here is the exact URL :<br />
<br />
<a href="http://juicystudio.com/tutorial/vb/files.asp" rel="ugc">http://juicystudio.com/tutorial/vb/files.asp</a>
</div>


Here is the exact URL :

http://juicystudio.com/tutorial/vb/files.asp [http://juicystudio.com/tutorial/vb/files.asp]

<div>
<div class="content wysiwyg-content">
At the moment I have a 3 very simple tables - 'survey', 'value', and 'variable' that each follow the same structure of having 2 columns - 'Name' and 'Format'<br />
<br />
The Variable table appears as below:<br />
<br />
'Name' &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Format<br />
custom3 &nbsp; &nbsp; &nbsp; &nbsp;EMPTY<br />
custom34 &nbsp; &nbsp; &nbsp;EMPTY<br />
custom345 &nbsp; &nbsp;EMPTY<br />
<br />
<br />
What I would like to do is that when any record is added or deleted from this database that a text file with the structure below is created.<br />
<br />
&lt;!ELEMENT custom3 EMPTY&gt;<br />
&lt;!ELEMENT custom34 EMPTY&gt;<br />
&lt;!ELEMENT custom345 EMPTY&gt;<br />
<br />
&lt;!ENTITY % UDvariable_controls &quot;custom3 | custom34 | custom345 &quot;&gt;<br />
<br />
If possible I would also like to be able to have this saved with a '.dtd' extension rather than a '.txt' one. Any help will be greatly appreciated as I have got no-where with this.<br />
<br />
Thanks
</div>
</div>


At the moment I have a 3 very simple tables - 'survey', 'value', and 'variable' that each follow the same structure of having 2 columns - 'Name' and 'Format'

The Variable table appears as below:

'Name'          Format
custom3        EMPTY
custom34      EMPTY
custom345    EMPTY


What I would like to do is that when any record is added or deleted from this database that a text file with the structure below is created.

<!ELEMENT custom3 EMPTY>
<!ELEMENT custom34 EMPTY>
<!ELEMENT custom345 EMPTY>

<!ENTITY % UDvariable_controls "custom3 | custom34 | custom345 ">

If possible I would also like to be able to have this saved with a '.dtd' extension rather than a '.txt' one. Any help will be greatly appreciated as I have got no-where with this.

Thanks

Writing a text file from Database data

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.