Darryl Collins
Darryl.Collins at iag.com.au
Thu Jun 17 02:07:34 CDT 2010
_______________________________________________________________________________________ Note: This e-mail is subject to the disclaimer contained at the bottom of this message. _______________________________________________________________________________________ Hi Jim, I had assumed you would have taken that sort of approach - especially with unbound forms. But experience has also taught me never to assume anything... :) Cheers Darryl. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: Thursday, 17 June 2010 2:45 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Date standardization Hi Darryl: I do as a matter of fact. In addition to an input mask, there is full data programmed validation and a check to make sure all the data included... In addition there combo box and calendar entry... also with appropriate programmed formatting. If someone can enter invalid data that would be quite incredible. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins Sent: Wednesday, June 16, 2010 9:10 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Date standardization ____________________________________________________________________________ ___________ Note: This e-mail is subject to the disclaimer contained at the bottom of this message. ____________________________________________________________________________ ___________ Hi Jim, Not really been following this, but this bit caught my attention "The information being provided are from unbound fields" as unbound fields by default have none of the inherited controls of a bound field (that said I usually use unbound). Do you have logic in place to ensure the data that is being passed in an actual valid date, rather than something that looks like a data that a user has keyed? Humans will do dumb stuff in date fields like "Yesterday" "Next Week" "April" "Monday" when you are expecting 30-Jan-2010. I am sure you have considered all of this, but just in case.... Cheers Darryl. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: Thursday, 17 June 2010 11:15 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Date standardization Hi Steve: Yes, of course it is just that I think that for comment purposes 'dd Mon yyyy' translates a little better... many of the other language just use that display method. The following is one of a number of errors that may come up: Run time error 3163; The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data. The information being provided are from unbound fields and the error is initiated from a basic Select query. My development site of course works perfectly and as it should. So the client's data file will be the key and as Alice said, "Curiouser and Curiouser". Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel Sent: Wednesday, June 16, 2010 2:12 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Date standardization Jim, As an aside, I assume you mean 'dd mmm yyyy' not 'dd Mon yyyy'. In any case, the point that I have been trying to make here is that it doesn't make any difference at all, none, what the format of the "entry points" is. And it doesn't matter if the user is directly entering into the tables (though of course in general you don't want users to have direct access to the tables). If it's a Date/Time data type field, then the value stored in the table will be precisely the same, regardless of the format of how it's entered or displayed in one place or another. Can you give any specific example of the type of anomaly that is occurring? Regards Steve -------------------------------------------------- From: "Jim Lawrence" <accessd at shaw.ca> Sent: Thursday, June 17, 2010 8:47 AM To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Subject: Re: [AccessD] Date standardization > Hi Gustav: > > That is true but all the entry points that I could find in the original FE > MDB, I set to 'dd Mon yyyy'. My fear is that the client has decided for > expedience sake that direct entry into the tables was faster. 8-( > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ____________________________________________________________________________ ___________ The information transmitted in this message and its attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information, by persons or entities other than the intended recipient is prohibited. If you have received this in error, please contact the sender and delete this e-mail and associated material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files, with the permission of the sender. This message has been scanned for viruses. ____________________________________________________________________________ ___________ -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________________________________________________ The information transmitted in this message and its attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information, by persons or entities other than the intended recipient is prohibited. If you have received this in error, please contact the sender and delete this e-mail and associated material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files, with the permission of the sender. This message has been scanned for viruses. _______________________________________________________________________________________