Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Access (https://www.askmehelpdesk.com/forumdisplay.php?f=441)
-   -   Can Access 2000 Object Library use a different Const, than msoFileDialogFilePicker? (https://www.askmehelpdesk.com/showthread.php?t=560954)

  • Mar 9, 2011, 04:06 PM
    Micromax
    Can Access 2000 Object Library use a different Const, than msoFileDialogFilePicker?
    I used Access 2003 to create a database and saved as Access 2000 format. I used some code that downloads a logo. This won't work in Access 2000 because of the Library Microsoft Office 9 Object Library can't pick up the msoFileDialogFilePicker object. It think it's a variable. I'm not sure if Access 2000 is setup right or the msoFileDialogFilePicker really isn't available in Access 2000. Does anyone know if there is a way that the database can be distributed to have this logo download if the user is using Access 2000? Any help re: Access 2007 and Access 2010 with regards to picking up the same code or Access 2003 functionality in those later Access program would be appreciated.
    Thanks for you help.
  • Mar 17, 2011, 04:03 PM
    Micromax
    You can remove this question if you wish
  • Mar 17, 2011, 04:11 PM
    ScottGem

    References have little to do with the file format and much to do with the version of Access. The FileDialog object was introduced in Access XP So it can be used by anyone using the XP client or later regardless of the file format. However, it can't be used by earlier clients. To use the FileDialog object the Microsoft Office xx Library needs to be listed as a Reference where xx is version 10 or higher.
  • Mar 18, 2011, 04:25 PM
    Micromax
    Comment on ScottGem's post
    I had a feeling about that Scott. I tested the database on Access 2000 and it could'nt read that line specifically that constant. Thanks Scott for letting me know. I appreciate your input as usual.

  • All times are GMT -7. The time now is 03:36 PM.