InstantForum.NET v4.1.1A1VBCode Forumshttp://www.a1vbcode.com/vbforums/forums@a1vbcode.comThu, 09 Feb 2012 04:18:35 GMT20http://www.a1vbcode.com/vbforums/Topic15212-3-1.aspxVisual Basic program creates a batch according to the data in database field. No problem at here. But it has to create 3 types of batch. Suppose that there are 3 types of computer. For instance, IBM, Dell, HP. VB program will lookup the first record and match the field. If it is IBM, it will create test1.bat. If it is HP then test2.bat. It will read and create the batches step by step through the records. Is this possible to do this with Case statement or ? Any other suggest ?<br><br>A simple design will be helpfull for me. I am all doing this in acccess database.Tue, 29 Nov 2005 20:15:17 GMTfirfir