Search results

  1. R

    Looping through recordset uses last record to update all records

    Hi Guys, I have 5 subforms that run off 5 separate queries that are filtered by the criteria pointing to each day of the week. I have put together the following but it updates the 'ptemp' in each record with the last value it calculated, i.e. the correct value for the last record. Obviously i'm...
  2. R

    dBASE data type mismatch - using CAST?

    Anyone got an idea how to fix a data type mismatch when linking to a dBASE table on a seperate server? Used the following code before when using local Access 2007 tables but the incompatibility with dBASE is preventing access from recognising that data types are both numbers! Private Sub...
Back
Top Bottom