Results 1 to 3 of 3
  1. #1
    Ronald is offline Novice
    Windows Vista Access 2007
    Join Date
    Jul 2011
    Posts
    2

    Checking beforehand whether a file exists

    Hello there,

    In printing documents (report) I make use of links to existing files in codes like:

    Me![ImageFrame].Picture = "c:\Pictures\" & Me.Picturekey & ".tif"

    When however the wanted file does not exist, there is an occurance of an error.



    To be able to see before hand whether the file realy exists, I must have code to check this.

    I'm having much trouble to find this code.

    Can somebody do a suggestion??

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,722
    I answered a similar question (sort of) here
    http://www.access-programmers.co.uk/...d.php?t=213275

    Check FileFolderExists function..

  3. #3
    Ronald is offline Novice
    Windows Vista Access 2007
    Join Date
    Jul 2011
    Posts
    2

    Thanks !!!

    Quote Originally Posted by orange View Post
    I answered a similar question (sort of) here
    http://www.access-programmers.co.uk/...d.php?t=213275

    Check FileFolderExists function..
    Thank you very much for thhis answer.
    The problem is solved!!!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Checking if a year exists via DLookup
    By walter189 in forum Programming
    Replies: 6
    Last Post: 07-22-2011, 10:37 PM
  2. Automatically checking a box?
    By Delta223 in forum Access
    Replies: 3
    Last Post: 01-10-2011, 10:37 PM
  3. How to tell if a file exists and then delete it
    By orcinus in forum Programming
    Replies: 3
    Last Post: 05-17-2010, 05:15 PM
  4. Checking if files exists
    By geoffishere in forum Access
    Replies: 1
    Last Post: 02-09-2010, 01:32 PM
  5. Checking for Value in Query
    By jgelpi in forum Access
    Replies: 1
    Last Post: 06-24-2009, 04:57 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums