Recent content by Luke Storer

  1. L

    Empty a folder

    I'm currently building a small application and one of the buttons needs to empty a folder on the c:/ local drive is there a way to do this without removing the folder just all the contained files? as a possible bonus i would like to get the folder location from the registry but this is...
  2. L

    what is best way to clear tables?

    ah brilliant, that worked a treat - thankyou
  3. L

    what is best way to clear tables?

    hmm, couldn't get this to work... kept getting error "expected end of statement" so i wrote 3 Delete Queries, but every time they run i get an access warning about modifying tables, ordered them in a manner so that the link table is deleted first meaning the relationship error no longer occurs
  4. L

    what is best way to clear tables?

    I need to b able to clear records from 3 tables with one click I tried opening each as a record set and looping through deleting each in turn with a loop, however this I know to be poor practice and it also errors as i cannot delete a record that is part of a relationship. is there a more...
  5. L

    Help needed with conditional formatting

    not sure where in the conditional formatting I'm supposed to use Clng(TextCharRemain) so have made a copy of the form. where can is it best to upload .zip to? http://www.filefactory.com/file/f4975d/
  6. L

    Help needed with conditional formatting

    I have read the Access Help page before posting here I have a text box called TxtCharRemain formatted as general number It displays how many more characters can be typed into a text box named TxtActionTaken I want the contents to appear in red when TxtCharRemain is less than 1 (0 or negative)...
Back
Top Bottom