paul.hartland at fsmail.net
paul.hartland at fsmail.net
Mon Feb 17 07:57:00 CST 2003
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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com