Recent content by Philem

  1. P

    Run macros in Excel from Access button

    Hullo. Should be easy enough. Take a look here to get you started. As for the Excel part of your question, have the first macro make a Call to the second macro. HTH P
  2. P

    Routing From Excel to .txt before Import

    Hullo. Alrighty, after being redirected here for another board, I understand what you are trying to do. The good news, YES you are in fact able to do this! It's not even really all that hard. I've got an Access db that does all sorts of hijinx with Excel. The basic idea you need is calling on...
  3. P

    Speeding up a Database with graphics files

    Generally it's not considered a good idea to have the graphics stored directly in Access. A common solution is to simply have a link to the graphic location stored in the database. A bit of code to enable clicking the link to see the graphic, or pull the graphic in a floating window, and you...
  4. P

    Error 2001: "You cancelled the previous operation"

    Downline problem R2, Recently had the exact same problem on Acc97. It was caused by one of the underlying queries not working properly. Check that EACH query referenced in the code, including all sub-queries, are working. This error comes when the queries cannot execute. HTH! P
  5. P

    Creating Templates

    Hullo. If you are asking if there is a way to POSITIVELY prevent users from doing things they should not, my suggestion would be to NOT use Access. Now, to your typed questions, on it's face value, the answer is: When the database is finished, or nearly so, go Tools->Startup, and select the...
Back
Top Bottom