Matt,
How exactly have you configured these date/time fields? The fields I
refer to were created via a cfquery statement, as in
<cfquery
username="#myDBUserName#"
password="#myDBPassword#"
datasource="#DSN#">
CREATE TABLE myfile (
ID COUNTER not NULL PRIMARY KEY,
PostDate datetime NULL ,
ModDate datetime NULL ,
);
</cfquery>
As such whatever happens in the field config has to come about via SQL
and can't be set from within Access (although I would be curious to
hear if thats what it takes).
--
--mattRobertson--
Janitor, MSB Web Systems
mysecretbase.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208898
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54