Search results

  1. C

    Need to Display a Field +1 on a Form

    Guys, This is a simple one, I'm sure. I have a form that needs to display the Maximum Value of a Field in a related table, +1. I have tried DMAX in the default value of the field in question, but I'm either putting it in the wrong place, using the wrong syntax or using the wrong function...
  2. C

    Converting List Values to Text in a Report

    This is so simple that I'm amazed it's so difficult to find out how to do! I have a query which finds a selection of records from a table. These records have codes for certain fields; F for Forwards, B for Backwards etc. When I display these in my report I want to display Forwards and...
  3. C

    Skip fields on import into existing table

    Guys, I've one text file, which I want to import into three different tables - skipping fields which are in the text file but not the designated table. You could do this in Access 2003 - but Access 2007 does not, you just get a 'subscript out of bounds' error. Is there a way around this...
Back
Top Bottom