[AccessD] Deleting Dates

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




More information about the AccessD mailing list