Search results

  1. M

    Conundrum

    Hi I have a table of results I need to query. It is badly designed. It holds test results for individuals, where there can be a variable permutation of results. Like this: Person - Result Person 1 - Positive Person 1 - Resistant Person 1 - Type A Person 2 - Slight Positive Person 2 -...
  2. M

    Module Problem (data type)

    Hi, I've managed to find the following code to change a field's data type. it isn't running, though. I get a Run-time error for the line "fld.Type = 8". Any help would be gratefully received! Function ChangeFieldDataType() Dim db As DAO.Database, tdf As DAO.TableDef, fld As...
  3. M

    Access ODBC to SQL prob

    Hi Complete n00b here so please be gentle. I run a query to an SQL Server across our network from Access. My query has date criteria: between #date# and #date#. I use this every day so wanted to get a user-input date with: between [start date] and [end date]. This causes an ODBC connection...
  4. M

    Query to ODBC problem

    Hi Complete n00b here so please be gentle. I run a query to an SQL Server across our network from Access. My query has date criteria: between #date# and #date#. I use this every day so wanted to get a user-input date with: between [start date] and [end date]. This causes an ODBC connection...
Back
Top Bottom