Search results

  1. S

    Big, slow report problem

    I do something similar but in a different way. I created a local table (T_SamplesComparision) with one field in it which shares the same name as the field I wish to report on from my testing data(Sample #). I based a continious form on this table. Users can then enter the list of Sample #'s...
  2. S

    Justifying text in Access 97

    Pat, This only offers the Left, Right & Centre options, not Justify. Access 2000 and XP have the Justify option but not '97. Thanks Anyway.
  3. S

    Justifying text in Access 97

    Is it possible to Justify text in Access '97. Can work out how to do this is Access 2000 or XP but not '97. Any help appreciated. Cheers Scott
  4. S

    Creating autonumbers/index with code

    I am trying to generate an autonumber at a form level to be inserted back to a linked table that can't create it's own auto index. Is there a way of looking up the last record and adding one as the default value of a field when the record type is new? Any help greatly appreciated. Scott
  5. S

    Report Formatting

    On the Page tab in the Page Setup screen while in design view of a report, selct the Use Specific Printer option and then selct the Printer button. This should let you select the Printer and Tray etc that you want the report to go to. If your printing to different printers selct the Page Setup...
  6. S

    Formating 0.00 to blank

    You can try In Control Source on field name you want to display as null where fldname is the name of your field: If([fldname]=0.00,"",[fldname]) or If([fldname]=0,"",[fldname]) Prob better ways to do this but this should work.
  7. S

    Setting Autonumber at Form Level

    Hi all, I am using linked files back to access as a front end and hence want to be able to generate an autonumber that can be auto inserted into a field back in the linked database. Can I do this at form level, ie. as a default value on the ID field, and if so how? Due to the linked file being...
Back
Top Bottom