Mike and Doris Manning
mikedorism at ntelos.net
Mon Feb 17 07:54:00 CST 2003
Use an update sproc that sets the value back to Null. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com] On Behalf Of paul.hartland at fsmail.net Sent: Monday, February 17, 2003 08:48 AM To: dba-SQLServer at databaseadvisors.com; AccessD at databaseadvisors.com; dba-vb at databaseadvisors.com Subject: [AccessD] Deleting Dates To all, I have a Visual Basic 6 front-end which is currently linked into a SQL Server 7.0 back-end, I have a table called tblPersonnel in the BE which has a form on the VB6 FE. We take on temporary staff a certain points of the year to help with the workload, and when they finish we enter a finish date for that particualr person....No problem so far......However if they have proved themselves to be a good worker, they get invited back whenever we need the additional staff (saving on re-training etc). But I can seem to get the system to allow me to take out a finish date (making it null again)..... The tblPersonnel.Finishdate field will allow Nulls, and I'm using the ADODC DataControl with a text box linked to the Control and Field FinishDate........ Anyone had similar problems or can tell me how to reset the FinishDate to null Thanks in advance for any help.......... Paul __________________________________________________________________________ Freeserve AnyTime - Go online whenever you want for just £6.99 a month for your first 3 months, that's HALF PRICE! And then it's just £13.99 a month after that. For more information visit http://www.freeserve.com/time/ or call free on 0800 970 8890 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com