Search results

  1. C

    Need to Display a Field +1 on a Form

    Data Type is Text as it has a suffix of 'ORD' followed by number. cybrooksy
  2. C

    Need to Display a Field +1 on a Form

    Thanks, I tried: =Nz(DMax("[Key]","ORD in Primary Key"),0)+1 in the Default Value of the field. Switching to form view I just get "#Error" in the field, not the next number. Cybrooksy
  3. C

    Need to Display a Field +1 on a Form

    In the default value of the field I put: =DMAX([field], [table]) + 1 Thanks for looking at this. Cybrooksy
  4. 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...
  5. C

    Converting List Values to Text in a Report

    Thanks very much James - added field to report and have got desired outcome. SJB
  6. 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...
  7. C

    Skip fields on import into existing table

    Thanks Bob! That's a great idea. Simon
  8. 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