bmpvkm

There are lot of DATE functions in VB to use. Try any of them as you need in the program. . DateAdd, DateDiff etc.

use a code (a number ) for each user and put it in every table. Or create the primary key of the table with some relation with the userid.

Put the table names in a combobox and the user must select from the list to which table the data should go. Write the SAVE code in the click event of the combobox with enough validation checks. The data will be saved when the user selects the table name.

Just close the connection and open it after the report is refreshed Recordset1.MoveNext Loop ' HERE COME THE NEW CODE FROM ME............ ADConn.CLOSE: SET ADConn=NOTHING DOEVENTS 'HERE CODE ENDS .................... CrystalReport1.Reset CrystalReport1.ReportFileName = App.Path & "\StockReport.rpt" CrystalReport1.WindowState = crptMaximized CrystalReport1.WindowShowPrintSetupBtn = True CrystalReport1.WindowShowPrintBtn = True CrystalReport1.Action = 1 ' AGAIN …

Using Datareport it is difficult to adjust the paper-size. It will use default paper-size of the printer even though nothing to print. If you want to print a small voucher / bill use the DOS mode printing, like printer.print "XXXX"