<!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>Sorry for the re-posting - my email service has been intermittant over the
last couple of days and I have not been receiving all mail.</DIV>
<DIV> </DIV>
<DIV>If you've written me on this project and I haven't responded, please email
me again. I will reply to every message. 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>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=backroad@idir.net href="mailto:backroad@idir.net">Backroads Data</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">AccessD</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, October 15, 2003 2:18
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [AccessD] Small Access97 Project
Opportunity</DIV>
<DIV><BR></DIV>
<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>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>