Search results

  1. Z

    Operand type clash: Date inconsistent with float, data type mismatch

    Ran into in issue trying to support a SS backend and an Access backend in one of my DoCmd.RunSQL's The SQL is listed below. The field tblItemReceivingHeader.OrderDate in the where clause is the is the one that appears to have issues. The date field is define in SS as "date". I have tried...
  2. Z

    Access 2007 fails to run with linked SQL Server backend

    I have an application built in Access 2002 and running in Access 2002 /2003. It is a split with an Access front end and multiple versions of the back end. Access, Sql Server 2005 Express, and Sql Serve 2008 Express. All of the versions in what ever combination run fine with the application...
  3. Z

    Cheers!

    Hi all... been coding to long enuff to have had a staff of keypunch operators work for me.. but I am relatively new to Access and it many iterations. hope to avoid reinventing the wheel by being here.. thanks to all who help us wondering around in the dark... laters
Back
Top Bottom