<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1106" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV>Dear AccessD Listers,</DIV>
<DIV> </DIV>
<DIV>I have a small project for a non-U.S./non-Canadian Access97 coder. We
are modifying an existing application so that it can be used by customers
outside the U.S. and Canada. App interface will still be in English, but
'international' version will handle various currencies, address / phone formats,
and non-U.S. date formatting.</DIV>
<DIV> </DIV>
<DIV>I'm doing all mods except those required to handle dates properly in
SQL. That is the part being sub-contracted in this project. The
scope of this project involves reviewing all SQL and modifying any that deals
with date values, in the manner that has often been discussed on this
list: </DIV>
<DIV> </DIV>
<DIV>Format(dateValue, "mm\/dd\/yyyy")</DIV>
<DIV> </DIV>
<DIV>All modifications of this type should then be tested to ensure proper
functionality (primary reason I'm requesting someone outside US/Canada to work
on this).</DIV>
<DIV> </DIV>
<DIV>Here are some specs on this app:</DIV>
<DIV> </DIV>
<DIV>Access97, FE/BE, distributed as Access97 runtime mde using Sagekey
scripts. SQL needs to be reviewed throughout, including saved queries,
modules, form/report control sources. The app contains these objects
(though not all deal with dates):</DIV>
<DIV>42 queries</DIV>
<DIV>82 forms</DIV>
<DIV>57 reports</DIV>
<DIV>26 modules</DIV>
<DIV> </DIV>
<DIV>The development mdb will be ready (meaning all non-SQL-related mods have
been completed) for you on or before Oct. 24, and this project needs to be
completed by Nov. 14. Project deliverables include the modified mdb
(obviously), and a simple list of objects modified (example of list
entries: "qryApptsList", "mdlSchedule.fctNextAppt", etc.)</DIV>
<DIV> </DIV>
<DIV>If you want additional information about this application, you can find it
at <A href="http://www.farriersoftware.com">www.farriersoftware.com</A> .
You're also welcome to dowload a demo of the app from there (this requires
filling out a form first - please put "AccessD" in the comments so we don't
think you're a potential customer!)</DIV>
<DIV> </DIV>
<DIV>Please email me direct at <A
href="mailto:backroad@idir.net">backroad@idir.net</A> if you're interested or
have any questions. Thank you!</DIV>
<DIV> </DIV>
<DIV>Best Regards,</DIV>
<DIV> </DIV>
<DIV>Julie Schwalm<BR>Backroads Data<BR><A
href="http://www.backroadsdata.com">www.backroadsdata.com</A><BR>785-594-6807</DIV></BODY></HTML>